FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
44 rows where Document_Type = "Amendment" and Registrant_Name = "Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country 1
- - 44
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
80429 | 80429 | 2014-07-30 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20140730-4.pdf | |||
84863 | 84863 | 2013-08-02 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20130802-1.pdf | |||
88537 | 88537 | 2016-08-19 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20160819-12.pdf | |||
97780 | 97780 | 2017-09-14 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20170914-37.pdf | |||
109159 | 109159 | 2015-10-16 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20151016-9.pdf | |||
109574 | 109574 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-13.pdf | |||
109575 | 109575 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-14.pdf | |||
109576 | 109576 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-15.pdf | |||
109577 | 109577 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-16.pdf | |||
109578 | 109578 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-17.pdf | |||
109579 | 109579 | 2016-10-18 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161018-18.pdf | |||
121598 | 121598 | 2015-11-24 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20151124-10.pdf | |||
122542 | 122542 | 2016-11-29 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20161129-19.pdf | |||
130350 | 130350 | 2013-12-11 | Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20131211-2.pdf |
Advanced export
JSON shape: default, array, newline-delimited
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]) );