home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

358 rows where Registration_Number = 1619 sorted by rowid descending

✖
✖

✎ 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 1

  • NY 358

Registration_Number 1

  • KOTRA · 358 ✖

Registrant_Name 1

  • KOTRA 358

City 1

  • New York 358
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
41263 41263 2002-12-31 2001-05-17 Lee Sun-In KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
41078 41078 1998-12-31 1998-02-20 Cho Hong Yun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
40022 40022 1976-12-31 1973-12-27 Kim Oh Sung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
39231 39231 2010-12-27 2009-05-28 Lee KunBok KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
39025 39025 2005-12-23 2003-05-16 Kim Jae Hyo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
39024 39024 2002-12-23 2002-05-17 Kwon Oh Nam KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
38355 38355 1967-12-15 1968-03-14 Lee Sang Won KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
37071 37071 2015-11-30 2012-11-28 Jeon Misung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36873 36873 1999-11-30 1999-05-21 Yoon Jae-Chun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36867 36867 1998-11-30 1995-10-23 Kim Sung Jo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36860 36860 1997-11-30 1996-11-18 Chung Kui-Iae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36623 36623 1972-11-30 1972-08-15 Park Woojin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36596 36596 1964-11-30 1963-04-17 Kim Kwan-min KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36571 36571 2015-11-29 2012-11-28 Cho Youngsoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
36495 36495 2015-11-27 2011-11-28 Choi Inyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
35995 35995 1992-11-17 1992-05-29 Cho Tai Hyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
34371 34371 1995-10-31 1992-11-17 Hur Gil Joo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
34026 34026 1971-10-30 1970-06-29 Kim Dong Hun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
33208 33208 1994-10-19 1991-12-06 Kim Yong Jip KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
33207 33207 1994-10-19 1991-12-06 Choi Dong Suk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
33050 33050 1969-10-17 1968-03-14 Lee Doo Hwan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
33049 33049 1969-10-17 1968-03-14 Cho Kyung Don KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
32718 32718 1964-10-13 1964-06-16 Kim Hee Kon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31338 31338 2004-09-30 2001-12-03 Bok Dukkyoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31306 31306 2002-09-30 2000-12-06 Seo Jong-Seog KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31264 31264 2001-09-30 1999-05-21 Lee Tai Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31263 31263 2001-09-30 1999-05-21 Ahn Bok-Nyu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31260 31260 2000-09-30 1997-11-18 Kim Mahn Deug KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31250 31250 2000-09-30 1998-05-15 Lee Jong Tae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31247 31247 2000-09-30 1998-02-20 Kim Hyun Duk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31219 31219 1999-09-30 1998-05-15 Ham Jun-Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31209 31209 1999-09-30 1998-02-20 Lee Min Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31208 31208 1999-09-30 1998-02-20 Ham Jeong Oh KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31190 31190 1998-09-30 1998-02-20 Choi Kwang-Soo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31180 31180 1997-09-30 1994-10-17 Lee Kang Man KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31153 31153 1996-09-30 1995-10-23 Kim Bong Han KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31135 31135 1995-09-30 1992-11-17 Lee Sung Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31134 31134 1995-09-30 1994-10-17 Oh Su Cheol KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31080 31080 1991-09-30 1990-10-18 Jeon Sang Woo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30908 30908 1973-09-30 1972-08-15 Lee Doo Hwan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30907 30907 1973-09-30 1971-02-14 Ko Suk Won KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30897 30897 1971-09-30 1970-02-16 Shin Ho Nung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30607 30607 1991-09-27 1990-10-18 Lee Joun-Shik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
30548 30548 2008-09-26 2005-12-01 Um Sung Pil KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29901 29901 2008-09-15 2005-12-01 Yang Kook Bo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
28973 28973 2012-09-01 2009-11-30 Shin Seung Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
28578 28578 2011-08-31 2008-12-01 Kim Seungho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27999 27999 1977-08-31 1976-11-29 Lee Joun Shik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27913 27913 1975-08-31 1972-08-15 Yoon Jong Rak KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27912 27912 1975-08-31 1972-08-15 Kim Mahn Il KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27908 27908 1973-08-31 1972-08-15 Gahng Dae Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27800 27800 2003-08-30 2000-12-06 Kim Jaesung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27620 27620 2018-08-28 2015-11-30 Kim Myongsoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27619 27619 2015-08-28 2012-11-28 Park Dong Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27614 27614 2015-08-28 2014-05-28 Lee Tai Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27612 27612 2012-08-28 2008-12-01 Yeon Sungwhan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27611 27611 2011-08-28 2009-11-30 Kim Young-Woong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27610 27610 2011-08-28 2009-11-30 Kim Young-Chun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27499 27499 2011-08-26 2008-12-01 Han Jongbaik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27496 27496 2008-08-26 2007-05-29 Kim Joo Nam KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27440 27440 2006-08-25 2006-05-09 Woo Jae Ryang KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26403 26403 2018-08-10 2016-05-27 Won Yu Jung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
26391 26391 1995-08-10 1994-10-17 Lee Chang Ryul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25746 25746 2017-08-01 2013-05-28 Ahn Joongik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25731 25731 2015-08-01 2011-11-28 Kim Jung Hyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25667 25667 2012-08-01 2009-11-30 Oh Hyeokjong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25664 25664 2009-08-01 2005-12-01 Kim Ho Joon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25509 25509 1979-08-01 1973-12-27 Youn Suk Mahn KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25367 25367 2019-07-31 2016-11-30 Park Taewha KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25354 25354 2019-07-31 2016-05-27 Kim Jiyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25341 25341 2018-07-31 2016-11-30 Ahn Yooseok KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25340 25340 2018-07-31 2015-11-30 Yu Byoungwoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25339 25339 2018-07-31 2015-11-30 Kwon Ohsuk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25338 25338 2018-07-31 2014-11-25 Kim Sooyeon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25337 25337 2018-07-31 2014-11-25 Kim Hanseung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25336 25336 2018-07-31 2014-11-25 Cha Sungwook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25320 25320 2018-07-31 2016-05-27 Chae Hee Kwang KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25309 25309 2017-07-31 2014-11-25 Na Changyup KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25293 25293 2016-07-31 2014-11-25 Hwang Pilgoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25285 25285 2016-07-31 2012-05-29 Choi Myunglae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25253 25253 2014-07-31 2012-11-28 Choi Byunghun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25252 25252 2014-07-31 2011-11-28 Kim Ki Joon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25251 25251 2014-07-31 2011-11-28 Jeon Sanghyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25221 25221 2014-07-31 2011-05-25 Lee Sung Hun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25198 25198 2013-07-31 2012-11-28 Kim Jijin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25174 25174 2011-07-31 2008-05-28 Chung Eun Joo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25165 25165 2009-07-31 2008-12-01 Kim Jae Sung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25153 25153 2009-07-31 2005-05-10 Kim Myung Koo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25118 25118 2007-07-31 2003-11-17 Kim Doo Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25117 25117 2007-07-31 2003-11-17 Cho Ki Chang KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25099 25099 2007-07-31 2005-05-10 Kim Se Jin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25092 25092 2006-07-31 2002-11-18 Woo Ki Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25091 25091 2006-07-31 2003-11-17 Kim Sam Soo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25090 25090 2006-07-31 2004-11-12 Hong Seong-Woo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25086 25086 2006-07-31 2003-05-16 Chung Ho Won KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25080 25080 2005-07-31 2001-12-03 Park Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25079 25079 2005-07-31 2001-12-03 Lee Jang Hee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25078 25078 2005-07-31 2001-12-03 Kim Seung-Wook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25077 25077 2005-07-31 2001-12-03 Kim Rak Gon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25076 25076 2005-07-31 2001-12-03 Hahn Jung Hee 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])
);
Powered by Datasette · Queries took 627.267ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows