home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for 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

355 rows where State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City >30

  • Los Angeles 110
  • San Francisco 80
  • Sacramento 13
  • Beverly Hills 10
  • San Diego 10
  • Sunnyvale 6
  • Oakland 5
  • Palo Alto 5
  • San Jose 5
  • Anaheim 4
  • Hollywood 4
  • Pasadena 4
  • Torrance 4
  • La Jolla 3
  • Northridge 3
  • Santa Monica 3
  • Van Nuys 3
  • West Covina 3
  • Alameda 2
  • Burbank 2
  • Chatsworth 2
  • Culver City 2
  • Fresno 2
  • Glendale 2
  • Long Beach 2
  • Los Altos 2
  • Sausalito 2
  • South San Francisco 2
  • Temple City 2
  • West Hollywood 2
  • …

Address_1 >30

  • 2029 Century Park East 3
  • 350 South Figueroa Street 3
  • 3550 Wilshire Boulevard 3
  • 611 North Larchmont Boulevard 3
  • 625 South Kingsley Drive 3
  • 11601 Wilshire Boulevard 2
  • 13940 Sherman Way 2
  • 155 Sansome Street 2
  • 1773 W. San Bernardino Road 2
  • 2 Embarcadero Center 2
  • 210 Post Street 2
  • 21350 Lassen Street 2
  • 250 North Canon Drive 2
  • 3 Embarcadero Center 2
  • 3055 Wilshire Boulevard 2
  • 3075 Wilshire Boulevard 2
  • 310 Sansome Street 2
  • 3440 Wilshire Boulevard 2
  • 3600 Wilshire Boulevard 2
  • 395 Oyster Point Boulevard 2
  • 44 Montgomery Street 2
  • 461 Market Street 2
  • 465 California Street 2
  • 50 California Street 2
  • 5250 Sereno Drive 2
  • 680 Beach Street 2
  • 681 Market Street 2
  • 710 Lakeway 2
  • 980 9th Street 2
  • Post Office Box 4581 2
  • …

State 1

  • CA · 355 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
42 1942-07-13 1945-07-13 Larsen-Heltborg, Arthur E.   787 Lydia Street Apartment #106 Oakland CA  
64 1942-07-27 1942-12-31 Brown, Howard C.   6404 Sunset Boulevard   Hollywood CA  
88 1942-08-11 1946-08-11 Ratzer & Bridge   311 South Spring Street   Los Angeles CA  
97 1942-08-15 1943-08-15 Gebhardt, H.A.   705 Financial Center Building 704 South Spring Street Los Angeles CA  
131 1942-09-14 1947-03-14 Comite France Amerique   Jones & McAllister Streets   San Francisco CA  
139 1942-10-08 1968-03-04 Comite Regional Sinarquista en Los Angeles   727 Camulos Street   Los Angeles CA  
174 1943-01-19 1944-07-19 Franzen, Knut Gosta   64 Pine Street   San Franciso CA  
180 1943-03-06 1943-03-06 Danielson, Walter G.   836 Title Insurance Building 433 South Spring Street Los Angeles CA  
207 1943-09-13 1946-05-05 Korean National Revolutionary Party, Los Angeles   955 West Jefferson Street   Los Angeles CA  
219 1943-10-29 1943-10-29 Min Joong Dai Hoi Korean People's Convention 1415 West 37th Street   Los Angeles CA  
257 1944-05-26 1951-11-26 Rojas, Jose Cleofas   721 Summer Street   Bakersfield CA  
260 1944-06-12 1954-12-31 Gallagher, Michael D.   542 South Broadway Suite 5 Los Angeles CA  
266 1944-06-20 1945-12-20 Korean Independence   955 West Jefferson Boulevard   Los Angeles CA  
282 1945-01-01 1988-01-01 Kuomintang of China   (Headquarters in America) 844 Stockton Street San Francisco CA 94108
292 1945-02-21 1945-06-08 Gantkowski, Romuald   4969 Sunset Boulevard   Hollywood CA  
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
363 1946-07-03 1946-10-09 American Friends of Miguel Aleman   3128 East 1st Street   Los Angeles CA  
367 1946-08-16 1960-02-16 Union Nacional Sinarquista, Inc.   120 North 10th Street   Montebello CA  
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
522 1948-04-13 1948-04-13 Executive Research, Inc., California   1151 South Broadway   Los Angeles CA  
531 1948-06-29 1948-11-05 Grzebieniowska, Xenia Zytomirska   1845 Berryman Street   Berkeley CA  
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  
608 1950-01-27 1955-07-27 Strong, William   215 West Fifth Street Room 923 Chester Williams Building Beverly Hills CA 00000
609 1950-02-01 1958-08-01 Goldstein, Gustave Louis   453 South Spring Street   Los Angeles CA  
639 1950-08-22 1977-05-23 Netherlands Chamber of Commerce in the U.S.   350 South Figueroa Street Suite 901 Los Angeles CA 90017
647 1950-11-01 1950-12-15 Latta & Company   448 South Hill Street   Los Angeles CA  
671 1951-04-18 1956-08-02 Marias, Joseph Francis   461 Market Street   San Francisco CA  
672 1951-04-23 1992-06-30 New Zealand Central Reservations Office   6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
702 1952-01-02 1958-07-02 Padilla, Jose G.   2953 - 22nd Street   San Francisco CA  
725 1952-05-12 1958-05-12 Kracik, Jarmila   1236-1/4 North Fuller Avenue   Hollywood 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  
793 1953-10-21 1992-10-13 Austrian Trade Commission, Los Angeles   11601 Wilshire Boulevard Suite 2420 Los Angeles CA 90025
810 1954-01-05 1995-07-05 Charles von Loewenfeldt, Inc.   17 Eagle Rock Road   Mill Valley CA 94941
871 1955-02-11 1955-02-11 Free China Political Organizations   736 Grant Avenue   San Francisco CA  
880 1955-03-23 1955-09-02 Cheesman, Frank Albert   7562 Tulare Avenue   Buena Park CA  
881 1955-03-23 1955-03-23 Lee Jr., Lawrence Dewey   1110 West Glenoaks Boulevard   Glendale 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
1032 1957-06-03   Tourism Australia   2029 Century Park East Suite 3150 Los Angeles CA 90067
1070 1957-08-09 1957-08-09 Davod, Mohammed Sulieman   8401 Quartz Avenue   Southgate CA  
1138 1958-04-28 1960-04-30 Rosell, Charles William Charles W. Rosell & Company Post Office Box 484   Pasadena CA  
1146 1958-06-09 1959-03-21 Conlon Associates, Ltd.   130 Bush Street   San Francisco CA  
1154 1958-07-01 1959-01-01 Danielson, George E.   403 Subway Terminal Building   Los Angeles CA  
1195 1959-01-29 1973-05-10 Philippine Tourist & Travel Association   212 Stockton Street   San Francisco CA 94108
1206 1959-02-27 1966-10-02 Low & Stone   8840 Olympic Boulevard   Beverly Hills CA  
1266 1959-09-08 1960-03-15 Rona Travel Bureau, Inc.   3459 West Sixth Street   Los Angeles CA  
1274 1959-09-25 1960-03-25 Safaritours, Inc.   7755 Sunset Boulevard   Hollywood CA  
1275 1959-09-25 1960-03-25 Chase Travel Service   224 South Brand   Glendale CA  
1276 1959-09-25 1989-12-31 New South Wales Government Office   2049 Century Park, East Suite 2250 Los Angeles CA 90067
1298 1959-11-20 1961-11-20 Braun & Company   625 South Kingsley Drive   Los Angeles CA  
1330 1960-02-16 1961-02-16 Nationalistic Revolutionary Movement for Liberation, D. Rep.   6523 Celia Vista Drive   San Diego CA  
1350 1960-04-06 1996-04-05 China Books & Periodicals, Inc.   2929 - 24th Street   San Francisco CA 94110
1407 1960-11-03 1961-05-03 Markheim, Irving   4055 Wilshire Boulevard Suite 310 Los Angeles CA  
1470 1961-08-03 1974-03-12 Brown, Charles H.   10100 Santa Monica Boulevard Suite 1600 Los Angeles CA 90067
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
1612 1963-03-26 1965-04-12 Frente Civico Mexicano de Afirmacion Revolucionaria   4620 Beverly Boulevard   Los Angeles CA  
1630 1963-05-23 1969-03-31 John A. Tetley Company, Inc.   3075 Wilshire Boulevard   Los Angeles CA 90005
1632 1963-05-24 1966-10-05 Public Relations Counselors, Inc.   68 Post Street Room 503 San Francisco CA  
1649 1963-04-05 1963-10-05 Rogers & Cowan, Inc.   250 North Canon Drive   Beverly Hills CA  
1729 1964-05-13 1965-10-15 Anchor, Clifford James Anchor-Schwartzkopf Radio Productions 100 - 26th Avenue Sea Cliff San Francisco CA 94121
1737 1964-05-19 1966-11-28 Bernie Klein Technical Advertising, Inc.   22715 Ventura Boulevard   Woodland Hills CA 91364
1763 1964-06-19 1984-01-25 Lewis Company, Ltd.   650 North Bronson Avenue   Los Angeles CA 90004
1773 1964-07-23 1966-07-29 Mull Jr., Archibald Marison   Citizens Bank Building 715 Crocker Sacramento CA 95814
1782 1964-09-01 1991-07-30 British Columbia House   100 Bush Street Suite 400 San Francisco CA 94104
1784 1964-09-01 1969-04-15 Compagnie des Bauxites de Guinea   19200 South Western Avenue   Torrance CA 90509
1799 1964-10-06 1966-04-05 Bretz, Rudy   Nat'l. Ed. Sciences Corp. 1360 S. Anaheim Boulevard #203 Anaheim CA 92805
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
1833 1964-12-14   JETRO, Los Angeles   777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1849 1965-02-02 1966-02-15 Kennedy, King   8923 Sunset Boulevard   Los Angeles CA 90069
1866 1965-03-10 1985-10-22 Mexican Government Tourism Office, San Diego   600 B Street Suite 1212 San Diego CA 92101
1869 1965-03-16 1976-12-31 Mexican Ministry of Tourism, Los Angeles   3106 Wilshire Boulevard   Los Angeles CA 90010
1872 1965-03-18 1985-10-22 Mexican Government Tourism Office, San Francisco   50 California Street Suite 2465 San Francisco CA 94111
1884 1965-04-19 2018-12-31 Italian Government Tourist Board (ENIT), Los Angeles   10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024
1891 1965-05-13 1965-05-13 Fred W. Johnson & Company   3860 Crenshaw Boulevard Suite 213 Los Angeles CA 90008
1914 1965-08-11 1980-12-30 Spanish National Tourist Office, San Francisco   1 Hallidie Plaza   San Francisco CA 94102
1933 1965-10-27 1966-06-29 Rogers & Cowan, Inc.   250 North Canon Drive   Beverly Hills CA  
1955 1966-02-07 1969-09-23 Alianza Patriotica Nicaraguense   61 Fair Avenue   San Francisco CA 94110
1969 1966-03-18 1980-12-31 Chinese Information Service, Pacific Coast Bureau   3440 Wilshire Boulevard Suite 1108 Los Angeles CA 90010
1976 1966-04-25 1966-06-09 Sturges and Associates   1407 Industrial Road   San Carlos CA 00000
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
2078 1968-03-14 1970-09-18 Robert S. Goldstein Enterprises   13940 Sherman Way   Van Nuys CA 91405
2091 1968-05-09 1970-01-30 Braden Toureast, Inc.   210 Post Street   San Francisco CA 94108
2103 1968-09-06 1970-09-18 Goldstein, Robert S.   13940 Sherman Way   Van Nuys CA  
2110 1968-10-29   Hong Kong Tourism Board   5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
2129 1969-04-17 1969-07-30 Marsteller, Inc.   3600 Wilshire Boulevard   Los Angeles CA 90005
2178 1969-12-19   Tourism Authority of Thailand, Los Angeles   611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2185 1970-01-22 1972-01-22 Linkletter, Jack   2192 Dupont Drive Suite 204 Irvine CA 92664
2190 1970-02-24 2001-04-01 Whitehouse Associates, Inc. Japan Steel Information Center 523 West Sixth Street Suite 804 Los Angeles CA 90014-1222
2199 1970-06-09 1992-01-13 Greek National Tourist Organization, Los Angeles   611 West Sixth Street Suite 2198 Los Angeles CA 90017
2208 1970-09-03 1972-03-02 Frojen Advertising, Inc.   2500 Wilshire Boulevard Suite 500 Los Angeles CA 90057
2209 1970-09-08 2010-06-30 Mexican Tourism Board   2401 West 6th Street   Los Angeles CA 90057
2211 1970-10-06 1972-07-01 B.M. Lawrence & Company   351 California Street   San Francisco CA 94104

Next page

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