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 = "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

  • - 16

City

  • London · 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
116 116   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-19 UNITED KINGDOM 6827 6827 2020-05-19 Fragomen, Del Rey, Bernsen & Loewy, LLP 3 Whitehall Place SW1A 2AW London    
118 118   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-28 UNITED KINGDOM 6831 6831 2020-05-28 Harris, Wiltshire & Grannis LLP 3 Whitehall Place   London    
120 120   Department for International Trade, Government of the United Kingdom 2020-11-30 UNITED KINGDOM 3731 3731 1985-09-13 Sidley Austin, LLP 3 Whitehall Place SW1A ZAW London    
121 121   Department for International Trade, Government of the United Kingdom, through Linklaters LLP 2020-05-28 UNITED KINGDOM 6830 6830 2020-05-28 Fish & Richardson P.C. Three Whitehall Place   London    
631 631   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    
1761 1761 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    
1943 1943 2012-02-01 City of London (through the Latham Group) 2007-11-16 UNITED KINGDOM 5666 5666 2005-01-31 FGH Holdings City of London Guildhall, P.O. Box 270 London    
1944 1944 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    
2425 2425 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    
4507 4507 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    
5774 5774 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    
5949 5949 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    
7217 7217 2005-06-03 Camelot Oil & Gas Development Ltd. 2005-06-03 AZERBAIJAN 4990 4990 1995-02-06 JWI, LLC 4 Princess Street Mayfair   London    
9530 9530 2018-07-31 Asfari, Ayman 2018-02-05 SYRIA 6210 6210 2014-03-03 LB International Solutions, LLC     London    
10879 10879 2012-09-01 Nawaf Obaid 2011-08-11 SAUDI ARABIA 6059 6059 2011-08-11 Gracia, Chad 68 North Row   London    
11763 11763 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)
);