home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

196 rows where Registration_Number = 1850

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • IL 196

Registration_Number 1

  • JETRO, Chicago · 196 ✖

Registrant_Name 1

  • JETRO, Chicago 196

City 1

  • Chicago 196
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
654 654   2013-03-26 Stevenson Naoko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
661 661   2018-03-27 Hashimoto Tsubasa JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
694 694   2020-03-30 Nishizawa Tomofumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1817 1817   2022-09-21 Kawakaki Takehiko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1818 1818   2022-09-21 Nemoto Hiroyuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
1819 1819   2022-09-21 Togashi Tatsuya JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
3621 3621 1989-01-12 1986-10-17 Suzuki Akio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
4766 4766 2002-01-29 1998-10-01 Take Nobumasa JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5408 5408 2008-01-31 2004-08-31 Sasaki Teruo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5410 5410 2008-01-31 2006-10-26 Soobratty Ayumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5463 5463 2012-01-31 2008-09-30 Hashimoto (Behr) Ritsuko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5707 5707 1977-02-01 1975-03-21 Kimba Hirofumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
5833 5833 2006-02-01 2003-03-03 Saito Hidemi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
6628 6628 1999-02-11 1996-03-13 Morita Ikuhiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
7266 7266 2023-02-19 2021-09-30 Hobo Mayu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8257 8257 2013-02-28 2012-03-30 Florida Tomoko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8656 8656 1967-03-01 1965-02-02 Inui Fumio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
8660 8660 1969-03-01 1965-02-02 Hikida Joseph S. JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9146 9146 1971-03-05 1968-03-12 Suzuki Ken JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9579 9579 1999-03-10 1996-03-13 Monden Takao JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9635 9635 1993-03-11 1989-08-29 Hamada Kazuaki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9714 9714 1986-03-12 1983-09-22 Hoshino Akira JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9731 9731 1998-03-12 1995-09-18 Watanabe Hisanori JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9793 9793 2008-03-13 2005-10-05 Tsuchiya Takashi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
9933 9933 1981-03-15 1977-09-07 Koyanagi Takeaki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10427 10427 1973-03-21 1969-03-04 Izawa Chihiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10502 10502 1980-03-22 1977-03-11 Saito Shinichi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10504 10504 1983-03-22 1981-01-23 Nagata Eiichi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10705 10705 2000-03-24 1997-09-17 Ishii Yasumichi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10756 10756 1994-03-25 1990-10-16 Masuda Koutaro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10757 10757 1994-03-25 1990-10-16 Umezawa Shigeyuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10793 10793 1983-03-26 1981-01-23 Tanaka Sumio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10811 10811 1991-03-26 1988-10-25 Ito Tomoyuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10821 10821 2003-03-26 2001-01-10 Tomita Tetsutaro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10876 10876 1988-03-27 1986-04-21 Fujihara Shiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10885 10885 1995-03-27 1992-09-10 Hara Noriyasu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10887 10887 2001-03-27 1998-10-15 Ishii Shigeru JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10888 10888 2001-03-27 1998-10-15 Wada Aya JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10894 10894 2004-03-27 2001-09-04 Terahara Yoshihito JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10900 10900 2009-03-27 2004-08-31 Nakajo Kazuya JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10902 10902 2010-03-27 2008-09-30 Takashi Muneo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10967 10967 1996-03-28 1993-03-11 Toyonaga Yoshitaka JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
10981 10981 2006-03-28 2003-09-23 Funakoshi Teruyo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11068 11068 1997-03-29 1994-03-25 Sawano Hiroshi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11080 11080 2004-03-29 2001-09-04 Ohsawa Hiroshi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11088 11088 2010-03-29 2006-10-26 Toriyama Takayuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11122 11122 1979-03-30 1975-09-11 Tamura Tadao JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11182 11182 2000-03-30 1997-06-13 Komatsu Kyuhei JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11195 11195 2005-03-30 2002-02-27 Washio Tomoharu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11219 11219 2011-03-30 2008-04-15 Nakamura Kyoichi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11448 11448 1975-03-31 1969-03-04 Oshikawa Akira JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11716 11716 1995-03-31 1992-03-10 Suzuki Minoru JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
11804 11804 1999-03-31 1996-03-13 Kobayashi Yukio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12056 12056 2009-03-31 2006-10-26 Akiyama Kazuhiko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12057 12057 2009-03-31 2006-10-26 Takahara Yoshio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12461 12461 1986-04-01 1982-09-13 Yamamoto Tadashi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
12609 12609 2021-04-01 2016-09-27 Kawachi Akira JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
13376 13376 1971-04-15 1970-03-13 Nii Izumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
13795 13795 1990-04-20 1987-10-08 Hamano Michio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
13852 13852 1985-04-21 1982-09-13 Hara Joji JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14380 14380 2011-04-29 2010-03-22 Hata Masayuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
14579 14579 1987-04-30 1984-09-06 Yamazaki Akira JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15080 15080 2016-04-30 2013-03-26 Okui Kohei JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15336 15336 1977-05-01 1975-03-21 Okamoto Shosaku JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15617 15617 1984-05-03 1982-02-24 Setoya Hideo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
15645 15645 1996-05-03 1993-09-13 Kuwayama Shinya JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16252 16252 1987-05-13 1984-09-06 Nakamura Toshio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16508 16508 1980-05-16 1976-09-17 Nishikawa Yoshiharu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16747 16747 1978-05-20 1975-03-21 Hatakeyama Noboru JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16750 16750 1981-05-20 1978-03-03 Otera Nobuyuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
16751 16751 1981-05-20 1978-08-15 Ogawa Shuji JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17093 17093 2006-05-25 2001-09-04 Baba Keiji JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
17273 17273 1974-05-28 1971-09-08 Kaneko Kiyotaka JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18395 18395 1968-06-01 1966-03-04 Suzuki Ryohei JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
18426 18426 1977-06-01 1975-03-21 Hirono Tadashi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19105 19105 1986-06-09 1983-09-22 Nagao Masaaki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19108 19108 1989-06-09 1986-10-17 Yokoyama Mitsuhiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19120 19120 2001-06-09 1997-09-17 Nagahama Yuji JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19134 19134 1970-06-10 1967-03-03 Matsumoto Kei JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19341 19341 1984-06-13 1982-02-24 Kudo Tomiyuki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19351 19351 1996-06-13 1993-09-13 Motoshima Naoki JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19356 19356 1999-06-13 1996-09-12 Yamashita Ko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19454 19454 2004-06-14 2001-09-04 Maejima Akinari JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19457 19457 2010-06-14 2007-10-03 Mino Toshikatsu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19508 19508 1970-06-15 1968-11-05 Fuldauer Ivan JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19579 19579 1998-06-15 1995-09-18 Oyama Seiichiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19654 19654 1989-06-16 1987-04-06 Machino Kazumichi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19726 19726 2011-06-16 2008-09-30 Sumitani Yasushi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19769 19769 1999-06-17 1996-09-12 Kato Tomohiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19784 19784 2022-06-17 2019-09-30 Fujimoto Fujio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19809 19809 1990-06-18 1987-10-08 Fujino Tatsuo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19812 19812 1992-06-18 1989-08-29 Yamane Yoshio JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19820 19820 2003-06-18 2001-01-10 Sano Shun JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19832 19832 2019-06-18 2016-09-27 Kasahara Ken JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19842 19842 1974-06-19 1971-09-08 Sakakura Shogo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19884 19884 2015-06-19 2012-09-28 Okano Yusuke JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19934 19934 1998-06-20 1995-09-18 Okubo Tetsuo JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19943 19943 2008-06-20 2005-10-05 Yamauchi Terunobu JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
19947 19947 2018-06-20 2015-09-29 Takahashi Takahiro JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
20049 20049 2007-06-22 2004-08-31 Yamakuchi Junichiro JETRO, Chicago 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 · Queries took 452.854ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows