FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Hobbs"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_Date (date)
Registration_Number 7
Registrant_Name 7
City 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
242 | 242 | 2020-01-30 | Hobbs | Lemondria | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | ||
5923 | 5923 | 1967-02-02 | 1964-01-03 | Hobbs | Richard Hutchinson | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
8812 | 8812 | 1996-03-01 | 1995-10-18 | Hobbs | Laurie Ann | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
27381 | 27381 | 1946-08-25 | 1942-08-25 | Hobbs | William Henry | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
28779 | 28779 | 1970-09-01 | 1968-01-10 | Hobbs | Ranald D. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34792 | 34792 | 1951-11-01 | 1949-11-25 | Hobbs | Natalie Hall | Netherlands Information Service, New York 447 | 1947-03-14 | Netherlands Information Service, New York | 711 Third Avenue | New York | NY | 10017 | |
38174 | 38174 | 1990-12-12 | 1986-11-12 | Hobbs | Claude E. | Urenco, Inc. 3904 | 1986-11-12 | Urenco, Inc. | 2600 Virginia Avenue, N.W. | Suite 610 | Washington | DC | 20037 |
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]) );