FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Registration_Number = 34 sorted by State descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Short_Form_First_Name 18 ✖
- Hudson Fulton 2
- DeWitt Sanger 1
- Elliott Jacob 1
- Gustav 1
- Henry Ward Ford 1
- John 1
- John Desmond 1
- John Fowler 1
- John McGee 1
- Joseph 1
- Joseph Albert 1
- Joyce Leslie Whiting 1
- M.P. 1
- Mary 1
- Ralph N. 1
- Thomas Lloyd 1
- Thomas Peter 1
- William Clifford 1
State 1
- IL 19
Registration_Number 1
- Caples Company · 19 ✖
Registrant_Name 1
City 1
- Chicago 19
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 | ||
8627 | 8627 | 1959-03-01 | 1950-05-19 | 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]) );