FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Los Angeles" and Short_Form_First_Name = "Akira"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7591 | 7591 | 1977-02-25 | 1976-07-17 | Moromi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9406 | 9406 | 1995-03-07 | 1991-03-08 | Inaba | Akira | Japan National Tourism Organization, Los Angeles 2350 | 1972-07-03 | Japan National Tourism Organization, Los Angeles | 707 Wilshire Blvd. | Suite 4325 | Los Angeles | CA | 90017 |
9738 | 9738 | 2001-03-12 | 1998-02-06 | Moromi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
18675 | 18675 | 2001-06-02 | 1998-07-24 | Fukushima | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19355 | 19355 | 1998-06-13 | 1995-07-24 | Tonosaki | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19375 | 19375 | 1965-06-14 | 1964-12-14 | Yasui | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20320 | 20320 | 2001-06-26 | 1998-07-24 | Yamagishi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23425 | 23425 | 1984-07-17 | 1980-07-16 | Tsutsumi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23637 | 23637 | 1974-07-20 | 1971-07-19 | Yasui | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
24363 | 24363 | 1990-07-29 | 1988-01-27 | Hosoda | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
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]) );