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

42 rows where City = "Los Angeles" and Registrant_Name = "Korea National Tourism Organization, Los Angeles"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registrant_Name 1

  • Korea National Tourism Organization, Los Angeles · 42 ✖

City 1

  • Los Angeles · 42 ✖
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
1007 1007   2022-05-12 Jang You Hyun Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
3722 3722 2022-01-14 2019-11-29 Jeong Byeongok Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
4172 4172 1997-01-20 1994-12-29 Kim Yong-Il Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
4173 4173 1999-01-20 1997-07-17 Na Sang Hoon Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
4711 4711 1999-01-28 1997-11-10 Kim Hong Yoon Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
6662 6662 1989-02-12 1987-11-09 Limb Joo-Hwan Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
8172 8172 2004-02-28 2002-04-03 Jo Joon Kil Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
8770 8770 1988-03-01 1984-10-30 Ohm Kyong-Sop Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
9781 9781 1993-03-13 1989-07-25 Lee Sang-Oh Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
9783 9783 1997-03-13 1994-12-29 Kang Kwang-Ho Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
10820 10820 2000-03-26 1997-07-17 Lee Sang Oh Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
11133 11133 1987-03-30 1984-10-30 Lee Kwang-Hee Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
12424 12424 1976-04-01 1974-10-25 Rha Gun Young Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
13450 13450 1992-04-15 1990-07-03 Chung-Do Suh Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
13862 13862 1992-04-21 1989-07-25 Hur Duk-Soo Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
16342 16342 2012-05-14 2009-06-30 Lee In Sook Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
17772 17772 1994-05-31 1992-09-04 Yong-Tae Kim Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
19451 19451 2003-06-14 2002-04-03 Hong Ju Min Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
19742 19742 1980-06-17 1976-10-13 Ahn Kwang Charn Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
21572 21572 2006-06-30 2004-05-17 Kim Tae Shik Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
21573 21573 2006-06-30 2004-05-17 Lee Sang Yoon Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
21612 21612 2009-06-30 2009-01-15 Lee Jae Kyong Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
21705 21705 2012-06-30 2009-12-02 Kim Myongsun Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
21815 21815 2014-06-30 2012-11-30 Kang OK Hee Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
23143 23143 2017-07-14 2014-11-19 Kim Taeshik Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
23320 23320 2019-07-15 2017-11-22 Kim Heesun Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
24217 24217 1995-07-27 1993-07-27 Choi Jae-Il Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26639 26639 2011-08-14 2009-01-15 Lee Hyeonjin Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26643 26643 2014-08-14 2012-02-10 Baek Manseong Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26646 26646 2015-08-14 2012-11-30 Ahn Hyo Won Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26647 26647 2017-08-14 2015-11-17 Park Hyosook Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26648 26648 2017-08-14 2014-11-19 Park Kyunghee Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
26659 26659 2020-08-14 2017-11-22 Myung Sewon Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
27115 27115 1979-08-21 1974-10-25 Lee In Chong Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
27809 27809 2006-08-30 2004-05-17 Yong Sonchung Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
28528 28528 2009-08-31 2009-01-15 Shin Heesup Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
30000 30000 2012-09-17 2009-12-02 Jung Kijung Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
37837 37837 1994-12-06 1992-09-04 Jean-Sei Kim Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
39184 39184 2001-12-27 2002-04-03 Shin Jae Koo Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
39285 39285 1999-12-29 1997-07-17 Kim Chong Bae Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
41407 41407 2005-12-31 2004-05-17 Kim Young Hee Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
42353 42353 2020-12-31 2017-11-22 Suk Lee Dong Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036

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