FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

79 rows where "Registration_Date" is on date 1970-01-19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

City 1

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
447 447   2014-02-24 Cheung Winchell Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
493 493   2022-03-03 Hwa Wai Kwan Regina Lai Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
591 591   2002-03-18 Lee Bridget Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
1664 1664   2021-08-26 WONG PUI CHI Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
4108 4108 2004-01-19 2002-03-18 Cheng Keith Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
4318 4318 1998-01-23 1996-03-05 Chui William Iu Lam Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
5170 5170 1997-01-31 1970-01-19 Leung Peter Hung-sum Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
7221 7221 2000-02-18 1995-08-31 Bruno Carmen L. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
7230 7230 2013-02-18 2009-02-27 Chiu Dannie Nagm Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
7812 7812 2014-02-27 2010-08-23 Lee Ka Wai Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
7878 7878 1976-02-28 1973-02-22 Lo Francis Wing-Chan Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
7921 7921 1985-02-28 1983-02-24 Yip Chak Yan Raymond Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9030 9030 1992-03-03 1983-02-08 Williams Bobbie L. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9031 9031 1992-03-03 1982-02-22 Chu Roger Ying Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9032 9032 1992-03-03 1987-03-03 Tang Stella C.S. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9033 9033 1992-03-03 1985-03-19 Kraith Anson J. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9034 9034 1992-03-03 1985-03-19 Loi Chiu Yeung Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9035 9035 1992-03-03 1970-08-06 Kwong Nisbet Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9036 9036 1992-03-03 1983-08-17 Fernandez Dorado C. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
9037 9037 1992-03-03 1983-08-17 deSocarraz Elena Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
11546 11546 1986-03-31 1981-03-17 Davenport Luther M. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
11566 11566 1987-03-31 1974-08-27 Abbott B. Wayne Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
12486 12486 1990-04-01 1988-09-02 Fernandez Daniel C. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
12500 12500 1995-04-01 1990-03-02 Braga Joao C. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
13727 13727 2019-04-18 2014-08-26 Mak Ho Yin Anthony Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
13882 13882 2009-04-21 2001-08-31 Tam Richard S. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
14389 14389 2020-04-29 2017-08-18 Lo Yat Fung Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
14928 14928 2006-04-30 2004-03-02 Ng Chun-Wing Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
15095 15095 2017-04-30 2013-08-23 Poon Wai Sum Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
15354 15354 1981-05-01 1979-05-10 Wong Alan Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
15552 15552 2022-05-01 2019-08-27 Fan Wing Yin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
15947 15947 2003-05-08 2001-09-06 Mehta Manik Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
16906 16906 2001-05-22 1986-09-02 Yuin Lee Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
17074 17074 1973-05-25 1971-01-31 Ng Wing-Boo Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
18402 18402 1971-06-01 1970-01-19 Li Eric Fook-Chuen Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
19110 19110 1991-06-09 1988-09-02 Monks Sarah Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
19847 19847 1986-06-19 1981-02-23 McCabe John Joseph Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
20131 20131 1971-06-24 1970-01-19 Loh Jimmy Chung May Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
21528 21528 2005-06-30 1991-03-01 Cheung Winchell Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
21565 21565 2006-06-30 2004-03-02 Li Kin Man Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
21991 21991 2021-06-30 2014-08-26 Chow Shui Sang Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
22089 22089 1972-07-01 1972-02-23 Shek William F. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
22157 22157 1984-07-01 1976-08-17 Wong Anthony Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
22250 22250 1995-07-01 1988-09-02 Patterson Diana Lynn Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
22831 22831 1976-07-09 1972-02-23 Tso Pearl Min Yee Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
23200 23200 1973-07-15 1972-02-23 Sanders Alan A. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
25486 25486 1972-08-01 1971-07-20 Ho Shiu Keung Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
25572 25572 1989-08-01 1985-03-19 Farrell Sharon Maris Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
26077 26077 1970-08-06 1970-01-19 Sun Robert Strong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
26260 26260 1982-08-08 1979-05-10 Ma Andrew Tze-Chiu Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
26971 26971 1995-08-18 1989-09-07 Wong Alan Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
27190 27190 1985-08-22 1970-01-19 Stier Anna T. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
27710 27710 1995-08-29 1988-07-12 Ho Louis Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28076 28076 1984-08-31 1985-08-29 Ka-Wing Stephen Mak Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28095 28095 1986-08-31 1999-03-02 Chiu Robin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28109 28109 1987-08-31 1986-02-27 Wong Strephen Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28117 28117 1987-08-31 1985-08-29 Wang Dennis Yau Tat Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28333 28333 1998-08-31 1996-03-05 Oleksyn O. George Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
28353 28353 1999-08-31 1998-10-09 Cheung Hui Hang Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29019 29019 1988-09-02 1975-02-21 Chiu Robin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29020 29020 1988-09-02 1975-02-21 Tai Matthew Cheong Sin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29021 29021 1988-09-02 1973-02-22 Beck Bryna Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29022 29022 1988-09-02 1977-02-22 Phay Alexander Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29025 29025 1988-09-02 1978-06-19 Ng Wing Boo Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29026 29026 1988-09-02 1972-07-26 Ma Michael Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29173 29173 2001-09-04 1999-03-02 Yee Peggie Liu Sin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
31034 31034 1989-09-30 1987-03-03 Ma Andrew Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
31428 31428 2009-09-30 2004-03-02 Wong Stephen Che Keung Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
31941 31941 1996-10-01 1989-09-07 Tam Richard Siu-Hong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
32272 32272 2000-10-04 2000-02-29 Leung Godfrey Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
32357 32357 1982-10-06 1980-06-02 Liu Ernest Kwok-Hong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
34243 34243 1984-10-31 1982-02-22 Choy Francis Chi Kwong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
35341 35341 1998-11-06 1997-03-03 Yung Monica Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
36458 36458 2013-11-26 2013-02-27 Sham Wing Tong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
36670 36670 1984-11-30 1974-08-27 Wong Kam Fai (Alan) Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
36898 36898 2001-11-30 1988-09-02 Nystrom Patricia H. Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
40122 40122 1980-12-31 1973-02-22 Epstein Louis Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
40517 40517 1988-12-31 1970-08-06 Sun Robert Strong Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
41610 41610 2008-12-31 2007-02-26 Ma Hoi Lee Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017

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])
);