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

499 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

State

City

  • San Francisco · 499 ✖
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
45 45   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
178 178   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
284 284   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
311 311   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
320 320   2012-02-23 Sprague Esther M. 6091 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
323 323   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
704 704   2018-04-19 Oresman Matthew S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
720 720   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
731 731   2019-04-25 Braver Adam 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
756 756   2018-04-27 Hirokazu Shimoda 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1753 1753   2019-09-20 Brauer Gabe 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1754 1754   2019-09-20 Patriana Zarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1755 1755   2019-09-20 Pejan Ramin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1756 1756   2019-09-20 Sivaraman Bala 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1757 1757   2019-09-20 Zniber Siham 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1775 1775   2019-09-24 Brenner Sarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1776 1776   2019-09-24 Dillen Abigail 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1777 1777   2019-09-24 Wagner Martin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1784 1784   2019-09-25 Fitzsimmons Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1963 1963   2018-10-23 Ferguson William 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1964 1964   2018-10-23 Ishibashi Yuki 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2012 2012   2015-10-30 Hunter Naoco 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2013 2013   2015-10-30 Tanaka Mihoko 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2016 2016   2017-10-30 Nakazawa Norio 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2017 2017   2017-10-30 Tarutani Noriya 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2018 2018   2017-10-30 Tomita Hiroshi 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2131 2131   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
2269 2269   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
2283 2283   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
2297 2297   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
2549 2549 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
2638 2638 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
3006 3006 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
3132 3132 1990-01-05 1988-07-26 Germano Karen 1350 1350 1960-04-06 China Books & Periodicals, Inc. 2929 - 24th Street   San Francisco CA 94110
3216 3216 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
3217 3217 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
3221 3221 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
3222 3222 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
3223 3223 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
3261 3261 1980-01-08 1972-01-14 Fanning Branwell D. 2305 2305 1972-01-14 Gleason Associates, Inc. 251 Kearny Street   San Francisco CA 94108
3262 3262 1980-01-08 1972-01-14 Gleason William E. 2305 2305 1972-01-14 Gleason Associates, Inc. 251 Kearny Street   San Francisco CA 94108
3263 3263 1980-01-08 1972-01-14 McKean Suzanne L. 2305 2305 1972-01-14 Gleason Associates, Inc. 251 Kearny Street   San Francisco CA 94108
3264 3264 1980-01-08 1972-01-14 Winslow David C. 2305 2305 1972-01-14 Gleason Associates, Inc. 251 Kearny Street   San Francisco CA 94108
3338 3338 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
3363 3363 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
3482 3482 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
3616 3616 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
3993 3993 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
4122 4122 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
4301 4301 1953-01-26 1953-01-26 Feingold Jeremiah 754 754 1953-01-26 Russky Kustar 1200 Divisadero Street   San Francisco CA  
4565 4565 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  
4566 4566 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  
4567 4567 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  
4578 4578 1970-01-30 1969-01-09 Ito Hidemaro 2091 2091 1968-05-09 Braden Toureast, Inc. 210 Post Street   San Francisco CA 94108
4579 4579 1970-01-30 1968-05-09 Braden Edwin E. 2091 2091 1968-05-09 Braden Toureast, Inc. 210 Post Street   San Francisco CA 94108
4580 4580 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
4696 4696 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
4822 4822 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
4823 4823 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
4824 4824 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
4977 4977 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
4984 4984 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
5249 5249 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
5280 5280 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
5291 5291 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
5438 5438 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
5597 5597 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
5712 5712 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
6040 6040 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
6293 6293 1955-02-11 1955-02-11 Li Tsung-Jen 871 871 1955-02-11 Free China Political Organizations 736 Grant Avenue   San Francisco CA  
6294 6294 1955-02-11 1955-02-11 Wu Shang-Ying 871 871 1955-02-11 Free China Political Organizations 736 Grant Avenue   San Francisco CA  
6482 6482 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
6896 6896 2020-02-19 2019-09-24 Coleman Daveon 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
7133 7133 1989-02-24 1988-07-25 Basterl Irene 1350 1350 1960-04-06 China Books & Periodicals, Inc. 2929 - 24th Street   San Francisco CA 94110
7264 7264 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
7405 7405 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
7416 7416 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
7975 7975 1976-02-29 1975-01-31 Carlson Jack Jay 2542 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
8183 8183 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
8262 8262 1981-03-01 1976-12-02 Field Sondra 1350 1350 1960-04-06 China Books & Periodicals, Inc. 2929 - 24th Street   San Francisco CA 94110
8342 8342 1999-03-01 1998-07-12 Blomquist Eric 5264 5264 1998-07-12 PBN Company Three Embarcadero Center Suite 2210 San Francisco CA 94111
8343 8343 1999-03-01 1998-07-12 Nathanson Paul 5264 5264 1998-07-12 PBN Company Three Embarcadero Center Suite 2210 San Francisco CA 94111
8345 8345 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
8356 8356 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
8365 8365 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
8465 8465 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
8735 8735 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
9088 9088 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
9090 9090 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
9130 9130 2020-03-11 2019-09-20 Tauber Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
9156 9156 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
9247 9247 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
9254 9254 1947-03-14 1943-03-16 Tobin Richard M. 131 131 1942-09-14 Comite France Amerique Jones & McAllister Streets   San Francisco CA  
9255 9255 1947-03-14 1946-04-16 Raoul-Duval Richard 131 131 1942-09-14 Comite France Amerique Jones & McAllister Streets   San Francisco CA  
9256 9256 1947-03-14 1946-04-18 Harrison Maurice E. 131 131 1942-09-14 Comite France Amerique Jones & McAllister Streets   San Francisco CA  
9457 9457 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
9458 9458 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
9462 9462 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
9529 9529 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
9642 9642 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

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 · Query took 326.523ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history