FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

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

14 rows where City = "Los Angeles"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

Country/Location_Represented

State

City

  • Los Angeles · 14 ✖
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
107 107   Consulate General for Japan in Los Angeles 2019-04-09 JAPAN 6659 6659 2019-04-09 Community Partners 350 S. Grand Avenue   Los Angeles CA 90071
640 640   Tahiti Tourisme 2019-06-26 TAHITI 6492 6492 2017-11-27 MMGY Global, LLC 5901 W. Century Blvd. Suite 1120   Los Angeles CA 90045
661 661   Tourism Australia 2018-04-30 AUSTRALIA 6549 6549 2018-04-30 Myriad International Marketing, LLC 2029 Century Park E Ste 3150   Los Angeles CA 90067
966 966 2016-01-01 Tourism Australia 2012-09-05 AUSTRALIA 5758 5758 2006-05-09 Ketchum Inc. NY 6100 Center Drive, Suite 1150   Los Angeles CA 90045
4524 4524 2016-03-31 Consulate General of the Republic of Azerbaijan 2009-03-09 AZERBAIJAN 5916 5916 2009-03-09 Tool Shed Group, LLC 11766 Wilshire Boulevard Suite 1410 Los Angeles CA 90025
7694 7694 2018-06-26 Mr. Valerii Babych through Medowood Management, LLC 2018-03-19 UKRAINE 6459 6459 2017-09-08 Potomac International Partners, Inc. 5757 W Century Blvd Suite 700 Los Angeles CA 90045
8252 8252 2008-06-30 Tourism Victoria 2008-06-30 AUSTRALIA 5872 5872 2008-06-30 Spring O'Brien & Company, Inc. 6100 Center Drive   Los Angeles CA 90045
8274 8274 2011-06-30 Hong Kong Tourism Board 2008-06-30 HONG KONG 5872 5872 2008-06-30 Spring O'Brien & Company, Inc. 10940 Wilshire Blvd.   Los Angeles CA 90024
10096 10096 2005-08-18 Voice of Democracy 2005-07-08 EQUATORIAL GUINEA 4990 4990 1995-02-06 JWI, LLC 1185 South Keniston Avenue   Los Angeles CA 90019-1710
10570 10570 2005-08-31 Kingdom of Thailand (through the Thai Trade Center) 2006-01-27 THAILAND 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC c/o Tai Trade Center 611 North Larchmont Boulevard, 3rd Floor Los Angeles CA 90004
11803 11803 2010-10-01 Thai Trade Center, Los Angeles, Royal Thai Consulate General (Commercial) 2009-09-23 THAILAND 5817 5817 2007-06-26 Global Communicators, LLC 611 North Larchmont Boulevard, Third Floor   Los Angeles CA 90004
11817 11817 2017-10-01 Serhey Rybalka through Meadowood Management, LLC 2017-09-08 UKRAINE 6459 6459 2017-09-08 Potomac International Partners, Inc. 5757 W. Century Blvd. Suite 700 Los Angeles CA 90045
11848 11848 2014-10-03 Representatives in Azerbaijan (through West Coast Connections Inc.) 2014-04-16 AZERBAIJAN 6215 6215 2014-04-16 Delahunt Group, LLC 11601 Wilshire Blvd. Suite 585 Los Angeles CA  
12835 12835 2017-10-31 Tourism Fiji 2018-04-30 FIJI 6549 6549 2018-04-30 Myriad International Marketing, LLC 5777 Century Blvd, #220   Los Angeles CA 90045

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