List of all foreign principals (active and terminated)

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

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

View and edit SQL

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

State

Country/Location_Represented

  • UNITED ARAB EMIRATES · 127
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
21   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    
22   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      
23   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    
40   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
127   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES 6200 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
138   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      
148   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    
226   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.          
227   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
228   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
229   Embassy of the United Arab Emirates 2021-08-05 UNITED ARAB EMIRATES 5666 5666 2005-01-31 FGH Holdings 3522 International Court, NW Suite 400 Washington DC 20008
230   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
231   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    
232   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
233   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      
242   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    
291   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      
325   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    
443   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      
516   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    
531   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      
555   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      
596   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      
721 1959-01-01 Al Joumhour 1958-11-24 UNITED ARAB EMIRATES 1073 1073 1957-10-18 Hagan, Mary Frances Damascus        
938 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        
1133 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
1185 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
1292 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      
1580 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    
1774 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        
1807 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
2464 1990-02-15 Jebel Ali Free Zone Authority 1988-08-30 UNITED ARAB EMIRATES 4174 4174 1988-08-30 International Public Relations Affiliates Dubai        
2476 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    
3053 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    
3196 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          
3652 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    
3655 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      
3808 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      
3995 1991-03-29 Relax International 1991-02-05 UNITED ARAB EMIRATES 4470 4470 1991-02-05 Paul Werth Associates, Inc. Dubai        
4087 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  
4390 1995-03-31 Government of Abu Dhabi 1992-07-29 UNITED ARAB EMIRATES 4293 4293 1989-09-15 Baker Botts L.L.P.          
4501 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      
4504 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
4553 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    
4624 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
4790 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    
4845 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  
5322 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        
5861 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      
5919 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      
6018 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  
6057 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      
6134 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          
6384 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        
6387 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      
6493 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          
6980 2003-05-31 Dubai Tourism & Commerce Marketing 1997-03-18 UNITED ARAB EMIRATES 5165 5165 1997-03-18 Phelps Group Dubai        
7009 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    
7219 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    
7229 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        
8074 1978-06-30 Arab Monetary Fund 1977-10-04 UNITED ARAB EMIRATES 2718 2718 1976-08-31 Burns, Jackson, Miller, Summit & Jacoby          
8228 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        
8424 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      
8432 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        
8475 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      
8667 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          
8682 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    
9181 1982-07-23 United Arab Emirates, Cultural Division 1982-07-26 UNITED ARAB EMIRATES 2835 2835 1977-10-07 Winters, LeFurge & Associates, Inc.       DC  
9422 1964-07-31 United Arab Republic Tourist Office 1958-10-08 UNITED ARAB EMIRATES 71 71 1942-07-30 Kelly, Nason, Inc. Cairo        
9596 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    
9695 1979-08-01 Government of the United Arab Emirates 1978-12-06 UNITED ARAB EMIRATES 2984 2984 1978-12-06 Patrick & Associates Abu Dhabi        
9765 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  
9784 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
9867 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
10256 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          
10519 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      
10784 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        
10833 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    
10848 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        
10913 1971-09-01 Government of Ra al-Khaima 1967-10-23 UNITED ARAB EMIRATES 2057 2057 1967-10-23 Adams, J. Collier          
11056 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        
11060 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      
11088 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,      
11471 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    
11490 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
11832 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.        
11859 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    
11860 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    
11917 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
12437 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    
12444 1960-10-18 Arab East News Agency 1958-09-24 UNITED ARAB EMIRATES 1073 1073 1957-10-18 Hagan, Mary Frances Damascus        
12712 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      
12731 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  
12734 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        
13076 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        
13131 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    
13251 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      
13258 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        
13259 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        
13497 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    

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