home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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 = "Abu Dhabi"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 14

  • Daniel J. Edelman, Inc. 2
  • APCO Worldwide LLC 1
  • BCW LLC 1
  • Brunswick Group, LLC 1
  • Camstoll Group, LLC 1
  • Department of Culture Tourism - Abu Dhabi (New York Branch) 1
  • Development Counsellors International 1
  • FGS Global (US) LLC (FKA FGH Holdings LLC) 1
  • FTI Consulting LLP 1
  • Fleishman-Hillard, Inc. 1
  • Harbour Group, LLC 1
  • Project Associates UK Ltd 1
  • Squire Patton Boggs, LLP 1
  • U.S. - Emirates Alliance, LLC 1

Foreign_Principal 14

  • Abu Dhabi Investment Authority 2
  • Abu Dhabi Future Energy Company DBA Masdar 1
  • Abu Dhabi Future Energy Company PJSC - Masdar 1
  • Abu Dhabi Investment Authority (ADIA) 1
  • Abu Dhabi Tourism and Culture Authority 1
  • Department of Culture and Tourism - Abu Dhabi 1
  • Executive Affairs Authority of Abu Dhabi 1
  • Museum of the Future LLC 1
  • National Media Council of the United Arab Emirates 1
  • Office of United Arab (UAE) Climate Change Special Envoy 1
  • Outlook Energy Investments, LLC (wholly owned by the Emirate of Abu Dhabi) 1
  • Technology Innovation Institute Sole Proprietorship LLC 1
  • U.A.E. Embassy 1
  • United Arab Emirates 1

State 1

  • - 15

Country/Location_Represented 1

  • UNITED ARAB EMIRATES 15

City 1

  • Abu Dhabi · 15 ✖
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
26 26   Abu Dhabi Future Energy Company PJSC - Masdar 2023-01-17 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. P.O. Box 54115, Khalifa A City, Opposite President Flight   Abu Dhabi    
142 142   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    
546 546   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    
680 680   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    
1045 1045 2022-01-01 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    
4815 4815 2022-03-31 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    
6253 6253 2022-05-01 Museum of the Future LLC 2022-02-11 UNITED ARAB EMIRATES Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. United Arab Emirates Space Agency Masdar City Abu Dhabi    
12188 12188 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    
13188 13188 2019-10-30 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    
13506 13506 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    
15504 15504 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    
16701 16701 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    
16795 16795 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    
16880 16880 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    
16916 16916 2022-12-31 Abu Dhabi Investment Authority 2011-01-07 UNITED ARAB EMIRATES FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) 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])
);
Powered by Datasette · Queries took 412.92ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history