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

11 rows where Document_Type = "Supplemental Statement" and Registrant_Name = "S.G.R. LLC Government Relations and Lobbying"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

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

Foreign_Principal_Name 1

  • - 11

Foreign_Principal_Country 1

  • - 11

Document_Type 1

  • Supplemental Statement · 11 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
31289 31289 2017-03-27 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20170327-1.pdf
45055 45055 2018-04-30 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20180430-5.pdf
45129 45129 2019-04-30 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20190430-7.pdf
49838 49838 2020-05-06 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20200506-9.pdf
55288 55288 2021-05-27 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20210527-11.pdf
63215 63215 2022-06-06 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20220606-13.pdf
112749 112749 2018-10-30 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20181030-6.pdf
112796 112796 2019-10-30 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20191030-8.pdf
113746 113746 2017-10-31 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20171031-2.pdf
120947 120947 2020-11-20 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20201120-10.pdf
130247 130247 2021-12-10 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20211210-12.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])
);