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

332 rows where City = "New York" and Registrant_Name = "KOTRA" sorted by Short_Form_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

Registrant_Name

  • KOTRA · 332 ✖

City

  • New York · 332 ✖
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
14 14     Jang Choong Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
16 16     Kim Chulmin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17 17     Lee Seok Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
18 18     Lee Yungsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27 27     Ryou Sungwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29 29     Seo Jiwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
47 47     Youngtae Kim 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
19883 19883 1964-06-30 1963-04-17 Park Hojoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35195 35195 1964-11-30 1963-04-17 Kim Kwan-min 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10613 10613 1966-03-30 1964-06-16 Johong Joondu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13828 13828 1965-04-30 1964-06-16 Chang Yong Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31437 31437 1964-10-13 1964-06-16 Kim Hee Kon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13017 13017 1969-04-17 1967-10-11 Chun Jin Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13018 13018 1969-04-17 1967-10-11 Yoon Byung Jae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13013 13013 1969-04-17 1968-03-14 Lee Hae Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
23644 23644 1970-07-31 1968-03-14 Yie Yul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31761 31761 1969-10-17 1968-03-14 Cho Kyung Don 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31762 31762 1969-10-17 1968-03-14 Lee Doo Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36880 36880 1967-12-15 1968-03-14 Lee Sang Won 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10090 10090 1973-03-23 1970-02-16 Lim Chonghoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13854 13854 1970-04-30 1970-02-16 Kim Eden 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29703 29703 1971-09-30 1970-02-16 Shin Ho Nung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
32721 32721 1971-10-30 1970-06-29 Kim Dong Hun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29713 29713 1973-09-30 1971-02-14 Ko Suk Won 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9433 9433 1972-03-15 1971-05-26 Park Moon Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
19980 19980 1972-06-30 1972-01-18 Belasco Claire E. 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10621 10621 1973-03-30 1972-08-15 Park Suk Yung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26784 26784 1973-08-31 1972-08-15 Gahng Dae Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26788 26788 1975-08-31 1972-08-15 Kim Mahn Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26789 26789 1975-08-31 1972-08-15 Yoon Jong Rak 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29714 29714 1973-09-30 1972-08-15 Lee Doo Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35222 35222 1972-11-30 1972-08-15 Park Woojin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20045 20045 1976-06-30 1973-06-12 Lee Tong Kyoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20046 20046 1976-06-30 1973-06-12 Oh Chang Suk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
24460 24460 1979-08-01 1973-12-27 Youn Suk Mahn 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
38523 38523 1976-12-31 1973-12-27 Kim Oh Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20275 20275 1990-06-30 1974-06-06 Cho Sung Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10988 10988 1979-03-31 1976-06-01 Ahn Jae-Kuen 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10989 10989 1979-03-31 1976-06-01 Hong Seung Man 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10990 10990 1979-03-31 1976-06-01 Koo Duk Mo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26875 26875 1977-08-31 1976-11-29 Lee Joun Shik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
16924 16924 1983-05-31 1979-01-16 Johong Joondu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
16395 16395 1984-05-26 1984-03-16 Lee Byung Chong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
16950 16950 1986-05-31 1985-02-06 Hong Jungpyo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11184 11184 1992-03-31 1990-10-18 Yoon Heui-Ro 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29417 29417 1991-09-27 1990-10-18 Lee Joun-Shik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29886 29886 1991-09-30 1990-10-18 Jeon Sang Woo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31917 31917 1994-10-19 1991-12-06 Choi Dong Suk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31918 31918 1994-10-19 1991-12-06 Kim Yong Jip 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13535 13535 1995-04-26 1992-05-29 Choi Yong Tai 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
34623 34623 1992-11-17 1992-05-29 Cho Tai Hyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29941 29941 1995-09-30 1992-11-17 Lee Sung Hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
33063 33063 1995-10-31 1992-11-17 Hur Gil Joo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20419 20419 1997-06-30 1994-10-17 Kim Hyun Tae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20420 20420 1997-06-30 1994-10-17 Park Dong Hyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25318 25318 1995-08-10 1994-10-17 Lee Chang Ryul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29940 29940 1995-09-30 1994-10-17 Oh Su Cheol 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29986 29986 1997-09-30 1994-10-17 Lee Kang Man 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11268 11268 1997-03-31 1995-04-26 Hwang Gyu Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29959 29959 1996-09-30 1995-10-23 Kim Bong Han 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35466 35466 1998-11-30 1995-10-23 Kim Sung Jo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
7708 7708 1999-02-28 1996-05-20 Kim Tae Hyeong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20481 20481 1999-06-30 1996-11-18 Koo Ja Yoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35459 35459 1997-11-30 1996-11-18 Chung Kui-Iae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11347 11347 2000-03-31 1997-11-18 Choe Ki Hyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11348 11348 2000-03-31 1997-11-18 Kim Tae Chil 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11349 11349 2000-03-31 1997-11-18 Son Pyung Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30066 30066 2000-09-30 1997-11-18 Kim Mahn Deug 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9258 9258 1999-03-12 1998-02-20 Kang Dae Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11301 11301 1999-03-31 1998-02-20 Gahng Young J. 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11333 11333 2000-03-31 1998-02-20 Ha Seung Beom 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17194 17194 2001-05-31 1998-02-20 Park Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29996 29996 1998-09-30 1998-02-20 Choi Kwang-Soo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30014 30014 1999-09-30 1998-02-20 Ham Jeong Oh 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30015 30015 1999-09-30 1998-02-20 Lee Min Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30053 30053 2000-09-30 1998-02-20 Kim Hyun Duk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
39579 39579 1998-12-31 1998-02-20 Cho Hong Yun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11368 11368 2001-03-31 1998-05-15 Lee Jung Min 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11369 11369 2001-03-31 1998-05-15 Park Kwon Tae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30025 30025 1999-09-30 1998-05-15 Ham Jun-Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30056 30056 2000-09-30 1998-05-15 Lee Jong Tae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9263 9263 2002-03-12 1999-05-21 Park Poong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14254 14254 2002-04-30 1999-05-21 Hong Dae-Eui 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20494 20494 2000-06-30 1999-05-21 Chung Won-Seo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20573 20573 2002-06-30 1999-05-21 Huh Jin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30069 30069 2001-09-30 1999-05-21 Ahn Bok-Nyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30070 30070 2001-09-30 1999-05-21 Lee Tai Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35472 35472 1999-11-30 1999-05-21 Yoon Jae-Chun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14262 14262 2002-04-30 1999-11-16 Kim Jae Han 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10484 10484 2003-03-28 2000-05-25 Ko Kyu-Suk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10485 10485 2003-03-28 2000-05-25 Kwon Joong Hun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10692 10692 2003-03-30 2000-05-25 Huh Byung Hee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10693 10693 2003-03-30 2000-05-25 Kim Kwan Mook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
24007 24007 2003-07-31 2000-05-25 Kim Hyeon Cheol 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5003 5003 2004-01-31 2000-12-06 Kim Jong-Weon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5004 5004 2004-01-31 2000-12-06 Kim Kyung-Yool 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5005 5005 2004-01-31 2000-12-06 Lee Kwang Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5006 5006 2004-01-31 2000-12-06 Lee Kyu-Seon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5007 5007 2004-01-31 2000-12-06 Yeon Young-Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5025 5025 2005-01-31 2000-12-06 Kang Shin-Taeg 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022

Next page

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