List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

35 rows where Registration_Number = 3069

View and edit SQL

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

State

Registration_Number

  • 3069 · 35

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
5132 2011-01-31 2010-03-15 Mun So Yeon 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
6239 2005-02-10 2004-06-29 Je Sangwon 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
6284 2010-02-11 2008-02-11 Lee Young Geun 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
7100 2005-02-23 2004-06-29 Park Jong Wong 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
8040 1988-02-29 1986-09-19 Kim Phil Wahn 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
9197 2010-03-11 2007-07-26 Jo Deok Hyun 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
9316 2007-03-13 2007-01-25 Lee Seangean 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
9317 2007-03-13 2004-07-02 Kim Kuen Soo 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
9358 1990-03-14 1988-06-22 Park Joo Wan 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
11059 1986-03-31 1982-12-28 Ahn Kwang Charn 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
11062 1987-03-31 1985-02-07 Han Seon Joo 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
11272 1997-03-31 1994-06-23 Min Byungho 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
11286 1997-03-31 1994-12-27 Kim Kwang Il 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
12742 1989-04-14 1987-07-06 Hwang Kee Hank 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
12864 1992-04-15 1990-06-12 You Se Joon 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
12865 1992-04-15 1989-06-28 Kim Tae Shik 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
15700 1991-05-15 1988-06-22 Kim Doh Hong 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
16548 1982-05-28 1979-11-23 Kim Jong Hee 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
20808 2010-06-30 2005-09-22 Brennan Bradley 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
21357 1998-07-01 1996-12-30 Ahn Yungman 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
22765 1996-07-21 1994-12-27 Jo Deok Hyun 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
23304 2002-07-28 2001-05-30 Kim Kap-Soo 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
23478 1984-07-30 1982-12-28 Kim Phil Wahn 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
23846 1994-07-31 1991-06-18 Choe Sung Rim 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
25440 2007-08-12 2005-09-22 Kwon Jong Sool 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
26673 2000-08-30 1997-06-24 Hwang Yong Ku 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
27268 2001-08-31 2001-05-30 Ruzbasan Debra 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
28486 2009-09-12 2007-07-26 Lee Seo Jin 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
32304 1982-10-25 1979-11-23 Rhee Byong Shik 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
35479 1999-11-30 1999-10-08 Parker David A. 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
37535 1999-12-23 1997-06-24 Park Sang Cheol 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
37686 1994-12-27 1992-06-23 Kwon Yong Jip 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
37687 1994-12-27 1992-06-23 Park Young Gyu 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
39813 2003-12-31 2001-05-30 Hwang Kee-Hak 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
39859 2004-12-31 2001-05-30 Han Jinny 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611

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