FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and "Short_Form_Date" is on date 1964-06-01
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6163 | 6163 | 1973-02-05 | 1964-06-01 | Cherner | Norman | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
6164 | 6164 | 1973-02-05 | 1964-06-01 | Shearman | Robert John | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
17006 | 17006 | 1969-05-24 | 1964-06-01 | Kopytin | Viktor Vassilievich | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
20348 | 20348 | 1967-06-27 | 1964-06-01 | Callan | Edward F. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20349 | 20349 | 1967-06-27 | 1964-06-01 | Hall | Louis H. , Jr. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20350 | 20350 | 1967-06-27 | 1964-06-01 | Hester | Charles B. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20351 | 20351 | 1967-06-27 | 1964-06-01 | Hoffman | Harold M. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20352 | 20352 | 1967-06-27 | 1964-06-01 | McClure | Carl Holz , III | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20353 | 20353 | 1967-06-27 | 1964-06-01 | Ordman | Howard F. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20354 | 20354 | 1967-06-27 | 1964-06-01 | Putney | William Beaumont , III | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
37275 | 37275 | 1969-12-01 | 1964-06-01 | Furman | Gerald S. | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
39871 | 39871 | 1969-12-31 | 1964-06-01 | Van Arsdale | H.C. | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
39919 | 39919 | 1972-12-31 | 1964-06-01 | Fischbeck | C. Lloyd | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
39920 | 39920 | 1972-12-31 | 1964-06-01 | Ueland | Arthur E. | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
39921 | 39921 | 1972-12-31 | 1964-06-01 | Uhe | George | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 |
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]) );