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

25 rows where Registration_Number = 2438

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

  • 2438 · 25 ✖

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
1475 1475   2019-08-15 Wyruchowski Dawn 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
1527 1527   2018-08-23 Nagamine Masanori 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
3278 3278 2015-01-08 2011-08-02 Hoak-Kagey Laura 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
5721 5721 1979-02-02 1976-01-21 Kajimura Fugie Rose 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
11787 11787 2015-03-31 2012-07-19 Kakiuchi Masao 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
11833 11833 2018-03-31 2016-02-09 Nave Andrew 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
11842 11842 2018-03-31 2015-08-18 Sometani Tetsuya 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
12068 12068 1997-04-01 1994-04-29 Ueda Kyoji 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
12460 12460 2012-04-07 2009-09-02 Nakamura Toshihiko 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
12723 12723 2003-04-11 2002-08-01 Matsuda Takaaki 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
12781 12781 2006-04-12 2003-08-07 Yamamoto Takeshi 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
12784 12784 2009-04-12 2006-09-26 Uematsu Kenji 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
13565 13565 2000-04-24 1997-08-27 Ono Toshihiko 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
14537 14537 2011-04-30 2008-08-25 Menard Marie 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
15273 15273 1991-05-07 1982-07-14 Ishida Toshiyuki 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
15891 15891 2019-05-15 2018-08-23 Corpuz Samantha 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
23512 23512 2004-07-29 2003-08-07 Weiss Sandra L. 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
25067 25067 1994-08-05 1991-05-15 Baba Toshiaki 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
26278 26278 2007-08-22 2005-08-30 Weiss-Plass Sandra L. 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
30540 30540 2015-09-30 2015-08-18 Seely Holly 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
31808 31808 2007-10-15 2003-08-07 Tokizawa Devin 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
32812 32812 1981-10-29 1973-07-02 Yamada Kotaro 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
39663 39663 1997-12-31 1976-02-06 Clinton Gordan S. 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
39670 39670 1997-12-31 1991-02-22 Thomson Keith C. 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
39681 39681 1997-12-31 1994-04-29 Cowan Pamela S. 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154

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