FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Foreign_Principal_Termination_Date" is on date 1976-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 39
- Mexican Government Tourism Department 2
- Asociacion Nacional del Cafe' (Formerly: Oficina Central del Cafe)" 1
- Associacion Cafetalera de El Salvador 1
- City of Hamburg 1
- Comision de Defensa del Cafe' y del Cacao 1
- Communications Affiliates (Bahamas), Ltd. on behalf of the Government of the Bahama Island 1
- Departamento De Turismo, Del Gobierno De Mexico, Mexican Government Tourism Department 1
- Departamento Nacional do Cafe' 1
- Departamento de Turismo 1
- Department of Tourism of the Government of Mexico (Department of Tourism of the Mexican Government) 1
- Federacion Nacional de Cafeteros de Colombia 1
- German Federal Railroad 1
- Government of Brazil 1
- Government of Colombia 1
- Government of Cuba 1
- Government of El Salvador 1
- Government of Guatemala 1
- Government of Haiti (Office National du Cafe') 1
- Government of Mexico 1
- Government of Panama 1
- Government of Peru (Comite Cafetalero del Peru) 1
- Government of Venezuela 1
- Government of the Dominican Republic 1
- Instituto Brasileiro do Cafe' 1
- Instituto Mexicano del Cafe' (Formerly: Comision Nacional del Cafe') 1
- Instituto Nacional de Estabilizacion del Cafe' 1
- Instituto de Defesa del Cafe' 1
- Instituto de Fomento Economico (Institute of Economic Development) 1
- Mauritius Chamber of Agriculture 1
- Mauritius Sugar Syndicate 1
- Ministerio de Agricultura 1
- Ministerio de Agricultura y Cria 1
- Ministerio de Economia 1
- Ministerio de Fomento, Agricultura y Trabajo 1
- Ministerio de Recursos Naturales (Formerly: Ministerio de Agricultura) 1
- Oficina Contralora de Cafe' (Formerly: Oficina Central del Cafe)" 1
- Press & Information Office of the City of West Berlin 1
- Rhodesian National Tourist Board 1
- Secretaria de Estado de Industria y Comercio (Formerly: Secretaria de Estado de Agricultura, Pecuaria y Colonizacion 1
Country/Location_Represented 19
- MEXICO 7
- BRAZIL 3
- DOMINICAN REPUBLIC 3
- GERMANY, FEDERAL REPUBLIC OF 3
- GUATEMALA 3
- COLOMBIA 2
- CUBA 2
- EL SALVADOR 2
- HONDURAS 2
- MAURITIUS 2
- PANAMA 2
- VENEZUELA 2
- BAHAMAS 1
- COSTA RICA 1
- ECUADOR 1
- HAITI 1
- NICARAGUA 1
- PERU 1
- ZIMBABWE 1
Registrant_Name 12
- Pan-American Coffee Bureau 28
- Pierson, Semmes, Crolius & Finley 2
- Association Films, Inc. 1
- Clinton E. Frank, Inc. 1
- Kaghan, Theodore 1
- Marquardt, H. William 1
- McCann-Erickson, Inc. 1
- Mexican Government Ministry of Tourism, New York 1
- Mexican Ministry of Tourism, Chicago 1
- Mexican Ministry of Tourism, Houston 1
- Mexican Ministry of Tourism, Los Angeles 1
- Mexican Ministry of Tourism, Washington, D.C. 1
City 1
- - 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15744 | 15744 | 1976-12-31 | Comision de Defensa del Cafe' y del Cacao | 1946-12-06 | DOMINICAN REPUBLIC | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Cuidad, Trujillo | ||||
15745 | 15745 | 1976-12-31 | Departamento Nacional do Cafe' | 1946-12-06 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
15746 | 15746 | 1976-12-31 | Government of Haiti (Office National du Cafe') | 1965-12-02 | HAITI | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Port-au-Prince | ||||
15747 | 15747 | 1976-12-31 | Instituto Brasileiro do Cafe' | 1953-05-25 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
15748 | 15748 | 1976-12-31 | Instituto Mexicano del Cafe' (Formerly: Comision Nacional del Cafe') | 1959-05-27 | MEXICO | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | |||||
15749 | 15749 | 1976-12-31 | Instituto Nacional de Estabilizacion del Cafe' | 1946-12-06 | CUBA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Havana | ||||
15750 | 15750 | 1976-12-31 | Instituto de Defesa del Cafe' | 1946-12-06 | COSTA RICA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | San Jose | ||||
15751 | 15751 | 1976-12-31 | Asociacion Nacional del Cafe' (Formerly: Oficina Central del Cafe)" | 1961-05-26 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemal City | ||||
15752 | 15752 | 1976-12-31 | Associacion Cafetalera de El Salvador | 1946-12-06 | EL SALVADOR | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | San Salvador | ||||
15753 | 15753 | 1976-12-31 | City of Hamburg | 1974-02-25 | GERMANY, FEDERAL REPUBLIC OF | Marquardt, H. William 2498 | 1974-02-25 | Marquardt, H. William | |||||
15754 | 15754 | 1976-12-31 | Communications Affiliates (Bahamas), Ltd. on behalf of the Government of the Bahama Island | 1967-07-05 | BAHAMAS | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | Nassau | ||||
15755 | 15755 | 1976-12-31 | Departamento De Turismo, Del Gobierno De Mexico, Mexican Government Tourism Department | 1965-03-15 | MEXICO | Mexican Ministry of Tourism, Houston 1847 | 1965-01-27 | Mexican Ministry of Tourism, Houston | |||||
15756 | 15756 | 1976-12-31 | Departamento de Turismo | 1965-04-12 | MEXICO | Mexican Government Ministry of Tourism, New York 1879 | 1965-04-12 | Mexican Government Ministry of Tourism, New York | |||||
15757 | 15757 | 1976-12-31 | Department of Tourism of the Government of Mexico (Department of Tourism of the Mexican Government) | 1965-02-04 | MEXICO | Mexican Ministry of Tourism, Chicago 1852 | 1965-02-04 | Mexican Ministry of Tourism, Chicago | |||||
15758 | 15758 | 1976-12-31 | Federacion Nacional de Cafeteros de Colombia | 1946-12-06 | COLOMBIA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Bogota | ||||
15759 | 15759 | 1976-12-31 | German Federal Railroad | 1975-05-28 | GERMANY, FEDERAL REPUBLIC OF | Clinton E. Frank, Inc. 2586 | 1975-05-28 | Clinton E. Frank, Inc. | New York | NY | |||
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 | ||||
15767 | 15767 | 1976-12-31 | Government of Peru (Comite Cafetalero del Peru) | 1965-12-02 | PERU | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Lima | ||||
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 | ||||
15770 | 15770 | 1976-12-31 | Instituto de Fomento Economico (Institute of Economic Development) | 1959-11-19 | PANAMA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | |||||
15771 | 15771 | 1976-12-31 | Mauritius Chamber of Agriculture | 1969-08-21 | MAURITIUS | Pierson, Semmes, Crolius & Finley 2159 | 1969-08-21 | Pierson, Semmes, Crolius & Finley | Port Louis | ||||
15772 | 15772 | 1976-12-31 | Mauritius Sugar Syndicate | 1969-08-21 | MAURITIUS | Pierson, Semmes, Crolius & Finley 2159 | 1969-08-21 | Pierson, Semmes, Crolius & Finley | Port Louis | ||||
15773 | 15773 | 1976-12-31 | Mexican Government Tourism Department | 1965-03-16 | MEXICO | Mexican Ministry of Tourism, Los Angeles 1869 | 1965-03-16 | Mexican Ministry of Tourism, Los Angeles | |||||
15774 | 15774 | 1976-12-31 | Mexican Government Tourism Department | 1970-05-13 | MEXICO | Mexican Ministry of Tourism, Washington, D.C. 2196 | 1970-05-13 | Mexican Ministry of Tourism, Washington, D.C. | Mexico City | ||||
15775 | 15775 | 1976-12-31 | Ministerio de Agricultura y Cria | 1946-12-06 | VENEZUELA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Caracas | ||||
15776 | 15776 | 1976-12-31 | Ministerio de Agricultura | 1959-11-20 | NICARAGUA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Managua | ||||
15777 | 15777 | 1976-12-31 | Ministerio de Economia | 1952-11-21 | ECUADOR | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Quito | ||||
15778 | 15778 | 1976-12-31 | Ministerio de Fomento, Agricultura y Trabajo | 1949-06-23 | HONDURAS | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Tegucigalpa | ||||
15779 | 15779 | 1976-12-31 | Ministerio de Recursos Naturales (Formerly: Ministerio de Agricultura) | 1957-11-25 | HONDURAS | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Tegucigalpa | ||||
15780 | 15780 | 1976-12-31 | Oficina Contralora de Cafe' (Formerly: Oficina Central del Cafe)" | 1960-11-25 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemala City | ||||
15781 | 15781 | 1976-12-31 | Press & Information Office of the City of West Berlin | 1976-04-01 | GERMANY, FEDERAL REPUBLIC OF | Kaghan, Theodore 2677 | 1976-04-01 | Kaghan, Theodore | |||||
15782 | 15782 | 1976-12-31 | Rhodesian National Tourist Board | 1971-08-24 | ZIMBABWE | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York City | NY | |||
15783 | 15783 | 1976-12-31 | Secretaria de Estado de Industria y Comercio (Formerly: Secretaria de Estado de Agricultura, Pecuaria y Colonizacion | 1956-11-19 | DOMINICAN REPUBLIC | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Cuidad Trujillo |
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]) );