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

22 rows where City = "London"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • - 22

City 1

  • London · 22 ✖
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
94 94   Campaign for Freedom Ltd. 2023-06-27 UNITED KINGDOM Freedom at Home and Abroad, Inc. 7288 2023-06-27 Freedom at Home and Abroad, Inc. Suite 1, 7th Floor, 50 Broadway   London    
107 107   Centre for Information Resilience 2022-11-18 UNITED KINGDOM Jankowicz, Nina 7192 2022-11-18 Jankowicz, Nina International House, 24 Holborn Viaduct   London    
440 440   London & Partners Limited 2022-09-14 UNITED KINGDOM MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 169 Union Street   London    
743 743   United Kingdom Department for Business, Energy, and Industrial Strategy 2022-08-26 UNITED KINGDOM Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 1, Victoria Street   London    
1043 1043 2022-01-01 Ennahdha Party Diaspora Group 2021-08-03 TUNISIA BCW LLC 6227 2014-06-18 BCW LLC 55 Bryanston Street Marble Arch Tower W1H London    
1882 1882 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    
2074 2074 2012-02-01 City of London (through the Latham Group) 2007-11-16 UNITED KINGDOM FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) City of London Guildhall, P.O. Box 270 London    
2075 2075 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    
2458 2458 2023-02-13 Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-28 UNITED KINGDOM HWG LLP 6831 2020-05-28 HWG LLP 3 Whitehall Place   London    
2569 2569 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    
3512 3512 2023-03-07 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    
3514 3514 2023-03-07 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    
3515 3515 2023-03-07 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    
4718 4718 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    
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    
6233 6233 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    
7291 7291 2022-05-31 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    
7552 7552 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    
9917 9917 2018-07-31 Asfari, Ayman 2018-02-05 SYRIA LB International Solutions, LLC 6210 2014-03-03 LB International Solutions, LLC     London    
11305 11305 2012-09-01 Nawaf Obaid 2011-08-11 SAUDI ARABIA Gracia, Chad 6059 2011-08-11 Gracia, Chad 68 North Row   London    
12211 12211 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    
15233 15233 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])
);