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

10 rows where City = "Abu Dhabi"

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
24   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    
25   Abu Dhabi Investment Authority 2011-01-07 UNITED ARAB EMIRATES 5666 5666 2005-01-31 Glover Park Group, LLC 211 Comiche Road, PO Box 3600   Abu Dhabi    
26   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    
225   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    
476   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    
494   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    
11692 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    
14859 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    
16056 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    
16149 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    

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)
);
Powered by Datasette · Query took 130.811ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history