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 Document_Type = "Supplemental Statement" and Registrant_Name = "Ogilvy Public Relations Worldwide"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Registrant_Name 1

  • Ogilvy Public Relations Worldwide · 18 ✖

Foreign_Principal_Name 1

  • - 18

Foreign_Principal_Country 1

  • - 18

Document_Type 1

  • Supplemental Statement · 18 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5258 5258 2016-01-13 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20160113-17.pdf
68234 68234 2013-06-28 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20130628-12.pdf
68661 68661 2012-06-29 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20120629-10.pdf
70052 70052 2010-06-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20100630-6.pdf
70075 70075 2011-06-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20110630-8.pdf
70098 70098 2014-06-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20140630-14.pdf
70140 70140 2015-06-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20150630-16.pdf
73355 73355 2008-07-01 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20080701-2.pdf
73572 73572 2009-07-02 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20090702-4.pdf
88341 88341 2016-08-18 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20160818-18.pdf
132223 132223 2010-12-20 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20101220-7.pdf
132564 132564 2012-12-21 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20121221-11.pdf
132891 132891 2009-12-22 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20091222-5.pdf
133158 133158 2008-12-23 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20081223-3.pdf
133213 133213 2013-12-23 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20131223-13.pdf
134587 134587 2011-12-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20111230-9.pdf
134633 134633 2014-12-30 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20141230-15.pdf
135747 135747 2007-12-31 Ogilvy Public Relations Worldwide Ogilvy Public Relations Worldwide 5807 Supplemental Statement       https://efile.fara.gov/docs/5807-Supplemental-Statement-20071231-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])
);