FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
110 rows where City = "Los Angeles"
This data as json, CSV (advanced)
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
6628 | 2019-01-23 | Latham & Watkins LLP | 355 South Grand Avenue | Suite 100 | Los Angeles | CA | 90071 | ||
6659 | 2019-04-09 | 2021-03-31 | Community Partners | 1000 N. Alameda Street | Suite 240 | Los Angeles | CA | 90012 | |
6705 | 2019-08-02 | 2021-08-31 | Quinn Emanuel Urquhart & Sullivan, LLP | 865 South Figueroa Street | 10th Floor | Los Angeles | CA | 90017 | |
6729 | 2019-09-26 | 2019-12-20 | Cardinal Bradette, Melina | 1635 South Beverly Glen Boulevard | Apt. 6 | Los Angeles | CA | 90024 | |
6769 | 2019-12-13 | 2021-03-01 | CMGRP, Inc., d/b/a Rogers & Cowan | 1840 Century Park East | 18th Floor | Los Angeles | CA | 90067 | |
6777 | 2019-12-30 | 2020-12-31 | Lexington Avenue Consulting | 4046 Collis Avenue | Los Angeles | CA | 90032 | ||
6934 | 2021-03-10 | Iranian Resurgent Party I.R.P. | 6603 Independence Avenue | Los Angeles | CA | 91303 | |||
6973 | 2021-06-10 | Heimberg, Steven Andrew | 800 West Sixth Street | Suite 1500 | Los Angeles | CA | 90017 | ||
7063 | 2021-12-20 | 2022-02-28 | Maffick LLC | 2917 W. Temple Street | Suite 102 | Los Angeles | CA | 90026 | |
7179 | 2022-10-07 | 2023-01-06 | Wagstaff Worldwide Public Relations, Inc. | 5443 Fountain Avenue | Los Angeles | CA | 90029 |
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]) );