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

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 5

Registrant_Name 1

  • Squire Patton Boggs, LLP · 132 ✖
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
3 3   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
200 200   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
536 536   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    
578 578   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      
675 675   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      
685 685   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
845 845 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        
979 979 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
981 981 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      
1362 1362 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        
1396 1396 1982-01-20 Central American Sugar Council 1969-10-09 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
1701 1701 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        
2005 2005 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  
2006 2006 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        
2008 2008 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  
2386 2386 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
2878 2878 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        
3577 3577 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      
4917 4917 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        
5390 5390 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        
5391 5391 1992-04-23 Nakajima All Company, Ltd. 1986-09-26 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
5392 5392 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        
5421 5421 2014-04-24 Banque du Liban 2012-10-25 LEBANON Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
5422 5422 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    
5709 5709 1982-04-30 Asociacion de Amigos del Pais 1980-05-20 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
6137 6137 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    
6139 6139 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    
6581 6581 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      
6703 6703 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        
6705 6705 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        
6706 6706 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        
6707 6707 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        
6797 6797 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      
7263 7263 1987-06-01 EXEL, Ltd. 1986-10-03 CAYMAN ISLANDS Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP          
7969 7969 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        
8001 8001 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
8002 8002 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      
8003 8003 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
8193 8193 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        
8194 8194 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        
8199 8199 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        
8237 8237 1984-06-30 Japan Airlines Company, Ltd. 1982-02-25 JAPAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Tokyo        
8240 8240 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          
8245 8245 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        
8252 8252 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  
8302 8302 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        
8307 8307 1990-06-30 Beckett Packaging, Ltd. 1988-03-16 CANADA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ontario        
8311 8311 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        
8317 8317 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        
8326 8326 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        
8341 8341 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        
8443 8443 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        
8445 8445 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"    
8447 8447 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        
8448 8448 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  
8455 8455 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        
8459 8459 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  
8461 8461 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  
8466 8466 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  
8468 8468 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  
8477 8477 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        
8482 8482 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  
8493 8493 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  
8497 8497 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  
8502 8502 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  
8510 8510 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  
8521 8521 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        
8545 8545 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
8553 8553 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    
8575 8575 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
8581 8581 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      
8582 8582 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
8584 8584 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      
8586 8586 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  
8634 8634 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        
8636 8636 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    
8711 8711 1987-07-01 Republic of the Philippines 1986-09-26 PHILIPPINES Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Manila        
10062 10062 1993-08-09 Republic of Guatemala 1991-02-12 GUATEMALA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Guatemala City        
10510 10510 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"  
10527 10527 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        
10625 10625 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
10792 10792 1988-08-31 Embassy of Spain 1988-01-19 SPAIN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
11495 11495 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        
11853 11853 1994-09-30 EUROFER 1994-08-02 BELGIUM Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bruxelles        
12414 12414 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        
12605 12605 1993-10-18 Republic of Uganda 1992-09-25 UGANDA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Kampala        
12805 12805 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          
13224 13224 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
13235 13235 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
13783 13783 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      
14513 14513 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
14595 14595 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        
14596 14596 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        
14597 14597 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        
14808 14808 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  
14961 14961 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
15024 15024 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
15053 15053 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      
15079 15079 2011-12-22 China Chamber of Commerce for Importers and Exporters of Machinery and Electronic Products 2010-09-14 CHINA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 937-939, 9th Floor, Building 12 Panja Yuan Nan Li Chaoyang District Beijing    

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