FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

55 rows where Registrant_Name = "Pan-American Coffee Bureau", Registration_Number = 406 and Zip = 10019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Pan-American Coffee Bureau · 55 ✖

Registrant_Name 1

  • Pan-American Coffee Bureau · 55 ✖

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
2549 2549 1970-01-01 1969-02-26 Cavalcanti Geraldo Holanda Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
6768 6768 1947-02-14 1946-12-06 Canal Carlos Manuel Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
8639 8639 1960-03-01 1956-11-19 D'Aubuisson Carlos Cordero Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
10177 10177 1956-03-18 1953-05-25 Cintra-Leite Horacio Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
11399 11399 1965-03-31 1946-12-06 Goelkel George Rinaldo Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
12372 12372 1959-04-01 1946-12-06 Barreda Manuel Proto Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14223 14223 1951-04-28 1948-11-17 de Andrade Theophilo Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14224 14224 1951-04-28 1950-11-24 McKiernan John F. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14225 14225 1954-04-28 1952-05-22 Pue George , Jr. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14226 14226 1954-04-28 1949-06-23 Pierini Spartacus Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14416 14416 1955-04-30 1952-05-22 Reydel William Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14417 14417 1955-04-30 1953-07-16 Burns John Arthur , Jr. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14420 14420 1958-04-30 1955-05-17 Van Horn Edward Eugene Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14423 14423 1960-04-30 1956-06-27 Bledsoe Samuel B. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
14458 14458 1966-04-30 1955-12-20 Evans John Kryder Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
15326 15326 1972-05-01 1969-02-26 de Sa Jose Luiz Ferreira Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
19628 19628 1948-06-16 1946-12-06 Lopez-Herrarte Enrique Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
19629 19629 1948-06-16 1946-12-06 Piza Samuel Emilio Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
19630 19630 1948-06-16 1946-12-06 de Moya Mario Ernesto Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
20738 20738 1963-06-30 1949-06-23 Saltonstall Ellen Short Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
20770 20770 1965-06-30 1953-11-30 Dexter Edwin Boardman Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
22082 22082 1970-07-01 1959-05-27 Marcos Jorge Canavati Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
23828 23828 1963-07-23 1948-11-17 Lindsay Charles Good Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
25484 25484 1972-08-01 1971-05-28 Gomes Cesar Augusto Aguiar Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
27251 27251 1965-08-23 1954-05-28 Wood James Earl Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
28780 28780 1970-09-01 1956-11-19 Beuta Marcos Uscocovich Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
29393 29393 1965-09-08 1959-05-27 Hafers Joao Roberto Suplicy Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
30811 30811 1956-09-30 1946-12-06 Aguilar Roberto Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
30886 30886 1968-09-30 1965-12-02 Llanso Ulises Valdes Ll. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
31806 31806 1969-10-01 1969-02-26 Loreto Jose J. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
32623 32623 1968-10-11 1965-08-16 Hopkins Dorothy Frances Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
33461 33461 1967-10-23 1946-12-06 C. Andres Uribe Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
33589 33589 1968-10-25 1968-02-02 Salgado Herbert M. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
33737 33737 1953-10-28 1951-05-24 Sarmanho Walder Lima Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
33738 33738 1953-10-28 1949-11-25 Martin Mary Margaret Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
34137 34137 1959-10-31 1954-05-28 Russell Richard A. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
34138 34138 1959-10-31 1958-06-26 Orgill James Thomas Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
34831 34831 1967-11-01 1965-12-02 Beltrao Alexandre Fontana Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
36285 36285 1958-11-24 1956-11-19 De Sa Vito Ferreira Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40023 40023 1977-12-31 1968-02-02 Pacheco Jose I. Medeiros Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40026 40026 1977-12-31 1950-03-09 Watson Robert Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40027 40027 1977-12-31 1962-03-14 Coburn Clarence Gilbert Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40028 40028 1977-12-31 1960-03-21 Skelly John Thomas Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40034 40034 1977-12-31 1955-05-17 Coburn Clarence G. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40036 40036 1977-12-31 1959-05-27 Bogan Stanley A. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40043 40043 1977-12-31 1965-08-16 Burgess Kenneth W. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40044 40044 1977-12-31 1968-08-29 Struning William C. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40049 40049 1977-12-31 1961-12-01 Lefeld Walter Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40050 40050 1977-12-31 1946-12-06 Aguila Armando Machado Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40051 40051 1977-12-31 1946-12-06 Hust Hurley Gregg Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40052 40052 1977-12-31 1946-12-06 Mendez William Cesar Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40053 40053 1977-12-31 1946-12-06 Nathanson Irwin M. Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40054 40054 1977-12-31 1946-12-06 Ortega Alberto Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40055 40055 1977-12-31 1946-12-06 Rosenthal Jacob Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019
40056 40056 1977-12-31 1946-12-06 Sherman Ira Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau 1350 Avenue of the Americas   New York NY 10019

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);