FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
503 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
Registrant_Name
- JETRO, San Francisco 119
- Pillsbury Winthrop Shaw Pittman, LLP 39
- Japan National Tourist Organization, San Francisco 32
- China Books & Periodicals, Inc. 30
- Kuomintang of China 27
- Kearns International 19
- Earthjustice 14
- 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
- CA 503
City
- San Francisco · 503 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39 | 39 | 2020-01-03 | Rabinowitz | Matthew R. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
206 | 206 | 2019-01-30 | Fork | William E. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
329 | 329 | 2002-02-13 | Becker | Stephan E. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
361 | 361 | 2018-02-20 | Merrifield | Jeffrey S. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
370 | 370 | 2012-02-23 | Sprague | Esther M. | 6091 6091 | 2012-02-23 | Sprague, Esther Marie | 123 Hanover Street | San Francisco | CA | 94112 | ||
372 | 372 | 2019-02-23 | Kaplan | Aryeh L. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
692 | 692 | 2015-04-24 | Moeller | Elizabeth V. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
699 | 699 | 2019-04-25 | Braver | Adam | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
719 | 719 | 2018-04-27 | Hirokazu | Shimoda | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1520 | 1520 | 2019-09-20 | Pejan | Ramin | 6725 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 | |
1533 | 1533 | 2019-09-24 | Dillen | Abigail | 6725 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 | |
1534 | 1534 | 2019-09-24 | Wagner | Martin | 6725 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 | |
1568 | 1568 | 2020-09-29 | Fast | Andrew | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1570 | 1570 | 2020-09-29 | Shiozaki | Misako | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1573 | 1573 | 2020-09-29 | Yamashita | Takanari | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1733 | 1733 | 2018-10-23 | Ferguson | William | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1734 | 1734 | 2018-10-23 | Ishibashi | Yuki | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1782 | 1782 | 2020-10-29 | Ramsey | Edward | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1787 | 1787 | 2015-10-30 | Hunter | Naoco | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1788 | 1788 | 2015-10-30 | Tanaka | Mihoko | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1790 | 1790 | 2017-10-30 | Tarutani | Noriya | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1791 | 1791 | 2017-10-30 | Tomita | Hiroshi | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1943 | 1943 | 2012-11-20 | Laughlin | Gregory H. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2079 | 2079 | 2019-12-03 | Fischer | Nancy A. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2094 | 2094 | 2012-12-07 | Saperstein | Craig J. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2108 | 2108 | 2019-12-09 | Wall | Christopher W. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2383 | 2383 | 1985-01-01 | 1979-06-01 | Green | Marjorie | 1782 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
2472 | 2472 | 1992-01-01 | 1975-05-12 | Horner | Phyllis R. | 1350 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
2842 | 2842 | 2007-01-02 | 2005-04-27 | McKamey | Jana | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
2970 | 2970 | 1990-01-05 | 1988-07-26 | Germano | Karen | 1350 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
3055 | 3055 | 1985-01-07 | 1985-01-07 | Kim | Sei Rok | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3056 | 3056 | 1985-01-07 | 1981-01-27 | Chong | Hui Sop | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3060 | 3060 | 1985-01-07 | 1978-04-11 | Lee | Soon Heung | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3061 | 3061 | 1985-01-07 | 1978-04-11 | Papesh | Michael H. | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3062 | 3062 | 1985-01-07 | 1981-10-27 | Baird | Philip | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3100 | 3100 | 1980-01-08 | 1972-01-14 | Fanning | Branwell D. | 2305 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3101 | 3101 | 1980-01-08 | 1972-01-14 | Gleason | William E. | 2305 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3102 | 3102 | 1980-01-08 | 1972-01-14 | McKean | Suzanne L. | 2305 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3103 | 3103 | 1980-01-08 | 1972-01-14 | Winslow | David C. | 2305 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3178 | 3178 | 1973-01-09 | 1964-09-01 | MacKay | Frederick Cameron | 1782 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
3203 | 3203 | 2016-01-09 | 2006-08-07 | MacLean | Matthew | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
3327 | 3327 | 2006-01-12 | 2003-05-29 | Eino | Masao | 5174 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
3462 | 3462 | 1979-01-15 | 1976-07-15 | Matsuo | Yasuyuki | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
3845 | 3845 | 1966-01-21 | 1964-11-05 | Nakano | Hideo | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
3975 | 3975 | 2015-01-23 | 2011-10-17 | Peterson | Charles H. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
4154 | 4154 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | 754 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero Street | San Francisco | CA | ||
4420 | 4420 | 1965-01-30 | 1963-09-03 | Crawford | James Whitson | 1632 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4421 | 4421 | 1965-01-30 | 1963-09-03 | Hoffman | Robert P. | 1632 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4422 | 4422 | 1965-01-30 | 1963-09-03 | Hoffman | Virginia | 1632 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4433 | 4433 | 1970-01-30 | 1969-01-09 | Ito | Hidemaro | 2091 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4434 | 4434 | 1970-01-30 | 1968-05-09 | Braden | Edwin E. | 2091 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4435 | 4435 | 1970-01-30 | 1968-06-19 | Manalac | Gabriel V. , Jr. | 2091 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4551 | 4551 | 1967-01-31 | 1967-05-02 | Nakamura | Kohji | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4677 | 4677 | 1990-01-31 | 1990-01-25 | Brown | Joanne | 4335 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
4678 | 4678 | 1990-01-31 | 1990-01-25 | Lewis | Dennis | 4335 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
4679 | 4679 | 1990-01-31 | 1990-01-25 | Wong | Fay | 4335 4335 | 1990-01-25 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 |
4832 | 4832 | 1998-01-31 | 1997-11-12 | O'Neill | John H. , Jr. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
4839 | 4839 | 1999-01-31 | 1998-08-31 | Wilkinson | Naomi J. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
5104 | 5104 | 2013-01-31 | 2008-06-09 | Ebara | Masashi | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5135 | 5135 | 2016-01-31 | 2006-08-07 | Cynamon | David J. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
5146 | 5146 | 2017-01-31 | 2015-03-26 | Wisner | Graham G. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
5307 | 5307 | 1975-02-01 | 1972-03-21 | Sasaki | Jun | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5466 | 5466 | 2011-02-01 | 2009-07-31 | Stillings | Susan | 5947 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
5582 | 5582 | 2005-02-02 | 2004-12-28 | Truong | Autumn Tru | 5664 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
5913 | 5913 | 2002-02-07 | 2000-07-21 | Fuentes | Rodolfo R. | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
6172 | 6172 | 1955-02-11 | 1955-02-11 | Li | Tsung-Jen | 871 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
6173 | 6173 | 1955-02-11 | 1955-02-11 | Wu | Shang-Ying | 871 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
6361 | 6361 | 1984-02-14 | 1982-03-12 | Tiong | Koh Poh | 3345 3345 | 1982-03-12 | Neptune Orient Lines, Ltd. | 300 Montgomery Street | Suite 540 | San Francisco | CA | 94104 |
6798 | 6798 | 2020-02-19 | 2019-09-24 | Coleman | Daveon | 6725 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
7038 | 7038 | 1989-02-24 | 1988-07-25 | Basterl | Irene | 1350 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
7169 | 7169 | 2005-02-25 | 2004-12-28 | Lande | Rachel | 5664 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
7319 | 7319 | 2003-02-27 | 2002-05-31 | Shigetome | Masayo | 5174 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
7330 | 7330 | 2014-02-27 | 2011-05-12 | Sato | Kenji | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
7931 | 7931 | 1976-02-29 | 1975-01-31 | Carlson | Jack Jay | 2542 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
8140 | 8140 | 1968-03-01 | 1964-11-05 | Tashiro | Nobuyuki | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8219 | 8219 | 1981-03-01 | 1976-12-02 | Field | Sondra | 1350 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
8299 | 8299 | 1999-03-01 | 1998-07-12 | Blomquist | Eric | 5264 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
8300 | 8300 | 1999-03-01 | 1998-07-12 | Nathanson | Paul | 5264 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
8302 | 8302 | 2000-03-01 | 1997-04-21 | Fujimura | Narumi | 5174 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8313 | 8313 | 2003-03-01 | 2000-05-18 | Hara | Shigeo | 5174 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8322 | 8322 | 2004-03-01 | 2002-12-31 | Nakamura | Satoshi | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8422 | 8422 | 1990-03-02 | 1988-12-22 | Conley | Lyle Hayden | 3421 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
8692 | 8692 | 1996-03-06 | 1991-08-05 | Fujimoto | Akemi | 2349 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
9045 | 9045 | 1983-03-11 | 1979-04-27 | Yamakawa | Ryuji | 2349 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
9047 | 9047 | 1987-03-11 | 1982-11-18 | Ashworth | Robert A. | 3421 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
9087 | 9087 | 2020-03-11 | 2019-09-20 | Tauber | Jill | 6725 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
9113 | 9113 | 1980-03-12 | 1977-08-11 | Kong | Yap Fung | 2507 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
9204 | 9204 | 2008-03-13 | 2006-01-03 | Sone | Ichiro | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9211 | 9211 | 1947-03-14 | 1943-03-16 | Tobin | Richard M. | 131 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9212 | 9212 | 1947-03-14 | 1946-04-16 | Raoul-Duval | Richard | 131 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9213 | 9213 | 1947-03-14 | 1946-04-18 | Harrison | Maurice E. | 131 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9414 | 9414 | 2018-03-15 | 2016-04-28 | Chiba | Taisei | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9415 | 9415 | 2018-03-15 | 2017-04-28 | Adams | Michelle | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9419 | 9419 | 2018-03-15 | 2017-10-30 | Higashihara | Keisuke | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9487 | 9487 | 2011-03-16 | 2008-06-09 | Sugimoto | Yasunobu | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9600 | 9600 | 1979-03-18 | 1976-12-09 | Choi | Yoon Hong | 2660 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
9624 | 9624 | 1988-03-18 | 1937-01-01 | Dawson | John H. | 1782 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
9675 | 9675 | 1966-03-19 | 1964-11-05 | Takeda | Ippei | 1813 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9707 | 9707 | 1992-03-19 | 1980-11-18 | Ippolito | Nancy | 1350 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
9708 | 9708 | 1992-03-19 | 1979-12-05 | Zumwalt | Pamela | 1350 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) );