FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
184 rows where Registration_Number = 1833
This data as json, CSV (advanced)
State 1
- CA 33
Registration_Number 1
- JETRO, Los Angeles · 33 ✖
Registrant_Name 1
City 1
- Los Angeles 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29206 | 29206 | 1978-09-05 | 1976-02-02 | Iwamori | Yo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
29569 | 29569 | 1977-09-11 | 1976-07-17 | Nakagawa | Koshio | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
29985 | 29985 | 1989-09-17 | 1986-09-08 | Hayase | Masatoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30254 | 30254 | 1975-09-22 | 1973-03-07 | Nemoto | Motoo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30322 | 30322 | 2007-09-23 | 2004-07-30 | Hara | Minoru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30612 | 30612 | 1997-09-27 | 1994-07-19 | Miura | Hideto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30707 | 30707 | 2018-09-28 | 2018-01-25 | Griffith | Kaori Ozawa | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30755 | 30755 | 1998-09-29 | 1996-01-17 | Ishikawa | Ichiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30765 | 30765 | 2008-09-29 | 2005-08-16 | Watanabe | Masayoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31674 | 31674 | 2019-09-30 | 2018-07-27 | Yamaguchi | Makoto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31699 | 31699 | 2020-09-30 | 2019-07-30 | Pike | Chika Yamaga | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31730 | 31730 | 2022-09-30 | 2021-07-30 | Maurata | Keiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
32096 | 32096 | 2017-10-01 | 2015-02-05 | Yasuda | Ayako | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
32562 | 32562 | 1973-10-10 | 1971-01-31 | Ikeda | Sobee | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
32632 | 32632 | 1997-10-11 | 1995-05-04 | Kitamura | Naohiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33213 | 33213 | 1995-10-19 | 1993-07-19 | Ishiwata | Kenjiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33221 | 33221 | 2020-10-19 | 2018-01-25 | Kuriyama | Ai | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33275 | 33275 | 2019-10-20 | 2017-02-10 | Nishimoto | Keiichi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33443 | 33443 | 2021-10-22 | 2021-07-30 | Servin | Alberto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33662 | 33662 | 1972-10-26 | 1970-01-14 | Nomoto | Masuji | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33749 | 33749 | 1987-10-28 | 1985-01-30 | Orita | Toshihiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
34982 | 34982 | 2003-11-01 | 1999-01-21 | Kobayashi | Tosaku | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
35232 | 35232 | 1998-11-04 | 1994-07-19 | Sone | Ichiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
35579 | 35579 | 1983-11-10 | 1980-07-16 | Saito | Toshiki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
35983 | 35983 | 1972-11-17 | 1969-07-14 | Kitagawa | Masaaki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
36158 | 36158 | 1982-11-21 | 1979-01-16 | Hirano | Shusaku | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38177 | 38177 | 1993-12-12 | 1991-01-17 | Fukuchi | Kenichi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38272 | 38272 | 1965-12-14 | 1964-12-14 | Nakazawa | Hachiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38505 | 38505 | 1987-12-16 | 1985-07-24 | Asanuma | Tomoyuki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38619 | 38619 | 1986-12-18 | 1983-07-18 | Suzaki | Hiroo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38749 | 38749 | 2003-12-19 | 2002-07-29 | Komatsuzaki | Satoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38936 | 38936 | 1990-12-22 | 1988-01-27 | Yamashita | Ryoichi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
39021 | 39021 | 1996-12-23 | 1994-01-18 | Yamaguchi | Kentaro | 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]) );