FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where State = "CA" and Zip = 92101 sorted by State
This data as json, CSV (advanced)
Suggested facets: Name, Address_2, Registration_Date (date), Termination_Date (date)
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State ▼ | Zip |
---|---|---|---|---|---|---|---|---|---|
1866 | 1965-03-10 | 1985-10-22 | Mexican Government Tourism Office, San Diego | 600 B Street | Suite 1212 | San Diego | CA | 92101 | |
4432 | 1990-11-13 | 1991-06-30 | Kennedy, William R. | Emerald Shapery Center | 402 West Broadway, Suite 400 | San Diego | CA | 92101 | |
5154 | 1997-01-24 | 1998-01-01 | Roni Hicks & Associates, Inc. | 1875 Third Avenue | San Diego | CA | 92101 | ||
6302 | 2015-06-19 | 2015-08-31 | Southwest Strategies, LLC | 401 B Street, Suite 150 | San Diego | CA | 92101 | ||
6343 | 2016-03-21 | 2016-05-15 | Southwest Strategies, LLC | 401 B Street | Suite 150 | San Diego | CA | 92101 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );