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

21 rows where Registration_Number = 6585

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Foreign_Principal_Name

Foreign_Principal_Country 3

Registrant_Name 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
29561 29561 2019-03-20 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Exhibit AB   China Telecom Americas CHINA https://efile.fara.gov/docs/6585-Exhibit-AB-20190320-4.pdf
31912 31912 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Baumann, Terri     https://efile.fara.gov/docs/6585-Short-Form-20190329-16.pdf
31913 31913 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Dickson, Madeline     https://efile.fara.gov/docs/6585-Short-Form-20190329-14.pdf
31914 31914 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form MacKay, David     https://efile.fara.gov/docs/6585-Short-Form-20190329-22.pdf
31915 31915 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Romero, Andrea     https://efile.fara.gov/docs/6585-Short-Form-20190329-20.pdf
31916 31916 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Rouse, Mary Campbell     https://efile.fara.gov/docs/6585-Short-Form-20190329-18.pdf
31917 31917 2019-03-29 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Supplemental Statement       https://efile.fara.gov/docs/6585-Supplemental-Statement-20190329-1.pdf
90900 90900 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Exhibit AB   Qatar Foundation QATAR https://efile.fara.gov/docs/6585-Exhibit-AB-20180830-3.pdf
90901 90901 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Exhibit C       https://efile.fara.gov/docs/6585-Exhibit-C-20180830-1.pdf
90902 90902 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Registration Statement       https://efile.fara.gov/docs/6585-Registration-Statement-20180830-1.pdf
90903 90903 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Chambliss, Corey     https://efile.fara.gov/docs/6585-Short-Form-20180830-2.pdf
90904 90904 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Risi, Jennifer     https://efile.fara.gov/docs/6585-Short-Form-20180830-4.pdf
90905 90905 2018-08-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Treganowan, Kathleen     https://efile.fara.gov/docs/6585-Short-Form-20180830-6.pdf
100709 100709 2019-09-26 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Merritt, Matthew     https://efile.fara.gov/docs/6585-Short-Form-20190926-26.pdf
100710 100710 2019-09-26 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Mullen, Kellie     https://efile.fara.gov/docs/6585-Short-Form-20190926-28.pdf
100711 100711 2019-09-26 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Stavk, Betsy     https://efile.fara.gov/docs/6585-Short-Form-20190926-24.pdf
100958 100958 2019-09-27 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Brylow, Lindsey     https://efile.fara.gov/docs/6585-Short-Form-20190927-30.pdf
101247 101247 2018-09-28 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Mullins, Tara     https://efile.fara.gov/docs/6585-Short-Form-20180928-8.pdf
101248 101248 2018-09-28 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Sfikas, Athanasia     https://efile.fara.gov/docs/6585-Short-Form-20180928-10.pdf
102606 102606 2019-09-30 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Supplemental Statement       https://efile.fara.gov/docs/6585-Supplemental-Statement-20190930-2.pdf
109860 109860 2018-10-19 Ogilvy Group, LLC Ogilvy Group, LLC 6585 Short-Form Harrison, Melissa     https://efile.fara.gov/docs/6585-Short-Form-20181019-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])
);