FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1977-04-11
This data as json, CSV (advanced)
Suggested facets: Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13146 | 13146 | 1977-04-11 | 1967-02-03 | Eaton | John McCurdy | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13147 | 13147 | 1977-04-11 | 1973-02-08 | Butler | Paul M. , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13148 | 13148 | 1977-04-11 | 1971-02-17 | Augur | Harrison H. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13149 | 13149 | 1977-04-11 | 1970-03-05 | Elicker | Gordon L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13150 | 13150 | 1977-04-11 | 1965-04-16 | MacKinnon | Robert H. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13151 | 13151 | 1977-04-11 | 1965-04-22 | Weiser | John W. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13152 | 13152 | 1977-04-11 | 1965-04-29 | Eaton | Frederick M. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13153 | 13153 | 1977-04-11 | 1965-04-29 | Knight | Robert Huntington | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13154 | 13154 | 1977-04-11 | 1970-05-08 | Lee | William L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13155 | 13155 | 1977-04-11 | 1971-08-03 | Hurley | Raymond D. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13156 | 13156 | 1977-04-11 | 1966-08-04 | Forrestal | Michael V. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13157 | 13157 | 1977-04-11 | 1966-08-11 | Ross | Alfred J. , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13158 | 13158 | 1977-04-11 | 1967-09-06 | Clare | Robert Linn , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13159 | 13159 | 1977-04-11 | 1976-09-09 | Crowley | James M. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13160 | 13160 | 1977-04-11 | 1974-10-18 | Cuneo | Donald L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13161 | 13161 | 1977-04-11 | 1969-10-29 | Goodwin | Charles , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13162 | 13162 | 1977-04-11 | 1969-10-29 | Murphy | Grayson M.P. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13163 | 13163 | 1977-04-11 | 1975-11-07 | Halverson | James T. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13164 | 13164 | 1977-04-11 | 1975-11-07 | McLaughlin | Joseph T. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 |
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]) );