FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
116 rows where Registrant_Name = "Squire Patton Boggs, LLP" and Zip = "" sorted by State
This data as json, CSV (advanced)
Foreign_Principal 19
- American Worldwide, Inc./Government of the Republic of Angola 1
- Embassy of Mexico 1
- Embassy of Spain 1
- Embassy of the Bolivarian Republic of Venezuela 1
- Embassy of the State of Kuwait 1
- Government of Haiti 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
- Ministry of Foreign Affairs Czech Republic, Embassy 1
- Ministry of Foreign Affairs, Republic of Croatia (Embassy) 1
- National Investment Council of Panama 1
- Republic of Gabon 1
- Republic of Peru, Embassy 1
- Republic of Sri Lanka, Embassy 1
- Republic of Turkey, Embassy 1
- Republic of Zaire 1
- Royal Embassy of Saudi Arabia through Qorvis Communications 1
Country/Location_Represented 19
Registrant_Name 1
- Squire Patton Boggs, LLP · 19 ✖
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
16497 | 16497 | 2001-12-31 | Government of Haiti | 2001-06-04 | HAITI | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Kurzban Kurzban Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133 | FL | |||
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 |
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]) );