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

15 rows where City = "London"

Search:

descending

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
128	128		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
130	130		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
132	132		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
648	648		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
1771	1771	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
1950	1950	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
1951	1951	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
4503	4503	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
5763	5763	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
5934	5934	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
7195	7195	2005-06-03	Camelot Oil & Gas Development Ltd.	2005-06-03	AZERBAIJAN	4990 4990	1995-02-06	JWI, LLC	4 Princess Street Mayfair		London
9501	9501	2018-07-31	Asfari, Ayman	2018-02-05	SYRIA	6210 6210	2014-03-03	LB International Solutions, LLC			London
10836	10836	2012-09-01	Nawaf Obaid	2011-08-11	SAUDI ARABIA	6059 6059	2011-08-11	Gracia, Chad	68 North Row		London
11715	11715	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

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