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

484 rows where Registration_Number = 1643

✎ 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

Registration_Number 1

  • JETRO, New York · 484 ✖

Registrant_Name 1

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
79 79   2020-01-09 Furujo Tatsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
101 101   2023-01-12 Ogata Tetsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
280 280   2006-02-01 Tanaka Yumiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
341 341   2021-02-09 Hiramoto Ryota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
490 490   2011-03-02 Nakajima Daiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
506 506   2023-03-03 Perrella Andrew JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
514 514   2021-03-04 Ohde Mariko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
660 660   2023-03-24 Mima Osamu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
735 735   2022-04-01 Fujioka Yota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
739 739   2023-04-04 Hirano Yuichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1260 1260   2019-06-11 Isobe Shinichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1308 1308   2021-06-24 Fujita Yuri JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1432 1432   2020-07-21 Ishihara Tetsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1463 1463   2022-07-26 Yamaguchi Jia JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1576 1576   2022-08-15 Fukuoka Kohei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1593 1593   2014-08-19 Ohara Noriko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1679 1679   2022-09-02 Iwabuchi Kana JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1687 1687   2019-09-05 Yoshida Natsue JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1706 1706   2022-09-07 Horigome Miho JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1708 1708   2015-09-08 Kashiba Sakura JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1713 1713   2021-09-09 Okada Takuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1735 1735   2018-09-13 Niikura Yukari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1772 1772   2022-09-19 Watanabe Hirokazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1803 1803   2020-09-24 Yoneyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1914 1914   2021-10-12 Tsukamoto Kazunari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1952 1952   2022-10-17 Kitade Teruo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2088 2088   2020-11-05 Miyano Keita JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2114 2114   2020-11-11 Nota Masayuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2177 2177   2019-11-19 Suga Mikiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2248 2248   2021-11-29 Hotta Motoi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2329 2329   2021-12-03 Rowland Amy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2342 2342   2021-12-06 Nambu Tomoshige JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2385 2385   2022-12-14 Aizawa Yasutoki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3107 3107 1974-01-03 1970-03-05 Tsuyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3189 3189 2008-01-04 2004-03-10 Silverbush Mark JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3196 3196 2019-01-04 2010-08-11 Watt Ian JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3375 3375 1965-01-08 1969-03-14 Hara Kiyoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3445 3445 2016-01-08 2014-05-27 Ota Naoko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3814 3814 2007-01-15 2006-05-26 Shih Dorothy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3822 3822 2016-01-15 2010-08-04 Kobayashi Nagisa JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4007 4007 1972-01-18 1968-01-29 Ochi Norio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4236 4236 1972-01-22 1969-09-11 Nakaima Hirokazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4852 4852 2017-01-30 2013-05-28 Horita Noriyasu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5693 5693 1977-02-01 1973-10-12 Miyata Kyoshiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5859 5859 2013-02-01 2010-04-09 Nagai Shingo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5966 5966 2002-02-02 1999-05-26 Shibata Sumio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6049 6049 1993-02-03 1990-02-02 Goto Hitoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6050 6050 1993-02-03 1990-02-02 Kojima Ainosuke JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6179 6179 2005-02-05 2002-07-31 Kaji Katsuhiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6180 6180 2008-02-05 2006-11-02 Takahashi Kei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6183 6183 2010-02-05 2004-10-19 Yamada Ryohei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6205 6205 1984-02-06 1983-04-29 Kawamoto Shigeo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6216 6216 1995-02-06 1992-02-04 Kameya Toshiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6217 6217 1995-02-06 1992-02-04 Kubota Hideo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6218 6218 1995-02-06 1992-02-04 Tanaka Hidetoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6219 6219 1995-02-06 1991-02-08 Hirai Sumihito JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6220 6220 1995-02-06 1991-02-08 Sasamoto Wataru JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6223 6223 1995-02-06 1992-08-06 Nishio Akemi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6443 6443 1988-02-09 1988-02-09 Furuta Hajime JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6691 6691 2021-02-12 2015-10-27 Tasaki O JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6797 6797 1994-02-14 1990-08-03 Ohashi Koshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6799 6799 1994-02-14 1989-08-14 Ito Kunio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6898 6898 1983-02-15 1980-04-30 Sugiura Shogo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6950 6950 2012-02-15 2009-09-25 Makino Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7130 7130 1975-02-17 1972-07-20 Kitamura Toshio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7228 7228 2016-02-19 2006-07-28 Yajima Haruko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7454 7454 2010-02-23 2009-05-07 Eiki-Law Maya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7658 7658 1973-02-26 1963-06-25 Hara Tsutomu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8613 8613 1964-03-01 1963-06-25 Someya Keiji JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9351 9351 1980-03-07 1977-12-05 Kuraishi Fumiaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9377 9377 2001-03-07 1999-04-27 Goto Hideyuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9412 9412 1975-03-08 1971-02-14 Mizuguchi Yasuhiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9590 9590 1991-03-11 1988-02-09 Ichikawa Nobuharu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9794 9794 1992-03-14 1988-08-16 Takahashi Toshiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10022 10022 1998-03-16 1995-02-06 Ando Masami JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10024 10024 1998-03-16 1995-07-28 Sagane Masakazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10075 10075 1966-03-17 1963-06-25 Moriguchi Ryouichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10083 10083 1983-03-17 1980-12-09 Yamakawa Sigeru JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10085 10085 1986-03-17 1983-11-14 Okamoto Junichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10219 10219 1997-03-18 1994-08-19 Hemmi Yoichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10284 10284 2003-03-19 2001-05-11 Mori Shigeki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10285 10285 2003-03-19 2000-09-18 Kometani Yuichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10324 10324 1966-03-20 1963-06-25 Aoyama Haruo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10327 10327 1973-03-20 1969-09-11 Yamazaki Tadao JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10330 10330 1977-03-20 1974-06-27 Kimura Nobuo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10361 10361 2015-03-20 2013-04-11 Eno Koichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10362 10362 2015-03-20 2013-08-27 Koshiba Jane JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10366 10366 2019-03-20 2018-04-12 Okimoto Kyoko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10380 10380 1969-03-21 1966-01-27 Kuroda Akio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10388 10388 1983-03-21 1980-04-30 Shioya Takafusa JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10426 10426 1999-03-21 1996-02-05 Hattori Osamu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10492 10492 2010-03-22 2006-09-20 Nishimoto Keiichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10494 10494 2013-03-22 2010-03-31 Kimura Tadaaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10495 10495 2013-03-22 2010-09-15 Takeuchi Mikio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10582 10582 2000-03-23 1999-04-27 Morii Motonao JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10587 10587 2002-03-23 1999-05-12 Deguchi Koji JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10594 10594 2021-03-23 2018-04-12 Suzuki Hiroyuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10655 10655 1996-03-24 1992-08-06 Moriai Mineo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10657 10657 2000-03-24 1999-04-27 Usuzawa Tsutomu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10667 10667 2005-03-24 2004-04-07 Hirose Miki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017

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