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

31 rows where City = "Englewood Cliffs" and State = "NJ"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Address_1, Zip, Short_Form_Termination_Date (date)

Registration_Number 3

  • Small Business Corporation - USA Office 26
  • ChungCheongNam-Do Provincial Government - New York Office 4
  • Vippi Media Inc. 1

Registrant_Name 3

  • Small Business Corporation - USA Office 26
  • ChungCheongNam-Do Provincial Government - New York Office 4
  • Vippi Media Inc. 1

State 1

  • NJ · 31 ✖

City 1

  • Englewood Cliffs · 31 ✖
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
3793 3793 1988-01-15 1983-05-25 Chung Bong Ik Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
3900 3900 1993-01-16 1990-03-29 Lee Keun Hong Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
3965 3965 1991-01-17 1988-08-16 Park Jong Been Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
4104 4104 2000-01-19 1997-06-23 Han Chan-Hee ChungCheongNam-Do Provincial Government - New York Office 5187 1997-06-23 ChungCheongNam-Do Provincial Government - New York Office 560 Sylvan Avenue 1st Floor Englewood Cliffs NJ 07632
5249 5249 2001-01-31 1997-11-05 Choi Sung Phil Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
5294 5294 2003-01-31 2000-07-17 Kwon Heung Chul Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
5989 5989 2006-02-02 2003-11-05 Park Chang Ki Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
6073 6073 2000-02-03 1997-11-05 Lee Hyeon Kook Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
9581 9581 2004-03-10 2001-07-03 Lee Kwan Woong Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
9664 9664 2007-03-11 2004-08-23 Park Jung Bae Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
9798 9798 2022-03-13 2021-12-10 Jaswal Vipinder S. Vippi Media Inc. 7057 2021-12-10 Vippi Media Inc. 61 Sherwood Avenue   Englewood Cliffs NJ 07632
17357 17357 1997-05-29 1994-06-20 Chun Pyong Chon Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
18045 18045 2009-05-31 2008-01-04 Lee Kwan Woong Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
18055 18055 2009-05-31 2006-06-16 Kim Sung Zua Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
18056 18056 2009-05-31 2007-06-19 Lee Kun Bok Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19452 19452 2004-06-14 2001-07-03 Park Seon Gon Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19576 19576 1995-06-15 1992-07-22 Shim Hyun Suk Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19591 19591 2007-06-15 2005-06-21 Lee Chan Ho Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19687 19687 1998-06-16 1995-12-12 Kwon Tae Hyung Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19694 19694 2001-06-16 1999-01-13 Lee Kunbok Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
19924 19924 1994-06-20 1992-01-02 Lee Kwan Woong Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
22913 22913 1989-07-10 1983-05-25 Park Young Joon Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
24893 24893 1997-07-31 1993-06-17 Lee Dong Kon Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
25140 25140 2008-07-31 2005-12-28 Song Jung Hye Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
31421 31421 2008-09-30 2005-12-28 Yoon In Kyoo Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
32219 32219 2007-10-03 2005-06-21 Maeng Kyung Ho Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
36962 36962 2007-11-30 2006-03-14 Park Jong-Hyun ChungCheongNam-Do Provincial Government - New York Office 5187 1997-06-23 ChungCheongNam-Do Provincial Government - New York Office 560 Sylvan Avenue 1st Floor Englewood Cliffs NJ 07632
36967 36967 2007-11-30 2006-08-15 Lim Young-Il ChungCheongNam-Do Provincial Government - New York Office 5187 1997-06-23 ChungCheongNam-Do Provincial Government - New York Office 560 Sylvan Avenue 1st Floor Englewood Cliffs NJ 07632
39230 39230 2008-12-27 2006-06-16 Jun Byung Won Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
39294 39294 2008-12-29 2008-01-04 Yeom Jung Hyeon Small Business Corporation - USA Office 3477 1983-05-25 Small Business Corporation - USA Office 120 Sylvan Avenue Suite 301 Englewood Cliffs NJ 07632
41425 41425 2005-12-31 1997-06-23 Kim Joong-Nam ChungCheongNam-Do Provincial Government - New York Office 5187 1997-06-23 ChungCheongNam-Do Provincial Government - New York Office 560 Sylvan Avenue 1st Floor Englewood Cliffs NJ 07632

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