FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Country/Location_Represented = "MEXICO" and "Foreign_Principal_Termination_Date" is on date 1985-10-22 sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Registrant_Date (date)
Registrant_Name 9
- Mexican Government Tourism Office, Dallas 1
- Mexican Government Tourism Office, Denver 1
- Mexican Government Tourism Office, New Orleans 1
- Mexican Government Tourism Office, San Antonio 1
- Mexican Government Tourism Office, San Diego 1
- Mexican Government Tourism Office, San Francisco 1
- Mexican Government Tourism Office, Washington, D.C. 1
- Mexican Government Tourist Office, Tucson 1
- Mexican National Tourist Council 1
Foreign_Principal_Registration_Date (date) 8 ✖
- 1965-04-13 2
- 1965-02-16 1
- 1965-03-10 1
- 1965-03-16 1
- 1965-03-18 1
- 1973-08-24 1
- 1976-01-09 1
- 1980-02-20 1
Foreign_Principal 7
- Departamento de Turismo del Gobierno de Mexico 2
- Mexican Government Tourism Department 2
- Consejo Nacional de Turismo 1
- Government of Mexico Tourism Department 1
- Mexican Government Department of Tourism (Departamento de Turismo) 1
- Mexican Government Tourist Office 1
- Mexican National Tourist Council Government of Mexico 1
State 1
- - 9
Country/Location_Represented 1
- MEXICO · 9 ✖
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12921 | 12921 | 1985-10-22 | Mexican Government Tourist Office | 1965-02-16 | MEXICO | Mexican Government Tourism Office, Dallas 1857 | 1965-02-16 | Mexican Government Tourism Office, Dallas | |||||
12915 | 12915 | 1985-10-22 | Departamento de Turismo del Gobierno de Mexico | 1965-03-10 | MEXICO | Mexican Government Tourism Office, San Diego 1866 | 1965-03-10 | Mexican Government Tourism Office, San Diego | |||||
12916 | 12916 | 1985-10-22 | Departamento de Turismo del Gobierno de Mexico | 1965-03-16 | MEXICO | Mexican Government Tourist Office, Tucson 1870 | 1965-03-16 | Mexican Government Tourist Office, Tucson | |||||
12917 | 12917 | 1985-10-22 | Government of Mexico Tourism Department | 1965-03-18 | MEXICO | Mexican Government Tourism Office, San Francisco 1872 | 1965-03-18 | Mexican Government Tourism Office, San Francisco | |||||
12919 | 12919 | 1985-10-22 | Mexican Government Tourism Department | 1965-04-13 | MEXICO | Mexican Government Tourism Office, New Orleans 1881 | 1965-04-13 | Mexican Government Tourism Office, New Orleans | |||||
12920 | 12920 | 1985-10-22 | Mexican Government Tourism Department | 1965-04-13 | MEXICO | Mexican Government Tourism Office, San Antonio 1882 | 1965-04-13 | Mexican Government Tourism Office, San Antonio | |||||
12918 | 12918 | 1985-10-22 | Mexican Government Department of Tourism (Departamento de Turismo) | 1973-08-24 | MEXICO | Mexican Government Tourism Office, Denver 2455 | 1973-08-24 | Mexican Government Tourism Office, Denver | |||||
12922 | 12922 | 1985-10-22 | Mexican National Tourist Council Government of Mexico | 1976-01-09 | MEXICO | Mexican Government Tourism Office, Washington, D.C. 2651 | 1976-01-09 | Mexican Government Tourism Office, Washington, D.C. | |||||
12914 | 12914 | 1985-10-22 | Consejo Nacional de Turismo | 1980-02-20 | MEXICO | Mexican National Tourist Council 3090 | 1980-02-20 | Mexican National Tourist Council |
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]) );