FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
135,872 rows
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country >30
- - 97,187
- SAUDI ARABIA 1,785
- JAPAN 1,482
- KOREA SOUTH 1,196
- BOSNIA & HERZEGOVINA 1,192
- RUSSIA 1,161
- CHINA 1,081
- CANADA 848
- UKRAINE 811
- TURKEY 625
- UNITED ARAB EMIRATES 562
- MEXICO 511
- GERMANY 442
- GREAT BRITAIN 432
- NORWAY 415
- QATAR 382
- ISRAEL 380
- INTERNATIONAL 375
- TAIWAN 356
- FRANCE 345
- LIBYA 323
- CAMBODIA 317
- IRAQ 314
- COLOMBIA 277
- ITALY 257
- HAITI 247
- ANGOLA 226
- AZERBAIJAN 218
- SERBIA 213
- HONDURAS 206
- …
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]) );