FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
55 rows where Foreign_Principal_Country = "USSR"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name
Registrant_Name 11
- Amtorg Trading Corporation 29
- NORTH AMERICAN PRECIS SYNDICATE 12
- BURSON-MARSTELLER 3
- Modern Education Services, Inc. 3
- MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON 2
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 1
- NOVUS CORPORATION 1
- PARTNERS & SHEVACK, INC. 1
- SHAW, PITTMAN, POTTS & TROWBRIDGE 1
- SKADDEN, ARPS, SLATE, MEAGHER & FLOM 1
- STYLES, DEBORAH M. 1
Foreign_Principal_Country 1
- USSR · 55 ✖
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]) );