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

This data as json, atom, CSV (advanced)

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 911   2018-05-25 Kim Jinjoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
912 912   2018-05-25 Koo Hyunmo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
913 913   2018-05-25 Kwon Oh Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
914 914   2017-05-26 Bin Joonhwa 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
915 915   2017-05-26 Choi Jinsung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
916 916   2017-05-26 Kim Minsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
917 917   2017-05-26 Koh Young Jun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
918 918   2017-05-26 Lee Mingee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
920 920   2016-05-27 Kim Jiyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
921 921   2016-05-27 Lee Hyoung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
922 922   2016-05-27 So Ra 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
923 923   2016-05-27 Sohn Soo Deuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
952 952   2019-05-30 Park Donguk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
953 953   2019-05-30 Park Jiung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
954 954   2019-05-30 Sung Kijoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2033 2033   2017-11-21 Kim Hansoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2034 2034   2017-11-21 Kim Sangwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2035 2035   2017-11-21 Kim Seong Su 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2036 2036   2017-11-21 Lee Ji Hyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2037 2037   2017-11-21 Lee Joon Kyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2038 2038   2017-11-21 Lee Yongjin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2039 2039   2017-11-21 Mun Jae Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2040 2040   2017-11-21 Ohcheol Kwonm 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2041 2041   2017-11-21 Park Chang Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2042 2042   2017-11-21 Shin Seung-hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2059 2059   2014-11-25 Kim Pil Seong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2060 2060   2014-11-25 Kim Sooyeon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2092 2092   2019-11-27 Jin Junhyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2093 2093   2019-11-27 Kim Hyung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2094 2094   2019-11-27 Youn Taewoong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2129 2129   2016-11-30 Kim Kunki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2131 2131   2016-11-30 Park Hyungdon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2132 2132   2016-11-30 Park Taewha 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2138 2138   2018-11-30 Cho Dong-Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2139 2139   2018-11-30 Choi Bosung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2140 2140   2018-11-30 Han Sukwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2142 2142   2018-11-30 Jung Oi Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2144 2144   2018-11-30 Kim Junho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2146 2146   2018-11-30 Kwon Sunyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2147 2147   2018-11-30 Lee Young Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2150 2150   2018-11-30 Yoem Ki Hyuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3423 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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