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_Registration_Date descending
This data as json, CSV (advanced)
Foreign_Principal >30
- Armazens Jose Luis da Costa & C.A., LDA 1
- Asociacion de Amigos del Pais 1
- Asociacion de Azucareros de Guatemala 1
- Associacao dos Armadores da Pesca Longinqua (ADAPLA) 1
- Bauxite Industry Development Company, Ltd. 1
- Beckett Packaging, Ltd. 1
- Buini & Grandi, S.p.A. 1
- Central American Sugar Council 1
- Chippendale Investment Company, N.V. 1
- Departement des Affaires Estrangeres et des Cultes 1
- Duty Free Shoppers Group, Ltd. 1
- EXEL, Ltd. 1
- Embassy of Spain 1
- F. Palicio y Cia., S.A. 1
- Fiart Cantieri Italiani, S.p.A. 1
- Fundacion de Defensa del Comercio Exterior 1
- Government of Iceland 1
- Government of the Republic of the Marshall Islands 1
- Government of the Sultanate of Oman 1
- Japan Airlines Company, Ltd. 1
- Korea Marine Industry Development Corporation 1
- Menendez, Garcia y Cia., Ltd. 1
- Metal Market & Exchange Company, Ltd. 1
- Minerals Marketing Corporation of Zimbabwe (MMCZ) 1
- Nakajima All Company, Ltd. 1
- National Association of Beer Manufacturers of Mexico 1
- National Investment Council of Panama 1
- Por Larranaga, Fabrica de Tabacos, S.A. 1
- Procesadora de Carne, S.A. (PROCASA) 1
- Republic of Gabon 1
- …
Country/Location_Represented 24
- GUATEMALA 4
- SPAIN 3
- GREAT BRITAIN 2
- ITALY 2
- JAPAN 2
- PORTUGAL 2
- CANADA 1
- CAYMAN ISLANDS 1
- COSTA RICA 1
- CURACAO 1
- GABON 1
- GUYANA 1
- HAITI 1
- HONG KONG 1
- ICELAND 1
- KOREA, SOUTH 1
- MARSHALL ISLANDS 1
- MEXICO 1
- OMAN 1
- PANAMA 1
- PHILIPPINES 1
- VENEZUELA 1
- ZAIRE 1
- ZIMBABWE 1
Registrant_Name 1
- Squire Patton Boggs, LLP · 33 ✖
City 1
- - 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8454 | 8454 | 1990-06-30 | Beckett Packaging, Ltd. | 1988-03-16 | CANADA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Ontario | ||||
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 | ||||
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 | |||
8464 | 8464 | 1990-06-30 | Minerals Marketing Corporation of Zimbabwe (MMCZ) | 1987-12-23 | ZIMBABWE | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Harare | ||||
16201 | 16201 | 1991-12-31 | Government of the Republic of the Marshall Islands | 1987-11-16 | MARSHALL ISLANDS | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Majuro | ||||
7400 | 7400 | 1987-06-01 | EXEL, Ltd. | 1986-10-03 | CAYMAN ISLANDS | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
16317 | 16317 | 1995-12-31 | Fiart Cantieri Italiani, S.p.A. | 1986-03-07 | ITALY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Napoli | ||||
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 | ||||
6822 | 6822 | 1989-05-25 | Buini & Grandi, S.p.A. | 1984-08-13 | ITALY | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Bologna | ||||
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 | |||
8387 | 8387 | 1984-06-30 | National Association of Beer Manufacturers of Mexico | 1982-10-21 | MEXICO | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
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 | ||||
6824 | 6824 | 1989-05-25 | F. Palicio y Cia., S.A. | 1982-03-26 | VENEZUELA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Caracas | ||||
6825 | 6825 | 1989-05-25 | Menendez, Garcia y Cia., Ltd. | 1982-03-26 | SPAIN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Madrid | ||||
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 | ||||
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 | ||||
8392 | 8392 | 1985-06-30 | Asociacion de Azucareros de Guatemala | 1982-01-25 | GUATEMALA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Guatemala | ||||
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 | |||
16312 | 16312 | 1995-12-31 | Duty Free Shoppers Group, Ltd. | 1981-02-13 | HONG KONG | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | |||||
8341 | 8341 | 1982-06-30 | Associacao dos Armadores da Pesca Longinqua (ADAPLA) | 1980-12-22 | PORTUGAL | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Lisbon | ||||
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 | |||
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 | ||||
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 | |||||
8340 | 8340 | 1982-06-30 | Armazens Jose Luis da Costa & C.A., LDA | 1980-03-11 | PORTUGAL | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Lisbon | ||||
15856 | 15856 | 1981-12-31 | Bauxite Industry Development Company, Ltd. | 1979-03-13 | GUYANA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Georgetown | ||||
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 | ||||
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 | ||||
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 |
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]) );