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

358 rows where City = "New York" and Registrant_Name = "KOTRA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

Registration_Number 1

Registrant_Name 1

  • KOTRA · 277 ✖

City 1

  • New York · 277 ✖
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
5318 5318 2004-01-31 2000-12-06 Kim Jong-Weon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5319 5319 2004-01-31 2000-12-06 Kim Kyung-Yool KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5320 5320 2004-01-31 2000-12-06 Lee Kwang Il KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5321 5321 2004-01-31 2000-12-06 Lee Kyu-Seon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5322 5322 2004-01-31 2000-12-06 Yeon Young-Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5332 5332 2005-01-31 2001-05-17 Hwang Eui Shun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5333 5333 2005-01-31 2002-05-17 Kim Yang Il KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5337 5337 2005-01-31 2002-11-18 Jeon Sang Woo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5338 5338 2005-01-31 2002-11-18 Kim Hyun-Duk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5339 5339 2005-01-31 2002-11-18 Kim Kwanghee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5340 5340 2005-01-31 2000-12-06 Kang Shin-Taeg KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5353 5353 2006-01-31 2003-05-16 Min Kyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5354 5354 2006-01-31 2002-05-17 Kwon Oh Hyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5376 5376 2007-01-31 2003-05-16 Jang Jin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5382 5382 2007-01-31 2004-07-08 Park Bum Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5406 5406 2008-01-31 2004-07-08 Kim Jeong Dong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5430 5430 2010-01-31 2007-05-29 Chung Jongtae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5431 5431 2010-01-31 2007-05-29 Kim Sang Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5447 5447 2011-01-31 2007-05-29 Hur Jin Hak KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5471 5471 2013-01-31 2009-05-28 Lim Jaegeol KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5485 5485 2014-01-31 2011-05-25 Kwon Kyoungmoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5486 5486 2014-01-31 2011-05-25 Lee Seunghee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5490 5490 2014-01-31 2011-11-28 Um Sungpil KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5520 5520 2018-01-31 2014-05-28 Ryu Seokchun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5529 5529 2018-01-31 2014-11-25 Kim Pil Seong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5530 5530 2018-01-31 2015-11-30 Lee Jonggun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5573 5573 2020-01-31 2017-05-26 Bin Joonhwa KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5574 5574 2020-01-31 2017-05-26 Kim Minsun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5575 5575 2020-01-31 2016-05-27 Lee Hyoung Seok KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5576 5576 2020-01-31 2016-05-27 So Ra KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5585 5585 2020-01-31 2018-11-30 Jung Oi Young KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5591 5591 2021-01-31 2017-05-26 Koh Young Jun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5592 5592 2021-01-31 2017-05-26 Lee Mingee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5606 5606 2021-01-31 2017-11-21 Kim Hansoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5607 5607 2021-01-31 2017-11-21 Kim Sangwoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5608 5608 2021-01-31 2018-11-30 Han Sukwoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5850 5850 2008-02-01 2005-05-10 Ahn Bok Nyu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5853 5853 2008-02-01 2006-11-27 Kim Min Jo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5867 5867 2011-02-01 2008-12-01 Kim Kijoong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5885 5885 2016-02-01 2013-05-28 Kang Young Soo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5886 5886 2016-02-01 2012-05-29 Hong Yongtaek KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5894 5894 2017-02-01 2014-05-28 Jung Young Hwa KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5994 5994 2012-02-02 2008-12-01 Kim Sung Jae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
6081 6081 2012-02-03 2009-11-30 Choi Kwang Soo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
6270 6270 2023-02-06 2020-05-29 Lee Hyeryong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
7741 7741 2011-02-26 2008-12-01 Lee Dooyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
7810 7810 2012-02-27 2008-12-01 Yang Ki Mo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
8101 8101 1999-02-28 1996-05-20 Kim Tae Hyeong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
8287 8287 2015-02-28 2011-05-25 Lee Sung Gi KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
8395 8395 2020-02-28 2018-05-25 Kim Jinjoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9734 9734 1999-03-12 1998-02-20 Kang Dae Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9739 9739 2002-03-12 1999-05-21 Park Poong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
9912 9912 1972-03-15 1971-05-26 Park Moon Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10576 10576 1973-03-23 1970-02-16 Lim Chonghoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10976 10976 2003-03-28 2000-05-25 Ko Kyu-Suk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10977 10977 2003-03-28 2000-05-25 Kwon Joong Hun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11109 11109 1966-03-30 1964-06-16 Johong Joondu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11117 11117 1973-03-30 1972-08-15 Park Suk Yung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11188 11188 2003-03-30 2000-05-25 Huh Byung Hee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11189 11189 2003-03-30 2000-05-25 Kim Kwan Mook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11486 11486 1979-03-31 1976-06-01 Ahn Jae-Kuen KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11487 11487 1979-03-31 1976-06-01 Hong Seung Man KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11488 11488 1979-03-31 1976-06-01 Koo Duk Mo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11682 11682 1992-03-31 1990-10-18 Yoon Heui-Ro KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11766 11766 1997-03-31 1995-04-26 Hwang Gyu Joon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11799 11799 1999-03-31 1998-02-20 Gahng Young J. KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11831 11831 2000-03-31 1998-02-20 Ha Seung Beom KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11845 11845 2000-03-31 1997-11-18 Choe Ki Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11846 11846 2000-03-31 1997-11-18 Kim Tae Chil KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11847 11847 2000-03-31 1997-11-18 Son Pyung Il KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11866 11866 2001-03-31 1998-05-15 Lee Jung Min KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11867 11867 2001-03-31 1998-05-15 Park Kwon Tae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11878 11878 2001-03-31 2000-12-06 Kwon Soon-Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11923 11923 2004-03-31 2001-05-17 Ahn Sang Keun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11925 11925 2004-03-31 2004-07-08 Ahn Bok Nyu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11975 11975 2006-03-31 2002-05-17 Im Sung Joo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13602 13602 1969-04-17 1968-03-14 Lee Hae Young KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13606 13606 1969-04-17 1967-10-11 Chun Jin Hwan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13607 13607 1969-04-17 1967-10-11 Yoon Byung Jae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14144 14144 1995-04-26 1992-05-29 Choi Yong Tai KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14304 14304 2012-04-28 2009-11-30 Lee Kiseok KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14447 14447 1965-04-30 1964-06-16 Chang Yong Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14473 14473 1970-04-30 1970-02-16 Kim Eden KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14873 14873 2002-04-30 1999-05-21 Hong Dae-Eui KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14881 14881 2002-04-30 1999-11-16 Kim Jae Han KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15547 15547 2022-05-01 2018-05-25 Kwon Oh Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15548 15548 2022-05-01 2017-05-26 Choi Jinsung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15549 15549 2022-05-01 2021-05-28 Ryou Sungwon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15550 15550 2022-05-01 2019-05-30 Park Jiung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15551 15551 2022-05-01 2022-05-31 Kim Taeryong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15553 15553 2022-05-01 2017-11-21 Kim Seong Su KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15554 15554 2022-05-01 2017-11-21 Lee Ji Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15555 15555 2022-05-01 2017-11-21 Lee Joon Kyu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15556 15556 2022-05-01 2017-11-21 Lee Yongjin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15557 15557 2022-05-01 2017-11-21 Mun Jae Sung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15558 15558 2022-05-01 2017-11-21 Park Chang Ki KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15559 15559 2022-05-01 2017-11-21 Shin Seung-hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15560 15560 2022-05-01 2019-11-27 Kim Hyung Seok KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15561 15561 2022-05-01 2019-11-27 Youn Taewoong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15562 15562 2022-05-01 2016-11-30 Kim Kunki KOTRA 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])
);