FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where "Short_Form_Termination_Date" is on date 1977-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Address_2, Registration_Date (date)
Registration_Number 12
- Pan-American Coffee Bureau 16
- Quebec Government Office 2
- H. Montana Publicity Enterprises, Inc. 2
- Chinese Information Service 1
- British Information Services 1
- Austrian Tourist Office, Inc. 1
- Belgian National Tourist Office 1
- Pekao Trading Corporation 1
- Jamaica Tourist Board, New York 1
- Ruder Finn, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Association Films, Inc. 1
Registrant_Name 12
- Pan-American Coffee Bureau 16
- H. Montana Publicity Enterprises, Inc. 2
- Quebec Government Office 2
- Association Films, Inc. 1
- Austrian Tourist Office, Inc. 1
- Belgian National Tourist Office 1
- British Information Services 1
- Chinese Information Service 1
- Jamaica Tourist Board, New York 1
- Pekao Trading Corporation 1
- Ruder Finn, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
State 1
- NY · 29 ✖
City 1
- New York 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
40024 | 40024 | 1977-12-31 | 1976-02-12 | Collings | Veronica | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
40025 | 40025 | 1977-12-31 | 1956-02-13 | De Maerel | Peter A. | Belgian National Tourist Office 529 | 1948-06-17 | Belgian National Tourist Office | 300 East 42nd Street | 14th Floor | New York | NY | 10017 |
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 | |
40029 | 40029 | 1977-12-31 | 1977-03-29 | Montana | Helene B. | H. Montana Publicity Enterprises, Inc. 2764 | 1977-03-28 | H. Montana Publicity Enterprises, Inc. | 290 Ninth Avenue | New York | NY | 10001 | |
40030 | 40030 | 1977-12-31 | 1977-03-29 | Montana | Vanni B. | H. Montana Publicity Enterprises, Inc. 2764 | 1977-03-28 | H. Montana Publicity Enterprises, Inc. | 290 Ninth Avenue | New York | NY | 10001 | |
40033 | 40033 | 1977-12-31 | 1973-05-15 | Deslauriers | J. Robert | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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 | |
40035 | 40035 | 1977-12-31 | 1973-05-21 | Tadeusz | Rokita | Pekao Trading Corporation 817 | 1954-02-23 | Pekao Trading Corporation | Two Park Avenue | Suite 400 | New York | NY | 10016 |
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 | |
40037 | 40037 | 1977-12-31 | 1973-06-12 | Peng | Kuang-Tien | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
40040 | 40040 | 1977-12-31 | 1965-08-05 | Sanders | William I. | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
40041 | 40041 | 1977-12-31 | 1976-08-10 | Sharpe | Eric Stuart | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
40042 | 40042 | 1977-12-31 | 1973-08-14 | Brussaly | Ophelia | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
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 | |
40046 | 40046 | 1977-12-31 | 1971-09-20 | Poliquin | Guy | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
40047 | 40047 | 1977-12-31 | 1963-10-25 | Iwamoto | Ranko | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
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 | |
40057 | 40057 | 1977-12-31 | 1974-12-27 | Fliegel | Rose Marie | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );