FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "Los Angeles" and Short_Form_First_Name = "John"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Date (date)
Short_Form_Termination_Date (date) 9 ✖
- 1944-12-15 1
- 1962-12-22 1
- 1980-01-21 1
- 1983-02-28 1
- 1984-01-30 1
- 1984-12-31 1
- 1986-06-15 1
- 2001-06-30 1
- 2016-03-31 1
Registration_Number 9
- Korean National Revolutionary Party, Los Angeles 1
- Tourism Australia 1
- New South Wales Government Office 1
- Hong Kong Tourism Board 1
- Greek National Tourist Organization, Los Angeles 1
- Dailey & Associates 1
- Indonesia Tourist Promotion Office for North America 1
- Braun & Company 1
- MediaFix Associates 1
Registrant_Name 9
- Braun & Company 1
- Dailey & Associates 1
- Greek National Tourist Organization, Los Angeles 1
- Hong Kong Tourism Board 1
- Indonesia Tourist Promotion Office for North America 1
- Korean National Revolutionary Party, Los Angeles 1
- MediaFix Associates 1
- New South Wales Government Office 1
- Tourism Australia 1
State 1
- CA 9
City 1
- Los Angeles · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4203 | 4203 | 1980-01-21 | 1977-07-28 | Clewis | John | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
4819 | 4819 | 1984-01-30 | 1977-10-28 | Efthimiou | John | 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 |
7909 | 7909 | 1983-02-28 | 1982-03-24 | Grimaldi | John | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
12183 | 12183 | 2016-03-31 | 2016-03-28 | Schwada | John | MediaFix Associates 6345 | 2016-03-28 | MediaFix Associates | 814 S. Westgate Avenue | Los Angeles | CA | 90049 | |
19542 | 19542 | 1986-06-15 | 1977-02-15 | Senduk | John | Indonesia Tourist Promotion Office for North America 2757 | 1977-02-15 | Indonesia Tourist Promotion Office for North America | 3457 Wilshire Boulevard | Los Angeles | CA | 90010-2203 | |
21410 | 21410 | 2001-06-30 | 1988-07-26 | King | John | Tourism Australia 1032 | 1957-06-03 | Tourism Australia | 2029 Century Park East | Suite 3150 | Los Angeles | CA | 90067 |
38336 | 38336 | 1944-12-15 | 1943-09-13 | Juhn | John | Korean National Revolutionary Party, Los Angeles 207 | 1943-09-13 | Korean National Revolutionary Party, Los Angeles | 955 West Jefferson Street | Los Angeles | CA | ||
38918 | 38918 | 1962-12-22 | 1961-10-12 | Savage | John | New South Wales Government Office 1276 | 1959-09-25 | New South Wales Government Office | 2049 Century Park, East | Suite 2250 | Los Angeles | CA | 90067 |
40289 | 40289 | 1984-12-31 | 1978-05-31 | Feeley | John | Dailey & Associates 2299 | 1971-12-27 | Dailey & Associates | 3055 Wilshire Boulevard | Los Angeles | CA |
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]) );