List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

126 rows where Country/Location_Represented = "UNITED ARAB EMIRATES"

View and edit SQL

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

State

Country/Location_Represented

  • UNITED ARAB EMIRATES · 126
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
19   Abu Dhabi Investment Authority 2011-01-07 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings 211 Comiche Road, PO Box 3600   Abu Dhabi    
20   Abu Dhabi National Oil Company 2021-04-14 UNITED ARAB EMIRATES 6582 6582 2018-08-22 APCO Worldwide LLC P.O. Box 898 Abu Dhabi      
21   Abu Dhabi Tourism and Culture Authority 2012-09-14 UNITED ARAB EMIRATES 6134 6134 2012-09-14 Department of Culture Tourism - Abu Dhabi (New York Branch) P.O. Box 94000   Abu Dhabi    
36   Akin Gump Strauss Hauer & Feld LLP on behalf of the Embassy of the United Arab Emirates 2017-12-29 UNITED ARAB EMIRATES 6504 6504 2017-12-29 Bullpen Strategy Group, Inc. 3522 International Court, NW Suite 400 Washington DC 20008
118   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES 6200 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
130   Department of Culture and Tourism - Abu Dhabi 2020-05-20 UNITED ARAB EMIRATES 6826 6826 2020-05-20 Brunswick Group LLC PO Box 94000 Abu Dhabi      
140   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    
212   Embassy of the United Arab Emirates via Akin Gump Strauss Hauer & Feld LLP 2020-02-13 UNITED ARAB EMIRATES 6567 6567 2018-07-05 American Defense International, Inc.          
213   Embassy of the United Arab Emirates 2020-03-24 UNITED ARAB EMIRATES 6806 6806 2020-03-24 Terakeet LLC 3522 International Court, NW   Washington DC 20008
214   Embassy of the United Arab Emirates 2010-04-30 UNITED ARAB EMIRATES 5478 5478 2002-03-04 Harbour Group, LLC 3228 International Drive   Washington DC 20008
215   Embassy of the United Arab Emirates 2007-09-10 UNITED ARAB EMIRATES 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 3522 International Court, NW Suite 400 Washington DC 20008
216   Embassy of the United Arab Emirates 2018-09-27 UNITED ARAB EMIRATES 6596 6596 2018-09-27 TRG Advisory Services, LLC 3522 International Court NW   Washington    
217   Embassy of the United Arab Emirates, on behalf of Akin Gump Strauss Hauer & Feld, LLP 2019-04-29 UNITED ARAB EMIRATES 6673 6673 2019-04-29 Gilliland & McKinney International Counsellors, LLC 3522 International Court, NW Suite 400 Washington DC 20008
218   Emirate of Ras Al Khaimah 2013-04-08 UNITED ARAB EMIRATES 6162 6162 2013-04-08 Karv Communications, Inc. P.O. Box 5130 Ras Al Khaimah      
226   Executive Affairs Authority of Abu Dhabi 2016-11-03 UNITED ARAB EMIRATES 5478 5478 2002-03-04 Harbour Group, LLC P.O. Box 44442   Abu Dhabi    
275   Government of Ras Al Khaimah 2019-06-12 UNITED ARAB EMIRATES 6227 6227 2014-06-18 BCW LLC 8th Floor Business Centre 4, Wing B RAK Free Trade Zone Authority AL Nakheel Ras Al Khaimah      
305   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    
418   Mashreqbank psc 2020-08-13 UNITED ARAB EMIRATES 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 1 A1 Ghurair Centre A1 Riqqa St Deira Dubai      
489   Outlook Energy Investments, LLC (wholly owned by the Emirate of Abu Dhabi) 2012-12-10 UNITED ARAB EMIRATES 6144 6144 2012-12-10 Camstoll Group, LLC P.O. Box 44442   Abu Dhabi    
503   Permanent Mission of the United Arab Emirates to the United Nations 2019-11-21 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings Ambassador Lana Zaki Nusseibeh 3 Dag Hammarskjold Plaza      
526   RAK Media Office Government of Ras Al Khaimah United Arab Emirates 2019-04-15 UNITED ARAB EMIRATES 6663 6663 2019-04-15 Envoy Strategy Group LLC RAK City Government of Ras al Khaimah      
568   Salama bint Hamdan Al Nahyan Foundation 2020-06-09 UNITED ARAB EMIRATES 6698 6698 2019-07-08 Teneo Strategy LLC Al Mamoura A Building, Ground Floor PO Box 62086, Abu Dhabi      
689 1959-01-01 Al Joumhour 1958-11-24 UNITED ARAB EMIRATES 1073 1073 1957-10-18 Hagan, Mary Frances Damascus        
906 2006-01-01 Telecommunications Regulatory Authority of the United Arab Emirates 2005-04-14 UNITED ARAB EMIRATES 5292 5292 1998-12-16 Global USA, Inc. P.O. Box 26662 Abu Dhabi        
1101 2020-01-10 Embassy of the United Arab Emirates 2017-08-14 UNITED ARAB EMIRATES 6455 6455 2017-08-14 Hagir Elawad & Associates, LLC 3522 International Court, NW   Washington DC 20008
1153 2020-01-12 Embassy of the United Arab Emirates via Hagir Elawad & Associates, LLC (DBA UAE Strategies) 2018-07-05 UNITED ARAB EMIRATES 6567 6567 2018-07-05 American Defense International, Inc. 3522 International Court, NW #100   Washington DC 20008
1260 2012-01-15 Princess Haya Bint Al Hussein 2009-10-20 UNITED ARAB EMIRATES 5913 5913 2009-03-05 Public Strategies, Inc. P.O. Box 111888 World Trade Center Complex Convention Center Bldg, 5th Floor Dubai      
1546 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    
1740 2004-01-31 Government of the United Arab Emirates (UAE) 2004-05-19 UNITED ARAB EMIRATES 5523 5523 2002-10-11 Gabriel Company, LLC United Arab Emirates        
1773 2011-01-31 Embassy of the United Arab Emirates through Harbour Group 2010-11-29 UNITED ARAB EMIRATES 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 3522 International Court, NW Suite 400 Washington DC 20008
2428 1990-02-15 Jebel Ali Free Zone Authority 1988-08-30 UNITED ARAB EMIRATES 4174 4174 1988-08-30 International Public Relations Affiliates Dubai        
2440 2010-02-15 Sheikh Khalid Bin Saqr Al Qasimi through California Strategies 2009-09-30 UNITED ARAB EMIRATES 5953 5953 2009-09-30 Mercury Public Affairs, LLC d/b/a IGR Group 6 Thornwood Gardens, Campden Hill Kensington, London    
3017 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    
3160 1996-03-01 Government of Abu Dhabi (formerly: Abu Dhabi Investment Authority) 1991-09-30 UNITED ARAB EMIRATES 3911 3911 1986-12-01 IPG DXTRA, Inc          
3615 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    
3618 2021-03-15 UAE Ministry of Cabinet Affairs and Future Public Diplomacy Office 2020-06-26 UNITED ARAB EMIRATES 5801 5801 2007-04-16 Fleishman-Hillard, Inc. P.O. Box: 212000 Dubai UAE      
3771 2010-03-21 Abu Dhabi Future Energy Company (Masdar) (through Gulf Hill & Knowlton WLL) 2009-12-01 UNITED ARAB EMIRATES 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC P.O. Box 54115 Abu Dhabi      
3958 1991-03-29 Relax International 1991-02-05 UNITED ARAB EMIRATES 4470 4470 1991-02-05 Paul Werth Associates, Inc. Dubai        
4050 2007-03-30 United Arab Emirates 2005-01-26 UNITED ARAB EMIRATES 5617 5617 2004-04-23 Clark & Weinstock 3522 International Court, NW 20008     DC  
4353 1995-03-31 Government of Abu Dhabi 1992-07-29 UNITED ARAB EMIRATES 4293 4293 1989-09-15 Baker Botts L.L.P.          
4464 2006-03-31 Government of Abu Dhabi 2006-05-31 UNITED ARAB EMIRATES 2759 2759 1977-03-09 White & Case, LLP Adwea Building P.O. Box 6120 Abu Dhabi      
4467 2006-03-31 Inchcape Shipping Services (through ISS Marine Services, Inc.) 2006-03-31 UNITED ARAB EMIRATES 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC 2180 North Loop West   Houston TX 77018-8014
4516 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    
4587 2018-03-31 Embassy of the United Arab Emirates 2008-12-15 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP 3522 International Court, NW   Washington DC 20008
4751 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    
4806 1963-04-04 United Arab Republic State Tourist Administration 1961-02-03 UNITED ARAB EMIRATES 810 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
5283 2018-04-23 Galeyr Security Service Corps. 2018-04-23 UNITED ARAB EMIRATES 6542 6542 2018-04-23 SAACS d/b/a of Independent Agency, LLC Mogadishu Somalia Banadir, Region Opposite Dhagahtur        
5822 2009-04-30 Abu Dhabi Investment Authority 2007-07-23 UNITED ARAB EMIRATES 2469 2469 1973-10-23 Burson-Marsteller P.O. Box 3600 Abu Dhabi      
5880 2020-04-30 Dubai Department of Tourism and Commerce Marketing, Government of Dubai 2018-11-14 UNITED ARAB EMIRATES 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 9th Floor Al-Fattan Plaza Building, Airport Road Al Garhoud P.O. Box 594 DUBAI      
5977 1991-05-01 Embassy of the Republic of Djibouti 1991-01-24 UNITED ARAB EMIRATES 3466 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
6016 2018-05-01 Lapis Middle East and Africa 2018-04-25 UNITED ARAB EMIRATES 6544 6544 2018-04-25 Policy Impact Strategic Communications, Inc. Office 401, Level 4, Building 4 Studio City Dubai      
6093 2009-05-04 Sheikh Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates 2007-09-07 UNITED ARAB EMIRATES 5827 5827 2007-09-07 Mark Saylor Company, LLC          
6343 2011-05-15 Ras Al Khaimah Investment Authority 2009-12-14 UNITED ARAB EMIRATES 5824 5824 2007-08-09 Kreab Gavin Anderson (USA), Inc. PO Box 31291 Ras AL Khaimah        
6346 2012-05-15 Ras Al Khaimah Investment Authority 2011-08-18 UNITED ARAB EMIRATES 6058 6058 2011-08-18 Strategy XXI Group, LLC P.O. Box 31291 Ras Al Khaimah      
6452 2003-05-21 Government of the United Arab Emirates (U.A.E.) 2003-05-30 UNITED ARAB EMIRATES 5523 5523 2002-10-11 Gabriel Company, LLC          
6939 2003-05-31 Dubai Tourism & Commerce Marketing 1997-03-18 UNITED ARAB EMIRATES 5165 5165 1997-03-18 Phelps Group Dubai        
6968 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    
7177 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    
7187 2014-06-01 Emirates Center for Strategic Studies and Research 2013-09-23 UNITED ARAB EMIRATES 6189 6189 2013-09-23 Adam Friedman Associates, LLC New Airport Road, Abu Dhabi        
8031 1978-06-30 Arab Monetary Fund 1977-10-04 UNITED ARAB EMIRATES 2718 2718 1976-08-31 Burns, Jackson, Miller, Summit & Jacoby          
8185 1991-06-30 Bank of Credit & Commerce International 1991-05-03 UNITED ARAB EMIRATES 2165 2165 1969-10-09 Squire Patton Boggs, LLP Abu Dhabi        
8381 2007-06-30 Ministry of Finance & Industry, United Arab Emirates 2006-08-23 UNITED ARAB EMIRATES 5549 5549 2003-04-01 Alston & Bird, LLP P.O. Box 433 Abu Dhabi      
8389 2009-06-30 Embassy of the United Arab Emirates 2007-01-22 UNITED ARAB EMIRATES 5478 5478 2002-03-04 Harbour Group, LLC P.O. Box 4442 Abu Dhabi        
8432 2014-06-30 Emirates Center for Strategic Studies & Research via Adam Friedman Associates, LLC 2014-02-06 UNITED ARAB EMIRATES 5875 5875 2008-06-17 BLJ Worldwide LTD New Airport Road Abu Dhabi      
8622 2009-07-01 Sheikh Khalid Bin Saqr Al Qasimi through California Strategies, LLC 2009-01-29 UNITED ARAB EMIRATES 5402 5402 2000-12-14 BKSH & Associates          
8637 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    
9135 1982-07-23 United Arab Emirates, Cultural Division 1982-07-26 UNITED ARAB EMIRATES 2835 2835 1977-10-07 Winters, LeFurge & Associates, Inc.       DC  
9376 1964-07-31 United Arab Republic Tourist Office 1958-10-08 UNITED ARAB EMIRATES 71 71 1942-07-30 Kelly, Nason, Inc. Cairo        
9550 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    
9648 1979-08-01 Government of the United Arab Emirates 1978-12-06 UNITED ARAB EMIRATES 2984 2984 1978-12-06 Patrick & Associates Abu Dhabi        
9718 2006-08-01 Ministry of Finance and Industry the United Arab Emirates 2005-02-22 UNITED ARAB EMIRATES 5627 5627 2004-06-15 Hunton & Williams, LLP 3522 International Court, NW 20008     DC  
9737 2020-08-01 The Embassy of the United Arab Emirates 2020-06-25 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings 3522 International Ct. NW, Suite 400   Washington DC 20008
9820 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
10209 2008-08-15 Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai) 2007-02-28 UNITED ARAB EMIRATES 5649 5649 2004-10-08 Levick Strategic Communications          
10471 2015-08-28 Masdar 2015-03-09 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings Masdar City, Presidential Flight Khalifa City A, Abud Dhabi UAE P.O. Box 54115      
10736 2003-08-31 Jebel Ali Free Zone Authority 1989-02-17 UNITED ARAB EMIRATES 4217 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Dubai        
10785 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    
10800 2012-08-31 United Arab Emirates Ministry of Foreign Affairs 2012-06-06 UNITED ARAB EMIRATES 3634 3634 1984-11-15 Daniel J. Edelman, Inc. P.O. Box 1, Abu Dhabi, UAE        
10865 1971-09-01 Government of Ra al-Khaima 1967-10-23 UNITED ARAB EMIRATES 2057 2057 1967-10-23 Adams, J. Collier          
11008 2010-09-04 Tourism Development and Investing Company (TDIC) 2007-10-26 UNITED ARAB EMIRATES 1481 1481 1961-09-27 Ruder Finn, Inc. P.O. Box 126888 Abu Dhabi        
11012 2019-09-04 Emirates Global Aluminum PJSC 2018-10-09 UNITED ARAB EMIRATES 6598 6598 2018-10-09 American Continental Group PO Box 1091111 Abu Dhabi      
11040 2007-09-06 Dubai Aerospace Enterprise Ltd. 2007-03-22 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings P.O. Box 9522 Dubai,      
11423 2017-09-23 National Media Council of UAE (via Project Associates) 2017-10-06 UNITED ARAB EMIRATES 6473 6473 2017-10-06 SCL Social Limited Al Muroor Street PO Box 3790 Abu Shabi    
11442 2014-09-24 Embassy of the United Arab Emirates, through the Harbour Group 2014-09-24 UNITED ARAB EMIRATES 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 3522 International Court Suite 400 Washington DC 20008
11784 2005-09-30 Dubai International Financial Centre 2004-09-27 UNITED ARAB EMIRATES 5483 5483 2002-03-06 QORVIS LLC Level 49, Emirates Towers P.O. Box 74777 Dubai, U.A.E.        
11811 2009-09-30 Abu Dhabi Future Energy Company DBA Masdar 2008-04-22 UNITED ARAB EMIRATES 3657 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    
11812 2009-09-30 CNIA - Critical National Infrastructure Authority, Abu Dhabi 2009-03-19 UNITED ARAB EMIRATES 3657 3657 1985-03-12 Daniel J. Edelman, Inc. Airport Road Al Bateen Air Base 62220 Abu Dhabi    
11869 2018-09-30 Embassy of United Arab Emirates through Harbour Group 2016-09-23 UNITED ARAB EMIRATES 6380 6380 2016-09-23 Greenwich Media Strategies, LLC 3522 International Court, NW #400 Washington DC 20008
12389 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    
12395 1960-10-18 Arab East News Agency 1958-09-24 UNITED ARAB EMIRATES 1073 1073 1957-10-18 Hagan, Mary Frances Damascus        
12663 2017-10-27 General Secretariat of the Executive Council of the Government of Abu Dhabi (GSEC) 2018-05-07 UNITED ARAB EMIRATES 5947 5947 2009-07-31 Brunswick Group, LLC PO Box 19 Abu Dhabi      
12682 1994-10-28 Embassy of the United Arab Emirates 1993-07-07 UNITED ARAB EMIRATES 4827 4827 1993-07-07 C&O Resources, Inc. Washington     DC  
12685 1999-10-28 Government of the United Arab Emirates 1991-08-09 UNITED ARAB EMIRATES 3964 3964 1987-04-28 Bannerman & Associates, Inc. Abu Dhabi        
13027 2010-10-31 Sheikh Khalid bin Saqr Al Qasimi 2008-10-14 UNITED ARAB EMIRATES 5889 5889 2008-10-14 California Strategies, LLC Ras Al Khaimah        
13082 2020-10-31 Abu Dhabi Investment Authority (ADIA) 2018-07-09 UNITED ARAB EMIRATES 6569 6569 2018-07-09 FTI Consulting LLP 211 Corniche, PO Box 3600   Abu Dhabi    
13202 2009-11-01 Abu Dhabi Department of Planning & Economy 2009-06-19 UNITED ARAB EMIRATES 5801 5801 2007-04-16 Fleishman-Hillard, Inc. P.O. Box 12 Al Salam Street      
13209 2010-11-01 Dubai Department of Finance 2010-05-12 UNITED ARAB EMIRATES 5947 5947 2009-07-31 Brunswick Group, LLC P.O. Box 516 Dubai        
13210 2010-11-01 RAK Ceramics 2009-11-23 UNITED ARAB EMIRATES 5964 5964 2009-11-23 First International Resources P.O. Box 4715 Ras Al Khaimah        
13448 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    
13577 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    

Next page

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