FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Short_Form_Last_Name = "Wang" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 14
- Chinese Information Service 4
- White & Case, LLP 2
- China National Tourist Office 2
- Taiwan Trade Center New York Inc. 2
- Central News Agency of China, New York Bureau 1
- Milbank, Tweed, Hadley & McCloy 1
- Singapore Economic Development Board 1
- Hong Kong Trade Development Council, Inc. 1
- Singapore Tourism Board 1
- China Daily Distribution Corporation 1
- IPG DXTRA, Inc 1
- Icon Group 1
- Kobre & Kim LLP 1
- Ogilvy Group LLC 1
Registrant_Name 14
- Chinese Information Service 4
- China National Tourist Office 2
- Taiwan Trade Center New York Inc. 2
- White & Case, LLP 2
- Central News Agency of China, New York Bureau 1
- China Daily Distribution Corporation 1
- Hong Kong Trade Development Council, Inc. 1
- IPG DXTRA, Inc 1
- Icon Group 1
- Kobre & Kim LLP 1
- Milbank, Tweed, Hadley & McCloy 1
- Ogilvy Group LLC 1
- Singapore Economic Development Board 1
- Singapore Tourism Board 1
City 2
- New York 19
- Bronxville 1
State 1
- NY · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1393 | 1393 | 2017-07-12 | Wang | Sze Mien | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 | |
2287 | 2287 | 2011-11-30 | Wang | Jun | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
2569 | 2569 | 1975-01-01 | 1974-08-01 | Wang | Francis S.L. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
4755 | 4755 | 1992-01-29 | 1990-04-09 | Wang | Danchi | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5180 | 5180 | 1997-01-31 | 1992-06-22 | Wang | Samuel Wei-Teh | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
14407 | 14407 | 1949-04-30 | 1948-04-06 | Wang | Ju-Mei | Central News Agency of China, New York Bureau 391 | 1946-11-08 | Central News Agency of China, New York Bureau | 220 East 42nd Street | Room 1231 | New York | NY | 10017 |
15189 | 15189 | 2020-04-30 | 2019-02-26 | Wang | Nan | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | |
15230 | 15230 | 2021-04-30 | 2021-04-16 | Wang | Andrea | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
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 |
19838 | 19838 | 1957-06-19 | 1957-01-30 | Wang | Hung-Chun | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
20635 | 20635 | 1950-06-30 | 1948-07-22 | Wang | King-Ching | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
24052 | 24052 | 1948-07-26 | 1946-11-26 | Wang | Hubert C. | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
24985 | 24985 | 2000-07-31 | 1996-11-12 | Wang | Samuel | Icon Group 4926 | 1994-07-08 | Icon Group | 130 Pondfield Road | Suite 1 | Bronxville | NY | 10708 |
27917 | 27917 | 1976-08-31 | 1973-06-12 | Wang | Louis I.C. | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
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 | |
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 |
31999 | 31999 | 2006-10-01 | 2006-05-31 | Wang | Xiaogang | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
34385 | 34385 | 1997-10-31 | 1995-03-06 | Wang | Jianhao | China National Tourist Office 3318 | 1981-12-30 | China National Tourist Office | 370 Lexington Avenue | Suite 912 | New York | NY | 10017 |
34655 | 34655 | 2013-10-31 | 2011-06-29 | Wang | Weixiang | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
42116 | 42116 | 2017-12-31 | 2017-02-13 | Wang | Yanjie | China National Tourist Office 3318 | 1981-12-30 | China National Tourist Office | 370 Lexington Avenue | Suite 912 | 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]) );