FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
35 rows where Registration_Number = 3069 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Short_Form_Termination_Date (date), Registration_Date (date)
Short_Form_Date (date) 23 ✖
- 2001-05-30 4
- 1979-11-23 2
- 1982-12-28 2
- 1988-06-22 2
- 1992-06-23 2
- 1994-12-27 2
- 1997-06-24 2
- 2004-06-29 2
- 2005-09-22 2
- 2007-07-26 2
- 1985-02-07 1
- 1986-09-19 1
- 1987-07-06 1
- 1989-06-28 1
- 1990-06-12 1
- 1991-06-18 1
- 1994-06-23 1
- 1996-12-30 1
- 1999-10-08 1
- 2004-07-02 1
- 2007-01-25 1
- 2008-02-11 1
- 2010-03-15 1
State 1
- IL 35
Registration_Number 1
- Korea National Tourism Organization, Chicago · 35 ✖
Registrant_Name 1
City 1
- Chicago 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5444 | 5444 | 2011-01-31 | 2010-03-15 | Mun | So Yeon | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
6591 | 6591 | 2005-02-10 | 2004-06-29 | Je | Sangwon | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
6637 | 6637 | 2010-02-11 | 2008-02-11 | Lee | Young Geun | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
7484 | 7484 | 2005-02-23 | 2004-06-29 | Park | Jong Wong | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
8456 | 8456 | 1988-02-29 | 1986-09-19 | Kim | Phil Wahn | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
9665 | 9665 | 2010-03-11 | 2007-07-26 | Jo | Deok Hyun | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
9789 | 9789 | 2007-03-13 | 2007-01-25 | Lee | Seangean | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
9790 | 9790 | 2007-03-13 | 2004-07-02 | Kim | Kuen Soo | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
9832 | 9832 | 1990-03-14 | 1988-06-22 | Park | Joo Wan | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
11554 | 11554 | 1986-03-31 | 1982-12-28 | Ahn | Kwang Charn | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
11557 | 11557 | 1987-03-31 | 1985-02-07 | Han | Seon Joo | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
11767 | 11767 | 1997-03-31 | 1994-06-23 | Min | Byungho | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
11781 | 11781 | 1997-03-31 | 1994-12-27 | Kim | Kwang Il | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
13322 | 13322 | 1989-04-14 | 1987-07-06 | Hwang | Kee Hank | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
13448 | 13448 | 1992-04-15 | 1990-06-12 | You | Se Joon | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
13449 | 13449 | 1992-04-15 | 1989-06-28 | Kim | Tae Shik | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
16418 | 16418 | 1991-05-15 | 1988-06-22 | Kim | Doh Hong | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
17286 | 17286 | 1982-05-28 | 1979-11-23 | Kim | Jong Hee | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
21668 | 21668 | 2010-06-30 | 2005-09-22 | Brennan | Bradley | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
22276 | 22276 | 1998-07-01 | 1996-12-30 | Ahn | Yungman | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
23741 | 23741 | 1996-07-21 | 1994-12-27 | Jo | Deok Hyun | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
24314 | 24314 | 2002-07-28 | 2001-05-30 | Kim | Kap-Soo | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
24492 | 24492 | 1984-07-30 | 1982-12-28 | Kim | Phil Wahn | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
24862 | 24862 | 1994-07-31 | 1991-06-18 | Choe | Sung Rim | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
26513 | 26513 | 2007-08-12 | 2005-09-22 | Kwon | Jong Sool | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
27791 | 27791 | 2000-08-30 | 1997-06-24 | Hwang | Yong Ku | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
28389 | 28389 | 2001-08-31 | 2001-05-30 | Ruzbasan | Debra | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
29650 | 29650 | 2009-09-12 | 2007-07-26 | Lee | Seo Jin | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
33599 | 33599 | 1982-10-25 | 1979-11-23 | Rhee | Byong Shik | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
36877 | 36877 | 1999-11-30 | 1999-10-08 | Parker | David A. | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
39023 | 39023 | 1999-12-23 | 1997-06-24 | Park | Sang Cheol | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
39179 | 39179 | 1994-12-27 | 1992-06-23 | Kwon | Yong Jip | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
39180 | 39180 | 1994-12-27 | 1992-06-23 | Park | Young Gyu | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
41310 | 41310 | 2003-12-31 | 2001-05-30 | Hwang | Kee-Hak | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
41356 | 41356 | 2004-12-31 | 2001-05-30 | Han | Jinny | Korea National Tourism Organization, Chicago 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
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]) );