FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

  • JETRO, Houston · 81 ✖

City 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
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

CSV options: 

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])
);