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

18 rows where City = "London"

✎ 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_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

  • - 18

City 1

  • London · 18 ✖
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
61 61   Bahaa Hariri thru CT Solutions & Private Advisory Ltd. 2021-09-03 LEBANON CTF Global LLC 7008 2021-09-03 CTF Global LLC 20 Grosvenor Square W1K 6LE London    
137 137   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-19 UNITED KINGDOM Fragomen, Del Rey, Bernsen & Loewy, LLP 6827 2020-05-19 Fragomen, Del Rey, Bernsen & Loewy, LLP 3 Whitehall Place SW1A 2AW London    
139 139   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-28 UNITED KINGDOM Harris, Wiltshire & Grannis LLP 6831 2020-05-28 Harris, Wiltshire & Grannis LLP 3 Whitehall Place   London    
141 141   Department for International Trade, Government of the United Kingdom 2020-11-30 UNITED KINGDOM Sidley Austin, LLP 3731 1985-09-13 Sidley Austin, LLP 3 Whitehall Place SW1A ZAW London    
142 142   Department for International Trade, Government of the United Kingdom, through Linklaters LLP 2020-05-28 UNITED KINGDOM Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. Three Whitehall Place   London    
239 239   Ennahdha Party Diaspora Group 2021-08-03 TUNISIA BCW LLC 6227 2014-06-18 BCW LLC 55 Bryanston Street Marble Arch Tower W1H London    
1845 1845 2010-01-31 New Century Media 2010-03-25 UNITED KINGDOM JWI, LLC 4990 1995-02-06 JWI, LLC 15 Buckingham Street London WC2N 6DF London    
2034 2034 2012-02-01 City of London (through the Latham Group) 2007-11-16 UNITED KINGDOM FGH Holdings 5666 2005-01-31 FGH Holdings City of London Guildhall, P.O. Box 270 London    
2035 2035 2012-02-01 Embassy of Kazahkstan through BGR Gabara 2010-01-22 KAZAKHSTAN BGR Public Relations, LLC 5973 2010-01-22 BGR Public Relations, LLC 17 Cavendish Square   London    
2522 2522 2010-02-15 Sheikh Khalid Bin Saqr Al Qasimi through California Strategies 2009-09-30 UNITED ARAB EMIRATES Mercury Public Affairs, LLC d/b/a IGR Group 5953 2009-09-30 Mercury Public Affairs, LLC d/b/a IGR Group 6 Thornwood Gardens, Campden Hill Kensington, London    
4639 4639 2012-03-31 BGR Gabara, Ltd. (for Bidzina Ivanshvili) 2011-12-21 GEORGIA Office of Sam Patten, LLC 6081 2011-12-21 Office of Sam Patten, LLC 1 Duchess Street   London    
5938 5938 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    
6121 6121 2009-05-01 Litvinenko Justice Foundation 2008-05-30 UNITED KINGDOM AG Consulting Group, Inc. 5866 2008-05-30 AG Consulting Group, Inc. 2-6 Cannon Street EC4M 6YH London    
7409 7409 2005-06-03 Camelot Oil & Gas Development Ltd. 2005-06-03 AZERBAIJAN JWI, LLC 4990 1995-02-06 JWI, LLC 4 Princess Street Mayfair   London    
9742 9742 2018-07-31 Asfari, Ayman 2018-02-05 SYRIA LB International Solutions, LLC 6210 2014-03-03 LB International Solutions, LLC     London    
11107 11107 2012-09-01 Nawaf Obaid 2011-08-11 SAUDI ARABIA Gracia, Chad 6059 2011-08-11 Gracia, Chad 68 North Row   London    
12005 12005 2012-09-30 Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited 2011-09-19 KAZAKHSTAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 1 Red Lion Court   London    
14978 14978 2019-12-19 Tom Charles - New York Center for Foreign Policy Affairs 2019-09-04 UNITED KINGDOM Lewis Jr., Robert E.  6717 2019-09-04 Lewis Jr., Robert E. 82 Harford House Tavistock Crescent W11 1 AZ 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])
);