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 rowid
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Short_Form_Date (date) >30 ✖
- 1946-10-01 11
- 1977-07-22 11
- 2002-12-31 11
- 1975-08-21 9
- 2009-06-09 7
- 2019-09-20 7
- 1972-04-13 6
- 2018-05-07 6
- 2019-09-24 6
- 1963-09-03 5
- 1964-11-05 5
- 1972-08-10 5
- 1991-12-03 5
- 2018-10-23 5
- 1945-07-17 4
- 1958-06-09 4
- 1972-01-14 4
- 1972-03-21 4
- 1973-08-08 4
- 1974-06-06 4
- 1974-10-24 4
- 1975-10-30 4
- 1998-08-31 4
- 2004-12-28 4
- 2006-01-03 4
- 2016-04-28 4
- 2017-10-30 4
- 1953-01-19 3
- 1954-06-11 3
- 1962-04-23 3
- …
Registration_Number >30
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- China Books & Periodicals, Inc. 30
- Kuomintang of China 27
- Kearns International 16
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Chinese Nationalist Daily 11
- Cotton, Seligman & Ray 11
- Brunswick Group, LLC 11
- Osaka Prefectural Government, California Office 9
- Swiss National Tourist Office, San Francisco 8
- Carl Byoir, Arnold, Palmer & Noble 8
- Osaka University, San Francisco Office 8
- British Columbia House 7
- 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
- …
Registrant_Name >30
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- China Books & Periodicals, Inc. 30
- Kuomintang of China 27
- Kearns International 19
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Brunswick Group, LLC 11
- Chinese Nationalist Daily 11
- Cotton, Seligman & Ray 11
- Osaka Prefectural Government, California Office 9
- Carl Byoir, Arnold, Palmer & Noble 8
- Osaka University, San Francisco Office 8
- Swiss National Tourist Office, San Francisco 8
- British Columbia House 7
- 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
- Central News Agency of China, San Francisco Bureau 4
- Gleason Associates, Inc. 4
- L'Echo de l'Quest, Inc. 4
- Philippine Tourist & Travel Association 4
- …
State 1
- CA 514
City 1
- San Francisco · 514 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58 | 58 | 2020-01-03 | Rabinowitz | Matthew R. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
363 | 363 | 2002-02-13 | Becker | Stephan E. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
438 | 438 | 2012-02-23 | Sprague | Esther M. | Sprague, Esther Marie 6091 | 2012-02-23 | Sprague, Esther Marie | 123 Hanover Street | San Francisco | CA | 94112 | ||
439 | 439 | 2019-02-23 | Kaplan | Aryeh L. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
863 | 863 | 2015-04-24 | Moeller | Elizabeth V. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
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 | |
1334 | 1334 | 2021-06-30 | Finch | Brian | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
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 | |
2202 | 2202 | 2021-11-19 | Tsai | David J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2203 | 2203 | 2012-11-20 | Laughlin | Gregory H. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2345 | 2345 | 2019-12-03 | Fischer | Nancy A. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2360 | 2360 | 2012-12-07 | Saperstein | Craig J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2370 | 2370 | 2019-12-09 | Wall | Christopher W. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2627 | 2627 | 1985-01-01 | 1979-06-01 | Green | Marjorie | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
2716 | 2716 | 1992-01-01 | 1975-05-12 | Horner | Phyllis R. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
3103 | 3103 | 2007-01-02 | 2005-04-27 | McKamey | Jana | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
3235 | 3235 | 1990-01-05 | 1988-07-26 | Germano | Karen | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
3353 | 3353 | 1985-01-07 | 1985-01-07 | Kim | Sei Rok | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3354 | 3354 | 1985-01-07 | 1981-01-27 | Chong | Hui Sop | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3358 | 3358 | 1985-01-07 | 1978-04-11 | Lee | Soon Heung | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3359 | 3359 | 1985-01-07 | 1978-04-11 | Papesh | Michael H. | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3360 | 3360 | 1985-01-07 | 1981-10-27 | Baird | Philip | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
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 | |
3479 | 3479 | 1973-01-09 | 1964-09-01 | MacKay | Frederick Cameron | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
3504 | 3504 | 2016-01-09 | 2006-08-07 | MacLean | Matthew | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
3630 | 3630 | 2006-01-12 | 2003-05-29 | Eino | Masao | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
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 |
4328 | 4328 | 2015-01-23 | 2011-10-17 | Peterson | Charles H. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
4508 | 4508 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | Russky Kustar 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero Street | San Francisco | CA | ||
4787 | 4787 | 1965-01-30 | 1963-09-03 | Crawford | James Whitson | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4788 | 4788 | 1965-01-30 | 1963-09-03 | Hoffman | Robert P. | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4789 | 4789 | 1965-01-30 | 1963-09-03 | Hoffman | Virginia | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4800 | 4800 | 1970-01-30 | 1969-01-09 | Ito | Hidemaro | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4801 | 4801 | 1970-01-30 | 1968-05-09 | Braden | Edwin E. | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4802 | 4802 | 1970-01-30 | 1968-06-19 | Manalac | Gabriel V. , Jr. | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
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 |
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 |
5200 | 5200 | 1998-01-31 | 1997-11-12 | O'Neill | John H. , Jr. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
5207 | 5207 | 1999-01-31 | 1998-08-31 | Wilkinson | Naomi J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
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 |
5503 | 5503 | 2016-01-31 | 2006-08-07 | Cynamon | David J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
5514 | 5514 | 2017-01-31 | 2015-03-26 | Wisner | Graham G. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
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 |
5864 | 5864 | 2011-02-01 | 2009-07-31 | Stillings | Susan | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
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 |
6335 | 6335 | 2002-02-07 | 2000-07-21 | Fuentes | Rodolfo R. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
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 | ||
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 |
6806 | 6806 | 1984-02-14 | 1982-03-12 | Tiong | Koh Poh | Neptune Orient Lines, Ltd. 3345 | 1982-03-12 | Neptune Orient Lines, Ltd. | 300 Montgomery Street | Suite 540 | San Francisco | CA | 94104 |
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 |
7515 | 7515 | 1989-02-24 | 1988-07-25 | Basterl | Irene | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
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 |
7800 | 7800 | 2003-02-27 | 2002-05-31 | Shigetome | Masayo | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
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 |
8450 | 8450 | 1976-02-29 | 1975-01-31 | Carlson | Jack Jay | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
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 |
8738 | 8738 | 1981-03-01 | 1976-12-02 | Field | Sondra | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
8818 | 8818 | 1999-03-01 | 1998-07-12 | Blomquist | Eric | PBN Company 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
8819 | 8819 | 1999-03-01 | 1998-07-12 | Nathanson | Paul | PBN Company 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
8821 | 8821 | 2000-03-01 | 1997-04-21 | Fujimura | Narumi | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8832 | 8832 | 2003-03-01 | 2000-05-18 | Hara | Shigeo | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
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 |
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 | |
9244 | 9244 | 1996-03-06 | 1991-08-05 | Fujimoto | Akemi | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
9626 | 9626 | 1983-03-11 | 1979-04-27 | Yamakawa | Ryuji | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
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 | |
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 |
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 |
9700 | 9700 | 1980-03-12 | 1977-08-11 | Kong | Yap Fung | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
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 |
9799 | 9799 | 1947-03-14 | 1943-03-16 | Tobin | Richard M. | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9800 | 9800 | 1947-03-14 | 1946-04-16 | Raoul-Duval | Richard | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9801 | 9801 | 1947-03-14 | 1946-04-18 | Harrison | Maurice E. | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
10004 | 10004 | 2018-03-15 | 2016-04-28 | Chiba | Taisei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10005 | 10005 | 2018-03-15 | 2017-04-28 | Adams | Michelle | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10009 | 10009 | 2018-03-15 | 2017-10-30 | Higashihara | Keisuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10086 | 10086 | 2011-03-16 | 2008-06-09 | Sugimoto | Yasunobu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10200 | 10200 | 1979-03-18 | 1976-12-09 | Choi | Yoon Hong | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
10224 | 10224 | 1988-03-18 | 1937-01-01 | Dawson | John H. | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
10276 | 10276 | 1966-03-19 | 1964-11-05 | Takeda | Ippei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10308 | 10308 | 1992-03-19 | 1980-11-18 | Ippolito | Nancy | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
10309 | 10309 | 1992-03-19 | 1979-12-05 | Zumwalt | Pamela | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 |
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]) );