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

490 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 · 490 ✖

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
106 106   2023-01-12 Ogata Tetsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
283 283   2006-02-01 Tanaka Yumiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
340 340   2021-02-09 Hiramoto Ryota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
479 479   2011-03-02 Nakajima Daiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
495 495   2023-03-03 Perrella Andrew JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
503 503   2021-03-04 Ohde Mariko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
647 647   2023-03-24 Mima Osamu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
720 720   2022-04-01 Fujioka Yota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
724 724   2023-04-04 Hirano Yuichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1224 1224   2019-06-11 Isobe Shinichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1251 1251   2023-06-16 Hiruta Atsushi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1288 1288   2021-06-24 Fujita Yuri JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1371 1371   2023-07-07 Miura Satoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1387 1387   2023-07-10 Kato Shoichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1388 1388   2023-07-10 Uchino Yasuaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1392 1392   2023-07-11 Abe Yukio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1414 1414   2023-07-17 Charles Cedric JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1491 1491   2022-07-26 Yamaguchi Jia JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1615 1615   2022-08-15 Fukuoka Kohei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1631 1631   2014-08-19 Ohara Noriko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1715 1715   2022-09-02 Iwabuchi Kana JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1723 1723   2019-09-05 Yoshida Natsue JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1742 1742   2022-09-07 Horigome Miho JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1744 1744   2015-09-08 Kashiba Sakura JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1749 1749   2021-09-09 Okada Takuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1806 1806   2022-09-19 Watanabe Hirokazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1836 1836   2020-09-24 Yoneyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1979 1979   2022-10-17 Kitade Teruo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2115 2115   2020-11-05 Miyano Keita JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2140 2140   2020-11-11 Nota Masayuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2198 2198   2019-11-19 Suga Mikiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2269 2269   2021-11-29 Hotta Motoi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2346 2346   2021-12-03 Rowland Amy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2359 2359   2021-12-06 Nambu Tomoshige JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2400 2400   2022-12-14 Aizawa Yasutoki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3118 3118 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
3200 3200 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
3207 3207 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
3386 3386 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
3456 3456 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
3825 3825 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
3833 3833 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
4018 4018 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
4190 4190 2023-01-20 2020-01-09 Furujo Tatsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4248 4248 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
4867 4867 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
5709 5709 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
5875 5875 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
5984 5984 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
6067 6067 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
6068 6068 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
6198 6198 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
6199 6199 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
6202 6202 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
6224 6224 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
6235 6235 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
6236 6236 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
6237 6237 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
6238 6238 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
6239 6239 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
6242 6242 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
6462 6462 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
6710 6710 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
6827 6827 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
6829 6829 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
6929 6929 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
6981 6981 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
7161 7161 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
7259 7259 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
7486 7486 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
7691 7691 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
8647 8647 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
9385 9385 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
9411 9411 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
9449 9449 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
9631 9631 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
9835 9835 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
10064 10064 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
10066 10066 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
10117 10117 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
10125 10125 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
10127 10127 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
10261 10261 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
10326 10326 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
10327 10327 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
10366 10366 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
10369 10369 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
10372 10372 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
10403 10403 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
10404 10404 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
10408 10408 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
10422 10422 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
10430 10430 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
10468 10468 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
10534 10534 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
10536 10536 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
10537 10537 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
10624 10624 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
10629 10629 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
10636 10636 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

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