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

21 rows where City = "Dubai"

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

Country/Location_Represented

State

  • - 21

City

  • Dubai · 21 ✖
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
133 133   Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES 6212 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
301 301   HH Sheikh Marwan Bin Muhd. Bin Rashid Al Maktoum 2021-01-08 UNITED ARAB EMIRATES 6905 6905 2021-01-08 Vega Jr., Luis Angel P.O. Box 91791 United Arab Emirates Dubai    
1539 1539 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    
3009 3009 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    
3606 3606 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    
4505 4505 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    
4736 4736 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    
5369 5369 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    
6941 6941 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    
6959 6959 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    
7148 7148 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    
8603 8603 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    
9515 9515 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    
10750 10750 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    
12353 12353 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    
13406 13406 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    
13535 13535 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    
13567 13567 2016-11-17 Adalid Business Consulting DMCC 2015-09-13 IRAQ 5666 5666 2005-01-31 FGH Holdings Unit 305, Indigo Tower, Cluster D Emirates Hill First, Jumeriah Lake Towers Dubai    
14702 14702 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    
16157 16157 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    
16160 16160 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)
);