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

23 rows where Country/Location_Represented = "CHINA" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • CHINA · 23 ✖
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
7 7   Embassy of the People's Republic of China 2005-07-21 CHINA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2300 Connecticut Avenue, NW   Washington DC 20008
1241 1241 1989-01-12 People's Republic of China 1986-01-23 CHINA Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Washington     DC  
1268 1268 1987-01-13 People's Republic of China 1986-01-23 CHINA Milbank, Furia Samuels 3837 1986-01-23 Milbank, Furia Samuels Washington     DC  
1546 1546 2021-01-26 People's Republic of China Embassy 2015-01-19 CHINA Rogich Communications Group 6274 2015-01-19 Rogich Communications Group 3505 International Place, NW   Washington DC 20008
1681 1681 1963-01-31 Republic of China, Chinese Embassy, Office of Ecomonic Counselor 1962-02-15 CHINA Farrington, Robert L. 1518 1962-02-15 Farrington, Robert L. Washington     DC  
2349 2349 1986-02-10 Embassy of the People's Republic of China 1984-04-18 CHINA Surrey & Morse 2649 1976-01-05 Surrey & Morse Washington     DC  
3303 3303 1992-03-01 Embassy of the People's Republic of China 1991-06-06 CHINA Miller, Canfield, Paddock & Stone, P.L.C. 4524 1991-05-23 Miller, Canfield, Paddock & Stone, P.L.C. Washington     DC  
3926 3926 1973-03-21 Sino-American Export/Imports, Inc. (Tai Wah Hong) 1972-08-24 CHINA DJJ Communications, Inc. 2371 1972-08-24 DJJ Communications, Inc. Washington     DC  
4111 4111 1972-03-28 Republic of China 1971-06-03 CHINA GM Washington Consultants, Inc. 2261 1971-06-03 GM Washington Consultants, Inc. Washington     DC  
4120 4120 1994-03-28 Government Information Office, Republic of China 1993-08-06 CHINA Leggett, Carroll H. 4769 1993-02-23 Leggett, Carroll H. Washington     DC  
4688 4688 2009-03-31 Embassy of the People's Republic of China 1986-01-31 CHINA Jones Day 3427 1982-12-10 Jones Day Washington     DC  
4721 4721 2012-03-31 CCTV America 2012-01-25 CHINA Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1099 New York Avenue, NW Suite 430 Washington DC 20001
7726 7726 1992-06-10 Embassy of the People's Republic of China 1991-07-03 CHINA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
7902 7902 2017-06-17 Embassy of the People's Republic of China 2014-02-10 CHINA QORVIS LLC 5483 2002-03-06 QORVIS LLC 3505 International Place NW   Washington DC 20008
8967 8967 1942-07-03 China Defense Supplies, Inc. 1942-07-03 CHINA Lawrence, William S. 3 1942-07-03 Lawrence, William S. Washington     DC  
9229 9229 1950-07-14 David Lu 1947-05-26 CHINA National Lecture Management 463 1947-05-26 National Lecture Management Washington     DC  
10241 10241 2002-08-09 Ambassador Jiechi Yang - Peoples Republic of China 2002-08-09 CHINA Johnston, J. Bennett 5515 2002-08-09 Johnston, J. Bennett 2300 Connecticut Avenue, N.W.     DC  
10242 10242 2002-08-09 Ambassador Jiechi Yang 2002-08-09 CHINA Johnston, J. Bennett 5515 2002-08-09 Johnston, J. Bennett His Excellency of the Peoples Republic of China 2300 Connecticut Avenue, N.W. 20006     DC  
11883 11883 2020-09-28 Embassy of the People's Republic of China in the United States 2017-06-29 CHINA BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD 3905 International Place, NW   Washington DC 20008
14629 14629 1970-12-01 Chinese Embassy 1970-12-08 CHINA Pendleton & McLaughlin 1743 1964-05-28 Pendleton & McLaughlin Washington     DC  
15040 15040 1980-12-12 Embassy of the Republic of China 1971-05-06 CHINA Chinese Investment & Trade Office, New York 1567 1962-08-20 Chinese Investment & Trade Office, New York Washington     DC  
15852 15852 1981-12-31 Embassy of the People's Republic of China 1979-09-24 CHINA Surrey & Morse 2649 1976-01-05 Surrey & Morse       DC  
16491 16491 2001-12-31 Commercial Office of the Embassy of the People's Republic of China in Washington 1999-01-06 CHINA Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. 2133 Wisconsin Avenue, N.W.     DC  

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