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 Foreign_Principal
This data as json, CSV (advanced)
Foreign_Principal >30
- Partido Accion Nacional (PAN) 1
- Por Larranaga, Fabrica de Tabacos, S.A. 1
- Procesadora de Carne, S.A. (PROCASA) 1
- Provincial Salahuddin Council/Province of Salah Addin 1
- Provisional Government of Kosova 1
- Republic of Benin 1
- Republic of Bulgaria 1
- Republic of Costa Rica 1
- Republic of Croatia 1
- Republic of Gabon 1
- Republic of Guatemala 1
- Republic of Kenya 1
- Republic of Peru, Embassy 1
- Republic of Sri Lanka, Embassy 1
- Republic of Turkey, Embassy 1
- Republic of Uganda 1
- Republic of Zaire 1
- Republic of the Philippines 1
- Royal Embassy of Saudi Arabia through Qorvis Communications 1
- Royal Trustco, Ltd. (Royal Trustco")" 1
- Saudi Food and Drug Authority, Kingdom of Southern Arabia 1
- Scheidt & Bachmann, GmbH 1
- Sociedade Nacional de Combustiveis de Angola (SONANGOL) /Republic of Angola 1
- Sovereign Military Hospitaller Order of St. John of Jerusalem of Rhodes and of Malta 1
- Sultanate of Oman 1
- Taiwanese Reichbanknote Creditors' Association 1
- Technical Secretariat for Planning of the Republic of Paraguay 1
- Temasek Holdings Limited 1
- The Federal Democratic Republic of Ethiopia 1
- The Islamic Republic of Afghanistan 1
- …
Country/Location_Represented >30
- GUATEMALA 2
- SAUDI ARABIA 2
- AFGHANISTAN 1
- ANGOLA 1
- BENIN 1
- BRAZIL 1
- BULGARIA 1
- CANADA 1
- COSTA RICA 1
- CROATIA 1
- ETHIOPIA 1
- GABON 1
- GERMANY 1
- GREAT BRITAIN 1
- IRAQ 1
- ITALY 1
- KENYA 1
- KOSOVA 1
- MEXICO 1
- OMAN 1
- PARAGUAY 1
- PERU 1
- PHILIPPINES 1
- SINGAPORE 1
- SPAIN 1
- SRI LANKA 1
- TAIWAN 1
- TURKEY 1
- UGANDA 1
- UNITED ARAB EMIRATES 1
- …
Foreign_Principal_Termination_Date (date) 25 ✖
- 1982-12-31 3
- 2000-12-31 3
- 1995-12-31 2
- 2000-06-30 2
- 2005-12-31 2
- 2021-06-30 2
- 1987-07-01 1
- 1989-05-25 1
- 1989-06-30 1
- 1991-06-30 1
- 1993-08-09 1
- 1993-10-18 1
- 1994-12-06 1
- 2001-12-31 1
- 2002-12-31 1
- 2004-06-30 1
- 2006-12-30 1
- 2011-06-30 1
- 2014-04-24 1
- 2015-04-03 1
- 2015-05-21 1
- 2015-06-30 1
- 2018-05-01 1
- 2022-07-07 1
- 2023-06-30 1
City 7
- - 27
- Abu Dhabi 1
- Juarez 1
- Kabul 1
- Rome 1
- Salahuddin 1
- Washington 1
Registrant_Name 1
- Squire Patton Boggs, LLP · 33 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||||
15882 | 15882 | 1982-12-31 | Procesadora de Carne, S.A. (PROCASA) | 1980-08-12 | GUATEMALA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Guatemala City | ||||
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 | ||
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 | ||||
16506 | 16506 | 2001-12-31 | Republic of Benin | 1999-07-08 | BENIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Minister of Finance B.P. 301 Benin, West Africa | ||||
16596 | 16596 | 2005-12-31 | Republic of Bulgaria | 2004-11-05 | BULGARIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 102, G.S. Rakovski Street Sofia, Bulgaria 1040 | ||||
16524 | 16524 | 2002-12-31 | Republic of Costa Rica | 2001-10-02 | COSTA RICA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | San Jose | ||||
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 | ||||
15884 | 15884 | 1982-12-31 | Republic of Gabon | 1982-01-25 | GABON | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
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 | ||||
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 | |||
16484 | 16484 | 2000-12-31 | Republic of Peru, Embassy | 1999-10-29 | PERU | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 1700 Massachusetts Avenue, NW | 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 | |||
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 | |||
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 | ||||
15885 | 15885 | 1982-12-31 | Republic of Zaire | 1981-10-27 | ZAIRE | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
16366 | 16366 | 1995-12-31 | Scheidt & Bachmann, GmbH | 1993-07-02 | GERMANY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Gladbach | ||||
16598 | 16598 | 2005-12-31 | Sociedade Nacional de Combustiveis de Angola (SONANGOL) /Republic of Angola | 2002-08-05 | ANGOLA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Av, 1 Congresso do MPLA 8-16 P.O. Box 2426, Luanda | ||||
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 | ||
16487 | 16487 | 2000-12-31 | Sultanate of Oman | 1999-06-14 | OMAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Royal Air Force of Oman P.O. Box 722 Postal Code 111 | ||||
16282 | 16282 | 1995-12-31 | Taiwanese Reichbanknote Creditors' Association | 1994-03-22 | TAIWAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Taoyen City | ||||
16488 | 16488 | 2000-12-31 | Technical Secretariat for Planning of the Republic of Paraguay | 1999-03-31 | PARAGUAY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Pte. Franco y Ayolas, 3er Piso Asuncion | ||||
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 | |||
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 |
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 | |||
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 | ||||
15504 | 15504 | 2006-12-30 | United Arab Emirates | 2005-05-10 | UNITED ARAB EMIRATES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | UAE Central Bank PO Box 854 | Abu Dhabi | |||
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 |
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]) );