FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
81 rows where Registrant_Name = "JETRO, Houston" and State = "TX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29172 | 29172 | 1999-09-04 | 1996-10-18 | Wada | Susumu | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
29366 | 29366 | 2012-09-07 | 1989-08-07 | Conry | Thomas | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
29591 | 29591 | 1999-09-11 | 1996-04-22 | Ishihara | Takashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
29696 | 29696 | 2013-09-13 | 2013-04-23 | Wong | Yuko | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
29950 | 29950 | 1985-09-16 | 1982-12-22 | Hanashi | Masuhiro | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
30070 | 30070 | 1983-09-19 | 1980-11-18 | Kusajima | Tsugio | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
30559 | 30559 | 2017-09-26 | 2016-10-21 | Oikawa | Kiyohito | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
30629 | 30629 | 2008-09-27 | 2004-09-10 | Hasegawa | Hitoshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
30757 | 30757 | 1999-09-29 | 1996-07-16 | Yamamuro | Keisuke | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
30909 | 30909 | 1973-09-30 | 1971-09-20 | Morikawa | Takeshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
31696 | 31696 | 2020-09-30 | 2019-04-12 | Koyama | Isao | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
32688 | 32688 | 1993-10-12 | 1990-11-20 | Sekioka | Seiichi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
32703 | 32703 | 1998-10-12 | 1995-04-18 | Kojima | Hiroshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
32741 | 32741 | 1994-10-13 | 1991-12-11 | Ida | Hisao | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
32958 | 32958 | 2019-10-15 | 2018-03-13 | Hirai | Toshinaga | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
33250 | 33250 | 1992-10-20 | 1989-08-07 | Yamada | Hisashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
34448 | 34448 | 2001-10-31 | 1998-05-07 | Kawate | Koji | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
34875 | 34875 | 1976-11-01 | 1974-06-21 | Masuto | Yasuo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
36325 | 36325 | 2002-11-24 | 1999-10-13 | Nakamura | Yukio | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
37698 | 37698 | 2004-12-03 | 2002-01-22 | Onishi | Hideo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
37806 | 37806 | 2014-12-05 | 2013-08-05 | Nakamizo | Takashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
37922 | 37922 | 2000-12-08 | 1997-07-22 | Nei | Hisanori | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
38394 | 38394 | 1986-12-15 | 1983-10-25 | Takada | Kenjiro | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
38569 | 38569 | 2003-12-17 | 2002-01-30 | Toyomoto | Shinichi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
40224 | 40224 | 1982-12-31 | 1980-05-15 | Kirwan | David Forbes | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
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]) );