FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where City = "", Registrant_Name = "Squire Patton Boggs, LLP" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 19
- American Environmental Company, Inc. 1
- Embassy of Mexico 1
- Embassy of Spain 1
- Embassy of the Arab Republic of Egypt 1
- Embassy of the Bolivarian Republic of Venezuela 1
- Embassy of the State of Kuwait 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
State 1
- DC · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 |
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]) );