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

79 rows where Registration_Number = 6379

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped, Short_Form_Name, Date_Stamped (date)

Foreign_Principal_Country

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
4706 4706 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 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
4707 4707 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Abu-Rubieh, Mahmood     https://efile.fara.gov/docs/6379-Short-Form-20180112-74.pdf
4708 4708 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Amundaray, Carla     https://efile.fara.gov/docs/6379-Short-Form-20180112-70.pdf
4709 4709 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20180112-68.pdf
4710 4710 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Fleming, Patrick     https://efile.fara.gov/docs/6379-Short-Form-20180112-64.pdf
4711 4711 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20180112-66.pdf
4712 4712 2018-01-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20180112-72.pdf
6998 6998 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Amendment       https://efile.fara.gov/docs/6379-Amendment-20170127-1.pdf
6999 6999 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Exhibit-AB-20170127-2.pdf
7000 7000 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Amundaray, Carla     https://efile.fara.gov/docs/6379-Short-Form-20170127-24.pdf
7001 7001 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Faulkner, Cynthia     https://efile.fara.gov/docs/6379-Short-Form-20170127-30.pdf
7002 7002 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Ghazal, Jay     https://efile.fara.gov/docs/6379-Short-Form-20170127-34.pdf
7003 7003 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Looney, Scott     https://efile.fara.gov/docs/6379-Short-Form-20170127-28.pdf
7004 7004 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20170127-20.pdf
7005 7005 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Sandground Sr, Mark     https://efile.fara.gov/docs/6379-Short-Form-20170127-32.pdf
7006 7006 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Walling, Chris     https://efile.fara.gov/docs/6379-Short-Form-20170127-26.pdf
7007 7007 2017-01-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Wyatt, Edward     https://efile.fara.gov/docs/6379-Short-Form-20170127-22.pdf
12811 12811 2018-02-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Exhibit-AB-20180205-6.pdf
12812 12812 2018-02-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20180205-76.pdf
13001 13001 2018-02-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Abu-Rubieh, Mahmood     https://efile.fara.gov/docs/6379-Short-Form-20180206-80.pdf
13002 13002 2018-02-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Amundaray, Carla     https://efile.fara.gov/docs/6379-Short-Form-20180206-78.pdf
13003 13003 2018-02-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20180206-82.pdf
13004 13004 2018-02-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Fleming, Patrick     https://efile.fara.gov/docs/6379-Short-Form-20180206-86.pdf
13005 13005 2018-02-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20180206-84.pdf
22694 22694 2017-03-07 S.G.R. LLC Government Relations and Lobbying 6379 6379 Amendment       https://efile.fara.gov/docs/6379-Amendment-20170307-2.pdf
22695 22695 2017-03-07 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Inovo BV through Flynn Intel Group, Inc. TURKEY https://efile.fara.gov/docs/6379-Exhibit-AB-20170307-3.pdf
22696 22696 2017-03-07 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20170307-38.pdf
22697 22697 2017-03-07 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Smith, Addison     https://efile.fara.gov/docs/6379-Short-Form-20170307-36.pdf
22876 22876 2018-03-08 S.G.R. LLC Government Relations and Lobbying 6379 6379 Amendment       https://efile.fara.gov/docs/6379-Amendment-20180308-3.pdf
22877 22877 2018-03-08 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Exhibit-AB-20180308-7.pdf
26753 26753 2017-03-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20170327-40.pdf
26754 26754 2017-03-27 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20170327-1.pdf
27038 27038 2017-03-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20170328-42.pdf
27039 27039 2017-03-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20170328-44.pdf
38546 38546 2018-04-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20180430-5.pdf
38618 38618 2019-04-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Informational-Materials-20190430-6.pdf
38619 38619 2019-04-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20190430-7.pdf
42106 42106 2018-05-02 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Informational-Materials-20180502-4.pdf
42791 42791 2020-05-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20200506-9.pdf
69796 69796 2020-07-31 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Shulklapper, Max     https://efile.fara.gov/docs/6379-Short-Form-20200731-100.pdf
73986 73986 2019-08-06 S.G.R. LLC Government Relations and Lobbying 6379 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
73987 73987 2019-08-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Bader El-Jeaan through Quinn Emanuel Urquhart & Sullivan, LLP KUWAIT https://efile.fara.gov/docs/6379-Exhibit-AB-20190806-10.pdf
73988 73988 2019-08-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20190806-96.pdf
73989 73989 2019-08-06 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20190806-98.pdf
75833 75833 2017-08-16 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Informational-Materials-20170816-11.pdf
75834 75834 2017-08-16 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/6379-Informational-Materials-20170816-12.pdf
77920 77920 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit AB   Government of Catalonia SPAIN https://efile.fara.gov/docs/6379-Exhibit-AB-20170828-4.pdf
77921 77921 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Abu-Rubieh, Mahmood     https://efile.fara.gov/docs/6379-Short-Form-20170828-46.pdf
77922 77922 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Amundaray, Carla     https://efile.fara.gov/docs/6379-Short-Form-20170828-52.pdf
77923 77923 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20170828-48.pdf
77924 77924 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20170828-50.pdf
77925 77925 2017-08-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Wyatt, Edward     https://efile.fara.gov/docs/6379-Short-Form-20170828-54.pdf
84328 84328 2017-09-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20170912-56.pdf
84329 84329 2017-09-12 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Vitello, Frank     https://efile.fara.gov/docs/6379-Short-Form-20170912-58.pdf
84518 84518 2018-09-13 S.G.R. LLC Government Relations and Lobbying 6379 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
84933 84933 2017-09-15 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Government of Catalonia (Spain) SPAIN https://efile.fara.gov/docs/6379-Informational-Materials-20170915-2.pdf
85922 85922 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 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
85923 85923 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Exhibit C       https://efile.fara.gov/docs/6379-Exhibit-C-20160920-1.pdf
85924 85924 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Registration Statement       https://efile.fara.gov/docs/6379-Registration-Statement-20160920-1.pdf
85925 85925 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Amundaray, Carla     https://efile.fara.gov/docs/6379-Short-Form-20160920-14.pdf
85926 85926 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Courtovich, James C.     https://efile.fara.gov/docs/6379-Short-Form-20160920-2.pdf
85927 85927 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Kelly, John     https://efile.fara.gov/docs/6379-Short-Form-20160920-18.pdf
85928 85928 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Looney, Scott     https://efile.fara.gov/docs/6379-Short-Form-20160920-16.pdf
85929 85929 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20160920-4.pdf
85930 85930 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20160920-6.pdf
85931 85931 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Smith, Addison     https://efile.fara.gov/docs/6379-Short-Form-20160920-8.pdf
85932 85932 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Walling, Chris     https://efile.fara.gov/docs/6379-Short-Form-20160920-10.pdf
85933 85933 2016-09-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Wyatt, Edward     https://efile.fara.gov/docs/6379-Short-Form-20160920-12.pdf
87703 87703 2017-09-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Fleming, Patrick     https://efile.fara.gov/docs/6379-Short-Form-20170928-60.pdf
87704 87704 2017-09-28 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Fleming, Patrick     https://efile.fara.gov/docs/6379-Short-Form-20170928-62.pdf
93142 93142 2018-10-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Argueta, Eduardo Jose Frances     https://efile.fara.gov/docs/6379-Short-Form-20181005-88.pdf
93143 93143 2018-10-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Lowman, Greg     https://efile.fara.gov/docs/6379-Short-Form-20181005-90.pdf
93144 93144 2018-10-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Mandelbaum, Aaron C.     https://efile.fara.gov/docs/6379-Short-Form-20181005-94.pdf
93145 93145 2018-10-05 S.G.R. LLC Government Relations and Lobbying 6379 6379 Short-Form Miller, James G.     https://efile.fara.gov/docs/6379-Short-Form-20181005-92.pdf
97689 97689 2019-10-29 S.G.R. LLC Government Relations and Lobbying 6379 6379 Informational Materials   Embassy of the State of Qatar through Venable LLP QATAR https://efile.fara.gov/docs/6379-Informational-Materials-20191029-9.pdf
98104 98104 2018-10-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20181030-6.pdf
98151 98151 2019-10-30 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20191030-8.pdf
99084 99084 2017-10-31 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20171031-2.pdf
105583 105583 2020-11-20 S.G.R. LLC Government Relations and Lobbying 6379 6379 Supplemental Statement       https://efile.fara.gov/docs/6379-Supplemental-Statement-20201120-10.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)
);