FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

191 rows where Registrant_Name = "JETRO, Chicago"

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

Registrant_Name

  • JETRO, Chicago · 191

City

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
516   2013-03-26 Stevenson Naoko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
521   2018-03-27 Hashimoto Tsubasa 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
590   2000-04-05 Inforzato Ralph 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1620   2018-09-25 Kamimura Makoto 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1621   2018-09-25 Ogawa Yumeko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1646   2016-09-27 Kawachi Akira 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1675   2015-09-29 Watanabe Takayuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1689   2019-09-30 Fujimoto Fujio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
3420 1989-01-12 1986-10-17 Suzuki Akio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
4484 2002-01-29 1998-10-01 Take Nobumasa 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5118 2008-01-31 2004-08-31 Sasaki Teruo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5120 2008-01-31 2006-10-26 Soobratty Ayumi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5173 2012-01-31 2008-09-30 Hashimoto (Behr) Ritsuko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5354 1977-02-01 1975-03-21 Kimba Hirofumi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5480 2006-02-01 2003-03-03 Saito Hidemi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
6228 1999-02-11 1996-03-13 Morita Ikuhiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
7753 2013-02-28 2012-03-30 Florida Tomoko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8052 1967-03-01 1965-02-02 Inui Fumio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8056 1969-03-01 1965-02-02 Hikida Joseph S. 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8507 1971-03-05 1968-03-12 Suzuki Ken 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8913 1999-03-10 1996-03-13 Monden Takao 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8965 1993-03-11 1989-08-29 Hamada Kazuaki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9037 1986-03-12 1983-09-22 Hoshino Akira 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9054 1998-03-12 1995-09-18 Watanabe Hisanori 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9116 2008-03-13 2005-10-05 Tsuchiya Takashi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9253 1981-03-15 1977-09-07 Koyanagi Takeaki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9734 1973-03-21 1969-03-04 Izawa Chihiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9809 1980-03-22 1977-03-11 Saito Shinichi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9811 1983-03-22 1981-01-23 Nagata Eiichi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10005 2000-03-24 1997-09-17 Ishii Yasumichi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10053 1994-03-25 1990-10-16 Masuda Koutaro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10054 1994-03-25 1990-10-16 Umezawa Shigeyuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10089 1983-03-26 1981-01-23 Tanaka Sumio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10107 1991-03-26 1988-10-25 Ito Tomoyuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10117 2003-03-26 2001-01-10 Tomita Tetsutaro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10169 1988-03-27 1986-04-21 Fujihara Shiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10178 1995-03-27 1992-09-10 Hara Noriyasu 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10180 2001-03-27 1998-10-15 Ishii Shigeru 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10181 2001-03-27 1998-10-15 Wada Aya 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10187 2004-03-27 2001-09-04 Terahara Yoshihito 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10193 2009-03-27 2004-08-31 Nakajo Kazuya 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10195 2010-03-27 2008-09-30 Takashi Muneo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10254 1996-03-28 1993-03-11 Toyonaga Yoshitaka 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10268 2006-03-28 2003-09-23 Funakoshi Teruyo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10352 1997-03-29 1994-03-25 Sawano Hiroshi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10364 2004-03-29 2001-09-04 Ohsawa Hiroshi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10372 2010-03-29 2006-10-26 Toriyama Takayuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10405 1979-03-30 1975-09-11 Tamura Tadao 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10465 2000-03-30 1997-06-13 Komatsu Kyuhei 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10478 2005-03-30 2002-02-27 Washio Tomoharu 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10502 2011-03-30 2008-04-15 Nakamura Kyoichi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10727 1975-03-31 1969-03-04 Oshikawa Akira 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10995 1995-03-31 1992-03-10 Suzuki Minoru 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11083 1999-03-31 1996-03-13 Kobayashi Yukio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11335 2009-03-31 2006-10-26 Akiyama Kazuhiko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11336 2009-03-31 2006-10-26 Takahara Yoshio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11634 1986-04-01 1982-09-13 Yamamoto Tadashi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12485 1971-04-15 1970-03-13 Nii Izumi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12885 1990-04-20 1987-10-08 Hamano Michio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12933 1985-04-21 1982-09-13 Hara Joji 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
13428 2011-04-29 2010-03-22 Hata Masayuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
13620 1987-04-30 1984-09-06 Yamazaki Akira 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14120 2016-04-30 2013-03-26 Okui Kohei 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14256 1977-05-01 1975-03-21 Okamoto Shosaku 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14488 1984-05-03 1982-02-24 Setoya Hideo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14516 1996-05-03 1993-09-13 Kuwayama Shinya 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15086 1987-05-13 1984-09-06 Nakamura Toshio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15327 1980-05-16 1976-09-17 Nishikawa Yoshiharu 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15556 1978-05-20 1975-03-21 Hatakeyama Noboru 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15559 1981-05-20 1978-03-03 Otera Nobuyuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15560 1981-05-20 1978-08-15 Ogawa Shuji 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15884 2006-05-25 2001-09-04 Baba Keiji 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16054 1974-05-28 1971-09-08 Kaneko Kiyotaka 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17088 1968-06-01 1966-03-04 Suzuki Ryohei 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17119 1977-06-01 1975-03-21 Hirono Tadashi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17751 1986-06-09 1983-09-22 Nagao Masaaki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17754 1989-06-09 1986-10-17 Yokoyama Mitsuhiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17766 2001-06-09 1997-09-17 Nagahama Yuji 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17775 1970-06-10 1967-03-03 Matsumoto Kei 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17973 1984-06-13 1982-02-24 Kudo Tomiyuki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17983 1996-06-13 1993-09-13 Motoshima Naoki 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17988 1999-06-13 1996-09-12 Yamashita Ko 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18083 2004-06-14 2001-09-04 Maejima Akinari 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18086 2010-06-14 2007-10-03 Mino Toshikatsu 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18131 1970-06-15 1968-11-05 Fuldauer Ivan 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18202 1998-06-15 1995-09-18 Oyama Seiichiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18267 1989-06-16 1987-04-06 Machino Kazumichi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18338 2011-06-16 2008-09-30 Sumitani Yasushi 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18378 1999-06-17 1996-09-12 Kato Tomohiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18412 1990-06-18 1987-10-08 Fujino Tatsuo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18415 1992-06-18 1989-08-29 Yamane Yoshio 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18423 2003-06-18 2001-01-10 Sano Shun 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18435 2019-06-18 2016-09-27 Kasahara Ken 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18442 1974-06-19 1971-09-08 Sakakura Shogo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18484 2015-06-19 2012-09-28 Okano Yusuke 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18533 1998-06-20 1995-09-18 Okubo Tetsuo 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18542 2008-06-20 2005-10-05 Yamauchi Terunobu 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18546 2018-06-20 2015-09-29 Takahashi Takahiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18648 2007-06-22 2004-08-31 Yamakuchi Junichiro 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18844 2005-06-25 2003-03-03 Horiguchi Hikaru 1850 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601

Next page

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)
);
Powered by Datasette · Query took 314.986ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history