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

16 rows where City = "Los Angeles" and State = "CA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)

Country/Location_Represented 10

State 1

City 1

  • Los Angeles · 16 ✖
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
330 330   Hong Kong Tourism Board 2020-10-29 HONG KONG Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 5901 W. Century Boulevard Suite 650 Los Angeles CA 90045
354 354   Iranian Resurgent Party 2021-03-10 IRAN Iranian Resurgent Party I.R.P. 6934 2021-03-10 Iranian Resurgent Party I.R.P. 6603 Independence Ave.   Los Angeles CA 91303
1028 1028 2016-01-01 Tourism Australia 2012-09-05 AUSTRALIA Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 6100 Center Drive, Suite 1150   Los Angeles CA 90045
4754 4754 2016-03-31 Consulate General of the Republic of Azerbaijan 2009-03-09 AZERBAIJAN Tool Shed Group, LLC 5916 2009-03-09 Tool Shed Group, LLC 11766 Wilshire Boulevard Suite 1410 Los Angeles CA 90025
4800 4800 2021-03-31 Consulate General for Japan in Los Angeles 2019-04-09 JAPAN Community Partners 6659 2019-04-09 Community Partners 350 S. Grand Avenue   Los Angeles CA 90071
6250 6250 2020-05-01 Tahiti Tourisme 2019-06-26 TAHITI MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 5901 W. Century Blvd. Suite 1120   Los Angeles CA 90045
8116 8116 2018-06-26 Mr. Valerii Babych through Medowood Management, LLC 2018-03-19 UKRAINE Potomac International Partners, Inc. 6459 2017-09-08 Potomac International Partners, Inc. 5757 W Century Blvd Suite 700 Los Angeles CA 90045
8675 8675 2008-06-30 Tourism Victoria 2008-06-30 AUSTRALIA Spring O'Brien & Company, Inc. 5872 2008-06-30 Spring O'Brien & Company, Inc. 6100 Center Drive   Los Angeles CA 90045
8697 8697 2011-06-30 Hong Kong Tourism Board 2008-06-30 HONG KONG Spring O'Brien & Company, Inc. 5872 2008-06-30 Spring O'Brien & Company, Inc. 10940 Wilshire Blvd.   Los Angeles CA 90024
10608 10608 2005-08-18 Voice of Democracy 2005-07-08 EQUATORIAL GUINEA JWI, LLC 4990 1995-02-06 JWI, LLC 1185 South Keniston Avenue   Los Angeles CA 90019-1710
11095 11095 2005-08-31 Kingdom of Thailand (through the Thai Trade Center) 2006-01-27 THAILAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC c/o Tai Trade Center 611 North Larchmont Boulevard, 3rd Floor Los Angeles CA 90004
12410 12410 2010-10-01 Thai Trade Center, Los Angeles, Royal Thai Consulate General (Commercial) 2009-09-23 THAILAND Global Communicators, LLC 5817 2007-06-26 Global Communicators, LLC 611 North Larchmont Boulevard, Third Floor   Los Angeles CA 90004
12424 12424 2017-10-01 Serhey Rybalka through Meadowood Management, LLC 2017-09-08 UKRAINE Potomac International Partners, Inc. 6459 2017-09-08 Potomac International Partners, Inc. 5757 W. Century Blvd. Suite 700 Los Angeles CA 90045
12461 12461 2014-10-03 Representatives in Azerbaijan (through West Coast Connections Inc.) 2014-04-16 AZERBAIJAN Delahunt Group, LLC 6215 2014-04-16 Delahunt Group, LLC 11601 Wilshire Blvd. Suite 585 Los Angeles CA  
13487 13487 2017-10-31 Tourism Fiji 2018-04-30 FIJI Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 5777 Century Blvd, #220   Los Angeles CA 90045
16889 16889 2020-12-31 Tourism Australia 2018-04-30 AUSTRALIA Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 2029 Century Park E Ste 3150   Los Angeles CA 90067

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])
);