FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

30 rows where Foreign_Principal = "Hong Kong Trade Development Council" sorted by Foreign_Principal_Registration_Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

Foreign_Principal

  • Hong Kong Trade Development Council · 30 ✖

Country/Location_Represented

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
4145 4145 1969-03-31 Hong Kong Trade Development Council 1967-10-30 HONG KONG 2060 2060 1967-10-30 Bostelman Associates, Inc. New York     NY  
10287 10287 1969-08-21 Hong Kong Trade Development Council 1969-08-21 HONG KONG 2158 2158 1969-08-21 Li, Eric Fook-Chuen          
314 314   Hong Kong Trade Development Council 1970-01-19 HONG KONG 2181 2181 1970-01-19 Hong Kong Trade Development Council, Inc.          
13731 13731 1976-11-23 Hong Kong Trade Development Council 1976-06-21 HONG KONG 2072 2072 1968-01-30 Daniels, Houlihan & Palmeter          
6555 6555 1983-05-25 Hong Kong Trade Development Council 1978-08-10 HONG KONG 2072 2072 1968-01-30 Daniels, Houlihan & Palmeter          
10478 10478 1984-08-30 Hong Kong Trade Development Council 1978-11-01 HONG KONG 2540 2540 1974-10-22 International Marketing Group          
6556 6556 1983-05-25 Hong Kong Trade Development Council 1979-11-26 HONG KONG 2944 2944 1978-08-09 Fasturn, Inc.          
2808 2808 1988-02-28 Hong Kong Trade Development Council 1985-04-05 HONG KONG 3666 3666 1985-04-05 French & Company          
15631 15631 1989-12-31 Hong Kong Trade Development Council 1985-09-26 HONG KONG 3740 3740 1985-09-26 Hecht, Spencer & Associates, Inc.          
10266 10266 1986-08-19 Hong Kong Trade Development Council 1986-08-11 HONG KONG 3773 3773 1986-07-17 Ernest Wittenberg Associates, Inc.          
13958 13958 1990-11-30 Hong Kong Trade Development Council 1987-09-29 HONG KONG 4045 4045 1987-09-29 Enquiries Associates Hong Kong        
15630 15630 1989-12-31 Hong Kong Trade Development Council 1989-09-07 HONG KONG 3856 3856 1986-07-11 GCI Group, Inc. New York     NY  
10490 10490 1993-08-30 Hong Kong Trade Development Council 1990-01-25 HONG KONG 4334 4334 1990-01-25 Loeffler & Leath, Inc. Wanchai        
10685 10685 1996-08-31 Hong Kong Trade Development Council 1993-02-12 HONG KONG 4766 4766 1993-02-12 Johnson, Smith, Dover, Kitzmiller & Stewart, Inc.          
12131 12131 1993-10-08 Hong Kong Trade Development Council 1993-04-09 HONG KONG 3274 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P.          
13320 13320 1995-11-06 Hong Kong Trade Development Council 1993-09-27 HONG KONG 3200 3200 1981-02-18 Mudge, Rose, Guthrie, Alexander & Ferdon          
4355 4355 1995-03-31 Hong Kong Trade Development Council 1994-02-09 HONG KONG 3869 3869 1986-08-13 Winston & Strawn          
5765 5765 2001-04-30 Hong Kong Trade Development Council 1995-06-26 HONG KONG 5031 5031 1995-06-26 Arter & Hadden, LLP New York     NY  
11017 11017 1997-09-05 Hong Kong Trade Development Council 1996-03-27 HONG KONG 3275 3275 1981-09-23 Graham & James, L.L.P. Wanchai        
6067 6067 2002-05-03 Hong Kong Trade Development Council 1997-10-01 HONG KONG 3274 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Wanchai        
1102 1102 2014-01-10 Hong Kong Trade Development Council 1998-07-15 HONG KONG 5265 5265 1998-07-15 Wexler & Walker Public Policy Associates Wan Chai        
8327 8327 2002-06-30 Hong Kong Trade Development Council 2001-08-10 HONG KONG 2165 2165 1969-10-09 Squire Patton Boggs, LLP 36-69 Office Tower Convention Plaza 1 Harbour Road        
4598 4598 2019-03-31 Hong Kong Trade Development Council 2002-10-15 HONG KONG 3731 3731 1985-09-13 Sidley Austin, LLP 1520 18th Street, N.W. 20036     DC  
14110 14110 2017-11-30 Hong Kong Trade Development Council 2009-04-17 HONG KONG 5926 5926 2009-04-01 Podesta Group, Inc. 36-9/F, Office Tower, Convention Plaza 1 Harbour Road      
319 319   Hong Kong Trade Development Council 2009-06-02 HONG KONG 5931 5931 2009-04-17 Venable, LLP 36-39/F, Office Tower, Convention Plaza 1 Harbour Road Wanchai    
315 315   Hong Kong Trade Development Council 2012-02-21 HONG KONG 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 36-39/F Office Tower, Convention Plaza 1 Harbour Road      
4563 4563 2015-03-31 Hong Kong Trade Development Council 2014-04-17 HONG KONG 6217 6217 2014-04-17 FTI Consulting (Government Affairs) LLC 36/39/F, Office Tower, Convention Plaza, 1 Harbour Road        
318 318   Hong Kong Trade Development Council 2015-04-09 HONG KONG 6287 6287 2015-04-09 Legislative Strategies, Inc. 36-39/F, Office Tower, Convention Plaza, 1 Harbour Road        
316 316   Hong Kong Trade Development Council 2019-04-05 HONG KONG 5430 5430 2001-05-10 BGR Government Affairs, LLC 219 East 46th Street   New York NY 10017
317 317   Hong Kong Trade Development Council 2019-04-08 HONG KONG 6656 6656 2019-04-08 Jacobs Global Trade & Compliance LLC 219 East 46th Street   New York NY 10017

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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