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

133 rows where Registrant_Name = "Squire Patton Boggs, LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 5

Registrant_Name 1

  • Squire Patton Boggs, LLP · 133 ✖
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
6 6   Embassy of the People's Republic of China 2005-07-21 CHINA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2300 Connecticut Avenue, NW   Washington DC 20008
206 206   Embassy of the Republic of Korea 2018-01-10 KOREA, SOUTH Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
305 305   Government of the Republic of Angola 2019-06-25 ANGOLA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Office of the Presidency of the Republic of Angola Presidential Palace Luanda      
456 456   Ministry of Commerce and Industries, Republic of Panama 2022-11-14 PANAMA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
533 533   Office of the Presidency of the Republic of Benin 2022-02-14 BENIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Route de l'Aeroport 01 BP 301   Cotonou    
548 548   Palestinian Authority 2014-11-14 PALESTINE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP P.O. Box 795   Ramallah    
682 682   The Federal Democratic Republic of Ethiopia 2022-04-13 ETHIOPIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP The United States Embassy of Ethiopia, 3506 International Dr NW, Washington DC 20008
861 861 1985-01-01 Departement des Affaires Estrangeres et des Cultes 1982-10-15 HAITI Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Port-au-Prince        
995 995 2009-01-01 Embassy of the Republic of Chad 2007-08-29 CHAD Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2002 R Street, NW   Washington DC 20009
997 997 2009-01-01 Ministry of Finance, Government of Bermuda 2007-09-04 BERMUDA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 30 Parliament Street Hamilton, HM 12      
1386 1386 1987-01-18 Chippendale Investment Company, N.V. 1986-04-07 CURACAO Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Curacao        
1420 1420 1982-01-20 Central American Sugar Council 1969-10-09 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
1728 1728 1990-01-31 Cargolux Airlines International, S.A. 1988-08-19 LUXEMBOURG Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Luxembourg Airport        
2034 2034 1993-02-01 Embassy of the Arab Republic of Egypt 1990-03-15 EGYPT Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
2035 2035 1993-02-01 Japan Aviation Electronics Industry, Ltd. 1991-10-04 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
2037 2037 1994-02-01 American Environmental Company, Inc. 1992-06-19 LIBERIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
2420 2420 2013-02-12 Embassy of Sri Lanka 2009-02-17 SRI LANKA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2148 Wyoming Avenue, NW   Washington DC 20008
2921 2921 1982-02-28 Metal Market & Exchange Company, Ltd. 1977-03-25 GREAT BRITAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP London        
3634 3634 2013-03-11 Bidzina Ivanishvili/Georgian Dream 2012-08-06 GEORGIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 6 King Erekle Circle Tbilisi 0102      
4998 4998 2015-04-03 Saudi Food and Drug Authority, Kingdom of Southern Arabia 2012-06-21 SAUDI ARABIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 3292 North Highway Al Nafal Unit (1) Riyadh 13312-6288        
5477 5477 1992-04-23 Fundacion de Defensa del Comercio Exterior 1988-02-11 COSTA RICA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP San Jose        
5478 5478 1992-04-23 Nakajima All Company, Ltd. 1986-09-26 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
5479 5479 1992-04-23 Olympic Fibers, S.A. 1989-02-09 COSTA RICA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP San Jose        
5508 5508 2014-04-24 Banque du Liban 2012-10-25 LEBANON Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
5509 5509 2014-04-24 Sovereign Military Hospitaller Order of St. John of Jerusalem of Rhodes and of Malta 2008-06-25 ITALY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Magistral Palace Via Condotti, 68 - 00187 Rome    
5798 5798 1982-04-30 Asociacion de Amigos del Pais 1980-05-20 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
6231 6231 2018-05-01 Government of Kosova 2011-08-31 KOSOVA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Office of the Prime Minister Republic of Kosova Pristina    
6233 6233 2018-05-01 Provincial Salahuddin Council/Province of Salah Addin 2016-07-28 IRAQ Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Salahuddin Provincial Council Building City of Tikrit Salahuddin    
6684 6684 2015-05-21 Republic of Kenya 2015-05-14 KENYA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Old Treasury Building Harambee Avenue PO Box 30551 - 00100 Nairobi      
6807 6807 1989-05-25 Buini & Grandi, S.p.A. 1984-08-13 ITALY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bologna        
6809 6809 1989-05-25 F. Palicio y Cia., S.A. 1982-03-26 VENEZUELA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Caracas        
6810 6810 1989-05-25 Menendez, Garcia y Cia., Ltd. 1982-03-26 SPAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Madrid        
6811 6811 1989-05-25 Por Larranaga, Fabrica de Tabacos, S.A. 1982-03-26 SPAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Madrid        
6903 6903 2015-05-29 Office of the National Security Advisor 2013-11-21 NIGERIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Three Arms Zone The Presidency Abuja, FCT      
7381 7381 1987-06-01 EXEL, Ltd. 1986-10-03 CAYMAN ISLANDS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
8093 8093 2013-06-26 Al-Ahmar Trading Group 2012-06-21 YEMEN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Sabafon Blue Building Zubairi Street P.O. Box 18550 Sana'ss        
8125 8125 2012-06-28 Embassy of the Republic of Chad 2011-08-25 CHAD Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2401 Massachusetts Avenue, NW   Washington DC 20008
8126 8126 2012-06-28 Government of Albania 2010-01-28 ALBANIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bulevardi Deshmoret e Kombit"" Keshilli i Ministrave      
8127 8127 2013-06-28 Embassy of Ecuador 2009-09-29 ECUADOR Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2535 15th Street, NW   Washington DC 20009
8318 8318 1982-06-30 Armazens Jose Luis da Costa & C.A., LDA 1980-03-11 PORTUGAL Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Lisbon        
8319 8319 1982-06-30 Associacao dos Armadores da Pesca Longinqua (ADAPLA) 1980-12-22 PORTUGAL Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Lisbon        
8324 8324 1982-06-30 Korea Marine Industry Development Corporation 1976-04-06 KOREA, SOUTH Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Seoul        
8362 8362 1984-06-30 Japan Airlines Company, Ltd. 1982-02-25 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
8365 8365 1984-06-30 National Association of Beer Manufacturers of Mexico 1982-10-21 MEXICO Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
8370 8370 1985-06-30 Asociacion de Azucareros de Guatemala 1982-01-25 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Guatemala        
8377 8377 1985-06-30 National Investment Council of Panama 1983-07-15 PANAMA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
8427 8427 1989-06-30 Unitary Tax Campaign, Ltd. 1986-02-13 GREAT BRITAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP London        
8432 8432 1990-06-30 Beckett Packaging, Ltd. 1988-03-16 CANADA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ontario        
8436 8436 1990-06-30 Fundacion Pro-Imagen de Colombia en el Exterior 1988-11-02 COLOMBIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bogota        
8442 8442 1990-06-30 Minerals Marketing Corporation of Zimbabwe (MMCZ) 1987-12-23 ZIMBABWE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Harare        
8451 8451 1991-06-30 Bank of Credit & Commerce International 1991-05-03 UNITED ARAB EMIRATES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Abu Dhabi        
8466 8466 1991-06-30 Royal Trustco, Ltd. (Royal Trustco")" 1989-05-31 CANADA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ontario        
8568 8568 2000-06-30 Fondo De Garantia De Depositos Y Proteccio Bancaria (Fogade) 1999-08-09 VENEZUELA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Esquina San Jacinto con Plaza el Venezolano Edificio Fogade, Planta Alta Caracas        
8570 8570 2000-06-30 National Council on Privatisation, Secretariat: Bureau of Public Enterprises of the Federal Republic of Nigeria 1999-10-18 NIGERIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP NDIC Building 1st" Plot 447/448 Constitution Avenue Central Business District P.M.B. 442 Garki Ab"    
8572 8572 2000-06-30 Provisional Government of Kosova 1999-07-23 KOSOVA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 10 E. 33rd. New York, N.Y. 10016        
8573 8573 2000-06-30 Republic of Turkey, Embassy 1997-10-06 TURKEY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
8580 8580 2001-06-30 Central American Bank of Economic Integration 1999-07-21 HONDURAS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tegucigalpa        
8584 8584 2001-06-30 Government of Pakistan, Embassy 1994-11-30 PAKISTAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
8586 8586 2001-06-30 Government of the Republic of the Philippines 1995-10-05 PHILIPPINES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
8591 8591 2001-06-30 Ministry of Foreign Affairs, Republic of Croatia (Embassy) 1999-02-19 CROATIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2343 Massachusetts Ave. N.W.     DC  
8593 8593 2002-06-30 American Worldwide, Inc./Government of the Republic of Angola 2001-02-14 ANGOLA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 3 Bethesda Metro Center Suite 600 Bethesda 20814     MD  
8602 8602 2002-06-30 Hong Kong Trade Development Council 2001-08-10 HONG KONG Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 36-69 Office Tower Convention Plaza 1 Harbour Road        
8607 8607 2003-06-30 Embassy of Mexico 2001-10-02 MEXICO Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 1911 Pennsylvania Avenue, N.W. 20006     DC  
8618 8618 2004-06-30 Republic of Sri Lanka, Embassy 2003-12-15 SRI LANKA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2148 Wyoming Avenue, N.W. 20008     DC  
8622 8622 2005-06-30 Embassy of the Bolivarian Republic of Venezuela 2003-10-21 VENEZUELA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 1099 30th Street, N.W. 20007     DC  
8627 8627 2005-06-30 Ministry of Foreign Affairs Czech Republic, Embassy 2004-11-01 CZECHIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 3900 Spring of Freedom Street, N.W. 20008     DC  
8635 8635 2006-06-30 Embassy of the State of Kuwait 2004-09-08 KUWAIT Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2940 Tilden Street, N.W. 20008     DC  
8646 8646 2007-06-30 Government of Trinidad and Tobago 2005-03-28 TRINIDAD AND TOBAGO Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Independence Square, Port of Spain        
8670 8670 2010-06-30 Government of the Republic of Angola, Embassy 2008-05-19 ANGOLA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2108 16th Street, NW   Washington DC 20009
8678 8678 2011-06-30 Partido Accion Nacional (PAN) 2010-11-24 MEXICO Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Av. Coyoacan No. 1546 - Col. Del Valle Deleg. Benito Juarez    
8700 8700 2014-06-30 Government of South Korea 2012-11-20 KOREA, SOUTH Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
8706 8706 2015-06-30 Government of Georgia 2013-02-22 GEORGIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tbilisi, Georgia 0175 P. Ingorokva Str. N7      
8707 8707 2015-06-30 Government of Libya 2011-06-24 LIBYA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2445 M Street   Washington DC 20037
8709 8709 2015-06-30 Kurdistan Regional Government 2014-03-31 IRAQ Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Erbil, Iraq and 1532 16th Street, NW Washington, DC 20036      
8711 8711 2015-06-30 Royal Embassy of Saudi Arabia through Qorvis Communications 2002-01-22 SAUDI ARABIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 601 New Hampshire Avenue 20037     DC  
8759 8759 2021-06-30 Republic of Croatia 2011-08-05 CROATIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Dezmanova 10 Zagreb        
8761 8761 2021-06-30 The Islamic Republic of Afghanistan 2021-06-21 AFGHANISTAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Presidental Place   Kabul    
8843 8843 1987-07-01 Republic of the Philippines 1986-09-26 PHILIPPINES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Manila        
9060 9060 2022-07-07 Temasek Holdings Limited 2012-05-14 SINGAPORE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 60B Orchard Road #06-18 Tower 2 The Atrium @Orchard Singapore 238891      
10212 10212 1993-08-09 Republic of Guatemala 1991-02-12 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Guatemala City        
10672 10672 2013-08-23 Government of the Republic of Albania 2013-01-15 ALBANIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Mr. Gjergj Lezhja c/o Ms. Emelinda Muho Advisor to the Minister for Innovation and ICT Blv Deshmoret e Kombit" NR.1 Tirana"  
10689 10689 2018-08-24 Government of Saint Lucia 2016-02-10 SAINT LUCIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Minister of External Affairs, International Trade and Civil Aviation        
10789 10789 2015-08-28 Government of Turkey (through the Gephardt Group) 2015-08-10 TURKEY Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
10956 10956 1988-08-31 Embassy of Spain 1988-01-19 SPAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
11664 11664 2021-09-17 Center for Studies and Media Affairs at the Saudi Royal Court 2016-09-20 SAUDI ARABIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Riyadh PO Box 11111        
12029 12029 1994-09-30 EUROFER 1994-08-02 BELGIUM Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bruxelles        
12613 12613 2019-10-12 High Negotiations Committee of the Syrian Opposition (HNC) 2017-02-22 SYRIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP HNC Headquarters, Riyadh        
12806 12806 1993-10-18 Republic of Uganda 1992-09-25 UGANDA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Kampala        
13008 13008 2012-10-25 Embassy of the Republic of Azerbaijan 2010-12-08 AZERBAIJAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
13428 13428 2011-10-31 Government of the Republic of Cyprus, Embassy 2007-09-25 CYPRUS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2211 R Street, NW   Washington DC 20008
13439 13439 2014-10-31 Bo Zhang 2013-12-23 CHINA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 5600 Wisconson Avenue Apt. 906 Chevy Chase MD 20815
13993 13993 2016-11-16 Government of the Dominican Republic 2015-07-17 DOMINICAN REPUBLIC Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP National Palace Santo Domingo      
14728 14728 2010-12-02 Embassy of India 2008-09-18 INDIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2107 Massachusetts Avenue, NW   Washington DC 20008
14811 14811 1994-12-06 Institute for Development & Security of the Republic of Belarus 1993-06-17 BELARUS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Minsk        
14812 14812 1994-12-06 Makerere University, School of Law 1992-02-18 UGANDA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Kampala        
14813 14813 1994-12-06 VARIG, S.A. 1994-04-22 BRAZIL Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Rio de Janeiro        
15025 15025 2019-12-12 Government of the State of Qatar 1994-02-28 QATAR Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
15182 15182 2008-12-18 Government of the Kingdom of Bahrain, Embassy 2008-11-03 BAHRAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 3502 International Drive, NW   Washington DC 20008
15246 15246 2018-12-20 Government of the Republic of Sudan, Embassy 2017-06-01 SUDAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2210 Massachusetts Avenue, NW   Washington DC 20008
15275 15275 2012-12-21 Federal Republic of Nigeria 2010-01-20 NIGERIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ministry of Foreign Affairs Maputo Street, Wuse Zone 3, P.M.B. 130 Garki, Abuja      

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