FARA_All_Registrants

List of all registrant data (active and terminated)

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

79 rows where City = "San Francisco"

View and edit SQL

Suggested facets: Business_Name, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • San Francisco · 79
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
131 1942-09-14 1947-03-14 Comite France Amerique   Jones & McAllister Streets   San Francisco CA  
282 1945-01-01 1988-01-01 Kuomintang of China   (Headquarters in America) 844 Stockton Street San Francisco CA 94108
309 1945-07-17 1947-07-17 L'Echo de l'Quest, Inc.   2448 Clay Street   San Francisco CA  
329 1945-10-12 1951-06-30 Meng, Shou-Ch'un   790 California Street   San Francisco CA 94108
373 1946-10-01 1949-12-19 Chinese Nationalist Daily   809 Sacramento Street   San Francisco CA  
458 1947-04-25 1990-09-27 Swiss National Tourist Office, San Francisco   260 Stockton Street   San Francisco CA 94108
546 1948-12-02 1949-06-03 Central News Agency of China, San Francisco Bureau   Cornell Hotel 715 Bush Street, Room 103 San Francisco CA  
563 1949-02-14 1949-02-14 Marias, Joseph Francis   461 Market Street   San Francisco CA  
671 1951-04-18 1956-08-02 Marias, Joseph Francis   461 Market Street   San Francisco CA  
702 1952-01-02 1958-07-02 Padilla, Jose G.   2953 - 22nd Street   San Francisco CA  
745 1952-11-04 1952-11-04 Kulka, Ervin   1400 McAllister Street   San Francisco CA  
750 1952-12-16 1953-12-16 Lykke-Wilkin & Associates   681 Market Street   San Francisco CA  
754 1953-01-26 1953-01-26 Russky Kustar   1200 Divisadero Street   San Francisco CA  
871 1955-02-11 1955-02-11 Free China Political Organizations   736 Grant Avenue   San Francisco CA  
1025 1957-05-13 1973-05-22 Central News Agency of China, San Francisco Bureau   681 Market Street Room 772 San Francisco CA 94105
1146 1958-06-09 1959-03-21 Conlon Associates, Ltd.   130 Bush Street   San Francisco CA  
1195 1959-01-29 1973-05-10 Philippine Tourist & Travel Association   212 Stockton Street   San Francisco CA 94108
1350 1960-04-06 1996-04-05 China Books & Periodicals, Inc.   2929 - 24th Street   San Francisco CA 94110
1543 1962-05-09 1962-11-09 Democratic & Socialist Party of China   777 Sacramento Street   San Francisco CA  
1554 1962-07-03 1969-04-11 James, Leonard Gage   310 Sansome Street   San Francisco CA 94104
1632 1963-05-24 1966-10-05 Public Relations Counselors, Inc.   68 Post Street Room 503 San Francisco CA  
1729 1964-05-13 1965-10-15 Anchor, Clifford James Anchor-Schwartzkopf Radio Productions 100 - 26th Avenue Sea Cliff San Francisco CA 94121
1782 1964-09-01 1991-07-30 British Columbia House   100 Bush Street Suite 400 San Francisco CA 94104
1813 1964-11-05   JETRO, San Francisco   575 Market Street Suite 2400 San Francisco CA 94105
1825 1964-12-03 1966-11-02 Graham, James & Rolph   310 Sansome Street   San Francisco CA 94104
1872 1965-03-18 1985-10-22 Mexican Government Tourism Office, San Francisco   50 California Street Suite 2465 San Francisco CA 94111
1914 1965-08-11 1980-12-30 Spanish National Tourist Office, San Francisco   1 Hallidie Plaza   San Francisco CA 94102
1955 1966-02-07 1969-09-23 Alianza Patriotica Nicaraguense   61 Fair Avenue   San Francisco CA 94110
2015 1967-03-14 1972-09-14 Neeson Company   704 Russ Building   San Francisco CA 94104
2030 1967-06-20 1981-06-20 Steele, Donald Dickinson International Public Relations Company, Ltd. 703 Market Street Suite 1305 San Francisco CA 94103
2048 1966-12-31 1973-04-10 Netherlands Information Service   601 California Street   San Francisco CA 94108
2091 1968-05-09 1970-01-30 Braden Toureast, Inc.   210 Post Street   San Francisco CA 94108
2211 1970-10-06 1972-07-01 B.M. Lawrence & Company   351 California Street   San Francisco CA 94104
2305 1972-01-14 1980-01-08 Gleason Associates, Inc.   251 Kearny Street   San Francisco CA 94108
2317 1972-02-15 1972-12-18 Jamaica Tourist Board, San Francisco   680 Beach Street Suite 494 San Francisco CA 94109
2335 1972-04-25 1972-08-31 Korea Tourist Service   210 Post Street Suite 1017 San Francisco CA 94108
2349 1972-07-03 2006-03-31 Japan National Tourist Organization, San Francisco   One Daniel Burnham Court Suite 250 C San Francisco CA 94109-5455
2367 1972-08-10 1984-09-05 Carl Byoir, Arnold, Palmer & Noble   181 Fremont Street Mezzanine Suite San Francisco CA 94105
2433 1973-06-12 1992-11-17 German-American Chamber of Commerce of Pacific Coast, Inc.   465 California Street   San Francisco CA 94104
2450 1973-08-09 1973-08-08 Freeman, Teilmann & Associates Public Relations   26 O'Farrell Street Suite 903 San Francisco CA 94108
2507 1974-03-25 1983-05-24 Malaysian Trade Commission   TransAmerica Pyramid Building 600 Montgomery Street, 36th Fl San Francisco CA 94111
2531 1974-08-27 1974-10-17 Kearns International   155 Sansome Street   San Francisco CA 94104
2542 1974-10-24 1979-11-05 Kearns International   155 Sansome Street   San Francisco CA 94104
2550 1974-12-06 1981-09-24 Polish Chamber of Foreign Trade   44 Montgomery Street Suite 626 San Francisco CA 94104
2628 1975-11-11 1989-11-14 Felda Marketing Corporation   C/O Graham & James 1 Maritime Plaza, 3rd Floor San Francisco CA 94111
2660 1976-02-13 1985-01-07 Korea Trade Center, San Francisco   2 Embarcadero Center Suite 660 San Francisco CA 94111
2794 1977-06-21 1977-07-31 McKee, William D.   600 Montgomery Street 12th Floor San Francisco CA 94111
2806 1977-07-11 1978-08-21 Brookes, Valentine   1 Embarcadero Center Suite 3810 San Francisco CA 94111
2813 1977-07-22 1978-07-22 Cotton, Seligman & Ray   1400 Alcoa Building 1 Maritime Plaza San Francisco CA 94111
2814 1977-07-20 1978-01-31 Denebeim, James Evert & Bruce K.   100 Montgomery Street   San Francisco CA 94104
3088 1980-02-15 1981-02-12 Bomar, Thomas H.   333 Pine Street #300   San Francisco CA 94104
3249 1981-06-18 1984-09-20 Scottish Development Agency   465 California Street Suite 1220 San Francisco CA 94104
3252 1981-06-24 1986-07-18 Ford & Vlahos   Alcoa Building 1 Maritime Plaza, Suite 1313 San Francisco CA 94111
3254 1981-07-02 1983-02-23 Ernest Beyl Public Relations, Inc.   680 Beach Street Suite 315 San Francisco CA 94109
3316 1981-12-17 1984-05-30 Sullivan, Robert J.   44 Montgomery 5th Floor San Francisco CA 94104
3345 1982-03-12 1985-04-17 Neptune Orient Lines, Ltd.   300 Montgomery Street Suite 540 San Francisco CA 94104
3377 1982-06-08 1989-12-31 Russom & Leeper   350 Pacific Avenue   San Francisco CA 94111
3421 1982-11-18 1997-05-18 Hong Kong Government (Industry Department)   130 Montgomery Street   San Francisco CA 94104
3463 1983-04-26 1988-12-30 Ernest Beyl Public Relations, Inc.   874 North Point   San Francisco CA 94109
4046 1987-09-29 1988-03-31 Nossaman, Guthner, Knox & Elliott   100 The Embarcadero 3rd Floor San Francisco CA 94105
4057 1987-11-12 1994-12-24 J.R. Bechtle & Company   456 Montgomery Street Suite 1010 San Francisco CA 94104
4173 1988-08-26 1999-03-30 TransPacific Communications & Research Company   582 Market Street Suite 602 San Francisco CA 94104
4335 1990-01-25 1990-01-31 Hi-Tech Public Relations, Inc.   444 DeHaro Street Suite 207 San Francisco CA 94107
4338 1990-02-01 1990-10-04 Lillick & Charles   2 Embarcadero Center 26th Floor San Francisco CA 94111
4443 1990-12-03 1991-12-31 Farella, Braun & Martel   235 Montgomery Street Suite 3000 San Francisco CA 94104
5026 1995-06-20 1995-12-31 Sierra Club Legal Defense Fund, Inc.   180 Montgomery Street Suite 1400 San Francisco CA 94104-4209
5174 1997-04-21 2008-10-31 Osaka Prefectural Government, California Office   332 Pine Street Suite 610 San Francisco CA 94104
5198 1997-07-31   Pillsbury Winthrop Shaw Pittman, LLP   Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
5206 1997-09-04 1998-03-31 PBN Company   3 Embarcadero Center Suite 2210 San Francisco CA 94111
5218 1997-11-18 1998-05-31 McCutchen, Doyle, Brown & Enersen, L.L.P.   3 Embarcadero Center   San Francisco CA 94111-4067
5264 1998-07-12 1999-03-01 PBN Company   Three Embarcadero Center Suite 2210 San Francisco CA 94111
5281 1998-10-26 1999-10-26 Crane, Howard C.   3825 Scott Street Apartment 301 San Francisco CA 94123
5631 2004-07-12 2016-07-31 Osaka University, San Francisco Office   44 Montgomery Street Suite 3580 San Francisco CA 94104
5664 2004-12-28 2005-12-31 Daniel J. Edelman, Inc. - San Francisco   221 Main Street Suite 1300 San Francisco CA 94105
5947 2009-07-31 2018-05-07 Brunswick Group, LLC   One Market Street 35th Floor San Francisco CA 94105
6091 2012-02-23   Sprague, Esther Marie   123 Hanover Street   San Francisco CA 94112
6133 2012-09-14 2012-12-31 Grayling Connecting Point, LLC   665 Third Street   San Francisco CA 94107
6674 2019-05-08   Hurd, James Daniel   4200 California Street #207 San Francisco CA 94118
6725 2019-09-20   Earthjustice   50 California Street Suite 500 San Francisco CA 94111

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 37.131ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history