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

461 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

Registration_Number

  • 1643 · 461 ✖

Registrant_Name

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
40 40   2017-01-05 Gonda Tadashi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
60 60   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
183 183   2017-01-31 Nagao Yusuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
184 184   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
201 201   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
349 349   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
359 359   2016-03-03 Wakamatsu Isamu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
636 636   2018-04-12 Suzuki Hiroyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1052 1052   2019-06-11 Isobe Shinichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1140 1140   2017-06-27 Yanagisawa Tomoya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1186 1186   2018-07-05 Wakabayashi Kengo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1260 1260   2016-07-19 Sugimoto Keiji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1279 1279   2020-07-21 Ishihara Tetsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1295 1295   2018-07-23 Hatakeyama Issei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1413 1413   2017-08-08 Kasahara Ryo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1422 1422   2017-08-10 Nakazawa Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1467 1467   2014-08-19 Ohara Noriko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1522 1522   2019-08-27 Takeda Shinjiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1554 1554   2019-08-30 Ito Sadanori 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1563 1563   2017-08-31 Sakado Shunsuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1571 1571   2019-09-03 Machii Hiroaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1584 1584   2019-09-05 Yoshida Natsue 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1601 1601   2015-09-08 Kashiba Sakura 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1627 1627   2018-09-13 Niikura Yukari 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1703 1703   2020-09-24 Yoneyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1784 1784   2019-10-03 Inaba Kotohumi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1946 1946   2015-10-27 Tasaki O 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2081 2081   2019-11-19 Ara Takahiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2082 2082   2019-11-19 Suga Mikiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2325 2325   2019-12-23 Watanabe Takayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2331 2331   2019-12-26 Tani Hayato 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2967 2967 1974-01-03 1970-03-05 Tsuyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3045 3045 2008-01-04 2004-03-10 Silverbush Mark 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3052 3052 2019-01-04 2010-08-11 Watt Ian 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3193 3193 1965-01-08 1969-03-14 Hara Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3263 3263 2016-01-08 2014-05-27 Ota Naoko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3619 3619 2007-01-15 2006-05-26 Shih Dorothy 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3627 3627 2016-01-15 2010-08-04 Kobayashi Nagisa 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3776 3776 1972-01-18 1968-01-29 Ochi Norio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3996 3996 1972-01-22 1969-09-11 Nakaima Hirokazu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4596 4596 2017-01-30 2013-05-28 Horita Noriyasu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5394 5394 1977-02-01 1973-10-12 Miyata Kyoshiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5560 5560 2013-02-01 2010-04-09 Nagai Shingo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5662 5662 2002-02-02 1999-05-26 Shibata Sumio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5743 5743 1993-02-03 1990-02-02 Goto Hitoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5744 5744 1993-02-03 1990-02-02 Kojima Ainosuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5865 5865 2005-02-05 2002-07-31 Kaji Katsuhiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5866 5866 2008-02-05 2006-11-02 Takahashi Kei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5869 5869 2010-02-05 2004-10-19 Yamada Ryohei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5886 5886 1984-02-06 1983-04-29 Kawamoto Shigeo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5897 5897 1995-02-06 1992-02-04 Kameya Toshiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5898 5898 1995-02-06 1992-02-04 Kubota Hideo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5899 5899 1995-02-06 1992-02-04 Tanaka Hidetoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5900 5900 1995-02-06 1991-02-08 Hirai Sumihito 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5901 5901 1995-02-06 1991-02-08 Sasamoto Wataru 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5904 5904 1995-02-06 1992-08-06 Nishio Akemi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6115 6115 1988-02-09 1988-02-09 Furuta Hajime 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6458 6458 1994-02-14 1990-08-03 Ohashi Koshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6460 6460 1994-02-14 1989-08-14 Ito Kunio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6558 6558 1983-02-15 1980-04-30 Sugiura Shogo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6610 6610 2012-02-15 2009-09-25 Makino Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6778 6778 1975-02-17 1972-07-20 Kitamura Toshio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6866 6866 2016-02-19 2006-07-28 Yajima Haruko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7080 7080 2010-02-23 2009-05-07 Eiki-Law Maya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7278 7278 1973-02-26 1963-06-25 Hara Tsutomu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8153 8153 1964-03-01 1963-06-25 Someya Keiji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8857 8857 1980-03-07 1977-12-05 Kuraishi Fumiaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8883 8883 2001-03-07 1999-04-27 Goto Hideyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8905 8905 1975-03-08 1971-02-14 Mizuguchi Yasuhiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9075 9075 1991-03-11 1988-02-09 Ichikawa Nobuharu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9272 9272 1992-03-14 1988-08-16 Takahashi Toshiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9489 9489 1998-03-16 1995-02-06 Ando Masami 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9491 9491 1998-03-16 1995-07-28 Sagane Masakazu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9542 9542 1966-03-17 1963-06-25 Moriguchi Ryouichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9550 9550 1983-03-17 1980-12-09 Yamakawa Sigeru 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9552 9552 1986-03-17 1983-11-14 Okamoto Junichiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9685 9685 1997-03-18 1994-08-19 Hemmi Yoichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9749 9749 2003-03-19 2001-05-11 Mori Shigeki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9750 9750 2003-03-19 2000-09-18 Kometani Yuichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9789 9789 1966-03-20 1963-06-25 Aoyama Haruo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9792 9792 1973-03-20 1969-09-11 Yamazaki Tadao 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9795 9795 1977-03-20 1974-06-27 Kimura Nobuo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9826 9826 2015-03-20 2013-04-11 Eno Koichiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9827 9827 2015-03-20 2013-08-27 Koshiba Jane 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9831 9831 2019-03-20 2018-04-12 Okimoto Kyoko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9845 9845 1969-03-21 1966-01-27 Kuroda Akio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9853 9853 1983-03-21 1980-04-30 Shioya Takafusa 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9891 9891 1999-03-21 1996-02-05 Hattori Osamu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9957 9957 2010-03-22 2006-09-20 Nishimoto Keiichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9959 9959 2013-03-22 2010-03-31 Kimura Tadaaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9960 9960 2013-03-22 2010-09-15 Takeuchi Mikio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10046 10046 2000-03-23 1999-04-27 Morii Motonao 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10051 10051 2002-03-23 1999-05-12 Deguchi Koji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10115 10115 1996-03-24 1992-08-06 Moriai Mineo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10117 10117 2000-03-24 1999-04-27 Usuzawa Tsutomu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10127 10127 2005-03-24 2004-04-07 Hirose Miki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10132 10132 2016-03-24 2014-10-30 Ogawa Yuta 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10134 10134 2017-03-24 2016-05-26 Hiagakiuchi Miyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10199 10199 1975-03-26 1966-04-25 Ishikawa Samuel 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10238 10238 2010-03-26 2009-04-02 Hikino Teruki 1643 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 · Query took 367.193ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history