FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_First_Name = "John" and State = "CA"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 13
- Korean National Revolutionary Party, Los Angeles 1
- Tourism Australia 1
- New South Wales Government Office 1
- JETRO, San Francisco 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
- Fouch-Roseboro & Associates 1
- Brunswick Group, LLC 1
- Camstoll Group, LLC 1
- MediaFix Associates 1
Registrant_Name 13
- Braun & Company 1
- Brunswick Group, LLC 1
- Camstoll Group, LLC 1
- Dailey & Associates 1
- Fouch-Roseboro & Associates 1
- Greek National Tourist Organization, Los Angeles 1
- Hong Kong Tourism Board 1
- Indonesia Tourist Promotion Office for North America 1
- JETRO, San Francisco 1
- Korean National Revolutionary Party, Los Angeles 1
- MediaFix Associates 1
- New South Wales Government Office 1
- Tourism Australia 1
City 4
State 1
- CA · 13 ✖
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 | |
15866 | 15866 | 2018-05-07 | 2018-05-07 | Childress | John | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
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 |
26616 | 26616 | 1987-08-14 | 1985-11-13 | Roseboro | John | Fouch-Roseboro & Associates 3756 | 1985-11-13 | Fouch-Roseboro & Associates | 340 North Camden Drive | Beverly Hills | CA | 90210 | |
26840 | 26840 | 1994-08-16 | 1991-12-03 | Oh | John | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
37849 | 37849 | 2019-12-06 | 2017-01-12 | Metcalfe | John | Camstoll Group, LLC 6144 | 2012-12-10 | Camstoll Group, LLC | 1112 Montana Avenue | #904 | Santa Monica | CA | 90403 |
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]) );