FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

19 rows where Registration_Number = 34

Search:

descending

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	City	State
5618	5618	1961-02-03	1960-01-25	Richmond	Thomas Lloyd	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5619	5619	1961-02-03	1952-01-28	Gannon	John	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5620	5620	1961-02-03	1953-02-10	Kennedy	Thomas Peter	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5621	5621	1961-02-03	1953-02-10	King	Henry Ward Ford	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5622	5622	1961-02-03	1943-03-03	Hartsing	Ralph N.	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5623	5623	1961-02-03	1955-04-04	Jaeger	Joyce Leslie Whiting	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5624	5624	1961-02-03	1950-05-19	Cody	John McGee	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5625	5625	1961-02-03	1950-06-12	Aspinall	Joseph	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5626	5626	1961-02-03	1950-06-12	Kaiser	Gustav	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5627	5627	1961-02-03	1951-07-18	Marsden	John Fowler	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5628	5628	1961-02-03	1953-07-20	Davidson	DeWitt Sanger	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5629	5629	1961-02-03	1954-07-22	Tery	Joseph Albert	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5630	5630	1961-02-03	1959-08-04	Larner	William Clifford	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5631	5631	1961-02-03	1950-08-09	Slattery	John Desmond	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5632	5632	1961-02-03	1955-08-16	McLoud	Mary	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5633	5633	1961-02-03	1949-10-06	Hartsing	M.P.	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5634	5634	1961-02-03	1957-10-14	Echelman	Elliott Jacob	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
5635	5635	1961-02-03	1949-12-07	Meyer	Hudson Fulton	34 34	1943-03-03	Caples Company	216 East Ontario Street	Chicago	IL
8006	8006	1959-03-01	1950-05-19	Meyer	Hudson Fulton	34 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)
);