home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for FARA_All_RegistrantDocs
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

20 rows where Document_Type = "Supplemental Statement" and Registration_Number = 6170

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 2

  • Mercury Public Affairs, LLC 10
  • Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 10

Foreign_Principal_Name 1

  • - 20

Foreign_Principal_Country 1

  • - 20

Document_Type 1

  • Supplemental Statement · 20 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
8763 8763 2021-01-29 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20210129-16.pdf
9368 9368 2022-01-30 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20220130-19.pdf
16414 16414 2023-02-14 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20230214-21.pdf
66728 66728 2016-06-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20160622-6.pdf
67989 67989 2014-06-27 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20140627-2.pdf
68296 68296 2019-06-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20190628-13.pdf
68672 68672 2015-06-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20150629-4.pdf
68700 68700 2017-06-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20170629-8.pdf
73603 73603 2018-07-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20180702-10.pdf
78243 78243 2021-07-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20210723-17.pdf
80612 80612 2020-07-30 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20200730-15.pdf
80705 80705 2023-07-30 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20230730-22.pdf
88602 88602 2022-08-19 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20220819-20.pdf
130702 130702 2016-12-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20161213-7.pdf
132018 132018 2013-12-19 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20131219-1.pdf
132292 132292 2017-12-20 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20171220-9.pdf
133266 133266 2019-12-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20191223-14.pdf
133940 133940 2015-12-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20151228-5.pdf
134214 134214 2014-12-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20141229-3.pdf
134246 134246 2018-12-29 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20181229-11.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])
);
Powered by Datasette · Queries took 770.031ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history