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

✖
✖

✎ 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
1103 1103   2018-05-25 Koo Hyunmo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1130 1130   2021-05-28 Choung Dongha KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1134 1134   2021-05-28 Kho Dong Hyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1135 1135   2021-05-28 Kim Jooyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1136 1136   2021-05-28 Kim Wookjin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1138 1138   2021-05-28 Lee Donghoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1139 1139   2021-05-28 NA Joungyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1145 1145   2020-05-29 Jung Sewon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1151 1151   2019-05-30 Park Donguk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1152 1152   2019-05-30 Sung Kijoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1154 1154   2023-05-30 Baek Sungwoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1157 1157   2023-05-30 Kyung Kiwoo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1158 1158   2023-05-30 Park Jongpyo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1159 1159   2023-05-30 Park Keunhyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1160 1160   2023-05-30 Park Wooksang KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1161 1161   2023-05-30 Sungwoo BAEK KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1166 1166   2022-05-31 Chang Jae Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1169 1169   2022-05-31 Jeong Hui-ung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1170 1170   2022-05-31 Kim Dong Jun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1171 1171   2022-05-31 Kim Hyunbeom KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1172 1172   2022-05-31 Kim Mi-suk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
1173 1173   2022-05-31 Shin Jeongsu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2239 2239   2019-11-27 Jin Junhyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2270 2270   2021-11-29 Jang Hyosun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2271 2271   2021-11-29 Jung Yeonjin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2272 2272   2021-11-29 Kim Hyoung il KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2273 2273   2021-11-29 Kim Jonghyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2277 2277   2021-11-29 Min Keunggi KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2278 2278   2021-11-29 Park Sungho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2279 2279   2021-11-29 Shim Solina KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2280 2280   2021-11-29 Shin Yongho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2281 2281   2021-11-29 Sohn Hosung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2291 2291   2018-11-30 Choi Bosung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2296 2296   2020-11-30 Jang Choong Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2297 2297   2020-11-30 Kim Chulmin KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2298 2298   2020-11-30 Lee Seok Hwan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2299 2299   2020-11-30 Lee Yungsun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2301 2301   2020-11-30 Seo Jiwon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2313 2313   2022-11-30 Chang Seog II KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2314 2314   2022-11-30 Kim Hoiseung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
2315 2315   2022-11-30 Lee Joonsub KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3631 3631 2007-01-12 2006-11-27 Hwang Min Ha KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
3714 3714 2006-01-14 2002-11-18 Kim Yoon Tae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4113 4113 2010-01-19 2006-05-09 Choi Hyun Soo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4114 4114 2011-01-19 2008-05-28 Jung Won Joon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4234 4234 2016-01-21 2012-11-28 Lee Sujung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4325 4325 2008-01-23 2004-07-08 Noh Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4326 4326 2010-01-23 2008-05-28 Choe Kihyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4327 4327 2013-01-23 2010-06-01 Oh Jae Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4363 4363 2008-01-24 2004-11-12 Lim Chae Keun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4497 4497 2007-01-25 2005-05-10 Oh Sung Keun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4498 4498 2007-01-25 2003-05-16 Hong Doo Yung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4499 4499 2007-01-25 2003-05-16 Lee Jung Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4501 4501 2008-01-25 2004-07-08 Son Ho Gil KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4503 4503 2012-01-25 2008-05-28 Uh Jaesun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4504 4504 2013-01-25 2009-05-28 Bae Sangbum KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4588 4588 2012-01-26 2008-05-28 Kim Jun Sung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4589 4589 2015-01-26 2012-05-29 Park Jun Gwe KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4590 4590 2016-01-26 2012-05-29 Kim Ho Joon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4591 4591 2017-01-26 2014-11-25 Lee Jihoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4592 4592 2017-01-26 2013-11-27 Moon Jin Wook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4599 4599 2023-01-26 2020-05-29 Kim Seung Wook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4600 4600 2023-01-26 2020-05-29 Lee Nuri KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4601 4601 2023-01-26 2023-05-30 Kim Seowon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4644 4644 2007-01-27 2003-11-17 Kwak Dong Woon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4646 4646 2010-01-27 2006-05-09 Lee In Kyu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4661 4661 2013-01-27 2010-06-01 Chang Sunyoung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4662 4662 2018-01-27 2014-05-28 Kim Youngsang KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4664 4664 2023-01-27 2020-05-29 Kang Taek Woo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4665 4665 2023-01-27 2020-05-29 Park Yong Min KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4716 4716 2011-01-28 2007-05-29 Ahn Jaeyong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4721 4721 2014-01-28 2010-06-01 Kwon Oh Sung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4722 4722 2017-01-28 2014-11-25 Kim Byung Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4723 4723 2018-01-28 2015-11-30 Kang Junkyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4725 4725 2019-01-28 2015-05-28 Yoo Jeawook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4767 4767 2008-01-29 2004-11-12 Kim Doo Young KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4768 4768 2009-01-29 2004-11-12 Lee Hong Kyun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4772 4772 2011-01-29 2008-05-28 Park Sang Hyup KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4861 4861 2014-01-30 2011-05-25 Kang Sang Yeob KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4866 4866 2017-01-30 2013-05-28 Han Taesik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
4868 4868 2017-01-30 2014-05-28 Ahn Young Ju KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
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

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 498.888ms · 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