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

31 rows where Foreign_Principal = "Hong Kong Trade Development Council"

✎ 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)

City 4

State 3

Foreign_Principal 1

  • Hong Kong Trade Development Council · 31 ✖

Country/Location_Represented 1

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
325 325   Hong Kong Trade Development Council 1970-01-19 HONG KONG Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc.          
326 326   Hong Kong Trade Development Council 2022-03-31 HONG KONG Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1520 18th Street, NW   Washington DC 20036
327 327   Hong Kong Trade Development Council 2019-04-05 HONG KONG BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 219 East 46th Street   New York NY 10017
328 328   Hong Kong Trade Development Council 2019-04-08 HONG KONG Jacobs Global Trade & Compliance LLC 6656 2019-04-08 Jacobs Global Trade & Compliance LLC 219 East 46th Street   New York NY 10017
329 329   Hong Kong Trade Development Council 2009-06-02 HONG KONG Venable, LLP 5931 2009-04-17 Venable, LLP 36-39/F, Office Tower, Convention Plaza 1 Harbour Road Wanchai    
1168 1168 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        
1540 1540 2021-01-27 Hong Kong Trade Development Council 2012-02-21 HONG KONG Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 36-39/F Office Tower, Convention Plaza 1 Harbour Road      
2915 2915 1988-02-28 Hong Kong Trade Development Council 1985-04-05 HONG KONG French & Company 3666 1985-04-05 French & Company          
4284 4284 1969-03-31 Hong Kong Trade Development Council 1967-10-30 HONG KONG Bostelman Associates, Inc. 2060 1967-10-30 Bostelman Associates, Inc. New York     NY  
4494 4494 1995-03-31 Hong Kong Trade Development Council 1994-02-09 HONG KONG Winston & Strawn 3869 1986-08-13 Winston & Strawn          
4702 4702 2015-03-31 Hong Kong Trade Development Council 2014-04-17 HONG KONG FTI Consulting (Government Affairs) LLC 6217 2014-04-17 FTI Consulting (Government Affairs) LLC 36/39/F, Office Tower, Convention Plaza, 1 Harbour Road        
4737 4737 2019-03-31 Hong Kong Trade Development Council 2002-10-15 HONG KONG Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1520 18th Street, N.W. 20036     DC  
5933 5933 2001-04-30 Hong Kong Trade Development Council 1995-06-26 HONG KONG Arter & Hadden, LLP 5031 1995-06-26 Arter & Hadden, LLP New York     NY  
6250 6250 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        
6750 6750 1983-05-25 Hong Kong Trade Development Council 1978-08-10 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
6751 6751 1983-05-25 Hong Kong Trade Development Council 1979-11-26 HONG KONG Fasturn, Inc. 2944 1978-08-09 Fasturn, Inc.          
8555 8555 2002-06-30 Hong Kong Trade Development Council 2001-08-10 HONG KONG Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 36-69 Office Tower Convention Plaza 1 Harbour Road        
10539 10539 1986-08-19 Hong Kong Trade Development Council 1986-08-11 HONG KONG Ernest Wittenberg Associates, Inc. 3773 1986-07-17 Ernest Wittenberg Associates, Inc.          
10562 10562 1969-08-21 Hong Kong Trade Development Council 1969-08-21 HONG KONG Li, Eric Fook-Chuen 2158 1969-08-21 Li, Eric Fook-Chuen          
10760 10760 1984-08-30 Hong Kong Trade Development Council 1978-11-01 HONG KONG International Marketing Group 2540 1974-10-22 International Marketing Group          
10772 10772 1993-08-30 Hong Kong Trade Development Council 1990-01-25 HONG KONG Loeffler & Leath, Inc. 4334 1990-01-25 Loeffler & Leath, Inc. Wanchai        
10967 10967 1996-08-31 Hong Kong Trade Development Council 1993-02-12 HONG KONG Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 4766 1993-02-12 Johnson, Smith, Dover, Kitzmiller & Stewart, Inc.          
11308 11308 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        
12472 12472 1993-10-08 Hong Kong Trade Development Council 1993-04-09 HONG KONG Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P.          
13685 13685 1995-11-06 Hong Kong Trade Development Council 1993-09-27 HONG KONG Mudge, Rose, Guthrie, Alexander & Ferdon 3200 1981-02-18 Mudge, Rose, Guthrie, Alexander & Ferdon          
14103 14103 1976-11-23 Hong Kong Trade Development Council 1976-06-21 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
14331 14331 1990-11-30 Hong Kong Trade Development Council 1987-09-29 HONG KONG Enquiries Associates 4045 1987-09-29 Enquiries Associates Hong Kong        
14483 14483 2017-11-30 Hong Kong Trade Development Council 2009-04-17 HONG KONG Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 36-9/F, Office Tower, Convention Plaza 1 Harbour Road      
16034 16034 1989-12-31 Hong Kong Trade Development Council 1989-09-07 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
16035 16035 1989-12-31 Hong Kong Trade Development Council 1985-09-26 HONG KONG Hecht, Spencer & Associates, Inc. 3740 1985-09-26 Hecht, Spencer & Associates, Inc.          
16818 16818 2021-12-31 Hong Kong Trade Development Council 2015-04-09 HONG KONG Legislative Strategies, Inc. 6287 2015-04-09 Legislative Strategies, Inc. 36-39/F, Office Tower, Convention Plaza, 1 Harbour Road        

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