FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where City = "Los Angeles" and Short_Form_First_Name = "Michael"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Date (date), Registration_Date (date)
Short_Form_Termination_Date (date) 5 ✖
- 1982-10-30 1
- 1995-11-30 1
- 1997-10-31 1
- 2000-10-31 1
- 2007-11-30 1
Registration_Number 5
Registrant_Name 5
State 1
- CA 5
City 1
- Los Angeles · 5 ✖
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34052 | 34052 | 1982-10-30 | 1975-09-30 | Mavraganis | Michael | Greek National Tourist Organization, Los Angeles 2199 | 1970-06-09 | Greek National Tourist Organization, Los Angeles | 611 West Sixth Street | Suite 2198 | Los Angeles | CA | 90017 |
34405 | 34405 | 1997-10-31 | 1994-10-14 | Kolbenschlag | Michael | Sitrick & Company, Inc. 4967 | 1994-10-14 | Sitrick & Company, Inc. | 2029 Century Park East | Suite 1750 | Los Angeles | CA | 90067 |
34435 | 34435 | 2000-10-31 | 1997-06-30 | Krieg | Michael | German-American Chamber of Commerce of the Western U.S. 2563 | 1975-03-14 | German-American Chamber of Commerce of the Western U.S. | 5220 Pacific Concourse Dr. | Suite 280 | Los Angeles | CA | 90045 |
36791 | 36791 | 1995-11-30 | 1995-08-15 | Cassimaty | Michael | Tourism Queensland 4146 | 1988-05-31 | Tourism Queensland | 6100 Center Drive | Suite 1150 | Los Angeles | CA | 90045 |
36964 | 36964 | 2007-11-30 | 2007-06-29 | Sitrick | Michael | Sitrick and Company, Inc. 5777 | 2006-11-20 | Sitrick and Company, Inc. | 1840 Century Park East | Suite 800 | Los Angeles | CA | 90067-2109 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );