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

177 rows where Registrant_Name = "JETRO, Los Angeles"

✎ 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

Registrant_Name

  • JETRO, Los Angeles · 177 ✖

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
152 152   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
153 153   2018-01-25 Torres Kumiko Tanaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
154 154   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
191 191   2021-01-29 Nakano Chiaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
237 237   2020-01-31 Saeki Norihiko 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1321 1321   2017-07-28 Asai Yasutaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1361 1361   2021-07-30 Maurata Keiko 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1363 1363   2021-07-30 Nagata Hikara 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1364 1364   2021-07-30 Servin Alberto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3633 3633 2005-01-15 2001-09-18 Takashi Muneo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3774 3774 1995-01-17 1991-01-17 Suzuki Masahiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3780 3780 1995-01-17 1991-12-23 Inagaki Akihisa 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3781 3781 1995-01-17 1991-12-23 Obata Tomoyasu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3855 3855 1994-01-18 1991-01-17 Iwaki Shigenori 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3954 3954 1974-01-20 1971-01-31 Ueda Kooichi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4129 4129 1974-01-24 1969-01-21 Whitehouse Jack P. 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4131 4131 1979-01-24 1979-01-24 Kasagi Shunsuke 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4414 4414 1985-01-27 1982-08-04 Ishida Takashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
6785 6785 1971-02-16 1969-01-02 Iki Tatsuo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7089 7089 1977-02-22 1974-01-28 Sunami Taira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7253 7253 1994-02-24 1991-07-25 Yuzawa Saburo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7301 7301 1977-02-25 1974-01-28 Furukawa Aritsune 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7305 7305 1977-02-25 1976-07-17 Moromi Akira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7441 7441 2002-02-26 1999-07-26 Wakaume Masaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7484 7484 1981-02-27 1978-07-15 Kawakami Tsutomu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8413 8413 1978-03-01 1974-01-28 Watanabe Yasuo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8430 8430 1982-03-01 1979-07-17 Mitsuhashi Takayoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8817 8817 1974-03-05 1969-07-14 Takasugi Haruoki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8896 8896 1990-03-06 1987-07-17 Fukawa Hiroaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9064 9064 1987-03-07 1984-07-20 Harada Hideyuki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9163 9163 1984-03-09 1981-07-20 Suzuki Masachika 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9224 9224 1996-03-10 1993-08-09 Moriya Masanobu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9295 9295 2002-03-11 1998-06-15 Taki Osamu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9376 9376 2001-03-12 1998-02-06 Moromi Akira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9793 9793 1999-03-17 1996-07-17 Masui Hiroshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9919 9919 1977-03-19 1974-01-28 Imai Yoshio 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9930 9930 1983-03-19 1980-07-16 Ishii Masaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10004 10004 1983-03-20 1980-07-16 Miyao Hiroyuki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10008 10008 1990-03-20 1986-07-28 Yaeda Osamu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10010 10010 1991-03-20 1988-01-27 Kimura Nobuo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10057 10057 1980-03-21 1977-07-19 Watanabe Masafumi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10095 10095 1996-03-21 1995-01-17 Kanno Takahiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10096 10096 1997-03-21 1993-07-19 Nishizawa Kiyoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10141 10141 1992-03-22 1989-07-25 Kubota Hitoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10154 10154 1998-03-22 1995-07-24 Mitsui Makoto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10250 10250 1995-03-23 1992-07-27 Tachibana Kenji 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10291 10291 1980-03-24 1977-07-19 Shimomura Masao 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10295 10295 1986-03-24 1983-07-18 Yokoyama Toyonori 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10360 10360 1968-03-25 1964-12-14 Ihara Kiyoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10436 10436 1991-03-26 1987-07-17 Hattori Ryuichi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10486 10486 1980-03-27 1977-07-15 Morita Shozo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10487 10487 1980-03-27 1977-07-19 Saito Itaru 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10518 10518 2004-03-27 2001-08-07 Kato Hiroshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10599 10599 2001-03-28 1998-06-15 Yamaoka Nobukuni 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10712 10712 2011-03-29 2008-09-05 Kimura Shigeru 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11505 11505 2002-03-31 1997-07-22 Inoue Satoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11529 11529 2003-03-31 2000-07-21 Oki Kenichi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11530 11530 2003-03-31 2002-07-29 Matsushita Ikuzo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11691 11691 2010-03-31 2008-07-03 Takahashi Mitsuo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12069 12069 1994-04-01 1991-07-25 Kamekawa Harumi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12359 12359 2008-04-05 2004-02-06 Tsuchiya Keizo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12593 12593 1995-04-09 1991-12-23 Kanda Hiroyasu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12874 12874 2000-04-14 1997-01-30 Hirano Masao 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13308 13308 1974-04-20 1971-07-19 Nakagawa Osamu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13542 13542 1971-04-24 1969-01-02 Matsuoka Hiroshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13728 13728 2012-04-27 2009-02-25 Kobayashi Hiroto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13853 13853 1989-04-29 1986-09-08 Kobayashi Tadakazu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
15127 15127 1983-05-04 1980-07-30 Shimizu Ichiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
16056 16056 1986-05-18 1983-07-18 Yamada Masahito 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
16082 16082 2006-05-18 2001-09-18 Nishiura Masaru 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
16407 16407 1973-05-24 1970-09-03 Yokoiyama Noboru 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
17785 17785 1979-06-01 1976-08-06 Shimada Ichiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
17797 17797 1982-06-01 1979-07-17 Arai Hiroaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
17854 17854 1995-06-01 1994-01-18 Yokoiyama Noboru 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18007 18007 2001-06-02 1998-07-24 Fukushima Akira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18076 18076 1980-06-03 1978-01-16 Suzuki Kazumi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18465 18465 1976-06-10 1973-03-07 Takada Kenjiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18552 18552 1985-06-11 1982-08-04 Kawarada Takane 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18674 18674 1998-06-13 1995-07-24 Tonosaki Akira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18691 18691 1965-06-14 1964-12-14 Yasui Akira 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18741 18741 1987-06-14 1984-01-27 Tashiro Shigemitsu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18763 18763 1998-06-14 1995-07-24 Murayama Masazumi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18827 18827 1974-06-15 1971-07-19 Saito Kazumi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18831 18831 1977-06-15 1976-07-17 Takagi Shinya 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18959 18959 1989-06-16 1986-07-28 Fukuda Hidetoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19050 19050 1986-06-17 1983-07-18 Sato Yukinori 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19060 19060 1992-06-17 1989-07-25 Kono Kuniaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19080 19080 2017-06-17 2015-02-05 Okumoto Kazuo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19138 19138 1983-06-19 1980-07-16 Hashimoto Satoshi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19169 19169 2004-06-19 2001-09-18 Yokota Makoto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19205 19205 1977-06-20 1976-07-17 Sogo Shinsaku 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19247 19247 1973-06-21 1971-01-31 Wakasone Kazuyuki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19272 19272 1995-06-21 1992-07-27 Watanabe Takeo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19294 19294 1971-06-22 1969-01-21 Watanabe Yusuke 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19339 19339 2004-06-22 2001-09-18 Tamura Yoshihiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19349 19349 2013-06-22 2011-02-17 Nakagawa Kentaro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19377 19377 1972-06-23 1969-07-14 Komoda Kazuto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19380 19380 1980-06-23 1977-07-15 Itokawa Kazumasa 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19389 19389 1991-06-23 1988-01-27 Saito Jiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19411 19411 2007-06-23 2004-07-30 Mashita Toshiharu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513

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