FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1965-06-30
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20750 | 20750 | 1965-06-30 | 1962-01-17 | Rittersporn | Bernard Andrew , Jr. | Murden & Company, Inc. 1510 | 1962-01-17 | Murden & Company, Inc. | 39 East 51st Street | New York | NY | 10022 | |
20751 | 20751 | 1965-06-30 | 1963-01-25 | Ouchi | Yukio | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
20752 | 20752 | 1965-06-30 | 1964-01-30 | Fujinei | Kazuo | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
20753 | 20753 | 1965-06-30 | 1964-01-30 | Fuke | Teizo | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
20757 | 20757 | 1965-06-30 | 1956-03-16 | Chilleri | Luigi Ferdinando | Italian Government Tourist Board, New York 568 | 1949-04-21 | Italian Government Tourist Board, New York | 686 Park Avenue | 3rd Floor | New York | NY | 10065 |
20758 | 20758 | 1965-06-30 | 1962-04-18 | Kimura | Tsutomu | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
20759 | 20759 | 1965-06-30 | 1962-04-18 | Noguchi | Akira | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
20760 | 20760 | 1965-06-30 | 1961-04-20 | Sepulveda | Marcelo | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
20761 | 20761 | 1965-06-30 | 1964-05-08 | McIntosh | Alma | Rescue Committee for Mozambique 1724 | 1964-05-08 | Rescue Committee for Mozambique | 2019 5th Avenue | New York | NY | 10012 | |
20762 | 20762 | 1965-06-30 | 1964-05-08 | Scribner | Gertrude | Rescue Committee for Mozambique 1724 | 1964-05-08 | Rescue Committee for Mozambique | 2019 5th Avenue | New York | NY | 10012 | |
20763 | 20763 | 1965-06-30 | 1964-05-08 | Smith | Klytus | Rescue Committee for Mozambique 1724 | 1964-05-08 | Rescue Committee for Mozambique | 2019 5th Avenue | New York | NY | 10012 | |
20764 | 20764 | 1965-06-30 | 1964-05-08 | Williams, Jr., | Art | Rescue Committee for Mozambique 1724 | 1964-05-08 | Rescue Committee for Mozambique | 2019 5th Avenue | New York | NY | 10012 | |
20765 | 20765 | 1965-06-30 | 1961-05-22 | Bennahum | Victor | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
20769 | 20769 | 1965-06-30 | 1946-11-25 | Siemon | William J. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
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 | |
20771 | 20771 | 1965-06-30 | 1964-12-15 | Litell | Richard John | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | 825 Third Avenue | New York | NY | 10022 |
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]) );