FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

56 rows where Address_1 = "Los Angeles"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 2

City 1

  • - 56
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
841 841 1982-01-01 Brazilian Consulate General, Los Angeles 1976-09-27 BRAZIL Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
1733 1733 1989-01-31 Industrial Bank of Japan, Ltd. Los Angeles Agency 1988-12-28 JAPAN Coudert Brothers 3743 1985-10-02 Coudert Brothers Los Angeles     CA  
1782 1782 1995-01-31 Australian Tourist Commission 1989-02-22 AUSTRALIA Aviso, Inc. 4220 1989-02-22 Aviso, Inc. Los Angeles     CA  
2738 2738 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
2739 2739 1981-02-24 Japan Trade Center, Agriculture and Fisheries Section 1973-03-06 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
3465 3465 1943-03-06 Consul of the Netherlands 1943-03-06 NETHERLANDS Danielson, Walter G. 180 1943-03-06 Danielson, Walter G. Los Angeles     CA  
4356 4356 1976-03-31 Brazilian Consulate General 1974-03-12 BRAZIL Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
4518 4518 1992-03-31 JETRO, Los Angeles (Japan External Trade Organization) 1988-03-08 JAPAN Productions by Hirahara 4099 1988-03-08 Productions by Hirahara Los Angeles     CA  
4618 4618 2003-03-31 Japan External Trade Organization 1992-08-10 JAPAN MS Research, Inc. 4697 1992-08-10 MS Research, Inc. Los Angeles     CA  
4948 4948 2001-04-01 Consulate General of Japan 1970-02-24 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
5023 5023 1995-04-04 APARI, Inc. 1994-08-08 PHILIPPINES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Los Angeles     CA  
5101 5101 1992-04-08 California Life Holdings, Inc. 1991-10-30 FRANCE Barrett Jr., Michael F. 4582 1991-10-30 Barrett Jr., Michael F. Los Angeles     CA  
5229 5229 1993-04-12 Korea National Tourism Corporation 1993-01-14 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
5988 5988 2000-04-30 Queensland Travel & Tourist Corporation 1994-03-08 AUSTRALIA Fontayne Group, Inc. 3752 1985-10-30 Fontayne Group, Inc. Los Angeles     CA  
6280 6280 1961-05-03 Guillermo Simo Clark, Dominican Republic 1960-11-03 DOMINICAN REPUBLIC Markheim, Irving 1407 1960-11-03 Markheim, Irving Los Angeles     CA  
6779 6779 1994-05-24 Crystal Cruises 1989-08-03 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Los Angeles     CA  
6785 6785 1994-05-24 Princess Cruises 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Los Angeles     CA  
8079 8079 1996-06-24 New California Life Holdings, Inc. 1991-08-07 FRANCE Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Los Angeles     CA  
8174 8174 1993-06-29 State of Israel, Consulate General of Israel 1991-07-25 ISRAEL Boonshaft-Lewis & Savitch Public Relations, Inc. 4548 1991-07-25 Boonshaft-Lewis & Savitch Public Relations, Inc. Los Angeles     CA  
8433 8433 1988-06-30 Victorian Tourist Commission 1987-02-10 AUSTRALIA N.W. Ayer & Son, Inc. 3411 1982-09-27 N.W. Ayer & Son, Inc. Los Angeles     CA  
9264 9264 1986-07-15 Japan Trade Center 1984-02-01 JAPAN Productions by Hirahara 3556 1984-02-01 Productions by Hirahara Los Angeles     CA  
9363 9363 1994-07-19 Australian Trade Commission (Austrade) 1988-04-04 AUSTRALIA Australian-American Public Relations, Inc. 4113 1988-04-04 Australian-American Public Relations, Inc. Los Angeles     CA  
9364 9364 1994-07-19 Queensland Government Representative Office 1988-04-04 AUSTRALIA Australian-American Public Relations, Inc. 4113 1988-04-04 Australian-American Public Relations, Inc. Los Angeles     CA  
9365 9365 1994-07-19 Victorian Tourism Commission 1988-04-04 AUSTRALIA Australian-American Public Relations, Inc. 4113 1988-04-04 Australian-American Public Relations, Inc. Los Angeles     CA  
9366 9366 1994-07-19 Western Australian Tourism Commission 1988-04-04 AUSTRALIA Australian-American Public Relations, Inc. 4113 1988-04-04 Australian-American Public Relations, Inc. Los Angeles     CA  
10188 10188 1985-08-07 Japan Trade Center, Los Angeles 1975-07-11 JAPAN InfoAid 2594 1975-07-11 InfoAid Los Angeles     CA  
10261 10261 1946-08-11 Confederation of Switzerland (Swiss Consulate) 1942-08-11 SWITZERLAND Ratzer & Bridge 88 1942-08-11 Ratzer & Bridge Los Angeles        
10681 10681 1992-08-23 German National Tourist Office, Los Angeles 1978-09-01 GERMANY Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
10684 10684 1992-08-23 India Government Tourist Office, Los Angeles 1975-02-01 INDIA Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
10688 10688 1992-08-23 Royal Danish Consulate General, Los Angeles 1974-08-13 DENMARK Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
10694 10694 1992-08-23 Tahiti Tourist Board 1976-09-27 TAHITI Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
10902 10902 1981-08-31 Air France 1970-04-27 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
10910 10910 1981-08-31 Chinese Information Service 1973-07-24 CHINA Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
10911 10911 1981-08-31 Chinese Information Service, Pacific Coast Bureau 1973-08-23 TAIWAN Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
11931 11931 1973-09-30 Japan External Trade Organization 1971-10-07 JAPAN Ruder & Finn of California, Inc. 2284 1971-10-07 Ruder & Finn of California, Inc. Los Angeles     CA  
12436 12436 1966-10-02 Consulate General of the State of Israel for the Eleven Western States 1959-02-27 ISRAEL Low & Stone 1206 1959-02-27 Low & Stone Los Angeles     CA  
12511 12511 1992-10-06 Canadian Consulate General Commercial Division - Los Angeles 1991-02-26 CANADA Read Communications 4475 1991-02-26 Read Communications Los Angeles     CA  
12677 12677 1993-10-14 New California Life Holdings, Inc. 1991-12-05 FRANCE Morgan, Lewis & Bockius, L.L.P. 3794 1986-03-12 Morgan, Lewis & Bockius, L.L.P. Los Angeles     CA  
13023 13023 1989-10-25 Malaysian Airline System 1988-04-12 MALAYSIA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13164 13164 1987-10-30 JETRO, Los Angeles 1986-09-05 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Los Angeles     CA  
13595 13595 1991-11-01 Korea National Tourism Corporation 1991-03-29 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13596 13596 1991-11-01 Korea National Tourism Corporation 1991-07-11 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13738 13738 1990-11-05 Japan Shipbuilding Industry Foundation 1990-04-17 JAPAN North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13739 13739 1990-11-05 Korea National Tourism Corporation 1990-06-21 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13740 13740 1990-11-05 Korea National Tourism Corporation 1989-12-20 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
13871 13871 1992-11-10 Korea National Tourism Corporation 1992-07-23 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate Los Angeles     CA  
14350 14350 1977-11-30 Korea National Tourism Corporation 1975-07-17 KOREA, SOUTH Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
14352 14352 1977-11-30 U.T.A. French Airlines 1970-04-27 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
14772 14772 1990-12-03 Princess Cruise Lines 1990-09-14 INTERNATIONAL Alcalde & Fay 3571 1984-03-14 Alcalde & Fay Los Angeles     CA  
15105 15105 1992-12-14 IR&D, Inc. 1991-05-28 JAPAN Steptoe & Johnson, L.L.P. 3975 1987-05-08 Steptoe & Johnson, L.L.P. Los Angeles     CA  
15123 15123 1971-12-15 Scandinavian National Travel Offices 1970-04-27 INTERNATIONAL Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
15256 15256 1993-12-20 New California Life Holdings, Inc. 1991-08-09 FRANCE Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. Los Angeles     CA  
15629 15629 1963-12-31 Yamaha International Corporation 1963-02-28 JAPAN Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. Los Angeles        
15675 15675 1970-12-31 British Travel Association 1970-05-18 GREAT BRITAIN Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Los Angeles     CA  
15936 15936 1985-12-31 Korea National Tourism Corporation, Los Angeles 1976-09-27 KOREA, SOUTH Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
16410 16410 1997-12-31 Australian Tourist Commission 1995-06-23 AUSTRALIA Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc. Los Angeles     CA  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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])
);