FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Short_Form_Last_Name = "Kimura"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Zip
Registration_Number 9
Registrant_Name 9
City 7
- New York 7
- Los Angeles 4
- Houston 2
- New York 2
- Atlanta 1
- Dallas 1
- San Francisco 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326 | 326 | 2023-02-06 | Kimura | Kota | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
8643 | 8643 | 1962-03-01 | 1960-03-24 | Kimura | Eiichi | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
9886 | 9886 | 1959-03-15 | 1956-02-23 | Kimura | Shigeo | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
10057 | 10057 | 1985-03-16 | 1981-12-28 | Kimura | Yoshio | 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 |
10372 | 10372 | 1977-03-20 | 1974-06-27 | Kimura | Nobuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10381 | 10381 | 1991-03-20 | 1988-01-27 | Kimura | Nobuo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10536 | 10536 | 2013-03-22 | 2010-03-31 | Kimura | Tadaaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10904 | 10904 | 2013-03-27 | 2008-11-03 | Kimura | Makoto | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
11090 | 11090 | 2011-03-29 | 2008-09-05 | Kimura | Shigeru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
13592 | 13592 | 2015-04-16 | 2013-01-30 | Kimura | Keiichi | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
16324 | 16324 | 1976-05-14 | 1973-08-08 | Kimura | Yasuhiko | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
16745 | 16745 | 1976-05-20 | 1972-07-03 | Kimura | Yoshio | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
20585 | 20585 | 2008-06-29 | 2005-08-02 | Kimura | Masayuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20758 | 20758 | 1965-06-30 | 1962-04-18 | Kimura | Tsutomu | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
24318 | 24318 | 2008-07-28 | 2005-04-08 | Kimura | Keiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25477 | 25477 | 1970-08-01 | 1968-02-12 | Kimura | Shizuo | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
27794 | 27794 | 2002-08-30 | 1999-04-27 | Kimura | Yoichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35030 | 35030 | 2014-11-01 | 2011-05-12 | Kimura | Yoichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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]) );