FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
81 rows where Registration_Number = 2277 and State = "TX"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- TX · 81 ✖
Registration_Number 1
- JETRO, Houston · 81 ✖
Registration_Date 1 ✖
- 1971-09-20 81
Registrant_Name 1
City 1
- Houston 81
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
828 | 828 | 2023-04-18 | Mayu | Hobo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
859 | 859 | 2013-04-23 | Sanders | Keith | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
1626 | 1626 | 2020-08-17 | Okimoto | Kenji | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
1969 | 1969 | 2019-10-16 | Sakurauchi | Masahiro | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
1985 | 1985 | 2022-10-19 | Hirasawa | Yuka | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
1987 | 1987 | 2022-10-19 | killian | Chika | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 | |
3196 | 3196 | 2001-01-04 | 2001-02-14 | Iwano | Hiroshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
3256 | 3256 | 2018-01-05 | 2015-04-22 | Kurokawa | Junji | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
3638 | 3638 | 2021-01-12 | 2019-04-12 | McKisick | Sheridan | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
6540 | 6540 | 1990-02-10 | 1988-12-02 | Nakata | Yutaka | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
6877 | 6877 | 2014-02-14 | 2013-04-23 | Shimada | Aki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
8363 | 8363 | 2019-02-28 | 2017-10-30 | Uchida | Kaori | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
8990 | 8990 | 2023-03-02 | 2019-10-01 | Shioiri | Emi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
9623 | 9623 | 1982-03-11 | 1979-05-18 | Suganuma | Koki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
9741 | 9741 | 2004-03-12 | 2001-08-13 | Kobara | Makoto | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
9779 | 9779 | 1992-03-13 | 1989-08-07 | Oishi | Shintaro | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
10063 | 10063 | 1996-03-16 | 1992-10-29 | Nemoto | Hiroyuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
10759 | 10759 | 1995-03-25 | 1992-05-19 | Sato | Yoshiki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
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 |
11191 | 11191 | 2004-03-30 | 2002-06-14 | Ozawa | Jingo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
12185 | 12185 | 2016-03-31 | 2014-04-25 | Maeda | Shinobu | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
12543 | 12543 | 2010-04-01 | 2006-05-09 | Kurita | Kaoru | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
13651 | 13651 | 2007-04-17 | 2003-08-01 | Nakamizo | Takashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
14290 | 14290 | 2006-04-28 | 2002-12-10 | Tokita | Setsuko | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
14371 | 14371 | 2001-04-29 | 1997-06-16 | Iida | Akimasa | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
16142 | 16142 | 1991-05-12 | 1989-08-07 | Kikuoka | Eiji | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
16797 | 16797 | 2022-05-20 | 2021-10-25 | Holdstock | Erika | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
17478 | 17478 | 1996-05-30 | 1993-10-12 | Saito | Sadayuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
18457 | 18457 | 1984-06-01 | 1982-01-08 | Adachi | Masaki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19141 | 19141 | 1975-06-10 | 1972-11-06 | Asami | Toshihiko | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19402 | 19402 | 1980-06-14 | 1977-11-07 | Kitagawa | Masaaki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19403 | 19403 | 1981-06-14 | 1978-12-12 | Inque | Takuo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19546 | 19546 | 1987-06-15 | 1984-10-23 | Hideshima | Tsuneo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19682 | 19682 | 1996-06-16 | 1993-10-12 | Sakamoto | Hirokazu | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19941 | 19941 | 2006-06-20 | 2003-07-17 | Yajima | Yoshinori | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20112 | 20112 | 1997-06-23 | 1994-10-13 | Aoyama | Ichizo | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20116 | 20116 | 2003-06-23 | 2002-11-05 | Iwano | Hiroshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20474 | 20474 | 2012-06-28 | 2009-07-24 | Koyari | Takashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
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 |
20587 | 20587 | 2011-06-29 | 2008-07-30 | Hirai | Mika | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20853 | 20853 | 1972-06-30 | 1971-09-20 | Kato | Yasuhiko | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
20894 | 20894 | 1974-06-30 | 1971-09-20 | Hirose | Akira | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
22148 | 22148 | 1982-07-01 | 1979-12-06 | Utsunomiya | Makoto | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
22298 | 22298 | 2002-07-01 | 1999-08-03 | Kanazawa | Takashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
22534 | 22534 | 1999-07-03 | 1996-07-16 | Okane | Hideki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
22535 | 22535 | 2005-07-03 | 2002-09-24 | Chiba | Toshinori | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
22541 | 22541 | 2009-07-03 | 2006-07-06 | Okabe | Tadahisa | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
23005 | 23005 | 1977-07-12 | 1974-11-14 | Tabata | Kiyoshi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
23563 | 23563 | 2003-07-18 | 1999-09-21 | Maekawa | Naoyuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
23662 | 23662 | 1990-07-20 | 1988-12-02 | Hata | Kuniaki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
24382 | 24382 | 2001-07-29 | 1998-10-21 | Nishiyama | Yujiro | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
25263 | 25263 | 2015-07-31 | 2013-04-23 | Zhao | Yiou | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
26716 | 26716 | 1985-08-15 | 1982-04-26 | Nagatomo | Osamu | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
26804 | 26804 | 2020-08-15 | 2017-10-30 | Nakagawa | Naoto | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
27446 | 27446 | 2022-08-25 | 2021-10-25 | Fukasawa | Ryuta | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
28925 | 28925 | 2002-09-01 | 1999-11-03 | Hosokawa | Hiroyuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
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]) );