FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

313 rows where Registration_Number = 1619

View and edit SQL

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

State

Registration_Number

  • 1619 · 313

Registrant_Name

City

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
911   2018-05-25 Kim Jinjoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
912   2018-05-25 Koo Hyunmo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
913   2018-05-25 Kwon Oh Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
914   2017-05-26 Bin Joonhwa 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
915   2017-05-26 Choi Jinsung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
916   2017-05-26 Kim Minsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
917   2017-05-26 Koh Young Jun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
918   2017-05-26 Lee Mingee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
920   2016-05-27 Kim Jiyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
921   2016-05-27 Lee Hyoung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
922   2016-05-27 So Ra 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
923   2016-05-27 Sohn Soo Deuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
952   2019-05-30 Park Donguk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
953   2019-05-30 Park Jiung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
954   2019-05-30 Sung Kijoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2033   2017-11-21 Kim Hansoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2034   2017-11-21 Kim Sangwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2035   2017-11-21 Kim Seong Su 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2036   2017-11-21 Lee Ji Hyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2037   2017-11-21 Lee Joon Kyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2038   2017-11-21 Lee Yongjin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2039   2017-11-21 Mun Jae Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2040   2017-11-21 Ohcheol Kwonm 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2041   2017-11-21 Park Chang Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2042   2017-11-21 Shin Seung-hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2059   2014-11-25 Kim Pil Seong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2060   2014-11-25 Kim Sooyeon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2092   2019-11-27 Jin Junhyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2093   2019-11-27 Kim Hyung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2094   2019-11-27 Youn Taewoong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2129   2016-11-30 Kim Kunki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2131   2016-11-30 Park Hyungdon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2132   2016-11-30 Park Taewha 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2138   2018-11-30 Cho Dong-Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2139   2018-11-30 Choi Bosung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2140   2018-11-30 Han Sukwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2142   2018-11-30 Jung Oi Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2144   2018-11-30 Kim Junho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2146   2018-11-30 Kwon Sunyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2147   2018-11-30 Lee Young Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2150   2018-11-30 Yoem Ki Hyuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3423 2007-01-12 2006-11-27 Hwang Min Ha 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3503 2006-01-14 2002-11-18 Kim Yoon Tae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3853 2010-01-19 2006-05-09 Choi Hyun Soo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3854 2011-01-19 2008-05-28 Jung Won Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3968 2016-01-21 2012-11-28 Lee Sujung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4055 2008-01-23 2004-07-08 Noh Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4056 2010-01-23 2008-05-28 Choe Kihyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4057 2013-01-23 2010-06-01 Oh Jae Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4093 2008-01-24 2004-11-12 Lim Chae Keun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4223 2007-01-25 2005-05-10 Oh Sung Keun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4224 2007-01-25 2003-05-16 Hong Doo Yung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4225 2007-01-25 2003-05-16 Lee Jung Hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4227 2008-01-25 2004-07-08 Son Ho Gil 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4229 2012-01-25 2008-05-28 Uh Jaesun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4230 2013-01-25 2009-05-28 Bae Sangbum 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4314 2012-01-26 2008-05-28 Kim Jun Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4315 2015-01-26 2012-05-29 Park Jun Gwe 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4316 2016-01-26 2012-05-29 Kim Ho Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4317 2017-01-26 2014-11-25 Lee Jihoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4318 2017-01-26 2013-11-27 Moon Jin Wook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4362 2007-01-27 2003-11-17 Kwak Dong Woon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4364 2010-01-27 2006-05-09 Lee In Kyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4379 2013-01-27 2010-06-01 Chang Sunyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4380 2018-01-27 2014-05-28 Kim Youngsang 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4429 2011-01-28 2007-05-29 Ahn Jaeyong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4434 2014-01-28 2010-06-01 Kwon Oh Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4435 2017-01-28 2014-11-25 Kim Byung Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4436 2018-01-28 2015-11-30 Kang Junkyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4437 2019-01-28 2015-05-28 Yoo Jeawook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4477 2008-01-29 2004-11-12 Kim Doo Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4478 2009-01-29 2004-11-12 Lee Hong Kyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4482 2011-01-29 2008-05-28 Park Sang Hyup 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4568 2014-01-30 2011-05-25 Kang Sang Yeob 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4573 2017-01-30 2013-05-28 Han Taesik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4575 2017-01-30 2014-05-28 Ahn Young Ju 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5020 2004-01-31 2000-12-06 Kim Jong-Weon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5021 2004-01-31 2000-12-06 Kim Kyung-Yool 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5022 2004-01-31 2000-12-06 Lee Kwang Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5023 2004-01-31 2000-12-06 Lee Kyu-Seon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5024 2004-01-31 2000-12-06 Yeon Young-Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5034 2005-01-31 2001-05-17 Hwang Eui Shun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5035 2005-01-31 2002-05-17 Kim Yang Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5039 2005-01-31 2002-11-18 Jeon Sang Woo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5040 2005-01-31 2002-11-18 Kim Hyun-Duk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5041 2005-01-31 2002-11-18 Kim Kwanghee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5042 2005-01-31 2000-12-06 Kang Shin-Taeg 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5055 2006-01-31 2003-05-16 Min Kyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5056 2006-01-31 2002-05-17 Kwon Oh Hyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5078 2007-01-31 2003-05-16 Jang Jin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5084 2007-01-31 2004-07-08 Park Bum Hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5108 2008-01-31 2004-07-08 Kim Jeong Dong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5132 2010-01-31 2007-05-29 Chung Jongtae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5133 2010-01-31 2007-05-29 Kim Sang Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5149 2011-01-31 2007-05-29 Hur Jin Hak 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5173 2013-01-31 2009-05-28 Lim Jaegeol 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5187 2014-01-31 2011-05-25 Kwon Kyoungmoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5188 2014-01-31 2011-05-25 Lee Seunghee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5192 2014-01-31 2011-11-28 Um Sungpil 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5222 2018-01-31 2014-05-28 Ryu Seokchun 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)
);
Powered by Datasette · Query took 383.265ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history