FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
512 rows where City = "San Francisco"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number >30
- JETRO, San Francisco 122
- 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 122
- 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 512
City 1
- San Francisco · 512 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 24 | 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 | |
83 | 83 | 2022-01-12 | Clay | Lacy | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
326 | 326 | 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 | |
365 | 365 | 2018-02-20 | Merrifield | Jeffrey S. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
377 | 377 | 2012-02-23 | Sprague | Esther M. | Sprague, Esther Marie 6091 | 2012-02-23 | Sprague, Esther Marie | 123 Hanover Street | San Francisco | CA | 94112 | ||
379 | 379 | 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 | |
831 | 831 | 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 | |
860 | 860 | 2021-04-28 | La | Kellie | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
861 | 861 | 2021-04-28 | Nakanishi | Tomoaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1273 | 1273 | 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 | |
1367 | 1367 | 2021-07-23 | Oresman | Matthew S. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
1669 | 1669 | 2019-09-20 | Pejan | Ramin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 | |
1713 | 1713 | 2020-09-29 | Fast | Andrew | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1715 | 1715 | 2020-09-29 | Shiozaki | Misako | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1717 | 1717 | 2020-09-29 | Yamashita | Takanari | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1862 | 1862 | 2018-10-23 | Ferguson | William | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1863 | 1863 | 2018-10-23 | Ishibashi | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1902 | 1902 | 2020-10-29 | Ramsey | Edward | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1916 | 1916 | 2015-10-30 | Hunter | Naoco | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1917 | 1917 | 2015-10-30 | Tanaka | Mihoko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1918 | 1918 | 2017-10-30 | Tarutani | Noriya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1919 | 1919 | 2017-10-30 | Tomita | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1963 | 1963 | 2021-11-02 | Maehiro | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2068 | 2068 | 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 | |
2069 | 2069 | 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 | |
2215 | 2215 | 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 | |
2233 | 2233 | 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 | |
2247 | 2247 | 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 | |
2497 | 2497 | 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 |
2586 | 2586 | 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 | |
2961 | 2961 | 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 |
3091 | 3091 | 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 | |
3176 | 3176 | 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 |
3177 | 3177 | 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 |
3181 | 3181 | 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 |
3182 | 3182 | 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 |
3183 | 3183 | 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 |
3224 | 3224 | 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 | |
3225 | 3225 | 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 | |
3226 | 3226 | 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 | |
3227 | 3227 | 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 | |
3303 | 3303 | 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 |
3328 | 3328 | 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 |
3453 | 3453 | 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 |
3593 | 3593 | 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 |
4009 | 4009 | 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 |
4140 | 4140 | 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 |
4319 | 4319 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | Russky Kustar 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero Street | San Francisco | CA | ||
4589 | 4589 | 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 | |
4590 | 4590 | 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 | |
4591 | 4591 | 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 | |
4602 | 4602 | 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 | |
4603 | 4603 | 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 | |
4604 | 4604 | 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 | |
4721 | 4721 | 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 |
4847 | 4847 | 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 |
4848 | 4848 | 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 |
4849 | 4849 | 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 |
5002 | 5002 | 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 |
5009 | 5009 | 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 |
5274 | 5274 | 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 |
5305 | 5305 | 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 |
5316 | 5316 | 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 |
5497 | 5497 | 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 |
5656 | 5656 | 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 |
5772 | 5772 | 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 |
6116 | 6116 | 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 |
6378 | 6378 | 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 | ||
6379 | 6379 | 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 | ||
6420 | 6420 | 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 |
6571 | 6571 | 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 |
7026 | 7026 | 2020-02-19 | 2019-09-24 | Coleman | Daveon | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
7269 | 7269 | 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 | |
7402 | 7402 | 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 |
7555 | 7555 | 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 |
7566 | 7566 | 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 |
8195 | 8195 | 1976-02-29 | 1975-01-31 | Carlson | Jack Jay | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
8404 | 8404 | 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 |
8483 | 8483 | 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 | |
8563 | 8563 | 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 |
8564 | 8564 | 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 |
8566 | 8566 | 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 |
8577 | 8577 | 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 |
8586 | 8586 | 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 |
8701 | 8701 | 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 | |
8976 | 8976 | 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 |
9338 | 9338 | 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 |
9340 | 9340 | 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 | |
9380 | 9380 | 2020-03-11 | 2019-09-20 | Tauber | Jill | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
9407 | 9407 | 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 |
9498 | 9498 | 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 |
9506 | 9506 | 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 | ||
9507 | 9507 | 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 | ||
9508 | 9508 | 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 | ||
9709 | 9709 | 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 |
9710 | 9710 | 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 |
9714 | 9714 | 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 |
9788 | 9788 | 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 |
9901 | 9901 | 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 |
9925 | 9925 | 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 |
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]) );