FARA_All_ShortForms
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"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );