home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

512 rows where City = "San Francisco"

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 292.594ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history