List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

10 rows where City = "Abu Dhabi" sorted by rowid descending

View and edit SQL

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

State

  • - 10

Country/Location_Represented

City

  • Abu Dhabi · 10
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
16385 2020-12-31 National Media Council of the United Arab Emirates 2017-10-06 UNITED ARAB EMIRATES 6472 6472 2017-10-06 Project Associates UK Ltd Al Muroor Street P.O. Box 3790 Abu Dhabi    
16306 2017-12-31 Abu Dhabi Investment Authority 2009-07-31 UNITED ARAB EMIRATES 5947 5947 2009-07-31 Brunswick Group, LLC 211 Corniche, PO Box 3600   Abu Dhabi    
16212 2011-12-31 U.A.E. Embassy 2007-01-22 UNITED ARAB EMIRATES 5785 5785 2007-01-22 U.S. - Emirates Alliance, LLC P.O. Box 4442   Abu Dhabi    
15015 2006-12-30 United Arab Emirates 2005-05-10 UNITED ARAB EMIRATES 2165 2165 1969-10-09 Squire Patton Boggs, LLP UAE Central Bank PO Box 854   Abu Dhabi    
13071 2020-10-31 Abu Dhabi Investment Authority (ADIA) 2018-07-09 UNITED ARAB EMIRATES 6569 6569 2018-07-09 FTI Consulting LLP 211 Corniche, PO Box 3600   Abu Dhabi    
11802 2009-09-30 Abu Dhabi Future Energy Company DBA Masdar 2008-04-22 UNITED ARAB EMIRATES 3657 3657 1985-03-12 Daniel J. Edelman, Inc. P.O. Box 45005, Abu Dhabi, United Arab Emirates ADPC Administrative Building, 2nd Floor Mina Abu Dhabi    
493   Outlook Energy Investments, LLC (wholly owned by the Emirate of Abu Dhabi) 2012-12-10 UNITED ARAB EMIRATES 6144 6144 2012-12-10 Camstoll Group, LLC P.O. Box 44442   Abu Dhabi    
229   Executive Affairs Authority of Abu Dhabi 2016-11-03 UNITED ARAB EMIRATES 5478 5478 2002-03-04 Harbour Group, LLC P.O. Box 44442   Abu Dhabi    
21   Abu Dhabi Tourism and Culture Authority 2012-09-14 UNITED ARAB EMIRATES 6134 6134 2012-09-14 Department of Culture Tourism - Abu Dhabi (New York Branch) P.O. Box 94000   Abu Dhabi    
19   Abu Dhabi Investment Authority 2011-01-07 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings 211 Comiche Road, PO Box 3600   Abu Dhabi    

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