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 Address_1
This data as json, CSV (advanced)
Foreign_Principal >30
- Al-Ahmar Trading Group 1
- American Environmental Company, Inc. 1
- Center for Studies and Media Affairs at the Saudi Royal Court 1
- Central American Bank of Economic Integration 1
- City of Heidelberg, Germany 1
- Confederation of Garment Exporters of the Philippines (CONGEP) 1
- Embassy of Spain 1
- Embassy of the Arab Republic of Egypt 1
- Fundacion de Defensa del Comercio Exterior 1
- Government of Georgia 1
- Government of Iceland 1
- Government of Pakistan, Embassy 1
- Government of the Republic of the Philippines 1
- Government of the State of Qatar 1
- Government of the Sultanate of Oman 1
- Japan Airlines Company, Ltd. 1
- Japan Aviation Electronics Industry, Ltd. 1
- Korea Marine Industry Development Corporation 1
- Nakajima All Company, Ltd. 1
- National Investment Council of Panama 1
- Office of the National Security Advisor 1
- Office of the Presidency of the Republic of Benin 1
- Olympic Fibers, S.A. 1
- Provincial Salahuddin Council/Province of Salah Addin 1
- Republic of Costa Rica 1
- Republic of Gabon 1
- Republic of Turkey, Embassy 1
- Republic of Zaire 1
- Sultanate of Oman 1
- Taiwanese Reichbanknote Creditors' Association 1
- …
Country/Location_Represented 27
City 6
- - 28
- Abu Dhabi 1
- Cotonou 1
- Heidelberg 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16675 | 16675 | 2010-12-31 | City of Heidelberg, Germany | 2009-10-27 | GERMANY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Rathaus/Town Hall/Mairie | Postfach 10 55 20, D-69045 | Heidelberg | ||
16199 | 16199 | 1991-12-31 | Government of Iceland | 1986-09-09 | ICELAND | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Reykjavik | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 |
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
16763 | 16763 | 2015-12-31 | Confederation of Garment Exporters of the Philippines (CONGEP) | 2015-02-20 | PHILIPPINES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Unit 15F - 15th Floor - Parkview Tower 2 | Eastwood City - Quezon City | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
16389 | 16389 | 1996-12-31 | Government of the Sultanate of Oman | 1980-10-15 | OMAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC |
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]) );