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

136 rows where Registrant_Name = "Daniel J. Edelman, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 6

Registrant_Name 1

  • Daniel J. Edelman, Inc. · 136 ✖
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 19   AXA 2021-03-03 FRANCE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 25 Avenue Matignon 75008 Paris        
69 69   Bahrain Economic Development Board 2021-11-03 BAHRAIN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. P.O. Box 11299   Manama    
458 458   Mashreqbank psc 2020-08-13 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1 A1 Ghurair Centre A1 Riqqa St Deira Dubai      
520 520   Neom Company 2021-10-07 INTERNATIONAL Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Information Technology and Communicatin Complex (ITCC) Second Floor, Building IN-01, Al Nakheel District 12382 P.O. Box 10 11411 Riyadh    
730 730   United Nations Development Programme on behalf of the Government of Panama 2020-11-06 PANAMA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Clayton, Ciudad del Saber, Edif. 129 Casa de las Naciones Unidas, Ciudad de Panama      
951 951 1997-01-01 Korean Foreign Trade Association 1995-05-12 KOREA, SOUTH Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Seoul        
979 979 2009-01-01 Embassy of Panama 2008-05-02 PANAMA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2862 McGill Terrace, NW   Washington DC 20008
1324 1324 2010-01-15 Embassy of Switzerland 2009-10-06 SWITZERLAND Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2900 Cathedral Avenue, NW   Washington DC 20008
1330 1330 2021-01-15 Saudi Basic Industries Corporation (SABIC) 2020-02-14 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Qordoba District Global Headquarters Riyadh 11422      
1568 1568 1990-01-29 Yamazaki Mazak Corporation 1989-11-30 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Aichi-Pref.        
1795 1795 2002-01-31 Government of Portugal (Trade Commission) 1994-11-15 PORTUGAL Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. New York     NY  
1803 1803 2003-01-31 Embassy of Morocco 2002-11-15 MOROCCO Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1601 21st Street, N.W. 20009     DC  
1841 1841 2011-01-31 Embassy of the United Arab Emirates through Harbour Group 2010-11-29 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 3522 International Court, NW Suite 400 Washington DC 20008
1849 1849 2012-01-31 Panama Canal Authority 2002-09-17 PANAMA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Building 710 Balboa        
1857 1857 2014-01-31 TEL Solar 2010-07-20 SWITZERLAND Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Hauptstrasse 1a CH-9477 Trubbach        
1859 1859 2015-01-31 Libyan Investment Authority thru Enyo Law LLP 2014-03-21 LIBYA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 22nd Floor, Tripoli Tower P.O. Box 93099 Tripoli      
1888 1888 2021-01-31 Minderoo Foundation Pty Ltd 2020-10-02 AUSTRALIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. P.O. Box 3155 Broadway Nedlands, Western Australia      
1889 1889 2021-01-31 NEOM Company 2020-11-20 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Information Technology and Communication Complex (ITCC) 2nd Floor, Building IN-01, A1 Nakheel District 12382 Riyadh      
1974 1974 1987-02-01 Government of the Republic of Panama 1985-11-12 PANAMA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Panama City        
1975 1975 1987-02-01 Hitachi, Ltd. 1985-08-08 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Tokyo        
1977 1977 1987-02-01 Republic of China/Coordination Council for North American Affairs 1986-12-23 TAIWAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. New York     NY  
1978 1978 1987-02-01 Social Christian Reform Party of the Dominican Republic 1986-06-30 DOMINICAN REPUBLIC Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc.          
2003 2003 1995-02-01 Rolls Royce Aerospace Division 1994-09-22 GREAT BRITAIN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. London        
2028 2028 2013-02-01 Kongsberg Protech Systems 2011-07-22 NORWAY Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1725 Duke Street, Suite 600   Alexandria VA 22314
2980 2980 2002-02-28 Korea International Trade Association 1999-03-18 KOREA, SOUTH Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Trade Tower, 47th Floor 159-1 Samsung-dong, Kangnam-gu Seoul        
2987 2987 2003-02-28 Government of Jordan 2002-11-15 JORDAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Amman        
3028 3028 2013-02-28 Permanent Mission of the Kingdom of Saudi Arabia 2013-03-15 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 809 UN Plaza 10th Floor   New York NY 10017
3198 3198 1987-03-01 Freedom & Justice for Cyprus Trust 1986-10-31 CYPRUS Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Nicosia        
3576 3576 1998-03-12 Pulsar International 1995-05-12 MEXICO Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Monterrey        
3577 3577 2000-03-12 Ministry of Foreign Affairs Government of the Arab Republic of Egypt 1997-05-20 EGYPT Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Cairo        
3679 3679 2003-03-15 Kuwait Information Office 2003-04-21 KUWAIT Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2600 Virginia Avenue, N.W. 20037     DC  
3806 3806 1987-03-20 New Zealand Steel, Ltd. 1987-03-20 NEW ZEALAND Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Auckland        
3908 3908 1994-03-24 Korean Foreign Trade Association 1994-03-24 KOREA, SOUTH Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Washington     DC  
4054 4054 1986-03-30 Republic of Greece 1984-11-19 GREECE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Athens        
4122 4122 2001-03-30 Ukraine through UKR Investments, Inc. 2001-02-07 UKRAINE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc.          
4323 4323 1987-03-31 Government of the Republic of China 1988-03-22 TAIWAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc.          
4393 4393 1991-03-31 Government of Japan 1991-04-18 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4586 4586 2009-03-31 Office of the Japanese Consul General 1993-10-25 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4595 4595 2011-03-31 Economic Development Board of Bahrain (EDB) 2011-03-24 BAHRAIN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 8th Floor, Seef Tower P.O. Box 11299 Manama    
4604 4604 2011-03-31 Religare Enterprises Limited 2010-03-08 INDIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. D-3, Saket District Centre   New Delhi    
4652 4652 2016-03-31 Singapore Economic Development Board 2012-02-07 SINGAPORE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Singapore Headquarters 250 North Bridge Road #28-00 Raffles City Tower 179101      
4653 4653 2017-03-31 Japan Prime Minister's Office 2016-09-26 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2-3-1 Nagata-cho Chiyodaku, Tokyo 100-0014        
4800 4800 1990-04-01 Japan Tobacco, Inc. 1986-08-07 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Washington     DC  
4815 4815 1997-04-01 Government of Israel Economic Mission 1994-01-12 ISRAEL Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4892 4892 1995-04-04 APARI, Inc. 1994-08-08 PHILIPPINES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Los Angeles     CA  
5154 5154 1992-04-15 Fujitsu, Ltd. 1991-04-25 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Tokyo        
5800 5800 1995-04-30 Mexican Ministry of Tourism 1992-10-09 MEXICO Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Anzures        
5805 5805 1996-04-30 Mexican Investment Board 1996-05-08 MEXICO Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Mexico City        
5828 5828 1999-04-30 Government of the Republic of Kazakhstan 1999-03-05 KAZAKHSTAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc.          
5853 5853 2002-04-30 Government of Angola 2001-02-15 ANGOLA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Luanda        
5953 5953 2019-04-30 Ontario Ministry of Economic Development and Growth 2018-04-27 CANADA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 56 Wellesley Street West 7th Floor Toronto ONTARIO M7A 2E7      
5955 5955 2020-04-30 Dubai Department of Tourism and Commerce Marketing, Government of Dubai 2018-11-14 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 9th Floor Al-Fattan Plaza Building, Airport Road Al Garhoud P.O. Box 594 DUBAI      
6316 6316 1995-05-12 Democratic Party of Russia 1994-04-27 RUSSIA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Moscow        
6322 6322 1995-05-12 Government of Australia 1994-09-29 AUSTRALIA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Canberra        
6349 6349 1993-05-13 Banco Nacional de Disenvolvimento Economico a Social-BNDES 1992-05-28 BRAZIL Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Rio de Janeiro        
6417 6417 2009-05-15 Government of Turkey 2009-04-09 TURKEY Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Ministry of Foreign Affairs Balgat/Ankara/Turkey 06100      
6440 6440 1994-05-16 British Airways (A & B Filed in error Washington Office has client) 1993-03-05 GREAT BRITAIN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Jackson Heights     NY  
6902 6902 1990-05-31 Cote d'Ivoire 1990-01-09 COTE D'IVOIRE (IVORY COAST) Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Abidjan        
6966 6966 1995-05-31 Fernando Marin Radical Party of Argentina 1995-05-12 ARGENTINA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Buenos Aires        
6978 6978 1996-05-31 Colombia Hemispheric Trade Forum 1995-12-12 COLOMBIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Bogota        
7074 7074 2014-05-31 Emaar, The Economic City 2014-05-15 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Unit No. 1, 7082-BayLaSun-Juman St. King Abdullah Economic City 23964-2522      
7078 7078 2015-05-31 Government of Japan 2015-05-01 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2-3-1, Nagata-cho, Chiyoda-ku, Tokyo 100-8968        
7092 7092 2017-05-31 Embassy of the Gabonese Republic 2016-10-27 GABON Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2034 20th Street, NW   Washington DC 20009
7101 7101 2017-05-31 Saudi Arabian General Investment Authority (SAGIA) 2017-05-02 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Imam Saud Bin Abdulaziz Road-Al Nakhil District PO Box 5927 Riyadh 11432      
7258 7258 2007-06-01 Thaksin Shinawatra, former Prime Minister of Thailand 2007-01-25 THAILAND Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. c/o Baker Botts The Warner 1299 Pennsylvania Avenue, NW Washington DC 20004
7457 7457 1976-06-07 Aerospatiale 1975-12-15 FRANCE Daniel J. Edelman, Inc. 2640 1975-12-15 Daniel J. Edelman, Inc. Washington     DC  
8213 8213 1986-06-30 Republic of Panama 1988-03-22 PANAMA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc.          
8222 8222 1987-06-30 Trade Development Authority of India 1986-07-28 INDIA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
8230 8230 1988-06-30 Korean Foreign Trade Association 1988-05-02 KOREA, SOUTH Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Seoul        
8245 8245 1989-06-30 Korea Foreign Trade Association (KFTA) 1989-03-22 KOREA, SOUTH Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Seoul        
8338 8338 1995-06-30 Mexican Investment Board 1991-04-18 MEXICO Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Mexico City        
8368 8368 1998-06-30 Government of Colombia, Embassy 1998-04-01 COLOMBIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2118 Leroy Place, N.W.     DC  
8422 8422 2002-06-30 Government of Jordan 2001-04-17 JORDAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Amman        
8474 8474 2008-06-30 Embassy of the Kingdom of Morocco 2004-11-10 MOROCCO Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 1601 21st Street, N.W. 20009     DC  
8532 8532 2015-06-30 ITC (International Trust Construction) through Levant Suez Consulting Corp. 2015-06-18 SAUDI ARABIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Jeddah - Alharmen Street        
8543 8543 2017-06-30 100 Lives Limited 2015-01-08 BRITISH VIRGIN ISLANDS Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 100 Lives Limited, Trident Chambers P.O. Box 146, Road Town, Tortola      
8562 8562 2019-06-30 GIC Private Ltd. Singapore 2019-01-31 SINGAPORE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 168 Robinson Road #37-01 Capital Tower Singapore 068912      
8565 8565 2019-06-30 Minderoo Foundation 2019-07-12 AUSTRALIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 80 Birdwood Parade, Dalkeith WA 6009      
8635 8635 1974-07-01 Government of the Republic of Liberia 1974-07-01 LIBERIA Daniel J. Edelman, Inc. 2523 1974-07-01 Daniel J. Edelman, Inc. Monrovia        
8709 8709 2003-07-01 Embassy of Sri Lanka 2003-04-21 SRI LANKA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2148 Wyoming Avenue, N.W. 20008     DC  
9060 9060 2000-07-15 Transportacion Maritima Mexicana 2000-03-03 MEXICO Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Servicios Corp. TM AV. de la Cuspide 4755 2nd Floor Parques del Pedregal 14010        
9551 9551 1990-07-31 Government of the Philippines 1990-03-29 PHILIPPINES Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Manila        
9660 9660 2009-07-31 International Enterprise Singapore 2009-03-19 SINGAPORE Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. 230 Victoria Street #09-00 Bugis Junction Office Tower 188024      
9676 9676 2014-07-31 Grupo Vicini 2010-03-08 DOMINICAN REPUBLIC Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Av. Winston Churchill No. 5 Torre Progreso Santo Domingo    
9710 9710 2019-07-31 White House Writers Group on behalf of the Consulate of Poland 2018-06-21 POLAND Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 233 Madison Avenue   New York NY 10016
9778 9778 1989-08-01 Fuji Photo Film U.S.A., Inc. 1987-04-09 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Elmsford     NJ  
10050 10050 2004-08-11 UK Trade and Investment 2003-05-27 GREAT BRITAIN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Bay 321 1 Victoria Street London SW1H 0ET United Kingdom        
10730 10730 1986-08-31 Republic of Colombia 1986-08-08 COLOMBIA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc.          
10796 10796 1996-08-31 German-American Chamber of Commerce 1996-10-23 GERMANY Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
10801 10801 1997-08-31 Embassy of the Government of India 1994-01-25 INDIA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Washington     DC  
10807 10807 1997-08-31 Ukrainian United Energy Systems 1997-02-20 UKRAINE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Alexandria     VA  
10812 10812 1998-08-31 Government of Chile, Office of Communications 1994-11-15 CHILE Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Santiago        
10901 10901 2012-08-31 United Arab Emirates Ministry of Foreign Affairs 2012-06-06 UNITED ARAB EMIRATES Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. P.O. Box 1, Abu Dhabi, UAE        
10971 10971 1973-09-01 Government of Liberia 1973-08-09 LIBERIA Daniel J. Edelman, Inc. 2449 1973-08-09 Daniel J. Edelman, Inc. Monrovia        
11012 11012 1987-09-01 Toshiba Corporation (Through Hakuhodo, Inc.) 1987-07-02 JAPAN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Tokyo        
11493 11493 1994-09-21 British Airways 1993-03-12 GREAT BRITAIN Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Jackson Heights     NY  
11715 11715 1986-09-30 New Republic of the Philippines 1988-03-22 PHILIPPINES Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc.          
11764 11764 1990-09-30 Tourism Canada 1986-12-02 CANADA Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Ottawa        
11808 11808 1996-09-30 Consortium of German States' Economic Development Organizations 1995-10-18 GERMANY Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Erfurt        
11817 11817 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        

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