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 = "MOROCCO" and Registrant_Name = "S.G.R. LLC Government Relations and Lobbying"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Registrant_Name 1

  • S.G.R. LLC Government Relations and Lobbying · 1 ✖

Foreign_Principal_Country 1

  • MOROCCO · 1 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5049 5049 2018-01-12 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Ministry of Foreign Affairs and International Cooperation of the Kingdom of Morocco (through JPC Strategies LLC) MOROCCO https://efile.fara.gov/docs/6379-Exhibit-AB-20180112-5.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])
);