FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
110 rows where City = "Los Angeles" sorted by Address_2
This data as json, CSV (advanced)
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 ▼ | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3192 | 1981-01-23 | 1983-02-28 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 | |
1884 | 1965-04-19 | 2018-12-31 | Italian Government Tourist Board (ENIT), Los Angeles | 10850 Wilshire Boulevard | Suite 575 | Los Angeles | CA | 90024 | |
6474 | 2017-10-07 | 2018-06-26 | Medowood Management, LLC | 5757 W. Century Blvd. | Suite 700 | Los Angeles | CA | 90045 | |
3879 | 1986-08-28 | 1989-02-28 | Rifkind, Pondel & Parsons | 11601 Wilshire Boulevard | Suite 760 | Los Angeles | CA | 90025 | |
5777 | 2006-11-20 | 2008-05-31 | Sitrick and Company, Inc. | 1840 Century Park East | Suite 800 | Los Angeles | CA | 90067-2109 | |
2190 | 1970-02-24 | 2001-04-01 | Whitehouse Associates, Inc. | Japan Steel Information Center | 523 West Sixth Street | Suite 804 | Los Angeles | CA | 90014-1222 |
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 | |
2447 | 1973-08-09 | 1989-04-28 | Romanian Foreign Trade Promotion Office, Los Angeles | 350 South Figueroa Street | Suite 944 | Los Angeles | CA | 90071 | |
2510 | 1974-04-17 | Malaysia Tourism Promotion Board | 818 West Seventh Street | Suite 970 | Los Angeles | CA | 90017-3432 | ||
5873 | 2008-07-08 | 2018-05-02 | India Tourism, Los Angeles | 3550 Wilshire Boulevard | Suite No. 204 | Los Angeles | CA | 90010-2485 |
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]) );