FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Registration_Date" is on date 1965-08-16 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Termination_Date (date)
Foreign_Principal 13
- Government of Brazil 1
- Government of Colombia 1
- Government of Costa Rica 1
- Government of Cuba 1
- Government of Ecuador 1
- Government of El Salvador 1
- Government of Guatemala 1
- Government of Honduras 1
- Government of Mexico 1
- Government of Nicaragua 1
- Government of Panama 1
- Government of Venezuela 1
- Government of the Dominican Republic 1
Country/Location_Represented 13
- BRAZIL 1
- COLOMBIA 1
- COSTA RICA 1
- CUBA 1
- DOMINICAN REPUBLIC 1
- ECUADOR 1
- EL SALVADOR 1
- GUATEMALA 1
- HONDURAS 1
- MEXICO 1
- NICARAGUA 1
- PANAMA 1
- VENEZUELA 1
State 1
- - 13
Registrant_Name 1
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3224 | 3224 | 1969-03-01 | Government of Nicaragua | 1965-08-16 | NICARAGUA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Managua | ||||
11930 | 11930 | 1973-09-30 | Government of Ecuador | 1965-08-16 | ECUADOR | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Quito | ||||
11933 | 11933 | 1974-09-30 | Government of Honduras | 1965-08-16 | HONDURAS | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Tegucigalpa | ||||
14297 | 14297 | 1971-11-29 | Government of Costa Rica | 1965-08-16 | COSTA RICA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | San Jose | ||||
15760 | 15760 | 1976-12-31 | Government of Brazil | 1965-08-16 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
15761 | 15761 | 1976-12-31 | Government of Colombia | 1965-08-16 | COLOMBIA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Bogota | ||||
15762 | 15762 | 1976-12-31 | Government of Cuba | 1965-08-16 | CUBA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Havana | ||||
15763 | 15763 | 1976-12-31 | Government of El Salvador | 1965-08-16 | EL SALVADOR | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | San Salvador | ||||
15764 | 15764 | 1976-12-31 | Government of Guatemala | 1965-08-16 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemala City | ||||
15765 | 15765 | 1976-12-31 | Government of Mexico | 1965-08-16 | MEXICO | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | |||||
15766 | 15766 | 1976-12-31 | Government of Panama | 1965-08-16 | PANAMA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Panama City | ||||
15768 | 15768 | 1976-12-31 | Government of Venezuela | 1965-08-16 | VENEZUELA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Caracas | ||||
15769 | 15769 | 1976-12-31 | Government of the Dominican Republic | 1965-08-16 | DOMINICAN REPUBLIC | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Santo Domingo |
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]) );