List of all foreign principals (active and terminated)

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

17 rows where Country/Location_Represented = "CHINA" and State = "NY"

View and edit SQL

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

City

State

Country/Location_Represented

  • CHINA · 17
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
1580 1963-01-31 Sandys Bao, Chinese Government Procurement & Services Mission, Division of Taiwan Sugar Corporation 1962-02-15 CHINA 1518 1518 1962-02-15 Farrington, Robert L. New York     NY  
1873 1975-02-01 Chinese Information Service 1973-05-01 CHINA 2421 2421 1973-05-01 Communetics, Inc. New York     NY  
2133 2003-02-06 Air China International Corp. 1998-06-09 CHINA 3718 3718 1985-08-07 Holland & Knight New York     NY  
3000 2019-02-28 China National Tourist Office 2018-04-30 CHINA 6549 6549 2018-04-30 Myriad International Marketing, LLC 370 Lexington Avenue #912   New York NY 10017
3928 1954-03-28 China's Fighting League for Free Democracy 1953-09-28 CHINA 791 791 1953-09-28 Chang, Carsun Somewhere in Asia     NY  
4103 1949-03-31 National Resources Commission of China 1948-04-09 CHINA 521 521 1948-04-09 Goodwin, William J. New York     NY  
6406 1978-05-19 Chinese Information Service 1978-04-18 CHINA 2885 2885 1978-04-18 Francis Thompson, Inc. New York     NY  
8653 2020-07-02 Consulate General of The People's Republic of China in New York 2020-11-06 CHINA 6840 6840 2020-06-22 Ruder Finn, Inc. 520 12th Avenue   New York City NY 10036
10998 1973-09-04 Chinese Information Service 1973-09-04 CHINA 2453 2453 1973-09-04 Mass Communications, Inc. New York     NY  
11533 1965-09-30 Chinese Government Procurement & Services Mission - Division for Taiway Sugar Corporation 1964-11-27 CHINA 1727 1727 1964-05-12 Farrington, Robert L. New York     NY  
12577 1989-10-25 Chinese Cultural Center 1988-10-12 CHINA 2836 2836 1977-10-12 North American Precis Syndicate New York     NY  
13073 2019-10-31 Virgo Star, Inc. on behalf of CRRC North America, Inc. 2019-07-18 CHINA 6702 6702 2019-07-18 Crossroads Strategies LLC One Rockeller Plaza Suite 2802 New York NY 10020
14421 1965-12-08 Republic of China, Office of Economic Counselor 1964-05-12 CHINA 1727 1727 1964-05-12 Farrington, Robert L. New York     NY  
14645 1950-12-15 Bank of China, New York Agency 1950-01-06 CHINA 604 604 1950-01-06 Allied Syndicates, Inc. New York     NY  
15040 1949-12-31 Chinese Petroleum Corporation 1948-07-07 CHINA 532 532 1948-07-07 Fleming, John William New York     NY  
15168 1967-12-31 Chinese News Service 1965-02-11 CHINA 1597 1597 1963-02-12 Sterling Movies New York     NY  
16256 2014-12-31 China National Tourist Office 2014-01-30 CHINA 5872 5872 2008-06-30 Spring O'Brien & Company, Inc. 370 Lexington Avenue Suite #912 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])
);