home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
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" sorted by Foreign_Principal_Registration_Date

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 28

  • Akin, Gump, Strauss, Hauer & Feld, LLP 2
  • Daniels, Houlihan & Palmeter 2
  • Powell, Goldstein, Frazer & Murphy, L.L.P. 2
  • Arter & Hadden, LLP 1
  • BGR Government Affairs, LLC 1
  • Bostelman Associates, Inc. 1
  • Enquiries Associates 1
  • Ernest Wittenberg Associates, Inc. 1
  • FTI Consulting (Government Affairs) LLC 1
  • Fasturn, Inc. 1
  • French & Company 1
  • GCI Group, Inc. 1
  • Graham & James, L.L.P. 1
  • Hecht, Spencer & Associates, Inc. 1
  • Hong Kong Trade Development Council, Inc. 1
  • International Marketing Group 1
  • Jacobs Global Trade & Compliance LLC 1
  • Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. 1
  • Legislative Strategies, Inc. 1
  • Li, Eric Fook-Chuen 1
  • Loeffler & Leath, Inc. 1
  • Mudge, Rose, Guthrie, Alexander & Ferdon 1
  • Podesta Group, Inc. 1
  • Sidley Austin LLP 1
  • Squire Patton Boggs, LLP 1
  • Venable, LLP 1
  • Wexler & Walker Public Policy Associates 1
  • Winston & Strawn 1

City 4

  • - 27
  • New York 2
  • Wanchai 1
  • Washington 1

State 3

  • - 24
  • NY 5
  • DC 2

Foreign_Principal 1

  • Hong Kong Trade Development Council · 31 ✖

Country/Location_Represented 1

  • HONG KONG 31
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
4330 4330 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  
10637 10637 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          
331 331   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.          
14187 14187 1976-11-23 Hong Kong Trade Development Council 1976-06-21 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
6810 6810 1983-05-25 Hong Kong Trade Development Council 1978-08-10 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
10837 10837 1984-08-30 Hong Kong Trade Development Council 1978-11-01 HONG KONG International Marketing Group 2540 1974-10-22 International Marketing Group          
6811 6811 1983-05-25 Hong Kong Trade Development Council 1979-11-26 HONG KONG Fasturn, Inc. 2944 1978-08-09 Fasturn, Inc.          
2948 2948 1988-02-28 Hong Kong Trade Development Council 1985-04-05 HONG KONG French & Company 3666 1985-04-05 French & Company          
16123 16123 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.          
10614 10614 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.          
14415 14415 1990-11-30 Hong Kong Trade Development Council 1987-09-29 HONG KONG Enquiries Associates 4045 1987-09-29 Enquiries Associates Hong Kong        
16122 16122 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  
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        
11044 11044 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.          
12553 12553 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.          
13768 13768 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          
4540 4540 1995-03-31 Hong Kong Trade Development Council 1994-02-09 HONG KONG Winston & Strawn 3869 1986-08-13 Winston & Strawn          
5992 5992 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  
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        
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        
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        
8624 8624 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        
4783 4783 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  
14567 14567 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      
335 335   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    
1571 1571 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      
4748 4748 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        
16905 16905 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        
333 333   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
334 334   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
332 332   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

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])
);
Powered by Datasette · Queries took 326.691ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows