FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where City = "New York" and "Short_Form_Date" is on date 1950-07-05 sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18790 | 18790 | 1952-06-04 | 1950-07-05 | Alfred | Hohl | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18791 | 18791 | 1952-06-04 | 1950-07-05 | Benais | Hubert B. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18792 | 18792 | 1952-06-04 | 1950-07-05 | Bendi | Andrea | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18793 | 18793 | 1952-06-04 | 1950-07-05 | Boggia | Norma | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18794 | 18794 | 1952-06-04 | 1950-07-05 | Buonaguidi | Lolita Elizabeth | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18795 | 18795 | 1952-06-04 | 1950-07-05 | Cuttitta | Carmel Marie | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18796 | 18796 | 1952-06-04 | 1950-07-05 | Di Rubba | Marisa | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18797 | 18797 | 1952-06-04 | 1950-07-05 | Doria | Nunzio Anthony | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18798 | 18798 | 1952-06-04 | 1950-07-05 | Habberton | Andrew A. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18799 | 18799 | 1952-06-04 | 1950-07-05 | Kahn | Fred C. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18800 | 18800 | 1952-06-04 | 1950-07-05 | Kreiswirth | Arline | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18801 | 18801 | 1952-06-04 | 1950-07-05 | Latham | Savillah Wyatt | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18802 | 18802 | 1952-06-04 | 1950-07-05 | McDougall | Celia M. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18803 | 18803 | 1952-06-04 | 1950-07-05 | Montella | Damaso | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18804 | 18804 | 1952-06-04 | 1950-07-05 | Morcaldi | Frank A. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18805 | 18805 | 1952-06-04 | 1950-07-05 | Sachs | Moses | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18806 | 18806 | 1952-06-04 | 1950-07-05 | Sarah | Gertrude Hulda | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18807 | 18807 | 1952-06-04 | 1950-07-05 | Spina | Eugenio | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18808 | 18808 | 1952-06-04 | 1950-07-05 | Staub | Ruth | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18809 | 18809 | 1952-06-04 | 1950-07-05 | White | Georgette S. | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
18810 | 18810 | 1952-06-04 | 1950-07-05 | de Rosa | Eugene Lucien | CIT Travel Service, Inc. 465 | 1947-06-04 | CIT Travel Service, Inc. | C/O Excel Shipping Company | 44 Whitehall Street | New York | NY | |
39601 | 39601 | 1957-12-31 | 1950-07-05 | de Champeaux | Denis | Agence France-Presse (France-Presse News Agency) 223 | 1943-12-02 | Agence France-Presse (France-Presse News Agency) | 50 Rockefeller Plaza | New York | NY | 10020 |
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]) );