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

18 rows where Registration_Number = 6376

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 2

Foreign_Principal_Country 2

Registrant_Name 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
66482 66482 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Blank, Spenser     https://efile.fara.gov/docs/6376-Short-Form-20170621-28.pdf
66483 66483 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Colon, Carol Lyn     https://efile.fara.gov/docs/6376-Short-Form-20170621-22.pdf
66484 66484 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Fillip, Chris     https://efile.fara.gov/docs/6376-Short-Form-20170621-24.pdf
66485 66485 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Moeller, James     https://efile.fara.gov/docs/6376-Short-Form-20170621-20.pdf
66486 66486 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Schwartz, Robert     https://efile.fara.gov/docs/6376-Short-Form-20170621-26.pdf
66487 66487 2017-06-21 Ogilvy Public Relations Ogilvy Public Relations 6376 Supplemental Statement       https://efile.fara.gov/docs/6376-Supplemental-Statement-20170621-1.pdf
98006 98006 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Exhibit AB   Gabonese Republic GABON https://efile.fara.gov/docs/6376-Exhibit-AB-20160915-1.pdf
98007 98007 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Exhibit C       https://efile.fara.gov/docs/6376-Exhibit-C-20160915-1.pdf
98008 98008 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Registration Statement       https://efile.fara.gov/docs/6376-Registration-Statement-20160915-1.pdf
98009 98009 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Bundred, Iain     https://efile.fara.gov/docs/6376-Short-Form-20160915-2.pdf
98010 98010 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form King, Benjamin     https://efile.fara.gov/docs/6376-Short-Form-20160915-4.pdf
98011 98011 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Mullins, Tara     https://efile.fara.gov/docs/6376-Short-Form-20160915-6.pdf
98012 98012 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Risi, Jennifer     https://efile.fara.gov/docs/6376-Short-Form-20160915-8.pdf
98013 98013 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Rosenthal, David     https://efile.fara.gov/docs/6376-Short-Form-20160915-10.pdf
98014 98014 2016-09-15 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Stewart, James     https://efile.fara.gov/docs/6376-Short-Form-20160915-12.pdf
108340 108340 2016-10-12 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Ludlum, Nicholas     https://efile.fara.gov/docs/6376-Short-Form-20161012-16.pdf
108341 108341 2016-10-12 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Rios, Michelle Corrigan     https://efile.fara.gov/docs/6376-Short-Form-20161012-14.pdf
108342 108342 2016-10-12 Ogilvy Public Relations Ogilvy Public Relations 6376 Short-Form Valeriano, Julio M.     https://efile.fara.gov/docs/6376-Short-Form-20161012-18.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])
);