FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Chu"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
Registrant_Name 11
City 4
- New York 7
- Washington 2
- Germantown 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6258 | 6258 | 2019-02-06 | 2016-06-23 | Chu | MinSok | Korea International Trade Association, Inc. 2686 | 1976-04-23 | Korea International Trade Association, Inc. | 460 Park Avenue | Suite 400 | New York | NY | 10022 |
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 | |
23801 | 23801 | 2018-07-22 | 2014-11-25 | Chu | Youn Jung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
26565 | 26565 | 2011-08-13 | 2011-08-11 | Chu | Alan | PricewaterhouseCoopers, LLP ('PwC LLP") 6053 | 2011-08-11 | PricewaterhouseCoopers, LLP ('PwC LLP") | 300 Madison Avenue | New York | NY | 10017 | |
27032 | 27032 | 1949-08-20 | 1946-05-07 | Chu | Yao Kui | Lu, David 102 | 1942-08-20 | Lu, David | National Press Building | Room 1151 | Washington | DC | |
28039 | 28039 | 1981-08-31 | 1975-08-21 | Chu | Leonard C. | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
29410 | 29410 | 1987-09-08 | 1984-02-10 | Chu | Charles | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | 2000 Pennsylvania Avenue, N.W. | Washington | DC | 20006-1882 | |
34125 | 34125 | 1947-10-31 | 1946-11-26 | Chu | Mary York | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
37479 | 37479 | 2003-12-01 | 2003-12-01 | Chu | Nam Hoon | Chu, Nam Hoon 5590 | 2003-12-01 | Chu, Nam Hoon | 21027 Sojourn Court | Germantown | MD | 20876 | |
40610 | 40610 | 1990-12-31 | 1990-02-28 | Chu | Gary | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
41898 | 41898 | 2014-12-31 | 2013-01-29 | Chu | Ellen Wei-Hsin | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 |
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]) );