FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
133 rows where Registrant_Name = "Squire Patton Boggs, LLP" sorted by rowid descending
This data as json, CSV (advanced)
Foreign_Principal 27
- American Environmental Company, Inc. 1
- Asociacion de Amigos del Pais 1
- Banque du Liban 1
- Bidzina Ivanishvili/Georgian Dream 1
- Cargolux Airlines International, S.A. 1
- Central American Sugar Council 1
- Chippendale Investment Company, N.V. 1
- Departement des Affaires Estrangeres et des Cultes 1
- Embassy of Sri Lanka 1
- Embassy of the Arab Republic of Egypt 1
- Embassy of the People's Republic of China 1
- Embassy of the Republic of Chad 1
- Embassy of the Republic of Korea 1
- Fundacion de Defensa del Comercio Exterior 1
- Government of Kosova 1
- Government of the Republic of Angola 1
- Japan Aviation Electronics Industry, Ltd. 1
- Metal Market & Exchange Company, Ltd. 1
- Ministry of Commerce and Industries, Republic of Panama 1
- Ministry of Finance, Government of Bermuda 1
- Nakajima All Company, Ltd. 1
- Office of the Presidency of the Republic of Benin 1
- Olympic Fibers, S.A. 1
- Palestinian Authority 1
- Provincial Salahuddin Council/Province of Salah Addin 1
- Saudi Food and Drug Authority, Kingdom of Southern Arabia 1
- Sovereign Military Hospitaller Order of St. John of Jerusalem of Rhodes and of Malta 1
Country/Location_Represented 24
- COSTA RICA 2
- GUATEMALA 2
- JAPAN 2
- ANGOLA 1
- BENIN 1
- BERMUDA 1
- CHAD 1
- CHINA 1
- CURACAO 1
- EGYPT 1
- GEORGIA 1
- GREAT BRITAIN 1
- HAITI 1
- IRAQ 1
- ITALY 1
- KOREA, SOUTH 1
- KOSOVA 1
- LEBANON 1
- LIBERIA 1
- LUXEMBOURG 1
- PALESTINE 1
- PANAMA 1
- SAUDI ARABIA 1
- SRI LANKA 1
City 7
- - 18
- Washington 4
- Cotonou 1
- Pristina 1
- Ramallah 1
- Rome 1
- Salahuddin 1
Registrant_Name 1
- Squire Patton Boggs, LLP · 27 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | |||||
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 | ||
5523 | 5523 | 2014-04-24 | Banque du Liban | 2012-10-25 | LEBANON | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 | |||
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 | |
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 | ||||
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 | ||||
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 | ||||
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 | ||||||
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 | ||||
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );