FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Foreign_Principal = "Government of Mexico"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name 11
- Burson-Marsteller 1
- FTI Consulting (SC), Inc. 1
- Law Offices of Cohen & Uretz 1
- McCutchen, Doyle, Brown & Enersen, L.L.P. 1
- Milbank, Tweed, Hadley & McCloy 1
- Moran, Mark E. 1
- Morgan, Lewis & Bockius, L.L.P. 1
- Pan-American Coffee Bureau 1
- Protocol Services, Ltd. 1
- Public Strategies Washington, Inc. 1
- Ruder Finn, Inc. 1
Address_1 6 ✖
City 2
- - 10
- Mexico City 1
Address_2 2 ✖
Foreign_Principal 1
- Government of Mexico · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1217 | 1217 | 1988-01-11 | Government of Mexico | 1974-02-20 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
2256 | 2256 | 1983-02-07 | Government of Mexico | 1979-07-11 | MEXICO | Law Offices of Cohen & Uretz 2272 | 1971-07-29 | Law Offices of Cohen & Uretz | |||||
2576 | 2576 | 2019-02-15 | Government of Mexico | 1991-03-15 | MEXICO | Public Strategies Washington, Inc. 4486 | 1991-03-15 | Public Strategies Washington, Inc. | Mexico City | ||||
3490 | 3490 | 2019-03-06 | Government of Mexico | 2017-11-03 | MEXICO | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | Av. Paseo de la Reforma 296, 24th Floor | Col. Juarez, Deleg. Cuauhtemoc C.P. 06600 Mexico City | |||
5799 | 5799 | 1973-04-30 | Government of Mexico | 1971-11-23 | MEXICO | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
6781 | 6781 | 1994-05-24 | Government of Mexico | 1990-01-16 | MEXICO | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Chapultapec | ||||
6789 | 6789 | 1995-05-24 | Government of Mexico | 1989-09-29 | MEXICO | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | Washington | DC | |||
7168 | 7168 | 1998-05-31 | Government of Mexico | 1997-11-18 | MEXICO | McCutchen, Doyle, Brown & Enersen, L.L.P. 5218 | 1997-11-18 | McCutchen, Doyle, Brown & Enersen, L.L.P. | |||||
11640 | 11640 | 1989-09-15 | Government of Mexico | 1987-03-09 | MEXICO | Moran, Mark E. 3945 | 1987-03-09 | Moran, Mark E. | Mexico City | ||||
12903 | 12903 | 1964-10-22 | Government of Mexico | 1964-06-04 | MEXICO | Protocol Services, Ltd. 1749 | 1964-06-04 | Protocol Services, Ltd. | New York | NY | |||
15765 | 15765 | 1976-12-31 | Government of Mexico | 1965-08-16 | MEXICO | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau |
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]) );