FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
94 rows where Country/Location_Represented = "HONG KONG" and State = "" sorted by Address_1
This data as json, CSV (advanced)
Registrant_Name 10
Foreign_Principal 7
City 3
- - 8
- Admiralty 1
- New Territories 1
State 1
- - · 10 ✖
Country/Location_Represented 1
- HONG KONG · 10 ✖
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 ▼ | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5630 | 5630 | 2009-04-27 | Shining Prospect Pte. Ltd. | 2009-02-19 | HONG KONG | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | Room 4501 Far East Finance Center | No. 16 Harcourt Road | Admiralty | ||
634 | 634 | Sing Tao News Corporation Ltd. | 2021-08-23 | HONG KONG | Sing Tao US 6999 | 2021-08-23 | Sing Tao US | Sing Tao News Corporation Bldg., 7 Chun Cheong St., | Tseung Kwan O Industrial Estate, Tseung Kwan O | New Territories | |||
8718 | 8718 | 2013-06-30 | Tiangang Sung | 2012-12-24 | HONG KONG | Peter O'Toole, LLC 6147 | 2012-12-24 | Peter O'Toole, LLC | Suite 5304 on 53/F Central Plaza | 18 Harbour Road Wanchai | |||
1198 | 1198 | 2014-01-10 | Hong Kong Trade Development Council | 1998-07-15 | HONG KONG | Wexler & Walker Public Policy Associates 5265 | 1998-07-15 | Wexler & Walker Public Policy Associates | Wan Chai | ||||
6310 | 6310 | 2002-05-03 | Hong Kong Trade Development Council | 1997-10-01 | HONG KONG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Wanchai | ||||
10849 | 10849 | 1993-08-30 | Hong Kong Trade Development Council | 1990-01-25 | HONG KONG | Loeffler & Leath, Inc. 4334 | 1990-01-25 | Loeffler & Leath, Inc. | Wanchai | ||||
11287 | 11287 | 1997-09-01 | Better Hong Kong Foundation | 1996-02-13 | HONG KONG | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Wanchai | ||||
11387 | 11387 | 1997-09-05 | Hong Kong Trade Development Council | 1996-03-27 | HONG KONG | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Wanchai | ||||
13383 | 13383 | 1999-10-31 | Better Hong Kong Foundation (BHKF) | 1996-06-04 | HONG KONG | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Wanchai | ||||
14383 | 14383 | 1989-11-30 | Asia Satellite Telecommunications, Hong Kong, Ltd. | 1988-07-27 | HONG KONG | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Wanchai |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );