FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

59 rows where Registration_Number = 2646

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Korea Trade Center, Los Angeles · 59 ✖

Registrant_Name 1

City 1

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
4833 4833 1995-01-30 1991-05-19 Sun Seog Ki Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
4834 4834 1995-01-30 1992-05-19 Kim Doo Young Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
5784 5784 1993-02-01 1992-05-19 Sando Dawn Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
8471 8471 1996-02-29 1992-11-30 Kim Ung Kyong Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11530 11530 1984-03-31 1982-02-25 Fisher Francine Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11531 11531 1984-03-31 1982-02-25 Ward Douglas A. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11547 11547 1986-03-31 1985-04-10 Lee Gahng Up Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11551 11551 1986-03-31 1984-06-22 Lee Joun Shik Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11561 11561 1987-03-31 1985-04-10 Hwang Minha Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11562 11562 1987-03-31 1985-04-10 Kim Sei Rok Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11576 11576 1987-03-31 1987-12-15 Taevs Gregory Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11633 11633 1990-03-31 1989-10-10 Duncan Gary Charles Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11635 11635 1990-03-31 1987-12-15 Shin Yoo Kyung Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11650 11650 1991-03-31 1989-10-10 Park Eun Woo Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
11760 11760 1996-03-31 1992-11-30 Koo Ja Kul Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
12432 12432 1982-04-01 1979-08-24 Cho Young Bok Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
12433 12433 1982-04-01 1979-08-24 Song Moo Cho Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
12467 12467 1987-04-01 1985-04-10 Ramirez M. Pia Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
13431 13431 1988-04-15 1986-04-09 Park Jin Woo Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
14510 14510 1976-04-30 1975-12-19 Lee Dong He Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
14549 14549 1985-04-30 1983-02-07 Choi Yong Do Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
14550 14550 1985-04-30 1983-02-07 Hahn Suk Hee Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
14553 14553 1985-04-30 1982-02-25 Yoo Chung Kook Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
14588 14588 1988-04-30 1985-11-18 Yoon In Han Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
16749 16749 1981-05-20 1981-02-24 Hwang Hwa-Sook Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17419 17419 1976-05-30 1975-12-19 Kim Yongwon Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17420 17420 1976-05-30 1975-12-19 Lee Poong Jick Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17699 17699 1986-05-31 1986-04-09 Ruster Jeff Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17748 17748 1991-05-31 1990-08-02 Kim Kenneth Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17749 17749 1991-05-31 1990-08-02 Mudge Jonathan E. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
17753 17753 1991-05-31 1989-10-10 Austin R. Hugh Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
22161 22161 1985-07-01 1977-10-20 Choi Duk Hee Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24311 24311 1994-07-28 1992-05-19 Roh In Ho Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24554 24554 1993-07-30 1990-08-02 Chang Sung Soo Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24555 24555 1993-07-30 1990-08-02 Kim Ilhwan Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24556 24556 1993-07-30 1990-08-02 Suh Eric Hyosuk Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24560 24560 1993-07-30 1992-11-30 Savage Jeffrey Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24752 24752 1987-07-31 1985-04-10 Goitiandia Ray Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24763 24763 1988-07-31 1982-02-25 Kim Myung Hee Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24767 24767 1988-07-31 1986-06-13 Koo Ja Kul Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
24768 24768 1988-07-31 1986-06-13 Lee Jung Kyou Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
28017 28017 1981-08-31 1981-02-24 Jakob Urs B. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
29315 29315 1985-09-07 1985-04-10 Wapner Aaron H. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
31850 31850 1978-10-01 1978-02-15 Chang Byung Sun Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
31922 31922 1991-10-01 1989-10-10 Lee Gyu Heon Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
34340 34340 1992-10-31 1990-08-02 Im Kwang Sik Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
34341 34341 1992-10-31 1990-08-02 Lee Yohn Kyu Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
35284 35284 1980-11-05 1977-10-20 Snell Lorron A. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
35755 35755 1989-11-14 1987-12-15 Kim Ung Kyong Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
38389 38389 1983-12-15 1980-10-06 Chun Byung In Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40087 40087 1978-12-31 1975-12-19 Oh Chang Sung Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40409 40409 1987-12-31 1986-06-13 Simpson Teresa J. Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40960 40960 1996-12-31 1997-02-18 Cho Hong Yun Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40961 40961 1996-12-31 1997-02-18 Fitzpatrick Sheri Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40962 40962 1996-12-31 1997-02-18 Ham Jeong Oh Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40963 40963 1996-12-31 1997-02-18 Kim Wan Soo Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40964 40964 1996-12-31 1997-02-18 Lee Min Ho Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40965 40965 1996-12-31 1997-02-18 Park Jae Hong Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813
40976 40976 1996-12-31 1992-05-19 Hackney Don Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles 4801 Wilshire Boulevard Suite 104 Los Angeles CA 90010-3813

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])
);