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 = "Exhibit AB" 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

These facets timed out: Document_Type

Foreign_Principal_Country 8

Registrant_Name 1

  • S.G.R. LLC Government Relations and Lobbying · 11 ✖
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
7991 7991 2017-01-27 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Exhibit-AB-20170127-2.pdf
14458 14458 2018-02-05 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Exhibit-AB-20180205-6.pdf
25983 25983 2017-03-07 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Inovo BV through Flynn Intel Group, Inc. TURKEY https://efile.fara.gov/docs/6379-Exhibit-AB-20170307-3.pdf
26217 26217 2018-03-08 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Exhibit-AB-20180308-7.pdf
63471 63471 2022-06-07 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Exhibit-AB-20220607-11.pdf
85941 85941 2019-08-06 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Agility Public Warehousing Company K.S.C.P. through Quinn Emanuel Urquhart & Sullivan, LLP KUWAIT https://efile.fara.gov/docs/6379-Exhibit-AB-20190806-9.pdf
85942 85942 2019-08-06 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Bader El-Jeaan through Quinn Emanuel Urquhart & Sullivan, LLP KUWAIT https://efile.fara.gov/docs/6379-Exhibit-AB-20190806-10.pdf
90431 90431 2017-08-28 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Government of Catalonia SPAIN https://efile.fara.gov/docs/6379-Exhibit-AB-20170828-4.pdf
97528 97528 2018-09-13 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Partido Alianza Republicana Nacionalista (ARENA) And El Salvador Presidental candidate, Carlos Calleja EL SALVADOR https://efile.fara.gov/docs/6379-Exhibit-AB-20180913-8.pdf
99170 99170 2016-09-20 S.G.R. LLC Government Relations and Lobbying S.G.R. LLC Government Relations and Lobbying 6379 Exhibit AB   Center for Studies and Media Affairs at the Saudi Royal Court SAUDI ARABIA https://efile.fara.gov/docs/6379-Exhibit-AB-20160920-1.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])
);