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 City = "New York" and Registrant_Name = "KOTRA" sorted by Short_Form_Date

✖
✖
✖

✎ 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
20746 20746 1964-06-30 1963-04-17 Park Hojoon 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
11109 11109 1966-03-30 1964-06-16 Johong Joondu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14447 14447 1965-04-30 1964-06-16 Chang Yong Ho 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
13606 13606 1969-04-17 1967-10-11 Chun Jin Hwan KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13607 13607 1969-04-17 1967-10-11 Yoon Byung Jae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13602 13602 1969-04-17 1968-03-14 Lee Hae Young KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
24663 24663 1970-07-31 1968-03-14 Yie Yul 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
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
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
10576 10576 1973-03-23 1970-02-16 Lim Chonghoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14473 14473 1970-04-30 1970-02-16 Kim Eden 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
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
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
9912 9912 1972-03-15 1971-05-26 Park Moon Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20843 20843 1972-06-30 1972-01-18 Belasco Claire E. KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11117 11117 1973-03-30 1972-08-15 Park Suk Yung 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
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
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
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
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
20908 20908 1976-06-30 1973-06-12 Lee Tong Kyoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
20909 20909 1976-06-30 1973-06-12 Oh Chang Suk 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
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
21138 21138 1990-06-30 1974-06-06 Cho Sung Ho KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11486 11486 1979-03-31 1976-06-01 Ahn Jae-Kuen KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11487 11487 1979-03-31 1976-06-01 Hong Seung Man KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11488 11488 1979-03-31 1976-06-01 Koo Duk Mo 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
17670 17670 1983-05-31 1979-01-16 Johong Joondu KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17130 17130 1984-05-26 1984-03-16 Lee Byung Chong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17696 17696 1986-05-31 1985-02-06 Hong Jungpyo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11682 11682 1992-03-31 1990-10-18 Yoon Heui-Ro 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
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
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
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
14144 14144 1995-04-26 1992-05-29 Choi Yong Tai 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
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
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
21282 21282 1997-06-30 1994-10-17 Kim Hyun Tae KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
21283 21283 1997-06-30 1994-10-17 Park Dong Hyung 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
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
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
11766 11766 1997-03-31 1995-04-26 Hwang Gyu Joon 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
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
8101 8101 1999-02-28 1996-05-20 Kim Tae Hyeong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
21344 21344 1999-06-30 1996-11-18 Koo Ja Yoon 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
11845 11845 2000-03-31 1997-11-18 Choe Ki Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11846 11846 2000-03-31 1997-11-18 Kim Tae Chil KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11847 11847 2000-03-31 1997-11-18 Son Pyung Il 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
9734 9734 1999-03-12 1998-02-20 Kang Dae Chul KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11799 11799 1999-03-31 1998-02-20 Gahng Young J. KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11831 11831 2000-03-31 1998-02-20 Ha Seung Beom KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17940 17940 2001-05-31 1998-02-20 Park Sung 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
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
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
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
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
11866 11866 2001-03-31 1998-05-15 Lee Jung Min KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11867 11867 2001-03-31 1998-05-15 Park Kwon Tae 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
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
9739 9739 2002-03-12 1999-05-21 Park Poong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14873 14873 2002-04-30 1999-05-21 Hong Dae-Eui KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
21357 21357 2000-06-30 1999-05-21 Chung Won-Seo KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
21436 21436 2002-06-30 1999-05-21 Huh Jin 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
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
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
14881 14881 2002-04-30 1999-11-16 Kim Jae Han KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10976 10976 2003-03-28 2000-05-25 Ko Kyu-Suk KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10977 10977 2003-03-28 2000-05-25 Kwon Joong Hun KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11188 11188 2003-03-30 2000-05-25 Huh Byung Hee KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
11189 11189 2003-03-30 2000-05-25 Kim Kwan Mook KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25026 25026 2003-07-31 2000-05-25 Kim Hyeon Cheol 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
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
11878 11878 2001-03-31 2000-12-06 Kwon Soon-Hyung KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
21453 21453 2002-06-30 2000-12-06 Park Doo Seong KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25039 25039 2003-07-31 2000-12-06 Kim Chang-Sik KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25040 25040 2003-07-31 2000-12-06 Lee Jong-Yoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25041 25041 2003-07-31 2000-12-06 Lee Jungsoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
25054 25054 2004-07-31 2000-12-06 Choi Yun Gyu 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

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