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

43 rows where Registration_Number = 2686

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

  • NY 43

Registration_Number 1

  • Korea International Trade Association, Inc. · 43 ✖

Registrant_Name 1

  • Korea International Trade Association, Inc. 43

City 1

  • New York 43
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
1326 1326   2023-06-29 Lee Jun Bong Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
1335 1335   2021-06-30 Park Sol Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
1336 1336   2022-06-30 Je Hyun Jung Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
4065 4065 2013-01-18 2010-01-25 Jo Hak Hee Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
4077 4077 2022-01-18 2019-06-28 Chang Sang Sik Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
4495 4495 2000-01-25 1996-05-06 Kim Cheol Young Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
4594 4594 2020-01-26 2017-06-27 Chang Seokmin Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
4975 4975 1981-01-31 1978-01-25 Hong Sung Do Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
5914 5914 2023-02-01 2020-06-26 Lee Sang Jun Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
6207 6207 2017-02-05 2014-06-27 Kim Hyun Chul Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
6258 6258 2019-02-06 2016-06-23 Chu MinSok Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
6709 6709 2016-02-12 2013-12-26 Sung Young Hwa Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
6752 6752 2021-02-13 2018-06-25 Park Joung Woo Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
6804 6804 1979-02-14 1976-04-23 Kim Ock Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
7144 7144 2012-02-16 2010-01-25 Chung Chul Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
7231 7231 2018-02-18 2015-06-17 Park Sung Hwan Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
7899 7899 1982-02-28 1981-05-23 Lee Jong Bin Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
7900 7900 1982-02-28 1979-06-04 Shin Young Gak Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
8113 8113 2000-02-28 1994-04-26 Lee Sang Jik Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
8455 8455 1988-02-29 1982-05-28 Kim Yongsun Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
8887 8887 2011-03-01 2008-06-30 Kim Keuk Soo Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
9527 9527 2003-03-09 2000-06-07 Kwon Joon Hwa Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
10333 10333 2009-03-19 2008-06-30 Park Chun Il Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
11948 11948 2005-03-31 2003-04-29 Kim Jang Han Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
11949 11949 2005-03-31 2003-04-29 Yee Wang Gyu Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
12043 12043 2009-03-31 2008-06-30 Lee Woo Won Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
12971 12971 2012-04-08 2010-01-25 Lee Dong Ki Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
13107 13107 2003-04-10 2000-06-07 Kim Moo Han Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
13401 13401 1985-04-15 1982-05-28 Choi Jung Nam Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
13785 13785 1987-04-20 1983-11-28 Koo Kil Hoe Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
14142 14142 1994-04-26 1988-08-09 Chang Won Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
14702 14702 1996-04-30 1993-07-08 Yee Wang Gyu Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
14727 14727 1997-04-30 1994-05-18 Kim Wook Dong Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
14931 14931 2006-04-30 2003-04-29 Ahn Keun Bae Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
15940 15940 2000-05-08 1996-05-06 Park Dong Woo Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
16056 16056 1990-05-11 1988-08-09 Cha Jae Yoon Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
16666 16666 1994-05-18 1990-05-22 Park Dong Woo Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
17645 17645 1978-05-31 1976-04-23 Sohn Wan Soo Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
21016 21016 1983-06-30 1980-11-26 Koh Kwang Hoon Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
23247 23247 1988-07-15 1985-05-31 Lee Seung Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
24710 24710 1980-07-31 1978-05-31 Kim Nam-Jik Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
36097 36097 1977-11-20 1976-04-23 Lee Kyu Bong Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022
36764 36764 1993-11-30 1989-05-31 Park Myung Ho Korea International Trade Association, Inc. 2686 1976-04-23 Korea International Trade Association, Inc. 460 Park Avenue Suite 400 New York NY 10022

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