FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
124 rows where Registrant_Name = "JETRO, San Francisco" sorted by Short_Form_Last_Name
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10276 | 10276 | 1966-03-19 | 1964-11-05 | Takeda | Ippei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
29291 | 29291 | 2017-09-06 | 2016-04-28 | Takeuchi | Daisuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10927 | 10927 | 1967-03-28 | 1964-11-05 | Tanabe | Ryuichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
2067 | 2067 | 2015-10-30 | Tanaka | Mihoko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
21490 | 21490 | 2003-06-30 | 2000-12-29 | Tanaka | Shinsuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35638 | 35638 | 2021-11-11 | 2017-10-30 | Tarutani | Noriya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8659 | 8659 | 1968-03-01 | 1964-11-05 | Tashiro | Nobuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
23980 | 23980 | 2017-07-24 | 2014-10-17 | Tojo | Yoshiaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18976 | 18976 | 1987-06-06 | 1985-02-21 | Tokura | Osamu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
2068 | 2068 | 2017-10-30 | Tomita | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
18629 | 18629 | 1979-06-02 | 1977-05-23 | Tomita | Shunsuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22675 | 22675 | 1971-07-07 | 1968-05-06 | Tsubaki | Hiroyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20038 | 20038 | 1998-06-22 | 1996-06-06 | Tsuchiya | Keizo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35797 | 35797 | 1972-11-15 | 1972-03-21 | Tsuchiya | Naotoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19104 | 19104 | 1982-06-09 | 1979-02-01 | Uchida | Yoshio | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35568 | 35568 | 2018-11-09 | 2018-10-23 | Wang | Yenting | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
13336 | 13336 | 2010-04-14 | 2006-12-20 | Watanabe | Takayuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
30167 | 30167 | 2019-09-20 | 2017-04-24 | Wood | Miki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10405 | 10405 | 2016-03-20 | 2015-10-30 | Yamada | Masayoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
1873 | 1873 | 2020-09-29 | Yamashita | Takanari | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
33009 | 33009 | 1984-10-16 | 1981-12-02 | Yamazaki | Kunimitsu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18772 | 18772 | 1998-06-03 | 1996-06-06 | Yoshihara | Junji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27584 | 27584 | 1988-08-28 | 1986-08-19 | Yoshimoto | Seiji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
33336 | 33336 | 1976-10-22 | 1973-08-08 | Yoshitsugu | Koji | 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]) );