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

27 rows where Registration_Number = 2911

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • IL 27

Registration_Number 1

  • Far East Trade Service, Inc., Chicago · 27 ✖

Registrant_Name 1

  • Far East Trade Service, Inc., Chicago 27

City 1

  • Chicago 27
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
3371 3371 2001-01-07 1999-06-03 Chow Wann-Ling Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
3811 3811 1999-01-15 1998-12-03 Gajecky Yvonne Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
4839 4839 2000-01-30 1999-06-03 Iverson Katie Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
5169 5169 1996-01-31 1994-12-02 Hannon Kerrie A. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
7895 7895 1981-02-28 1980-10-28 Young Jing-Chuan Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
8089 8089 1998-02-28 1993-06-09 Piele Karen A. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
8156 8156 2002-02-28 2001-12-20 Jieh Wen-Chuan Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
8734 8734 1980-03-01 1978-06-08 Yu Charles Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
9129 9129 1999-03-04 1997-12-04 McCandless Teresa Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
13878 13878 2001-04-21 1998-12-03 Martin Kathleen Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
14583 14583 1988-04-30 1986-02-26 Chen Victor Shih-Wen Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
14885 14885 2002-04-30 2001-12-20 Yen Sanders Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
16518 16518 1995-05-16 1984-12-14 Yang Steve Tzu-Ting Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
17362 17362 2002-05-29 1998-06-02 Horng Jeng-Shiuann Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
17364 17364 2002-05-29 2000-12-04 Liao Ya-Fen Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
17722 17722 1989-05-31 1985-06-17 Collins Kimberly A. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
19115 19115 1993-06-09 1982-12-03 Weidell Gwen D. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
21041 21041 1985-06-30 1978-06-08 Lin Joseph Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
23358 23358 1984-07-16 1980-10-28 Chen Eugene I-Jen Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
23561 23561 1997-07-18 1993-12-08 Chang Shih-Chang Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
24776 24776 1989-07-31 1985-03-26 Lin Tom T.K. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
29641 29641 1997-09-12 1993-06-09 Anderson Daniel D. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
31145 31145 1996-09-30 1993-06-09 Fratzke Jill E. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
31168 31168 1997-09-30 1993-06-09 Fogarty Moira Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
32174 32174 1998-10-02 1996-12-06 Garcia Edward Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
34416 34416 1998-10-31 1996-05-28 Waxlax Jennifer K. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
36476 36476 1984-11-27 1982-12-03 Touchette Amy E. Far East Trade Service, Inc., Chicago 2911 1978-06-08 Far East Trade Service, Inc., Chicago 225 North Michigan Avenue Suite 1888 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 683.921ms · 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