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

36 rows where Registrant_Name = "Pan-American Coffee Bureau"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Asociacion Nacional del Cafe' (Formerly: Oficina Central del Cafe)" 1
  • Associacion Cafetalera de El Salvador 1
  • Comision Nacional del Cafe' (Formerly: Secretaria de al Economia Nacional) 1
  • Comision de Defensa del Cafe' y del Cacao 1
  • Departamento Nacional do Cafe' 1
  • Federacion Nacional de Cafeteros de Colombia 1
  • 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 Haiti (Office National du Cafe') 1
  • Government of Honduras 1
  • Government of Mexico 1
  • Government of Nicaragua 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
  • Ministerio de Agricultura 1
  • Ministerio de Agricultura y Cria 1
  • Ministerio de Economia 1
  • Ministerio de Fomento, Agricultura y Trabajo 1
  • …

Country/Location_Represented 16

  • GUATEMALA 4
  • MEXICO 4
  • BRAZIL 3
  • DOMINICAN REPUBLIC 3
  • HONDURAS 3
  • COLOMBIA 2
  • COSTA RICA 2
  • CUBA 2
  • ECUADOR 2
  • EL SALVADOR 2
  • NICARAGUA 2
  • PANAMA 2
  • VENEZUELA 2
  • HAITI 1
  • INTERNATIONAL 1
  • PERU 1

State 2

  • - 35
  • NY 1

Registrant_Name 1

  • Pan-American Coffee Bureau · 36 ✖

City 1

  • - 36
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        
6852 6852 1961-05-26 Oficina Central del Cafe' 1946-12-06 GUATEMALA Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau Guatemala City        
6860 6860 1959-05-27 Comision Nacional del Cafe' (Formerly: Secretaria de al Economia Nacional) 1956-11-19 MEXICO Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau          
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        
13151 13151 1964-10-30 World Coffee Promotion Committee 1962-10-29 INTERNATIONAL Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau New York     NY  
14068 14068 1956-11-19 Secretaria de Economia Nacional 1946-12-06 MEXICO Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau          
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        
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        
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        
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          
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        
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 137.259ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history