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

25 rows where Registration_Number = 2648 and State = "IL"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • IL · 25 ✖

Registration_Number 1

  • Korea Trade Center, Chicago · 25 ✖

Registrant_Name 1

  • Korea Trade Center, Chicago 25

City 1

  • Chicago 25
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
4055 4055 1995-01-18 1992-01-27 Kim Man Yool Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
5782 5782 1993-02-01 1990-02-05 Park Kyung-bae Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
10376 10376 1985-03-20 1985-03-20 Stangohr Craig Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11599 11599 1989-03-31 1987-04-15 Rhee Kwang Sik Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11620 11620 1990-03-31 1988-02-19 Song Dae-Kyun Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11623 11623 1990-03-31 1987-04-15 Sunwoo Young-Il Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11645 11645 1991-03-31 1988-09-16 Chung Ho-won Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
11662 11662 1992-03-31 1989-03-09 Yang Hyo Sik Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
12466 12466 1987-04-01 1985-03-20 Kim Man-Hyok Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
14192 14192 1988-04-27 1988-02-19 Min Kyun Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
14555 14555 1985-04-30 1985-03-20 Trudo O. Leonard Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
14563 14563 1986-04-30 1985-03-20 Bilous Olena Am Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
16746 16746 1976-05-20 1975-12-31 Kang Yong Ku Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
20941 20941 1979-06-30 1976-07-20 Hahn Dong-Gun Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
21013 21013 1983-06-30 1980-09-16 Park Ho-Taek Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
21160 21160 1991-06-30 1990-08-01 Chung Yeun Soon Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
23060 23060 1993-07-13 1990-08-01 Bae Jung Woong Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
24700 24700 1978-07-31 1975-12-31 Park Jong Han Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
28910 28910 1995-09-01 1993-07-13 Lee Jung Min Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
30917 30917 1976-09-30 1975-12-31 Song Byung Hee Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
36702 36702 1988-11-30 1987-04-15 Song Sung Soo Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
39323 39323 1979-12-30 1979-02-27 Lee Byung Chong Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
40956 40956 1996-12-31 1992-02-01 Sae-Kwang Ho Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
40984 40984 1996-12-31 1992-07-30 Lee Han Chul Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601
40985 40985 1996-12-31 1991-08-01 Kang Ho Shin Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago 111 East Wacker Drive Suite 2229 Chicago IL 60601

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