FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
948 rows where Document_Type = "Informational Materials" and Foreign_Principal_Country = "CHINA"
This data as json, CSV (advanced)
Registrant_Name 20
- 6650 69
- MediaLinks TV, LLC 60
- Racepoint Global, Inc. 58
- Hai Tian Development U.S.A., Inc. 46
- China Daily Distribution Corporation 24
- Wilson Global Communications, LLC 17
- Capitol Counsel, LLC 10
- 6328 5
- Mercury Public Affairs, LLC 4
- AUX Initiatives LLC 3
- 6584 2
- 6808 2
- Pivot Integrated Communications, a division of BCW LLC 2
- 6362 1
- 6633 1
- 6840 1
- BCW LLC 1
- Capita 1
- Hai TIAN 1
- Hai Tain 1
Foreign_Principal_Name 13
- Huawei Technologies USA 127
- CCTV 61
- People's Daily Overseas Edition 48
- China Daily of Beijing, China 24
- China-United States Exchange Foundation 20
- U.S.- China Transpacific Foundation 14
- Hikvision USA Inc. 4
- Huawei Technologies USA, Inc. 3
- Wanhua Chemical US Operations LLC 3
- Esquel Enterprises Ltd. 2
- China National Forest Products Industry Association (CNFPIA) 1
- Hikvision USA, Inc. 1
- U.S.-China Transpacific Foundation 1
Foreign_Principal_Country 1
- CHINA · 309 ✖
Document_Type 1
- Informational Materials · 309 ✖
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );