home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Termination_Date (date), Registrant_Date (date)

Foreign_Principal >30

  • 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
  • …

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

State 2

  • - 38
  • NY 2

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

CSV options:

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])
);
Powered by Datasette · Queries took 519.095ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows