FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Country/Location_Represented = "MEXICO" and Foreign_Principal_Termination_Date = ""
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 10
Foreign_Principal 9
- Embassy of Mexico 2
- Government of the United Mexican States 2
- DEACERO S.A.P.I. de .C,V, (DEACERO) 1
- Government of United Mexican States 1
- International Maize and Wheat Improvement Center (CIMMYT) 1
- Los Cabos Tourism Board, a.k.a. Fideicomiso de Turismo de los Cabos (FITURCA) 1
- Secretaria de Economia 1
- Secretaria de Turismo del Gobierno de Mexico (via Braintivity) 1
- Turismo de Los Cabos 1
City 7
- - 4
- Washington 2
- Cuauhtemoc 1
- Juarez 1
- MEXICO 1
- Mexico City 1
- Texcoco 1
Country/Location_Represented 1
- MEXICO · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135 | 135 | DEACERO S.A.P.I. de .C,V, (DEACERO) | 2022-03-17 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | ||||||
176 | 176 | Embassy of Mexico | 2022-01-12 | MEXICO | Glassman Enterprises, LLC 7069 | 2022-01-12 | Glassman Enterprises, LLC | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
177 | 177 | Embassy of Mexico | 2021-09-07 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
298 | 298 | Government of United Mexican States | 2009-03-09 | MEXICO | Kuykendall, Gregory J., PC 5917 | 2009-03-09 | Kuykendall, Gregory J., PC | Consultoria Juridica Plaza #20, Piso 6 | Col. Centro, Deleg. Cuauhtemoc C.P. 06010 D.F. | Juarez | |||
315 | 315 | Government of the United Mexican States | 2021-08-18 | MEXICO | Shadowen, Steve Duane 6993 | 2021-08-18 | Shadowen, Steve Duane | Ave. Juarez #20, Col. Centro, CP 06010, Del., Centro, CP | 06010, Del. Cuauhtemoc | Mexico City | |||
316 | 316 | Government of the United Mexican States | 2022-10-05 | MEXICO | Global Action on Gun Violence (GAGV) Inc. 7175 | 2022-10-05 | Global Action on Gun Violence (GAGV) Inc. | Ave. Juarez #20, Colonia Centro Mexico City, Del. | Cuauhtemoc | ||||
347 | 347 | International Maize and Wheat Improvement Center (CIMMYT) | 2022-05-13 | MEXICO | Ecospherics, LLC 7119 | 2022-05-13 | Ecospherics, LLC | 45 Carretera Mexico-Veracruz | El Batan | Texcoco | |||
441 | 441 | Los Cabos Tourism Board, a.k.a. Fideicomiso de Turismo de los Cabos (FITURCA) | 2022-01-06 | MEXICO | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | CARRETERA TRANSPENINSULAR KM. 4.3, FRACCION I LOTE 5 | PLAZA PROVIDENCIA, LOCAL 209-210 | MEXICO | 23454 | ||
630 | 630 | Secretaria de Economia | 1998-04-09 | MEXICO | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 50 Fremont Street San Francisco | CA | ||||
631 | 631 | Secretaria de Turismo del Gobierno de Mexico (via Braintivity) | 2022-10-12 | MEXICO | Visit Mexico USA, LLC 7184 | 2022-10-12 | Visit Mexico USA, LLC | Avenida Presidente Masaryk, 172 Bosques de Chapultepec Ciudad de México | |||||
725 | 725 | Turismo de Los Cabos | 2017-11-27 | MEXICO | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | Lote S Plaza Providencia | Cabo San Lucas |
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]) );