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

47 rows where Registration_Number = 2614

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Korea National Tourism Organization, New Jersey · 47 ✖

City 1

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
2110 2110   2021-11-04 Lee Sangmi Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
2111 2111   2021-11-04 Park Jaesok Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
2205 2205   2022-11-21 Choi Haeri Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
2206 2206   2022-11-21 Kang Mingu Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
2792 2792 2000-01-01 1998-11-30 Kyong-Sop Ohm Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
7553 7553 2010-02-24 2007-11-25 Park Yoonsook Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
7648 7648 2004-02-25 2002-05-29 Park Inshik Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
7807 7807 2006-02-27 2004-08-23 Kim Hyeong Joon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
8267 8267 2013-02-28 2010-11-08 Sung Phil Sang Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
8467 8467 1996-02-29 1993-06-11 Ahn Kwang-Charn Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
9717 9717 1990-03-12 1988-08-18 Kwon Yong Jip Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
9847 9847 2003-03-14 2000-11-08 Kang Kwang-Ho Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
10397 10397 2009-03-20 2006-08-17 Cho Sung Woock Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
13436 13436 1989-04-15 1987-04-28 Lee Byoung-Hyouk Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
13437 13437 1989-04-15 1984-10-18 Rhee Byoung-Shik Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
13447 13447 1992-04-15 1990-05-09 Jang Tae-Soon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
14244 14244 1987-04-28 1985-04-25 Park Eui-Suh Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
14291 14291 2009-04-28 2007-08-16 Kim Doojo Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
15482 15482 2012-05-01 2009-05-26 Park Younghee Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
15702 15702 1993-05-04 1989-07-28 Kang Chang-Hyo Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
16349 16349 2022-05-14 2019-05-16 Ban Hocheol Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
21296 21296 1998-06-30 1996-04-22 Choi Dal-Lyong Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
21367 21367 2000-06-30 1998-11-30 Sang-Yong Zhu Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
21699 21699 2012-06-30 2009-05-26 Min Min Hong Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
23261 23261 1991-07-15 1989-07-28 Park Eui-Suh Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
23383 23383 1996-07-16 1993-11-04 Min Min-Hong Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
24383 24383 2002-07-29 2000-11-08 Sung Phil-Sang Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
25052 25052 2004-07-31 2002-11-04 Park Chulho Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
26178 26178 1996-08-07 1994-10-31 Jo Hyun-Gwan Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
26653 26653 2018-08-14 2015-11-03 Kim Sehee Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
26797 26797 2015-08-15 2013-04-17 You Sejoon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
26798 26798 2015-08-15 2012-09-07 Hong Junghee Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
26806 26806 2021-08-15 2018-11-14 Kim Jee Hyung Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
27362 27362 2007-08-24 2006-08-17 Lee Kwan Sup Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
27439 27439 2006-08-25 2004-04-30 Yoon Seung Hwan Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
27600 27600 2007-08-28 2004-04-30 Park Young Gyu Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
27719 27719 2010-08-29 2007-11-25 Jun Young-Min Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
28446 28446 2005-08-31 2003-11-04 Hwang Yong Ku Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
29143 29143 1979-09-04 1975-10-01 Min Young Duck Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
33132 33132 1986-10-18 1979-09-04 Hong Seung-Chul Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
34050 34050 1980-10-30 1978-08-25 Kim Jae Hyon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
34249 34249 1984-10-31 1984-10-18 Kim Yong-ii Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
34347 34347 1994-10-31 1992-06-05 Ham Kyung-Joon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
35223 35223 1993-11-04 1992-06-05 Kim Dong-Won Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
35770 35770 2013-11-14 2011-02-10 Kim Jeongah Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
42164 42164 2017-12-31 2015-11-03 Na Sanghoon Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024
42323 42323 2020-12-31 2018-05-24 Yong Sonchung Korea National Tourism Organization, New Jersey 2614 1975-10-04 Korea National Tourism Organization, New Jersey 400 Kelby Street Suite 1602 Fort Lee NJ 07024

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