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

20 rows where Registration_Number = 5080

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 20

Registration_Number 1

  • Korea Local Government Center (KLAFIR, America) · 20 ✖

Registrant_Name 1

  • Korea Local Government Center (KLAFIR, America) 20

City 1

  • New York 20
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
3533 3533 2003-01-10 2001-01-10 Hwang Ho Yoon Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
3535 3535 2005-01-10 2001-01-10 Lee Young Seok Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
4284 4284 2009-01-22 2007-07-16 Lee Limmoo Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
4321 4321 2002-01-23 2000-06-23 Jeong Nun Gu Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
5809 5809 2001-02-01 2000-06-23 Koo Ki Chan Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
6336 6336 2007-02-07 2006-09-05 Kim Hyenam Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
6421 6421 2001-02-08 2000-06-23 Kim Young Garp Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
8111 8111 2000-02-28 1998-03-26 Kim Dae-Sung Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
9251 9251 2007-03-06 2007-04-02 Jung Hun Yul Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
9252 9252 2009-03-06 2007-04-02 Park Dong Hoon Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
10986 10986 2008-03-28 2006-09-05 Lee Dong Hoon Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
24898 24898 1997-07-31 1995-11-24 Han Jae-Sung Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
28334 28334 1998-08-31 1998-03-26 Shin Kun Jong Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
30693 30693 2000-09-28 2000-06-23 Yoo Keun Ho Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
31207 31207 1998-09-30 1995-11-24 Kim Ung-Ki Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
31951 31951 1999-10-01 1998-03-26 Seo Kang Suk Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
32267 32267 1996-10-04 1995-11-24 Bae Jin-Hwan Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
33984 33984 2009-10-29 2006-09-05 Yang Ji Hyun Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
34540 34540 2006-10-31 2006-09-05 Roh Jong Woo Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002
36519 36519 2008-11-28 2006-12-29 Cho Youngsik Korea Local Government Center (KLAFIR, America) 5080 1995-11-24 Korea Local Government Center (KLAFIR, America) 150 East 58th Street 14th Floor New York NY 10155-0002

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