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

19 rows where City = "Dubai"

View and edit SQL

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

Country/Location_Represented

State

  • 19

City

  • Dubai · 19
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
1545 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 5787 5787 2007-01-25 Rock Creek Strategic Marketing c/o The Executive Office Dubai Holdings P.O. Box 73311 Dubai    
2996 2008-02-29 Borse Dubai Limited 2007-10-19 UNITED ARAB EMIRATES 2244 2244 1971-02-18 Hogan Lovells US LLP P.O. Box 74777, Level 14, The Gate Dubai International Financial Centre, Dubai    
3590 2020-03-15 Expo 2020 Dubai 2019-04-26 UNITED ARAB EMIRATES 6530 6530 2018-03-07 Sanitas International, Inc. Expo Road Dubai South, Jebel Ali   Dubai    
4487 2010-03-31 Executive Office of Dubai 2008-08-07 UNITED ARAB EMIRATES 5827 5827 2007-09-07 Mark Saylor Company, LLC Emirates Towers, Level 38 P.O. Box 73311 Dubai    
4707 2009-04-01 Executive Office of His Highness Sheikh Mohammed Bin Rashid Al Maktoum 2007-01-19 UNITED ARAB EMIRATES 5776 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    
5330 2013-04-26 Fundo Soberano de Angola through Grayling 2013-04-17 ANGOLA 6166 6166 2013-04-17 Dutko Worldwide, LLC d/b/a Dutko Grayling Office 337, BUidling 10, Dubai Media City, P.O. Box 24554   Dubai    
6893 2009-05-31 Emirates 2008-11-18 UNITED ARAB EMIRATES 5891 5891 2008-11-18 Everson, David E. Emirates Group Legal Department Emirates New Group Headquarters Building Marrakesh Street P.O. Box 686 Dubai    
6911 2011-05-31 Turkish Ministry of Foreign Affairs through Hill & Knowlton Dubai 2011-05-12 TURKEY 5913 5913 2009-03-05 Public Strategies, Inc. c/o Gulf Hill & Knowlton P.O Box 50653 Dubai    
7099 2008-06-01 Borse Dubai Limited 2007-11-02 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 74777, Level 14 - The Gate Dubai International Financial Centre Dubai    
8547 2018-07-01 Lapis Middle East and Africa 2018-04-04 UNITED ARAB EMIRATES 6371 6371 2016-08-17 Andreae & Associates Office 401, Level 4, Building 4 Studio City Dubai    
9454 2007-07-31 Dubai Aerospace Enterprise (DAE) Ltd. 2007-05-01 UNITED ARAB EMIRATES 5753 5753 2006-06-01 Quinn Gillespie & Associates, LLC Level 8 Convention Tower P.O. Box 9522 Dubai    
10679 2009-08-31 Office of the UAE Pavilion for the Venice Biennale 2009-05-05 UNITED ARAB EMIRATES 1481 1481 1961-09-27 Ruder Finn, Inc. P.O. Box 60478   Dubai    
12251 2007-10-17 Dubai Aerospace Enterprise (DAE) Ltd., (through Skadden, Arps, Slate, Meagher & Flom, LLP) 2007-07-02 UNITED ARAB EMIRATES 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. Level 8 Convention Tower P.O. Box 9522 Dubai    
13295 2008-11-11 Executive Office of Dubai 2008-06-26 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Emirates Towers, Level 38 P.O. Box 73311 Dubai    
13423 2007-11-16 Dubai Aerospace Enterprise (DAE) Ltd. 2007-05-16 UNITED ARAB EMIRATES 5812 5812 2007-05-16 Skadden, Arps, Slate, Meagher & Flom, LLP Level 8 - Convention Tower P.O. Box 9522 Dubai    
13455 2016-11-17 Adalid Business Consulting DMCC 2015-09-13 IRAQ 5666 5666 2005-01-31 Glover Park Group, LLC Unit 305, Indigo Tower, Cluster D Emirates Hill First, Jumeriah Lake Towers Dubai    
14578 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 3712 3712 1985-08-05 DLA Piper US LLP c/o Dr. Habib Al Mulla Emirates Towers, Level 38 - P.O. Box 73311 Dubai    
16033 2010-12-31 Dubai Civil Aviation Authority 2010-01-05 UNITED ARAB EMIRATES 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 Dubai    
16036 2010-12-31 Government of Dubai 2010-01-05 UNITED ARAB EMIRATES 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP The Government of Dubai Legal Affairs Department Board P.O. Box 446 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)
);
Powered by Datasette · Query took 161.662ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history