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

22 rows where Registration_Number = 3652

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 22

Registration_Number 1

  • Taiwan Trade Center New York Inc. · 22 ✖

Registrant_Name 1

  • Taiwan Trade Center New York Inc. 22

City 1

  • New York 22
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
564 564   2020-03-12 Li Ming Hsuan Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
571 571   2022-03-14 Tsai Hsiu-Chen Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
3094 3094 1990-01-02 1987-09-21 Lee Tony Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
6075 6075 2003-02-03 2002-09-30 Lee Bret Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
7653 7653 2012-02-25 2006-03-30 Lee Tsay-Ren Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
8189 8189 2005-02-28 2000-10-17 Chen Wu Yueh Er Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
8591 8591 2020-02-29 2018-08-21 Su-Chi Lan Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
8891 8891 2014-03-01 2012-03-30 Wei Kwang-Hsun Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
10482 10482 2013-03-21 2007-10-03 Tsou Chuang Ching Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
10512 10512 1993-03-22 1990-02-22 Espey Jonna Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
11063 11063 1994-03-29 1986-12-02 Lee Sam S.M. Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
19313 19313 2007-06-12 2005-05-02 Wang Mei-Yu Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
22366 22366 2017-07-01 2013-09-06 Yang Tsun Hui Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
22370 22370 2018-07-01 2014-09-05 Su Cherng Chuan Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
23238 23238 1987-07-15 1985-02-28 Lee Bret E-An Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
23560 23560 1997-07-18 1992-09-02 Hou Jeff Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
29149 29149 1987-09-04 1985-02-28 Wang Gary Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
30209 30209 1992-09-21 1988-11-07 Liu David Y.L. Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
30697 30697 2005-09-28 2004-09-17 Tuan En Lei Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
31899 31899 1986-10-01 1985-02-28 Huang Ricky Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
32910 32910 1995-10-15 1989-03-30 Tseng Betty C. M. Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119
38703 38703 2019-12-18 2017-09-07 Lung Cheng Pao Taiwan Trade Center New York Inc. 3652 1985-02-28 Taiwan Trade Center New York Inc. One Penn Plaza Suite 2025 New York NY 10119

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