FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Registration_Number = 34 and "Short_Form_Termination_Date" is on date 1961-02-03
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6008 | 6008 | 1961-02-03 | 1960-01-25 | Richmond | Thomas Lloyd | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6009 | 6009 | 1961-02-03 | 1952-01-28 | Gannon | John | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6010 | 6010 | 1961-02-03 | 1953-02-10 | Kennedy | Thomas Peter | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6011 | 6011 | 1961-02-03 | 1953-02-10 | King | Henry Ward Ford | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6012 | 6012 | 1961-02-03 | 1943-03-03 | Hartsing | Ralph N. | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6013 | 6013 | 1961-02-03 | 1955-04-04 | Jaeger | Joyce Leslie Whiting | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6014 | 6014 | 1961-02-03 | 1950-05-19 | Cody | John McGee | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6015 | 6015 | 1961-02-03 | 1950-06-12 | Aspinall | Joseph | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6016 | 6016 | 1961-02-03 | 1950-06-12 | Kaiser | Gustav | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6017 | 6017 | 1961-02-03 | 1951-07-18 | Marsden | John Fowler | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6018 | 6018 | 1961-02-03 | 1953-07-20 | Davidson | DeWitt Sanger | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6019 | 6019 | 1961-02-03 | 1954-07-22 | Tery | Joseph Albert | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6020 | 6020 | 1961-02-03 | 1959-08-04 | Larner | William Clifford | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6021 | 6021 | 1961-02-03 | 1950-08-09 | Slattery | John Desmond | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6022 | 6022 | 1961-02-03 | 1955-08-16 | McLoud | Mary | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6023 | 6023 | 1961-02-03 | 1949-10-06 | Hartsing | M.P. | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6024 | 6024 | 1961-02-03 | 1957-10-14 | Echelman | Elliott Jacob | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6025 | 6025 | 1961-02-03 | 1949-12-07 | Meyer | Hudson Fulton | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL |
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]) );