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

319 rows where Registration_Number = 1619

✎ 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

  • 1619 · 319 ✖

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
982 982   2018-05-25 Kim Jinjoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
983 983   2018-05-25 Koo Hyunmo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
984 984   2018-05-25 Kwon Oh Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
985 985   2017-05-26 Bin Joonhwa 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
986 986   2017-05-26 Choi Jinsung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
987 987   2017-05-26 Kim Minsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
988 988   2017-05-26 Koh Young Jun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
989 989   2017-05-26 Lee Mingee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
992 992   2016-05-27 Kim Jiyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
993 993   2016-05-27 Lee Hyoung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
994 994   2016-05-27 So Ra 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
995 995   2016-05-27 Sohn Soo Deuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1037 1037   2020-05-29 Jung Sewon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1038 1038   2020-05-29 Kang Taek Woo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1039 1039   2020-05-29 Kim Seung Wook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1040 1040   2020-05-29 Lee Hyeryong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1041 1041   2020-05-29 Lee Nuri 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1042 1042   2020-05-29 Park Yong Min 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1050 1050   2019-05-30 Park Donguk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1051 1051   2019-05-30 Park Jiung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1052 1052   2019-05-30 Sung Kijoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2129 2129   2017-11-21 Kim Hansoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2130 2130   2017-11-21 Kim Sangwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2131 2131   2017-11-21 Kim Seong Su 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2132 2132   2017-11-21 Lee Ji Hyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2133 2133   2017-11-21 Lee Joon Kyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2134 2134   2017-11-21 Lee Yongjin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2135 2135   2017-11-21 Mun Jae Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2136 2136   2017-11-21 Ohcheol Kwonm 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2137 2137   2017-11-21 Park Chang Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2138 2138   2017-11-21 Shin Seung-hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2153 2153   2014-11-25 Kim Pil Seong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2154 2154   2014-11-25 Kim Sooyeon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2181 2181   2019-11-27 Jin Junhyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2182 2182   2019-11-27 Kim Hyung Seok 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2183 2183   2019-11-27 Youn Taewoong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2215 2215   2016-11-30 Kim Kunki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2217 2217   2016-11-30 Park Hyungdon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2218 2218   2016-11-30 Park Taewha 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2222 2222   2018-11-30 Cho Dong-Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2223 2223   2018-11-30 Choi Bosung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2224 2224   2018-11-30 Han Sukwoo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2226 2226   2018-11-30 Jung Oi Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2228 2228   2018-11-30 Kim Junho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2230 2230   2018-11-30 Kwon Sunyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2231 2231   2018-11-30 Lee Young Ki 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2234 2234   2018-11-30 Yoem Ki Hyuk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3487 3487 2007-01-12 2006-11-27 Hwang Min Ha 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3567 3567 2006-01-14 2002-11-18 Kim Yoon Tae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3920 3920 2010-01-19 2006-05-09 Choi Hyun Soo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3921 3921 2011-01-19 2008-05-28 Jung Won Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4035 4035 2016-01-21 2012-11-28 Lee Sujung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4123 4123 2008-01-23 2004-07-08 Noh Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4124 4124 2010-01-23 2008-05-28 Choe Kihyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4125 4125 2013-01-23 2010-06-01 Oh Jae Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4161 4161 2008-01-24 2004-11-12 Lim Chae Keun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4292 4292 2007-01-25 2005-05-10 Oh Sung Keun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4293 4293 2007-01-25 2003-05-16 Hong Doo Yung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4294 4294 2007-01-25 2003-05-16 Lee Jung Hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4296 4296 2008-01-25 2004-07-08 Son Ho Gil 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4298 4298 2012-01-25 2008-05-28 Uh Jaesun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4299 4299 2013-01-25 2009-05-28 Bae Sangbum 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4383 4383 2012-01-26 2008-05-28 Kim Jun Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4384 4384 2015-01-26 2012-05-29 Park Jun Gwe 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4385 4385 2016-01-26 2012-05-29 Kim Ho Joon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4386 4386 2017-01-26 2014-11-25 Lee Jihoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4387 4387 2017-01-26 2013-11-27 Moon Jin Wook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4432 4432 2007-01-27 2003-11-17 Kwak Dong Woon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4434 4434 2010-01-27 2006-05-09 Lee In Kyu 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4449 4449 2013-01-27 2010-06-01 Chang Sunyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4450 4450 2018-01-27 2014-05-28 Kim Youngsang 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4499 4499 2011-01-28 2007-05-29 Ahn Jaeyong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4504 4504 2014-01-28 2010-06-01 Kwon Oh Sung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4505 4505 2017-01-28 2014-11-25 Kim Byung Ho 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4506 4506 2018-01-28 2015-11-30 Kang Junkyung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4508 4508 2019-01-28 2015-05-28 Yoo Jeawook 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4548 4548 2008-01-29 2004-11-12 Kim Doo Young 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4549 4549 2009-01-29 2004-11-12 Lee Hong Kyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4553 4553 2011-01-29 2008-05-28 Park Sang Hyup 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4639 4639 2014-01-30 2011-05-25 Kang Sang Yeob 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4644 4644 2017-01-30 2013-05-28 Han Taesik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4646 4646 2017-01-30 2014-05-28 Ahn Young Ju 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5095 5095 2004-01-31 2000-12-06 Kim Jong-Weon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5096 5096 2004-01-31 2000-12-06 Kim Kyung-Yool 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5097 5097 2004-01-31 2000-12-06 Lee Kwang Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5098 5098 2004-01-31 2000-12-06 Lee Kyu-Seon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5099 5099 2004-01-31 2000-12-06 Yeon Young-Chul 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5109 5109 2005-01-31 2001-05-17 Hwang Eui Shun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5110 5110 2005-01-31 2002-05-17 Kim Yang Il 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5114 5114 2005-01-31 2002-11-18 Jeon Sang Woo 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5115 5115 2005-01-31 2002-11-18 Kim Hyun-Duk 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5116 5116 2005-01-31 2002-11-18 Kim Kwanghee 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5117 5117 2005-01-31 2000-12-06 Kang Shin-Taeg 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5130 5130 2006-01-31 2003-05-16 Min Kyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5131 5131 2006-01-31 2002-05-17 Kwon Oh Hyoung 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5153 5153 2007-01-31 2003-05-16 Jang Jin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5159 5159 2007-01-31 2004-07-08 Park Bum Hoon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5183 5183 2008-01-31 2004-07-08 Kim Jeong Dong 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5207 5207 2010-01-31 2007-05-29 Chung Jongtae 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
5208 5208 2010-01-31 2007-05-29 Kim Sang Chul 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 706.845ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history