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

22 rows where City = "Dubai" sorted by Registration_Number

✖
✖

✎ View and edit SQL

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), Registrant_Date (date)

Country/Location_Represented 4

State 1

  • - 22

City 1

  • Dubai · 22 ✖
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
11132 11132 2009-08-31 Office of the UAE Pavilion for the Venice Biennale 2009-05-05 UNITED ARAB EMIRATES Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. P.O. Box 60478   Dubai    
3173 3173 2008-02-29 Borse Dubai Limited 2007-10-19 UNITED ARAB EMIRATES Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP P.O. Box 74777, Level 14, The Gate Dubai International Financial Centre, Dubai    
16678 16678 2010-12-31 Dubai Civil Aviation Authority 2010-01-05 UNITED ARAB EMIRATES Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 Dubai    
16681 16681 2010-12-31 Government of Dubai 2010-01-05 UNITED ARAB EMIRATES Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 Dubai    
7445 7445 2008-06-01 Borse Dubai Limited 2007-11-02 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP P.O. Box 74777, Level 14 - The Gate Dubai International Financial Centre Dubai    
13886 13886 2008-11-11 Executive Office of Dubai 2008-06-26 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Emirates Towers, Level 38 P.O. Box 73311 Dubai    
15213 15213 2008-12-18 Sheikh Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates, et al 2006-11-20 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP c/o Dr. Habib Al Mulla Emirates Towers, Level 38 - P.O. Box 73311 Dubai    
14050 14050 2016-11-17 Adalid Business Consulting DMCC 2015-09-13 IRAQ FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) Unit 305, Indigo Tower, Cluster D Emirates Hill First, Jumeriah Lake Towers Dubai    
9870 9870 2007-07-31 Dubai Aerospace Enterprise (DAE) Ltd. 2007-05-01 UNITED ARAB EMIRATES Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC Level 8 Convention Tower P.O. Box 9522 Dubai    
4953 4953 2009-04-01 Executive Office of His Highness Sheikh Mohammed Bin Rashid Al Maktoum 2007-01-19 UNITED ARAB EMIRATES Peck, Madigan, Jones & Stewart, Inc. 5776 2006-11-17 Peck, Madigan, Jones & Stewart, Inc. Dr. Habib Al Mulla Emirate Towers, Level 38, Sheikh Zayed Road P.O. Box 73311 Dubai    
1656 1656 2008-01-30 Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry for the UAE), The Executive Office (Dubai) 2007-01-25 UNITED ARAB EMIRATES Rock Creek Strategic Marketing 5787 2007-01-25 Rock Creek Strategic Marketing c/o The Executive Office Dubai Holdings P.O. Box 73311 Dubai    
12288 12288 2022-09-30 United Arab Emirates 2021-09-10 UNITED ARAB EMIRATES Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. UAE Ministry of Cabinet Affairs and the Future Government Media Office P.O. Box 2 12000 Dubai    
14018 14018 2007-11-16 Dubai Aerospace Enterprise (DAE) Ltd. 2007-05-16 UNITED ARAB EMIRATES Skadden, Arps, Slate, Meagher & Flom, LLP 5812 2007-05-16 Skadden, Arps, Slate, Meagher & Flom, LLP Level 8 - Convention Tower P.O. Box 9522 Dubai    
12806 12806 2007-10-17 Dubai Aerospace Enterprise (DAE) Ltd., (through Skadden, Arps, Slate, Meagher & Flom, LLP) 2007-07-02 UNITED ARAB EMIRATES Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. Level 8 Convention Tower P.O. Box 9522 Dubai    
4702 4702 2010-03-31 Executive Office of Dubai 2008-08-07 UNITED ARAB EMIRATES Mark Saylor Company, LLC 5827 2007-09-07 Mark Saylor Company, LLC Emirates Towers, Level 38 P.O. Box 73311 Dubai    
7221 7221 2009-05-31 Emirates 2008-11-18 UNITED ARAB EMIRATES Everson, David E. 5891 2008-11-18 Everson, David E. Emirates Group Legal Department Emirates New Group Headquarters Building Marrakesh Street P.O. Box 686 Dubai    
7239 7239 2011-05-31 Turkish Ministry of Foreign Affairs through Hill & Knowlton Dubai 2011-05-12 TURKEY Public Strategies, Inc. 5913 2009-03-05 Public Strategies, Inc. c/o Gulf Hill & Knowlton P.O Box 50653 Dubai    
5607 5607 2013-04-26 Fundo Soberano de Angola through Grayling 2013-04-17 ANGOLA Dutko Worldwide, LLC d/b/a Dutko Grayling 6166 2013-04-17 Dutko Worldwide, LLC d/b/a Dutko Grayling Office 337, BUidling 10, Dubai Media City, P.O. Box 24554   Dubai    
3154 3154 2023-02-28 Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
8941 8941 2018-07-01 Lapis Middle East and Africa 2018-04-04 UNITED ARAB EMIRATES Andreae & Associates 6371 2016-08-17 Andreae & Associates Office 401, Level 4, Building 4 Studio City Dubai    
3793 3793 2020-03-15 Expo 2020 Dubai 2019-04-26 UNITED ARAB EMIRATES Sanitas International, Inc. 6530 2018-03-07 Sanitas International, Inc. Expo Road Dubai South, Jebel Ali   Dubai    
323 323   HH Sheikh Marwan Bin Muhd. Bin Rashid Al Maktoum 2021-01-08 UNITED ARAB EMIRATES Vega Jr., Luis Angel 6905 2021-01-08 Vega Jr., Luis Angel P.O. Box 91791 United Arab Emirates Dubai    

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