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
7 7   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
207 207   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      
459 459   Ministry of Commerce and Industries, Republic of Panama 2022-11-14 PANAMA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
538 538   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    
552 552   Palestinian Authority 2014-11-14 PALESTINE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP P.O. Box 795   Ramallah    
871 871 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        
1005 1005 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
1007 1007 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      
1396 1396 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        
1430 1430 1982-01-20 Central American Sugar Council 1969-10-09 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
1738 1738 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        
2044 2044 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  
2045 2045 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        
2047 2047 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  
2430 2430 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
2931 2931 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        
3645 3645 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      
5013 5013 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        
5492 5492 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        
5493 5493 1992-04-23 Nakajima All Company, Ltd. 1986-09-26 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
5494 5494 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        
5523 5523 2014-04-24 Banque du Liban 2012-10-25 LEBANON Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
5524 5524 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    
5813 5813 1982-04-30 Asociacion de Amigos del Pais 1980-05-20 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
6246 6246 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    
6248 6248 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    
6699 6699 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      
6822 6822 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        
6824 6824 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        
6825 6825 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        
6826 6826 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        
6918 6918 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      
7400 7400 1987-06-01 EXEL, Ltd. 1986-10-03 CAYMAN ISLANDS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
8115 8115 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        
8147 8147 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
8148 8148 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      
8149 8149 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
8340 8340 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        
8341 8341 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        
8346 8346 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        
8384 8384 1984-06-30 Japan Airlines Company, Ltd. 1982-02-25 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
8387 8387 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          
8392 8392 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        
8399 8399 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  
8449 8449 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        
8454 8454 1990-06-30 Beckett Packaging, Ltd. 1988-03-16 CANADA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ontario        
8458 8458 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        
8464 8464 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        
8473 8473 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        
8488 8488 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        
8590 8590 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        
8592 8592 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"    
8594 8594 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        
8595 8595 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  
8602 8602 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        
8606 8606 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  
8608 8608 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  
8613 8613 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  
8615 8615 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  
8624 8624 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        
8629 8629 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  
8640 8640 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  
8644 8644 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  
8649 8649 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  
8657 8657 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  
8668 8668 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        
8692 8692 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
8700 8700 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    
8722 8722 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
8728 8728 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      
8729 8729 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
8731 8731 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      
8733 8733 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  
8781 8781 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        
8783 8783 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    
8794 8794 2023-06-30 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
8868 8868 1987-07-01 Republic of the Philippines 1986-09-26 PHILIPPINES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Manila        
9086 9086 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      
10239 10239 1993-08-09 Republic of Guatemala 1991-02-12 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Guatemala City        
10699 10699 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"  
10716 10716 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        
10816 10816 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
10983 10983 1988-08-31 Embassy of Spain 1988-01-19 SPAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
11691 11691 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        
12055 12055 1994-09-30 EUROFER 1994-08-02 BELGIUM Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bruxelles        
12640 12640 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        
12833 12833 1993-10-18 Republic of Uganda 1992-09-25 UGANDA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Kampala        
13035 13035 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          
13455 13455 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
13466 13466 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
14021 14021 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      
14758 14758 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
14841 14841 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        
14842 14842 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        
14843 14843 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        
15055 15055 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  
15212 15212 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
15276 15276 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
15305 15305 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])
);