FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
514 rows where City = "San Francisco" sorted by Registrant_Name
This data as json, CSV (advanced)
Registration_Number >30
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- Kuomintang of China 27
- Kearns International 16
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Cotton, Seligman & Ray 11
- Osaka Prefectural Government, California Office 9
- Swiss National Tourist Office, San Francisco 8
- Osaka University, San Francisco Office 8
- Felda Marketing Corporation 7
- Daniel J. Edelman, Inc. - San Francisco 7
- Conlon Associates, Ltd. 6
- Scottish Development Agency 6
- Hong Kong Government (Industry Department) 6
- Public Relations Counselors, Inc. 5
- Neeson Company 5
- Malaysian Trade Commission 5
- Polish Chamber of Foreign Trade 5
- L'Echo de l'Quest, Inc. 4
- Philippine Tourist & Travel Association 4
- Spanish National Tourist Office, San Francisco 4
- Gleason Associates, Inc. 4
- PBN Company 4
- Lykke-Wilkin & Associates 3
- Mexican Government Tourism Office, San Francisco 3
- Kearns International 3
- Hi-Tech Public Relations, Inc. 3
- PBN Company 3
- …
Registrant_Name >30
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- Kuomintang of China 27
- Kearns International 19
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Cotton, Seligman & Ray 11
- Osaka Prefectural Government, California Office 9
- Osaka University, San Francisco Office 8
- Swiss National Tourist Office, San Francisco 8
- Daniel J. Edelman, Inc. - San Francisco 7
- Felda Marketing Corporation 7
- PBN Company 7
- Conlon Associates, Ltd. 6
- Hong Kong Government (Industry Department) 6
- Scottish Development Agency 6
- Malaysian Trade Commission 5
- Neeson Company 5
- Polish Chamber of Foreign Trade 5
- Public Relations Counselors, Inc. 5
- Gleason Associates, Inc. 4
- L'Echo de l'Quest, Inc. 4
- Philippine Tourist & Travel Association 4
- Spanish National Tourist Office, San Francisco 4
- Grayling Connecting Point, LLC 3
- Hi-Tech Public Relations, Inc. 3
- Lykke-Wilkin & Associates 3
- Mexican Government Tourism Office, San Francisco 3
- Democratic & Socialist Party of China 2
- …
State 1
- CA 435
City 1
- San Francisco · 435 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name ▼ | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10413 | 10413 | 1959-03-21 | 1959-03-11 | Gold | David Bernard | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10414 | 10414 | 1959-03-21 | 1959-03-11 | Mattson | Marie Joanne | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10415 | 10415 | 1959-03-21 | 1958-06-09 | Conlon | Richard Paul | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10416 | 10416 | 1959-03-21 | 1958-06-09 | Gerson | Richard I. | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10417 | 10417 | 1959-03-21 | 1958-06-09 | Harris | John Robert | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10418 | 10418 | 1959-03-21 | 1958-06-09 | Sloss | Leon | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
23772 | 23772 | 1978-07-22 | 1977-07-22 | Breece | Conrad D. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23773 | 23773 | 1978-07-22 | 1977-07-22 | Cox | Allen H. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23774 | 23774 | 1978-07-22 | 1977-07-22 | Friedman | Ronald B. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23775 | 23775 | 1978-07-22 | 1977-07-22 | Garvey | Joanne M. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23776 | 23776 | 1978-07-22 | 1977-07-22 | Keeler | George C. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23777 | 23777 | 1978-07-22 | 1977-07-22 | Koning | Kirk E. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23778 | 23778 | 1978-07-22 | 1977-07-22 | Olive | Jack H. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23779 | 23779 | 1978-07-22 | 1977-07-22 | Seligman | Joseph L. , Jr. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23780 | 23780 | 1978-07-22 | 1977-07-22 | Tomberling | George E. , Jr. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23781 | 23781 | 1978-07-22 | 1977-07-22 | Wright | William M. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
28799 | 28799 | 1977-09-01 | 1977-07-22 | Barusch | Lawrence R. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
5986 | 5986 | 2005-02-02 | 2004-12-28 | Truong | Autumn Tru | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
7649 | 7649 | 2005-02-25 | 2004-12-28 | Lande | Rachel | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
12523 | 12523 | 2005-04-01 | 2005-03-15 | Chung | Lucy Kyung Eun | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
32709 | 32709 | 2005-10-12 | 2004-12-28 | Vermazen | Kathleen A. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41460 | 41460 | 2005-12-31 | 2005-10-19 | Finn | Andrea W. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41461 | 41461 | 2005-12-31 | 2005-10-19 | Glass | Eric Mathew | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41472 | 41472 | 2005-12-31 | 2004-12-28 | Kawashima | Caroline M. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
35465 | 35465 | 1962-11-09 | 1962-05-09 | Liang | Chao Wei | Democratic & Socialist Party of China 1543 | 1962-05-09 | Democratic & Socialist Party of China | 777 Sacramento Street | San Francisco | CA | ||
35466 | 35466 | 1962-11-09 | 1962-05-09 | Tsang | Hu Chor | Democratic & Socialist Party of China 1543 | 1962-05-09 | Democratic & Socialist Party of China | 777 Sacramento Street | San Francisco | CA | ||
7264 | 7264 | 2020-02-19 | 2019-09-24 | Coleman | Daveon | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
9669 | 9669 | 2020-03-11 | 2019-09-20 | Tauber | Jill | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
14118 | 14118 | 2022-04-25 | 2019-09-24 | Wagner | Martin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
14119 | 14119 | 2022-04-25 | 2021-09-24 | Manupipatpong | Methawee | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
16856 | 16856 | 2021-05-21 | 2019-09-24 | Dillen | Abigail | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
17205 | 17205 | 2020-05-26 | 2019-09-20 | Arnoldy | Ben | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
31680 | 31680 | 2019-09-30 | 2019-09-24 | Fitzgerald | Erin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
31681 | 31681 | 2019-09-30 | 2019-09-24 | Trotter | Elizabeth | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
32645 | 32645 | 2021-10-11 | 2019-09-20 | Pejan | Ramin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33222 | 33222 | 2020-10-19 | 2019-09-20 | Patriana | Zarah | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33223 | 33223 | 2020-10-19 | 2019-09-20 | Sivaraman | Bala | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33224 | 33224 | 2020-10-19 | 2019-09-20 | Zniber | Siham | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33225 | 33225 | 2020-10-19 | 2019-09-24 | Brenner | Sarah | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33226 | 33226 | 2020-10-19 | 2019-09-25 | Fitzsimmons | Jill | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
35673 | 35673 | 2020-11-12 | 2019-09-20 | Brauer | Gabe | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
15359 | 15359 | 1982-05-01 | 1981-07-02 | Beyl | Erwin Leroy (Ernest Beyl) | Ernest Beyl Public Relations, Inc. 3254 | 1981-07-02 | Ernest Beyl Public Relations, Inc. | 680 Beach Street | Suite 315 | San Francisco | CA | 94109 |
39386 | 39386 | 1988-12-30 | 1983-04-26 | Beyl | Ernest | Ernest Beyl Public Relations, Inc. 3463 | 1983-04-26 | Ernest Beyl Public Relations, Inc. | 874 North Point | San Francisco | CA | 94109 | |
40728 | 40728 | 1991-12-31 | 1990-12-03 | Farella | Frank E. | Farella, Braun & Martel 4443 | 1990-12-03 | Farella, Braun & Martel | 235 Montgomery Street | Suite 3000 | San Francisco | CA | 94104 |
13278 | 13278 | 1980-04-13 | 1979-01-16 | Khen | Teng Peng | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
14569 | 14569 | 1986-04-30 | 1984-08-27 | Keling | Aminudin Bin | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
20977 | 20977 | 1981-06-30 | 1980-12-18 | Tan | Cheam Siew | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
29819 | 29819 | 1981-09-15 | 1979-11-30 | Salleh | Mohd Thabit Bin Mohd | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
35754 | 35754 | 1989-11-14 | 1986-09-21 | Aziz | Zubir B. Hj. Abd. | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
37601 | 37601 | 1977-12-02 | 1975-11-11 | Daud | Mohamad Bin | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
38372 | 38372 | 1978-12-15 | 1978-07-06 | Majed | Mohamed Bin Abd | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
23509 | 23509 | 1986-07-18 | 1981-06-24 | Ford | John J. , III | Ford & Vlahos 3252 | 1981-06-24 | Ford & Vlahos | Alcoa Building | 1 Maritime Plaza, Suite 1313 | San Francisco | CA | 94111 |
6600 | 6600 | 1955-02-11 | 1955-02-11 | Li | Tsung-Jen | Free China Political Organizations 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
6601 | 6601 | 1955-02-11 | 1955-02-11 | Wu | Shang-Ying | Free China Political Organizations 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
26246 | 26246 | 1973-08-08 | 1973-08-08 | Freeman | Howard Burton | Freeman, Teilmann & Associates Public Relations 2450 | 1973-08-09 | Freeman, Teilmann & Associates Public Relations | 26 O'Farrell Street | Suite 903 | San Francisco | CA | 94108 |
26247 | 26247 | 1973-08-08 | 1973-08-08 | Teilmann | Michael R. | Freeman, Teilmann & Associates Public Relations 2450 | 1973-08-09 | Freeman, Teilmann & Associates Public Relations | 26 O'Farrell Street | Suite 903 | San Francisco | CA | 94108 |
35996 | 35996 | 1992-11-17 | 1973-06-12 | Heidenreich | Adam J. | German-American Chamber of Commerce of Pacific Coast, Inc. 2433 | 1973-06-12 | German-American Chamber of Commerce of Pacific Coast, Inc. | 465 California Street | San Francisco | CA | 94104 | |
3400 | 3400 | 1980-01-08 | 1972-01-14 | Fanning | Branwell D. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3401 | 3401 | 1980-01-08 | 1972-01-14 | Gleason | William E. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3402 | 3402 | 1980-01-08 | 1972-01-14 | McKean | Suzanne L. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3403 | 3403 | 1980-01-08 | 1972-01-14 | Winslow | David C. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
35086 | 35086 | 1966-11-02 | 1964-12-03 | Calhoun | Alexander Dewey , Jr. | Graham, James & Rolph 1825 | 1964-12-03 | Graham, James & Rolph | 310 Sansome Street | San Francisco | CA | 94104 | |
35087 | 35087 | 1966-11-02 | 1964-12-03 | Fleischmann | Roger J. | Graham, James & Rolph 1825 | 1964-12-03 | Graham, James & Rolph | 310 Sansome Street | San Francisco | CA | 94104 | |
41837 | 41837 | 2012-12-31 | 2012-09-14 | Maloney | Kevin | Grayling Connecting Point, LLC 6133 | 2012-09-14 | Grayling Connecting Point, LLC | 665 Third Street | San Francisco | CA | 94107 | |
41838 | 41838 | 2012-12-31 | 2012-09-14 | Sunnak | Ravi | Grayling Connecting Point, LLC 6133 | 2012-09-14 | Grayling Connecting Point, LLC | 665 Third Street | San Francisco | CA | 94107 | |
41844 | 41844 | 2012-12-31 | 2012-09-25 | Nolan | Kevin | Grayling Connecting Point, LLC 6133 | 2012-09-14 | Grayling Connecting Point, LLC | 665 Third Street | San Francisco | CA | 94107 | |
5045 | 5045 | 1990-01-31 | 1990-01-25 | Brown | Joanne | Hi-Tech Public Relations, Inc. 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
5046 | 5046 | 1990-01-31 | 1990-01-25 | Lewis | Dennis | Hi-Tech Public Relations, Inc. 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
5047 | 5047 | 1990-01-31 | 1990-01-25 | Wong | Fay | Hi-Tech Public Relations, Inc. 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
8967 | 8967 | 1990-03-02 | 1988-12-22 | Conley | Lyle Hayden | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
9628 | 9628 | 1987-03-11 | 1982-11-18 | Ashworth | Robert A. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
14256 | 14256 | 1991-04-28 | 1988-11-18 | Fletcher | Donald M. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16667 | 16667 | 1997-05-18 | 1990-05-18 | Won | Robin N. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16668 | 16668 | 1997-05-18 | 1992-09-16 | Chung | Patrick | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16669 | 16669 | 1997-05-18 | 1988-12-15 | Minney | Yuemei | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
39066 | 39066 | 1994-12-24 | 1987-11-12 | Bechtle | Joachim R. | J.R. Bechtle & Company 4057 | 1987-11-12 | J.R. Bechtle & Company | 456 Montgomery Street | Suite 1010 | San Francisco | CA | 94104 |
899 | 899 | 2021-04-28 | La | Kellie | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
900 | 900 | 2021-04-28 | Nakanishi | Tomoaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
994 | 994 | 2023-05-09 | Hayashi | Yotetsu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1869 | 1869 | 2020-09-29 | Fast | Andrew | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1871 | 1871 | 2020-09-29 | Shiozaki | Misako | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1873 | 1873 | 2020-09-29 | Yamashita | Takanari | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2022 | 2022 | 2018-10-23 | Ferguson | William | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2023 | 2023 | 2018-10-23 | Ishibashi | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2057 | 2057 | 2020-10-29 | Ramsey | Edward | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2066 | 2066 | 2015-10-30 | Hunter | Naoco | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2067 | 2067 | 2015-10-30 | Tanaka | Mihoko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2068 | 2068 | 2017-10-30 | Tomita | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2169 | 2169 | 2022-11-14 | Ishiguro | Seiya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
3772 | 3772 | 1979-01-15 | 1976-07-15 | Matsuo | Yasuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4196 | 4196 | 1966-01-21 | 1964-11-05 | Nakano | Hideo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4919 | 4919 | 1967-01-31 | 1967-05-02 | Nakamura | Kohji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5472 | 5472 | 2013-01-31 | 2008-06-09 | Ebara | Masashi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5705 | 5705 | 1975-02-01 | 1972-03-21 | Sasaki | Jun | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
6642 | 6642 | 2021-02-11 | 2019-04-25 | Braver | Adam | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
7811 | 7811 | 2014-02-27 | 2011-05-12 | Sato | Kenji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8659 | 8659 | 1968-03-01 | 1964-11-05 | Tashiro | Nobuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8841 | 8841 | 2004-03-01 | 2002-12-31 | Nakamura | Satoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9652 | 9652 | 2002-03-11 | 2021-11-02 | Maehiro | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9791 | 9791 | 2008-03-13 | 2006-01-03 | Sone | Ichiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );