FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
38 rows where Short_Form_Termination_Date = "1957-06-30" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20653 | 20653 | 1957-06-30 | 1952-02-13 | Hasselriis | Caspar H.W. | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20654 | 20654 | 1957-06-30 | 1951-02-16 | Brink | Earl B. | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20655 | 20655 | 1957-06-30 | 1951-02-16 | Dessau | Axel Carl Julius | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20656 | 20656 | 1957-06-30 | 1951-02-16 | Nordholm | Birger Josef | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20657 | 20657 | 1957-06-30 | 1951-02-16 | Pillichody | Henry | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20658 | 20658 | 1957-06-30 | 1956-02-27 | Goris | Jan Albert | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20659 | 20659 | 1957-06-30 | 1952-03-12 | Wolleback | Einar Christian | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20660 | 20660 | 1957-06-30 | 1951-04-16 | Clark | Ronald | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20661 | 20661 | 1957-06-30 | 1946-04-22 | Brodie | Bernard B. | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20662 | 20662 | 1957-06-30 | 1946-04-22 | Moolman | Henry Martin | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20663 | 20663 | 1957-06-30 | 1946-04-22 | Rosenfeld | William | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
20664 | 20664 | 1957-06-30 | 1948-04-27 | Fritzner | Harald Haslum | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20665 | 20665 | 1957-06-30 | 1948-04-27 | Mohn | Christian J. | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20666 | 20666 | 1957-06-30 | 1948-04-27 | Sater | Sigurd | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20667 | 20667 | 1957-06-30 | 1948-04-27 | Vetlesen | F.W. Georg Unger | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20668 | 20668 | 1957-06-30 | 1948-04-27 | Williams | Harry J. | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20669 | 20669 | 1957-06-30 | 1947-05-15 | Fonkalsrud | Arne Saksum | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20670 | 20670 | 1957-06-30 | 1947-05-15 | Lindholm | Albert Blytt | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20671 | 20671 | 1957-06-30 | 1947-05-15 | Muller | Harald | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20672 | 20672 | 1957-06-30 | 1947-05-15 | Rost | Kristen B. | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20673 | 20673 | 1957-06-30 | 1947-05-15 | Sareussen | John Sverdrup | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20674 | 20674 | 1957-06-30 | 1948-06-14 | Huisking | Chas L. | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20675 | 20675 | 1957-06-30 | 1948-06-14 | Westad | Rolf Gronvold | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20676 | 20676 | 1957-06-30 | 1955-07-08 | Reed | Kenneth Milford , Jr. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
20677 | 20677 | 1957-06-30 | 1955-08-01 | Ido | Sakae | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
20678 | 20678 | 1957-06-30 | 1954-09-02 | Bull | John Storm | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20679 | 20679 | 1957-06-30 | 1954-09-02 | Holm | Oluf Sivert Thalberg | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20680 | 20680 | 1957-06-30 | 1954-09-02 | Johnson | Clinton Charles | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20681 | 20681 | 1957-06-30 | 1944-09-06 | Osmond | J.M. | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20682 | 20682 | 1957-06-30 | 1944-09-06 | Rohde | Georg Alfred | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20683 | 20683 | 1957-06-30 | 1956-10-02 | Blom | Christian Lauritz | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20684 | 20684 | 1957-06-30 | 1956-10-02 | Lorentzen | Per Arne | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20685 | 20685 | 1957-06-30 | 1947-10-10 | Cassidy | Turid Helmers Ryjord | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20686 | 20686 | 1957-06-30 | 1950-10-10 | Vanberg | Jarl Bent Egil | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20687 | 20687 | 1957-06-30 | 1957-10-21 | Watson | Arthur Kittredge | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20688 | 20688 | 1957-06-30 | 1954-10-28 | Asche | Douglas Ermando | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20689 | 20689 | 1957-06-30 | 1954-10-28 | Lange | Arthur Gustav | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 Madison Avenue | New York | NY | ||
20690 | 20690 | 1957-06-30 | 1952-11-10 | Dahil | Hans Herlof | Norwegian-American Chamber of Commerce, Inc. 277 | 1944-09-06 | Norwegian-American Chamber of Commerce, Inc. | 290 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]) );