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

64 rows where City = "Atlanta", Registrant_Name = "JETRO, Atlanta" and State = "GA"

✎ 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

Registrant_Name 1

  • JETRO, Atlanta · 64 ✖

City 1

  • Atlanta · 64 ✖
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
263 263   2020-01-31 Kanji Miyatake JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1102 1102   2018-05-25 Ishida Reiji JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1362 1362   2023-07-05 Danno Koki JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1474 1474   2023-07-24 Danno Kouki JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1554 1554   2017-08-01 Tomoda Ryoko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1573 1573   2018-08-07 Shimuzu Kristine Asuka JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
1957 1957   2022-10-14 Akiyama Hiroyuki JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
2480 2480   2004-12-30 Dye Trevin G. JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
3236 3236 1994-01-05 1993-01-19 Steeves Matthew W. JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
3238 3238 1994-01-05 1991-08-23 Riggins Robert JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
3544 3544 2019-01-10 2015-07-31 Mori Norikazu JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
3909 3909 2003-01-16 1999-12-29 Noma Tsuyoshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
6332 6332 1997-02-07 1996-12-16 Lowden Katherine M. JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
9974 9974 1995-03-15 1993-11-10 Panter Craig JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
10065 10065 1998-03-16 1994-07-19 Yoshikawa Hiroshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
10406 10406 2017-03-20 2016-08-01 Hotta Motoi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
10626 10626 2001-03-23 2000-06-19 Weber Grant JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
10889 10889 2003-03-27 2001-02-26 Kiuchi Shinkichi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
10970 10970 1998-03-28 1995-07-14 Imatomi Yoshitsugu JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
11094 11094 2019-03-29 2016-02-10 Lammers Naoko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
11707 11707 1995-03-31 1993-01-19 Koide Junji JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
11747 11747 1996-03-31 1992-07-27 Otake Masao JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
11752 11752 1996-03-31 1994-09-23 Beach John Charles JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
12797 12797 2002-04-05 2001-02-26 Franciscus Mark Donald JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
13103 13103 2001-04-10 1998-08-06 Watanabe Hiroshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
13592 13592 2015-04-16 2013-01-30 Kimura Keiichi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
13759 13759 2000-04-19 1996-07-03 Richardson Darrel JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
13760 13760 2000-04-19 1996-07-03 Tsuyoshi Darrel JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
13938 13938 2022-04-22 2020-01-31 Reynolds Katrina JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
14098 14098 1991-04-25 1988-08-16 Mori Shiro JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
15934 15934 1992-05-08 1991-08-23 Ratcliffe Linda Lee JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
17502 17502 2006-05-30 2001-09-24 Yamaoka Hirokazu JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
17976 17976 2004-05-31 2001-06-15 Greene Mastin JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
18250 18250 2022-05-31 2020-01-31 Yeung Keiko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
19878 19878 2007-06-19 2002-06-05 Narita Yusuke JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
20245 20245 1998-06-25 1994-10-21 Funaki Kuniyasu JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
20576 20576 2006-06-29 2000-11-15 McCauley Mindy Lyn JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
22642 22642 1994-07-06 1991-08-23 Oishi Hitoshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
23267 23267 1993-07-15 1992-07-27 Tanji Takashi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
23268 23268 1993-07-15 1989-12-13 Iwasaki Yasumasa JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
23562 23562 2002-07-18 1999-12-29 Saeki Kazuto JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
24566 24566 1999-07-30 1996-07-03 Fukuhara Yoshiaki JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
25796 25796 2001-08-02 1998-08-06 Takahashi Kosuke JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
26972 26972 1995-08-18 1993-11-10 Masters Bryson JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
27723 27723 2014-08-29 2011-02-04 Young Yasuko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
29697 29697 2013-09-13 2002-07-12 Barnett Larry John (L.J.) JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
30157 30157 1997-09-20 1993-05-26 Isaki Shoji JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
30615 30615 2001-09-27 1998-08-06 Tauchi Koji JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
30694 30694 2000-09-28 1997-10-22 Iino Shigefumi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
31565 31565 2014-09-30 2013-07-29 Sone Sumiko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
32298 32298 2022-10-04 2019-02-18 Takahashi Takuya JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
32745 32745 2000-10-13 1998-01-13 III William D. Bakun JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
33422 33422 1989-10-22 1987-12-01 Hirano Shusaku JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
33808 33808 2010-10-28 2007-08-01 Kira Daiji JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
35174 35174 2000-11-03 1997-02-28 Henderson Gregory M. JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
35338 35338 1992-11-06 1992-07-27 Garrard James JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
35765 35765 2005-11-14 2003-01-13 Kakuda Satoshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
36493 36493 2012-11-27 2010-01-29 Matsudaira Yoshifumi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
37447 37447 1996-12-01 1995-04-07 Seemueller Karen JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
37637 37637 2004-12-02 2002-01-15 Kobayashi Katsuhiko JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
38432 38432 2009-12-15 2006-08-01 Saito Takeshi JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
39418 39418 1994-12-30 1993-01-19 Clement Heather Hopkins JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
39420 39420 1994-12-30 1991-08-23 Iguchi Tadao JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328
41063 41063 1997-12-31 1995-12-08 Seiden Andrew L. JETRO, Atlanta 4069 1987-12-01 JETRO, Atlanta 5901 Peachtree Dunwoody Rd, Suite. B485 Atlanta GA 30328

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