FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

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

1 row where Foreign_Principal_Country = "USSR" and Foreign_Principal_Name = "TELEGRAPH AGENCY OF THE U.S.S.R. (TASS)"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 1

  • TELEGRAPH AGENCY OF THE U.S.S.R. (TASS) · 1 ✖

Foreign_Principal_Country 1

  • USSR · 1 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
57103 57103 1947-06-01 NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) New York Bureau of the Telegraph Agency of Russia (TASS) 464 Exhibit AB   TELEGRAPH AGENCY OF THE U.S.S.R. (TASS) USSR https://efile.fara.gov/docs/464-Exhibit-AB-19470601-CXXXPY02.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);