FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where City = "San Jose" sorted by Business_Name
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Address_2, Registration_Date (date)
Address_1 5
Termination_Date (date) 3 ✖
- 1998-06-30 1
- 2002-05-25 1
- 2003-10-31 1
State 1
- CA 5
City 1
- San Jose · 5 ✖
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name ▼ | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
5232 | 1998-02-09 | 1998-06-30 | Stearns, John Norton | 48 South 14th Street | San Jose | CA | 95112 | ||
5350 | 1999-12-10 | Malaysian Investment Development Authority | 226 Airport Parkway | Suite 480 | San Jose | CA | 95110 | ||
5388 | 2000-10-04 | 2003-10-31 | Peden, Jack L. | 15828 Alta Vista Way | San Jose | CA | 95127 | ||
5462 | 2001-10-17 | 2002-05-25 | Software Technology Parks of India (STPI) | 111 North Market Street | Suite 1000/1040 | San Jose | CA | 95113 | |
7109 | 2022-04-18 | Ho, Jason | 4664 Hill Top View Lane | San Jose | CA | 95138 |
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]) );