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

184 rows where Registrant_Name = "JETRO, Los Angeles" and State = "CA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

  • CA · 184 ✖

Registration_Number 1

  • JETRO, Los Angeles 184

Registrant_Name 1

  • JETRO, Los Angeles · 184 ✖

City 1

  • Los Angeles 184
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
188 188   2018-01-25 Baker Christopher JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
189 189   2018-01-25 Torres Kumiko Tanaka JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
190 190   2018-01-25 Vermeiren Sachie JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
216 216   2022-01-28 John Maai JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
217 217   2022-01-28 Shibahara Tomonori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
222 222   2021-01-29 Nakano Chiaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
325 325   2023-02-06 Hirano Junko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
326 326   2023-02-06 Kimura Kota JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
328 328   2023-02-06 Tsuwaki Yoshiko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
329 329   2023-02-06 Wanami Takuro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1546 1546   2021-07-30 Nagata Hikara JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3820 3820 2005-01-15 2001-09-18 Takashi Muneo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3971 3971 1995-01-17 1991-01-17 Suzuki Masahiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3977 3977 1995-01-17 1991-12-23 Inagaki Akihisa JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3978 3978 1995-01-17 1991-12-23 Obata Tomoyasu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4052 4052 1994-01-18 1991-01-17 Iwaki Shigenori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4155 4155 1974-01-20 1971-01-31 Ueda Kooichi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4334 4334 1974-01-24 1969-01-21 Whitehouse Jack P. JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4336 4336 1979-01-24 1979-01-24 Kasagi Shunsuke JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4625 4625 1985-01-27 1982-08-04 Ishida Takashi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7055 7055 1971-02-16 1969-01-02 Iki Tatsuo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7366 7366 1977-02-22 1974-01-28 Sunami Taira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7537 7537 1994-02-24 1991-07-25 Yuzawa Saburo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7587 7587 1977-02-25 1974-01-28 Furukawa Aritsune JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7591 7591 1977-02-25 1976-07-17 Moromi Akira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7728 7728 2002-02-26 1999-07-26 Wakaume Masaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
7770 7770 1981-02-27 1978-07-15 Kawakami Tsutomu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8724 8724 1978-03-01 1974-01-28 Watanabe Yasuo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
8741 8741 1982-03-01 1979-07-17 Mitsuhashi Takayoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9150 9150 1974-03-05 1969-07-14 Takasugi Haruoki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9229 9229 1990-03-06 1987-07-17 Fukawa Hiroaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9398 9398 1987-03-07 1984-07-20 Harada Hideyuki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9514 9514 1984-03-09 1981-07-20 Suzuki Masachika JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9576 9576 1996-03-10 1993-08-09 Moriya Masanobu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9651 9651 2002-03-11 1998-06-15 Taki Osamu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
9738 9738 2001-03-12 1998-02-06 Moromi Akira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10163 10163 1999-03-17 1996-07-17 Masui Hiroshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10290 10290 1977-03-19 1974-01-28 Imai Yoshio JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10301 10301 1983-03-19 1980-07-16 Ishii Masaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10375 10375 1983-03-20 1980-07-16 Miyao Hiroyuki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10379 10379 1990-03-20 1986-07-28 Yaeda Osamu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10381 10381 1991-03-20 1988-01-27 Kimura Nobuo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10428 10428 1980-03-21 1977-07-19 Watanabe Masafumi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10466 10466 1996-03-21 1995-01-17 Kanno Takahiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10467 10467 1997-03-21 1993-07-19 Nishizawa Kiyoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10511 10511 1992-03-22 1989-07-25 Kubota Hitoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10524 10524 1998-03-22 1995-07-24 Mitsui Makoto JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10621 10621 1995-03-23 1992-07-27 Tachibana Kenji JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10664 10664 1980-03-24 1977-07-19 Shimomura Masao JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10668 10668 1986-03-24 1983-07-18 Yokoyama Toyonori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10734 10734 1968-03-25 1964-12-14 Ihara Kiyoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10810 10810 1991-03-26 1987-07-17 Hattori Ryuichi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10861 10861 1980-03-27 1977-07-15 Morita Shozo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10862 10862 1980-03-27 1977-07-19 Saito Itaru JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10893 10893 2004-03-27 2001-08-07 Kato Hiroshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
10974 10974 2001-03-28 1998-06-15 Yamaoka Nobukuni JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11090 11090 2011-03-29 2008-09-05 Kimura Shigeru JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11885 11885 2002-03-31 1997-07-22 Inoue Satoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11909 11909 2003-03-31 2000-07-21 Oki Kenichi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
11910 11910 2003-03-31 2002-07-29 Matsushita Ikuzo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12071 12071 2010-03-31 2008-07-03 Takahashi Mitsuo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12499 12499 1994-04-01 1991-07-25 Kamekawa Harumi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
12802 12802 2008-04-05 2004-02-06 Tsuchiya Keizo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13043 13043 1995-04-09 1991-12-23 Kanda Hiroyasu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13331 13331 2000-04-14 1997-01-30 Hirano Masao JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
13778 13778 1974-04-20 1971-07-19 Nakagawa Osamu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
14023 14023 1971-04-24 1969-01-02 Matsuoka Hiroshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
14214 14214 2012-04-27 2009-02-25 Kobayashi Hiroto JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
14341 14341 1989-04-29 1986-09-08 Kobayashi Tadakazu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
15685 15685 1983-05-04 1980-07-30 Shimizu Ichiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
16649 16649 1986-05-18 1983-07-18 Yamada Masahito JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
16675 16675 2006-05-18 2001-09-18 Nishiura Masaru JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
17007 17007 1973-05-24 1970-09-03 Yokoiyama Noboru JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18436 18436 1979-06-01 1976-08-06 Shimada Ichiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18448 18448 1982-06-01 1979-07-17 Arai Hiroaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18505 18505 1995-06-01 1994-01-18 Yokoiyama Noboru JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18675 18675 2001-06-02 1998-07-24 Fukushima Akira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
18746 18746 1980-06-03 1978-01-16 Suzuki Kazumi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19142 19142 1976-06-10 1973-03-07 Takada Kenjiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19230 19230 1985-06-11 1982-08-04 Kawarada Takane JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19355 19355 1998-06-13 1995-07-24 Tonosaki Akira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19375 19375 1965-06-14 1964-12-14 Yasui Akira JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19425 19425 1987-06-14 1984-01-27 Tashiro Shigemitsu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19447 19447 1998-06-14 1995-07-24 Murayama Masazumi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19515 19515 1974-06-15 1971-07-19 Saito Kazumi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19519 19519 1977-06-15 1976-07-17 Takagi Shinya JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19656 19656 1989-06-16 1986-07-28 Fukuda Hidetoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19749 19749 1986-06-17 1983-07-18 Sato Yukinori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19759 19759 1992-06-17 1989-07-25 Kono Kuniaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19779 19779 2017-06-17 2015-02-05 Okumoto Kazuo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19845 19845 1983-06-19 1980-07-16 Hashimoto Satoshi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19876 19876 2004-06-19 2001-09-18 Yokota Makoto JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19912 19912 1977-06-20 1976-07-17 Sogo Shinsaku JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19954 19954 1973-06-21 1971-01-31 Wakasone Kazuyuki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
19979 19979 1995-06-21 1992-07-27 Watanabe Takeo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
20001 20001 1971-06-22 1969-01-21 Watanabe Yusuke JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
20046 20046 2004-06-22 2001-09-18 Tamura Yoshihiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
20056 20056 2013-06-22 2011-02-17 Nakagawa Kentaro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
20084 20084 1972-06-23 1969-07-14 Komoda Kazuto JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
20087 20087 1980-06-23 1977-07-15 Itokawa Kazumasa JETRO, Los Angeles 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])
);
Powered by Datasette · Queries took 629.628ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows