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

13 rows where City = "Abu Dhabi"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • - 13

Country/Location_Represented 1

City 1

  • Abu Dhabi · 13 ✖
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
21 21   Abu Dhabi Investment Authority 2011-01-07 UNITED ARAB EMIRATES FGH Holdings 5666 2005-01-31 FGH Holdings 211 Comiche Road, PO Box 3600   Abu Dhabi    
22 22   Abu Dhabi Tourism and Culture Authority 2012-09-14 UNITED ARAB EMIRATES Department of Culture Tourism - Abu Dhabi (New York Branch) 6134 2012-09-14 Department of Culture Tourism - Abu Dhabi (New York Branch) P.O. Box 94000   Abu Dhabi    
147 147   Department of Culture and Tourism - Abu Dhabi 2021-10-29 UNITED ARAB EMIRATES Development Counsellors International 4777 1993-03-12 Development Counsellors International Nation Towers Offices, Corniche P,O. Box 94000 Abu Dhabi    
253 253   Executive Affairs Authority of Abu Dhabi 2016-11-03 UNITED ARAB EMIRATES Harbour Group, LLC 5478 2002-03-04 Harbour Group, LLC P.O. Box 44442   Abu Dhabi    
536 536   Office of United Arab (UAE) Climate Change Special Envoy 2021-12-13 UNITED ARAB EMIRATES BCW LLC 6227 2014-06-18 BCW LLC Abu Dhabi National Oil Company Headquarters Building Corniche Road Abu Dhabi    
542 542   Outlook Energy Investments, LLC (wholly owned by the Emirate of Abu Dhabi) 2012-12-10 UNITED ARAB EMIRATES Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC P.O. Box 44442   Abu Dhabi    
676 676   Technology Innovation Institute Sole Proprietorship LLC 2021-10-20 UNITED ARAB EMIRATES APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC P.O.Box 9639 Masdar City Abu Dhabi    
11922 11922 2009-09-30 Abu Dhabi Future Energy Company DBA Masdar 2008-04-22 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 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    
13206 13206 2020-10-31 Abu Dhabi Investment Authority (ADIA) 2018-07-09 UNITED ARAB EMIRATES FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 211 Corniche, PO Box 3600   Abu Dhabi    
15163 15163 2006-12-30 United Arab Emirates 2005-05-10 UNITED ARAB EMIRATES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP UAE Central Bank PO Box 854   Abu Dhabi    
16360 16360 2011-12-31 U.A.E. Embassy 2007-01-22 UNITED ARAB EMIRATES U.S. - Emirates Alliance, LLC 5785 2007-01-22 U.S. - Emirates Alliance, LLC P.O. Box 4442   Abu Dhabi    
16454 16454 2017-12-31 Abu Dhabi Investment Authority 2009-07-31 UNITED ARAB EMIRATES Brunswick Group, LLC 5947 2009-07-31 Brunswick Group, LLC 211 Corniche, PO Box 3600   Abu Dhabi    
16538 16538 2020-12-31 National Media Council of the United Arab Emirates 2017-10-06 UNITED ARAB EMIRATES Project Associates UK Ltd 6472 2017-10-06 Project Associates UK Ltd Al Muroor Street P.O. Box 3790 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])
);