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 = "CONGO DEMOCRATIC REPUBLIC OF THE", Foreign_Principal_Name = "Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo" and Registrant_Name = "Avenue Strategies Global, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • Avenue Strategies Global, LLC · 1 ✖

Foreign_Principal_Name 1

  • Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo · 1 ✖

Foreign_Principal_Country 1

  • CONGO DEMOCRATIC REPUBLIC OF THE · 1 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
24143 24143 2018-03-01 Avenue Strategies Global, LLC Avenue Strategies, LLC 6446 Exhibit AB   Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo CONGO DEMOCRATIC REPUBLIC OF THE https://efile.fara.gov/docs/6446-Exhibit-AB-20180301-4.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])
);