FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "London"
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)
Registrant_Name
- JWI, LLC 2
- AG Consulting Group, Inc. 1
- BGR Public Relations, LLC 1
- FGH Holdings 1
- Fish & Richardson P.C. 1
- Fragomen, Del Rey, Bernsen & Loewy, LLP 1
- Gracia, Chad 1
- Harris, Wiltshire & Grannis LLP 1
- LB International Solutions, LLC 1
- Levick Strategic Communications 1
- Lewis Jr., Robert E. 1
- Mercury Public Affairs, LLC d/b/a IGR Group 1
- Office of Sam Patten, LLC 1
- Portland PR Inc. 1
- Sidley Austin, LLP 1
Foreign_Principal
- Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2
- Asfari, Ayman 1
- BGR Gabara, Ltd. (for Bidzina Ivanshvili) 1
- Camelot Oil & Gas Development Ltd. 1
- City of London (through the Latham Group) 1
- Department for International Trade, Government of the United Kingdom 1
- Department for International Trade, Government of the United Kingdom, through Linklaters LLP 1
- Embassy of Kazahkstan through BGR Gabara 1
- Litvinenko Justice Foundation 1
- Nawaf Obaid 1
- New Century Media 1
- Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited 1
- Sheikh Khalid Bin Saqr Al Qasimi through California Strategies 1
- Stolt-Nielsen S.A. 1
- Tom Charles - New York Center for Foreign Policy Affairs 1
Country/Location_Represented
- UNITED KINGDOM 8
- KAZAKHSTAN 2
- AZERBAIJAN 1
- GEORGIA 1
- GREAT BRITAIN 1
- SAUDI ARABIA 1
- SYRIA 1
- UNITED ARAB EMIRATES 1
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
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) );