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

473 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

  • NY 473

Registration_Number 1

  • JETRO, New York · 473 ✖

Registrant_Name 1

  • JETRO, New York 473

City 1

  • New York 473
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
58 58   2020-01-09 Furujo Tatsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
242 242   2006-02-01 Tanaka Yumiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
302 302   2021-02-09 Hiramoto Ryota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
434 434   2011-03-02 Nakajima Daiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
454 454   2021-03-04 Ohde Mariko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
705 705   2022-04-01 Fujioka Yota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1192 1192   2019-06-11 Isobe Shinichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1235 1235   2021-06-24 Fujita Yuri JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1255 1255   2017-06-27 Yanagisawa Tomoya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1363 1363   2020-07-21 Ishihara Tetsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1458 1458   2017-08-08 Kasahara Ryo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1465 1465   2017-08-10 Nakazawa Kiyoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1507 1507   2014-08-19 Ohara Noriko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1539 1539   2019-08-27 Takeda Shinjiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1555 1555   2019-08-30 Ito Sadanori JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1595 1595   2019-09-03 Machii Hiroaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1607 1607   2019-09-05 Yoshida Natsue JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1631 1631   2015-09-08 Kashiba Sakura JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1635 1635   2021-09-09 Nakayama Takaaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1636 1636   2021-09-09 Okada Takuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1649 1649   2018-09-13 Niikura Yukari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1695 1695   2020-09-24 Yoneyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1792 1792   2021-10-12 Tsukamoto Kazunari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1995 1995   2020-11-05 Miyano Keita JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2022 2022   2020-11-11 Nota Masayuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2082 2082   2019-11-19 Ara Takahiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2083 2083   2019-11-19 Suga Mikiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2149 2149   2021-11-29 Hotta Motoi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2236 2236   2021-12-03 Rowland Amy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2252 2252   2021-12-06 Nambu Tomoshige JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2352 2352   2019-12-26 Tani Hayato JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2996 2996 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
3077 3077 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
3084 3084 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
3230 3230 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
3300 3300 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
3665 3665 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
3673 3673 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
3855 3855 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
4080 4080 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
4688 4688 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
5520 5520 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
5686 5686 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
5789 5789 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
5872 5872 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
5873 5873 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
6001 6001 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
6002 6002 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
6005 6005 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
6025 6025 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
6036 6036 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
6037 6037 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
6038 6038 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
6039 6039 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
6040 6040 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
6043 6043 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
6260 6260 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
6507 6507 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
6611 6611 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
6613 6613 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
6712 6712 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
6764 6764 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
6944 6944 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
7040 7040 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
7261 7261 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
7464 7464 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
8410 8410 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
9134 9134 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
9160 9160 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
9184 9184 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
9361 9361 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
9559 9559 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
9783 9783 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
9785 9785 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
9836 9836 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
9844 9844 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
9846 9846 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
9979 9979 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
10044 10044 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
10045 10045 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
10084 10084 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
10087 10087 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
10090 10090 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
10121 10121 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
10122 10122 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
10126 10126 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
10140 10140 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
10148 10148 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
10186 10186 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
10253 10253 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
10255 10255 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
10256 10256 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
10343 10343 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
10348 10348 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
10354 10354 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
10414 10414 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
10416 10416 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
10426 10426 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
10432 10432 2016-03-24 2014-10-30 Ogawa Yuta JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10434 10434 2017-03-24 2016-05-26 Hiagakiuchi Miyuki 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])
);
Powered by Datasette · Queries took 266.707ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history