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)
These facets timed out: Document_Type, Foreign_Principal_Name, Date_Stamped
Registrant_Name >30
- Hai Tian Development U.S.A., Inc. 214
- China Daily Distribution Corporation 204
- Racepoint Global, Inc. 150
- 6650 141
- MediaLinks TV, LLC 124
- Wilson Global Communications, LLC 34
- Capitol Counsel, LLC 24
- 6328 9
- Mercury Public Affairs, LLC 6
- AUX Initiatives LLC 5
- Koenig Communications LLC 5
- 6584 4
- CGTN America 3
- 6808 2
- Chwat, John 2
- Pivot Integrated Communications, a division of BCW LLC 2
- 6170 1
- 6362 1
- 6580 1
- 6604 1
- 6633 1
- 6840 1
- BCW LLC 1
- Capita 1
- Hai TIAN 1
- Hai Tain 1
- Hai Tian 1
- Hia Tian 1
- Husch Blackwell Strategies, LLC 1
- Kobre & Kim LLP 1
- …
Foreign_Principal_Country 1
- CHINA · 948 ✖
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]) );