FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 1954-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39524 | 39524 | 1954-12-31 | 1944-05-23 | de Schepper | Hendrik Yssel | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39527 | 39527 | 1954-12-31 | 1952-07-03 | Kooiman | Pieter Johannes | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39528 | 39528 | 1954-12-31 | 1952-07-03 | Moormans | Willem Jan | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39529 | 39529 | 1954-12-31 | 1952-07-03 | Vrymoet | Harry | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39530 | 39530 | 1954-12-31 | 1952-07-24 | Wilmink | Willem M. | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39531 | 39531 | 1954-12-31 | 1954-09-07 | Lampi | Leona Lillian | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | 655 Third Avenue | Suite 1810 | New York | NY | 10017-5617 |
39533 | 39533 | 1954-12-31 | 1943-10-23 | Frank | Jacobus F. | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39534 | 39534 | 1954-12-31 | 1954-10-28 | Westergaard | John Albert | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
39535 | 39535 | 1954-12-31 | 1952-12-05 | Franklin | Edwin | Cunningham & Walsh, Inc. 747 | 1952-12-05 | Cunningham & Walsh, Inc. | 260 Madison Avenue | New York | NY | ||
39536 | 39536 | 1954-12-31 | 1952-12-05 | Reydel | William | Cunningham & Walsh, Inc. 747 | 1952-12-05 | Cunningham & Walsh, Inc. | 260 Madison Avenue | New York | NY | ||
39537 | 39537 | 1954-12-31 | 1952-12-05 | Sheehan | John Redmond | Cunningham & Walsh, Inc. 747 | 1952-12-05 | Cunningham & Walsh, Inc. | 260 Madison Avenue | New York | NY |
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]) );