FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
53 rows where Registration_Number = 1619 and Short_Form_Last_Name = "Lee"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1138 | 1138 | 2021-05-28 | Lee | Donghoon | 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 | |
2315 | 2315 | 2022-11-30 | Lee | Joonsub | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
5486 | 5486 | 2014-01-31 | 2011-05-25 | Lee | Seunghee | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
5530 | 5530 | 2018-01-31 | 2015-11-30 | Lee | Jonggun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
5575 | 5575 | 2020-01-31 | 2016-05-27 | Lee | Hyoung Seok | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
5592 | 5592 | 2021-01-31 | 2017-05-26 | Lee | Mingee | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
6270 | 6270 | 2023-02-06 | 2020-05-29 | Lee | Hyeryong | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
7741 | 7741 | 2011-02-26 | 2008-12-01 | Lee | Dooyoung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
8287 | 8287 | 2015-02-28 | 2011-05-25 | Lee | Sung Gi | 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 |
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 |
14304 | 14304 | 2012-04-28 | 2009-11-30 | Lee | Kiseok | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
15554 | 15554 | 2022-05-01 | 2017-11-21 | Lee | Ji Hyung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
15555 | 15555 | 2022-05-01 | 2017-11-21 | Lee | Joon Kyu | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
15556 | 15556 | 2022-05-01 | 2017-11-21 | Lee | Yongjin | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
15567 | 15567 | 2022-05-01 | 2018-11-30 | Lee | Young Ki | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
15762 | 15762 | 2005-05-05 | 2004-07-08 | Lee | Jong Ho | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
16035 | 16035 | 2013-05-10 | 2011-05-31 | Lee | Hee Sang | 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 |
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 |
22797 | 22797 | 2015-07-08 | 2011-11-28 | Lee | Sungnyung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
24036 | 24036 | 2009-07-25 | 2005-12-01 | Lee | Jeong Seon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
24228 | 24228 | 2009-07-27 | 2005-12-01 | Lee | Yang IL | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
24230 | 24230 | 2010-07-27 | 2006-11-27 | Lee | Seung Ki | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
24387 | 24387 | 2008-07-29 | 2004-11-12 | Lee | Ji Hyung | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]) );