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

161 rows where Document_Type = "Amendment" and Registration_Number = 6170

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Registrant_Name 2

  • Mercury Public Affairs, LLC 117
  • Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 44

Foreign_Principal_Name 1

  • - 161

Foreign_Principal_Country 1

  • - 161

Document_Type 1

  • Amendment · 161 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
2930 2930 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150102-5.pdf
3138 3138 2022-01-03 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220103-124.pdf
3728 3728 2020-01-06 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
4337 4337 2023-01-09 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230109-153.pdf
5077 5077 2021-01-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210112-93.pdf
5589 5589 2015-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150115-6.pdf
5606 5606 2016-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20160115-11.pdf
8066 8066 2022-01-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220127-125.pdf
8067 8067 2022-01-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220127-126.pdf
8068 8068 2022-01-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220127-127.pdf
8723 8723 2020-01-29 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200129-72.pdf
9199 9199 2017-01-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170130-20.pdf
9315 9315 2020-01-30 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.pdf
13447 13447 2019-02-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-54.pdf
13448 13448 2019-02-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-55.pdf
13493 13493 2022-02-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220201-128.pdf
13748 13748 2022-02-02 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220202-129.pdf
14894 14894 2020-02-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-74.pdf
14895 14895 2020-02-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-75.pdf
15341 15341 2021-02-09 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210209-94.pdf
16121 16121 2019-02-13 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190213-56.pdf
18032 18032 2021-02-22 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210222-95.pdf
18361 18361 2023-02-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230223-154.pdf
18593 18593 2022-02-24 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220224-130.pdf
18594 18594 2022-02-24 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220224-131.pdf
19343 19343 2017-02-27 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170227-21.pdf
19439 19439 2023-02-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230227-155.pdf
19440 19440 2023-02-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230227-156.pdf
20187 20187 2022-02-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220228-132.pdf
24151 24151 2018-03-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180301-39.pdf
24296 24296 2023-03-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230301-157.pdf
25031 25031 2023-03-03 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230303-158.pdf
25444 25444 2018-03-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180305-38.pdf
26481 26481 2017-03-09 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170309-22.pdf
26900 26900 2022-03-10 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220310-133.pdf
27148 27148 2019-03-11 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190311-57.pdf
27407 27407 2021-03-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210312-98.pdf
27408 27408 2021-03-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210312-99.pdf
27586 27586 2018-03-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180313-40.pdf
27639 27639 2020-03-13 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200313-76.pdf
28504 28504 2020-03-16 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200316-77.pdf
29559 29559 2019-03-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190320-58.pdf
29597 29597 2023-03-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230320-159.pdf
30010 30010 2017-03-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170322-23.pdf
30805 30805 2021-03-25 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210325-100.pdf
31064 31064 2020-03-26 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200326-78.pdf
37998 37998 2019-04-05 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190405-59.pdf
38237 38237 2017-04-06 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170406-24.pdf
38281 38281 2021-04-06 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210406-101.pdf
38827 38827 2021-04-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210408-102.pdf
38828 38828 2021-04-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210408-103.pdf
38829 38829 2021-04-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210408-104.pdf
39310 39310 2019-04-10 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190410-62.pdf
39539 39539 2019-04-11 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190411-61.pdf
39553 39553 2020-04-11 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200411-79.pdf
39763 39763 2019-04-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190412-60.pdf
39960 39960 2017-04-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170413-25.pdf
40249 40249 2021-04-14 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210414-105.pdf
41028 41028 2019-04-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190417-64.pdf
41029 41029 2019-04-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190417-65.pdf
41614 41614 2022-04-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220420-134.pdf
41615 41615 2022-04-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220420-135.pdf
43068 43068 2019-04-26 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190426-63.pdf
43713 43713 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-26.pdf
43714 43714 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-27.pdf
43715 43715 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-28.pdf
43716 43716 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-29.pdf
43717 43717 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-30.pdf
43718 43718 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-31.pdf
43719 43719 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-32.pdf
43799 43799 2022-04-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220428-136.pdf
48552 48552 2015-05-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150501-7.pdf
48610 48610 2020-05-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200501-80.pdf
49576 49576 2017-05-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170505-33.pdf
52008 52008 2021-05-14 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210514-106.pdf
52235 52235 2018-05-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180515-41.pdf
53455 53455 2015-05-20 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150520-8.pdf
54002 54002 2019-05-22 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190522-66.pdf
54439 54439 2017-05-24 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170524-34.pdf
54791 54791 2018-05-25 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180525-42.pdf
55033 55033 2020-05-26 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200526-81.pdf
55582 55582 2020-05-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200528-82.pdf
61920 61920 2018-06-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180601-44.pdf
62883 62883 2018-06-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180605-43.pdf
64700 64700 2023-06-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230612-160.pdf
64846 64846 2017-06-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170613-35.pdf
67025 67025 2021-06-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210623-107.pdf
67696 67696 2017-06-26 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170626-36.pdf
68305 68305 2020-06-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200628-83.pdf
68363 68363 2023-06-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230628-161.pdf
70367 70367 2023-06-30 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230630-162.pdf
74024 74024 2022-07-05 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220705-137.pdf
74467 74467 2020-07-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200707-84.pdf
74956 74956 2020-07-09 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200709-85.pdf
76726 76726 2018-07-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180717-45.pdf
76964 76964 2022-07-18 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20220718-138.pdf
77987 77987 2014-07-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20140722-3.pdf
79659 79659 2021-07-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210728-108.pdf
79660 79660 2021-07-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210728-109.pdf
79740 79740 2023-07-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20230728-163.pdf

Next page

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 740.751ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows