FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
79 rows where City = "New York" and Registration_Number = 2181 sorted by Short_Form_Date
This data as json, CSV (advanced)
State 1
- NY 40
Registration_Number 1
- Hong Kong Trade Development Council, Inc. · 40 ✖
Registrant_Name 1
City 1
- New York · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );