FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Document_Type = "Short-Form" and Registrant_Name = "Korea National Tourism Organization, Chicago"
This data as json, CSV (advanced)
Registrant_Name 1
- Korea National Tourism Organization, Chicago · 18 ✖
Foreign_Principal_Name 1
- - 18
Foreign_Principal_Country 1
- - 18
Document_Type 1
- Short-Form · 18 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
7433 | 7433 | 2007-01-25 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Lee, Seangean | Available-FARA-Public-Office | ||
15672 | 15672 | 2008-02-11 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Lee, Young Geun | https://efile.fara.gov/docs/3069-Short-Form-20080211-16.pdf | ||
28098 | 28098 | 2010-03-15 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Mun, So Yeon | https://efile.fara.gov/docs/3069-Short-Form-20100315-18.pdf | ||
56041 | 56041 | 2001-05-30 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Han,Jinny | Available-FARA-Public-Office | ||
56042 | 56042 | 2001-05-30 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Hwang,Kee-Hak | Available-FARA-Public-Office | ||
56043 | 56043 | 2001-05-30 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Kim,Kap-Soo | Available-FARA-Public-Office | ||
56044 | 56044 | 2001-05-30 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Ruzbasan,Debra | Available-FARA-Public-Office | ||
67138 | 67138 | 1997-06-24 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Park, Sang Cheol | Available-FARA-Public-Office | ||
67167 | 67167 | 2004-06-24 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Je, Sangwon | Available-FARA-Public-Office | ||
68493 | 68493 | 2004-06-29 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Park , Jong Wong | Available-FARA-Public-Office | ||
73543 | 73543 | 2004-07-02 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Kim,Kuen Soo | Available-FARA-Public-Office | ||
78883 | 78883 | 2007-07-26 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Jo, Deok Hyun | Available-FARA-Public-Office | ||
78884 | 78884 | 2007-07-26 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Lee, Seo Jin | Available-FARA-Public-Office | ||
99566 | 99566 | 2005-09-22 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Brennan, Bradley | Available-FARA-Public-Office | ||
99567 | 99567 | 2005-09-22 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Kwon, Jong Sool | Available-FARA-Public-Office | ||
107481 | 107481 | 1999-10-08 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Parker,David A. | Available-FARA-Public-Office | ||
121908 | 121908 | 2002-11-26 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Han, Ji Nny | Available-FARA-Public-Office | ||
121909 | 121909 | 2002-11-26 | Korea National Tourism Organization, Chicago | Korea National Tourism Organization, Chicago 3069 | Short-Form | Hwang,Kee-Hak | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );