FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where State = "CA" and Zip = 90017
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Address_2, Termination_Date (date)
Registration_Date (date) 8 ✖
- 1950-08-22 1
- 1970-06-09 1
- 1972-07-03 1
- 1980-05-19 1
- 1981-11-13 1
- 2019-08-02 1
- 2021-06-10 1
- 2023-08-02 1
Address_1 8
City 2
State 1
- CA · 8 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
639 | 1950-08-22 | 1977-05-23 | Netherlands Chamber of Commerce in the U.S. | 350 South Figueroa Street | Suite 901 | Los Angeles | CA | 90017 | |
2199 | 1970-06-09 | 1992-01-13 | Greek National Tourist Organization, Los Angeles | 611 West Sixth Street | Suite 2198 | Los Angeles | CA | 90017 | |
2350 | 1972-07-03 | Japan National Tourism Organization, Los Angeles | 707 Wilshire Blvd. | Suite 4325 | Los Angeles | CA | 90017 | ||
3107 | 1980-05-19 | 1981-11-19 | Intercontinental Development & Management Company, Inc. | 1 Wilshire Boulevard | Suite 2525 | Los Angeles | CA | 90017 | |
3303 | 1981-11-13 | 1982-07-30 | Morgan, Lewis & Bockius | 611 West 6th Street | Los Angeles | CA | 90017 | ||
6705 | 2019-08-02 | 2021-08-31 | Quinn Emanuel Urquhart & Sullivan, LLP | 865 South Figueroa Street | 10th Floor | Los Angeles | CA | 90017 | |
6973 | 2021-06-10 | Heimberg, Steven Andrew | 800 West Sixth Street | Suite 1500 | Los Angeles | CA | 90017 | ||
7303 | 2023-08-02 | Quinn Emanuel Urquhart & Sullivan, LLP | 865 South Figueroa Street, 10th Floor | Los Angeles | CA | 90017 |
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]) );