FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Registration_Date = "1964-06-01"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6161 | 6161 | 1973-02-05 | 1973-01-26 | Weening | Albert | George Uhe Company, Inc. 1745 | 1964-06-01 | George Uhe Company, Inc. | 76 Ninth Avenue | New York | NY | 10011 | |
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 | |
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 | |
20355 | 20355 | 1967-06-27 | 1964-06-22 | Kerrigan | Thomas M. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20356 | 20356 | 1967-06-27 | 1964-06-22 | Skidmore | Lemuel , Jr. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20357 | 20357 | 1967-06-27 | 1964-06-22 | Twombly | Edward Bancroft | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20358 | 20358 | 1967-06-27 | 1965-07-01 | Ryan | Thomas F. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20359 | 20359 | 1967-06-27 | 1966-07-05 | Getchell | David P. | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20360 | 20360 | 1967-06-27 | 1966-07-05 | Groppe | Charles Joseph | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20361 | 20361 | 1967-06-27 | 1966-07-05 | Iovenko | Michael | Putney, Twombly, Hall & Skidmore 1744 | 1964-06-01 | Putney, Twombly, Hall & Skidmore | 250 Park Avenue | New York | NY | 10017 | |
20362 | 20362 | 1967-06-27 | 1966-07-05 | Parauda | Joseph Ronald | 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 | |
39880 | 39880 | 1969-12-31 | 1966-12-09 | Norell | Mark W. | 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]) );