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

12 rows where City = "London"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

  • 12

City

  • London · 12 ✖
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
663 663   Tom Charles - New York Center for Foreign Policy Affairs 2019-09-04 UNITED KINGDOM 6717 6717 2019-09-04 Lewis Jr., Robert E. 82 Harford House Tavistock Crescent W11 1 AZ London    
1781 1781 2010-01-31 New Century Media 2010-03-25 UNITED KINGDOM 4990 4990 1995-02-06 JWI, LLC 15 Buckingham Street London WC2N 6DF London    
1955 1955 2012-02-01 City of London (through the Latham Group) 2007-11-16 UNITED KINGDOM 5666 5666 2005-01-31 Glover Park Group, LLC City of London Guildhall, P.O. Box 270 London    
1956 1956 2012-02-01 Embassy of Kazahkstan through BGR Gabara 2010-01-22 KAZAKHSTAN 5973 5973 2010-01-22 BGR Public Relations, LLC 17 Cavendish Square   London    
2428 2428 2010-02-15 Sheikh Khalid Bin Saqr Al Qasimi through California Strategies 2009-09-30 UNITED ARAB EMIRATES 5953 5953 2009-09-30 Mercury Public Affairs, LLC d/b/a IGR Group 6 Thornwood Gardens, Campden Hill Kensington, London    
4487 4487 2012-03-31 BGR Gabara, Ltd. (for Bidzina Ivanshvili) 2011-12-21 GEORGIA 6081 6081 2011-12-21 Office of Sam Patten, LLC 1 Duchess Street   London    
5727 5727 2008-04-30 Stolt-Nielsen S.A. 2006-08-22 GREAT BRITAIN 5649 5649 2004-10-08 Levick Strategic Communications Aldwych House 71 - 91 Aldwych London    
5896 5896 2009-05-01 Litvinenko Justice Foundation 2008-05-30 UNITED KINGDOM 5866 5866 2008-05-30 AG Consulting Group, Inc. 2-6 Cannon Street EC4M 6YH London    
7150 7150 2005-06-03 Camelot Oil & Gas Development Ltd. 2005-06-03 AZERBAIJAN 4990 4990 1995-02-06 JWI, LLC 4 Princess Street Mayfair   London    
9439 9439 2018-07-31 Asfari, Ayman 2018-02-05 SYRIA 6210 6210 2014-03-03 LB International Solutions, LLC     London    
10758 10758 2012-09-01 Nawaf Obaid 2011-08-11 SAUDI ARABIA 6059 6059 2011-08-11 Gracia, Chad 68 North Row   London    
11634 11634 2012-09-30 Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited 2011-09-19 KAZAKHSTAN 6064 6064 2011-09-19 Portland PR Inc. 1 Red Lion Court   London    

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