FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1974-12-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
Registration_Number 10
- German-American Chamber of Commerce, Inc., New York 2
- Swedish Tourist Office 1
- European Travel Commission 1
- Egyptian Government Tourist Office 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Tea Council of the U.S.A., Inc. 1
- Singapore Economic Development Board 1
- Marplan Research, Inc. 1
- Bozell & Jacobs Public Relations, Inc. 1
- Loeb, Rhoades & Company 1
Registrant_Name 10
- German-American Chamber of Commerce, Inc., New York 2
- Bozell & Jacobs Public Relations, Inc. 1
- Egyptian Government Tourist Office 1
- European Travel Commission 1
- Loeb, Rhoades & Company 1
- Marplan Research, Inc. 1
- Singapore Economic Development Board 1
- Swedish Tourist Office 1
- Tea Council of the U.S.A., Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39955 | 39955 | 1974-12-31 | 1972-01-11 | Khalil | Samir M. | Egyptian Government Tourist Office 1322 | 1960-01-13 | Egyptian Government Tourist Office | 630 Fifth Avenue | New York | NY | 10020 | |
39956 | 39956 | 1974-12-31 | 1965-02-10 | Wiederecht | Donald A. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
39957 | 39957 | 1974-12-31 | 1973-02-22 | Axen | Per Ulrik | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39960 | 39960 | 1974-12-31 | 1968-03-26 | Agnelli | Bernard F. | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
39962 | 39962 | 1974-12-31 | 1971-04-20 | Miller | John | Marplan Research, Inc. 2124 | 1969-02-26 | Marplan Research, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
39963 | 39963 | 1974-12-31 | 1974-06-24 | Andrews | John Paul | Bozell & Jacobs Public Relations, Inc. 2522 | 1974-06-24 | Bozell & Jacobs Public Relations, Inc. | 1 Dag Hammarskjold Plaza | New York | NY | 10017 | |
39965 | 39965 | 1974-12-31 | 1974-07-24 | Loeb | John L. | Loeb, Rhoades & Company 2527 | 1974-07-24 | Loeb, Rhoades & Company | 42 Wall Street | New York | NY | 10005 | |
39966 | 39966 | 1974-12-31 | 1974-07-27 | Hirseland | Gerhard | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | 40 West 57th Street | New York | NY | 10019-4092 | |
39968 | 39968 | 1974-12-31 | 1973-09-04 | Schwartz | Stephanie | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
39970 | 39970 | 1974-12-31 | 1964-11-04 | Ledermann | Christoph | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | 40 West 57th Street | New York | NY | 10019-4092 | |
39971 | 39971 | 1974-12-31 | 1973-11-07 | Mrkela | Djuro | European Travel Commission 574 | 1949-06-30 | European Travel Commission | c/o Spring O'Brien | 30 West 26th Street, 4th Floor | New York | NY | 10010 |
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]) );