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

6 rows where Registrant_Name = "Levick Strategic Communications"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 3

State 1

  • - 6

Registrant_Name 1

  • Levick Strategic Communications · 6 ✖
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
5025 5025 2013-04-04 Government of Antigua & Barbuda 2012-10-11 ANTIGUA & BARBUDA Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications          
6043 6043 2008-04-30 Shanfari Group of Companies 2004-12-22 OMAN Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications P.O. Box 783 Muscat Postal Code 113        
6045 6045 2008-04-30 Stolt-Nielsen S.A. 2006-08-22 GREAT BRITAIN Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications Aldwych House 71 - 91 Aldwych London    
6058 6058 2009-04-30 Trinidad and Tobago International Financial Center through AGA Group 2009-04-23 TRINIDAD AND TOBAGO Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications Eric Williams Finance Building Independence Square Port of Spain    
10542 10542 2008-08-15 Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai) 2007-02-28 UNITED ARAB EMIRATES Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications          
16696 16696 2011-12-31 International Counsel Bureau on behalf of Kuwaiti Detainees Committee 2004-10-08 KUWAIT Levick Strategic Communications 5649 2004-10-08 Levick Strategic Communications P.O Box 0941 Safat        

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