FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where State = "CA" and Zip = 94108 sorted by Business_Name
This data as json, CSV (advanced)
Suggested facets: Address_2, Registration_Date (date), Termination_Date (date)
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name ▼ | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
282 | 1945-01-01 | 1988-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 | |
329 | 1945-10-12 | 1951-06-30 | Meng, Shou-Ch'un | 790 California Street | San Francisco | CA | 94108 | ||
458 | 1947-04-25 | 1990-09-27 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | ||
1195 | 1959-01-29 | 1973-05-10 | Philippine Tourist & Travel Association | 212 Stockton Street | San Francisco | CA | 94108 | ||
2048 | 1966-12-31 | 1973-04-10 | Netherlands Information Service | 601 California Street | San Francisco | CA | 94108 | ||
2091 | 1968-05-09 | 1970-01-30 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | ||
2305 | 1972-01-14 | 1980-01-08 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | ||
2335 | 1972-04-25 | 1972-08-31 | Korea Tourist Service | 210 Post Street | Suite 1017 | San Francisco | CA | 94108 | |
2450 | 1973-08-09 | 1973-08-08 | Freeman, Teilmann & Associates Public Relations | 26 O'Farrell Street | Suite 903 | San Francisco | CA | 94108 |
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]) );