FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Registration_Number = 71
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6837 | 6837 | 1956-02-21 | 1945-03-08 | Cooney | Ralph B. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
8089 | 8089 | 1955-03-01 | 1949-03-15 | Jarvis | Thomas W. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
13111 | 13111 | 1963-04-22 | 1943-03-17 | McCormick | John F. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
13332 | 13332 | 1963-04-26 | 1954-10-12 | Rees | Howell Edward | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
21883 | 21883 | 1955-07-15 | 1942-07-30 | McCarthy | Elmer W. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23142 | 23142 | 1975-07-30 | 1959-03-06 | O'Doherty | James Stephen | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23143 | 23143 | 1975-07-30 | 1958-04-07 | Joslyn | Roger | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23144 | 23144 | 1975-07-30 | 1955-04-08 | Kelly | John Nicholas Joseph | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23145 | 23145 | 1975-07-30 | 1963-07-12 | Miller | G. Montagu | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23146 | 23146 | 1975-07-30 | 1942-07-30 | Herel | Frank J. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23148 | 23148 | 1975-07-30 | 1957-09-17 | McDermott | William M. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23149 | 23149 | 1975-07-30 | 1959-09-18 | Kelly | Robert Eugene | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23150 | 23150 | 1975-07-30 | 1948-10-04 | McAward | Patrick J. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
23301 | 23301 | 1963-07-31 | 1942-07-30 | Kelly | John C. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
25260 | 25260 | 1955-08-15 | 1955-03-31 | Morris | John H. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
26385 | 26385 | 1953-08-31 | 1949-03-15 | Galbo | Vincent James | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
35437 | 35437 | 1958-12-01 | 1942-07-30 | Nason | James R.P. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
36498 | 36498 | 1953-12-15 | 1949-03-15 | Sachtleben | Arthur F. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | ||
37857 | 37857 | 1962-12-31 | 1961-03-21 | Galbo | Vincent J. | 71 71 | 1942-07-30 | Kelly, Nason, Inc. | 247 Park 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) );