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

899 rows where Registration_Number = 6170 sorted by Foreign_Principal_Country

View and edit SQL

Suggested facets: Date_Stamped (date)

Link rowid Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country ▼ URL
2909 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150102-5.pdf
2911 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Ereli, Adam     https://efile.fara.gov/docs/6170-Short-Form-20150102-52.pdf
2912 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Weber, John Vincent     https://efile.fara.gov/docs/6170-Short-Form-20150102-54.pdf
3081 2019-01-03 Mercury Public Affairs, LLC 6170 6170 Short-Form Tayla, Suheyla     https://efile.fara.gov/docs/6170-Short-Form-20190103-304.pdf
3556 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
3560 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form Flotteron, Nicole     https://efile.fara.gov/docs/6170-Short-Form-20200106-544.pdf
3561 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form McCaleb, Ian     https://efile.fara.gov/docs/6170-Short-Form-20200106-542.pdf
3695 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lapham, Elizabeth     https://efile.fara.gov/docs/6170-Short-Form-20190107-306.pdf
3696 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Petrone, Brent James     https://efile.fara.gov/docs/6170-Short-Form-20190107-308.pdf
3844 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Denselow, Toby     https://efile.fara.gov/docs/6170-Short-Form-20200108-584.pdf
3845 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Tucker, George     https://efile.fara.gov/docs/6170-Short-Form-20200108-582.pdf
3958 2015-01-09 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Braden, Mark     https://efile.fara.gov/docs/6170-Short-Form-20150109-56.pdf
4277 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Bank, Daniel Marc     https://efile.fara.gov/docs/6170-Short-Form-20200110-590.pdf
4278 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Deschauer, John Anthony     https://efile.fara.gov/docs/6170-Short-Form-20200110-586.pdf
4279 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Weber, John     https://efile.fara.gov/docs/6170-Short-Form-20200110-588.pdf
4979 2015-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150115-6.pdf
4980 2015-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Frillici, Vincent     https://efile.fara.gov/docs/6170-Short-Form-20150115-58.pdf
4996 2016-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20160115-11.pdf
5008 2020-01-15 Mercury Public Affairs, LLC 6170 6170 Short-Form Gallagher, John     https://efile.fara.gov/docs/6170-Short-Form-20200115-546.pdf
5138 2018-01-16 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Pelton, Erin     https://efile.fara.gov/docs/6170-Short-Form-20180116-146.pdf
6142 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200123-560.pdf
6143 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Stach, Deirdre     https://efile.fara.gov/docs/6170-Short-Form-20200123-562.pdf
6341 2020-01-24 Mercury Public Affairs, LLC 6170 6170 Short-Form Rynsard, Louis     https://efile.fara.gov/docs/6170-Short-Form-20200124-548.pdf
6869 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Artunkal, Nijat Tahsin Can     https://efile.fara.gov/docs/6170-Short-Form-20200127-550.pdf
6870 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20200127-558.pdf
6871 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Kredisova, Anna     https://efile.fara.gov/docs/6170-Short-Form-20200127-552.pdf
6872 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Tritton, Benjamin Westlake     https://efile.fara.gov/docs/6170-Short-Form-20200127-554.pdf
6873 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Vilkos, Yulianna     https://efile.fara.gov/docs/6170-Short-Form-20200127-556.pdf
7137 2020-01-28 Mercury Public Affairs, LLC 6170 6170 Short-Form Arnaldo, Zharina     https://efile.fara.gov/docs/6170-Short-Form-20200128-564.pdf
7321 2015-01-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Soliman, Michael     https://efile.fara.gov/docs/6170-Short-Form-20150129-62.pdf
7414 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200129-72.pdf
7818 2017-01-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170130-20.pdf
7934 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.pdf
7938 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Short-Form Tomlin, John     https://efile.fara.gov/docs/6170-Short-Form-20200130-566.pdf
8860 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200131-568.pdf
11884 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-54.pdf
11885 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-55.pdf
11888 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20190201-312.pdf
12430 2016-02-04 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Threadgill, Tyler     https://efile.fara.gov/docs/6170-Short-Form-20160204-94.pdf
12447 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Dumas, Mamyrah Erica     https://efile.fara.gov/docs/6170-Short-Form-20190204-314.pdf
12448 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Eibensteiner, Hannah     https://efile.fara.gov/docs/6170-Short-Form-20190204-318.pdf
12449 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form King, Charles Gordon     https://efile.fara.gov/docs/6170-Short-Form-20190204-316.pdf
12472 2020-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200204-570.pdf
12671 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Kimmelman, Alicia     https://efile.fara.gov/docs/6170-Short-Form-20200205-572.pdf
12672 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20200205-574.pdf
13038 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-74.pdf
13039 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-75.pdf
13041 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200207-576.pdf
13774 2015-02-12 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Lewis, Katherine     https://efile.fara.gov/docs/6170-Short-Form-20150212-64.pdf
13801 2019-02-12 Mercury Public Affairs, LLC 6170 6170 Short-Form McKeon, Michael     https://efile.fara.gov/docs/6170-Short-Form-20190212-320.pdf
13961 2019-02-13 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190213-56.pdf
15090 2020-02-20 Mercury Public Affairs, LLC 6170 6170 Short-Form Melli, Juan     https://efile.fara.gov/docs/6170-Short-Form-20200220-578.pdf
15438 2018-02-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20180222-148.pdf
15439 2018-02-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Reid, Morris L.     https://efile.fara.gov/docs/6170-Short-Form-20180222-152.pdf
15440 2018-02-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Toomey, Molly     https://efile.fara.gov/docs/6170-Short-Form-20180222-150.pdf
15585 2017-02-23 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20170223-114.pdf
15609 2018-02-23 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Alvarez, Danielle Marie     https://efile.fara.gov/docs/6170-Short-Form-20180223-154.pdf
15610 2018-02-23 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Reid, Morris L.     https://efile.fara.gov/docs/6170-Short-Form-20180223-158.pdf
15611 2018-02-23 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Toomey, Molly     https://efile.fara.gov/docs/6170-Short-Form-20180223-156.pdf
16219 2020-02-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Yousef, Asma     https://efile.fara.gov/docs/6170-Short-Form-20200226-580.pdf
16466 2017-02-27 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170227-21.pdf
21128 2017-03-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Reid, Morris     https://efile.fara.gov/docs/6170-Short-Form-20170301-120.pdf
21129 2017-03-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20170301-116.pdf
21141 2018-03-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180301-39.pdf
22047 2018-03-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180305-38.pdf
22067 2019-03-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Reid, Lisa H.     https://efile.fara.gov/docs/6170-Short-Form-20190305-322.pdf
22547 2019-03-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Arnavat, Gustavo     https://efile.fara.gov/docs/6170-Short-Form-20190307-324.pdf
22668 2017-03-08 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Dilemani, Jake     https://efile.fara.gov/docs/6170-Short-Form-20170308-122.pdf
22857 2017-03-09 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170309-22.pdf
22859 2017-03-09 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Toomey, Molly     https://efile.fara.gov/docs/6170-Short-Form-20170309-124.pdf
23115 2019-03-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Braden, Mark     https://efile.fara.gov/docs/6170-Short-Form-20190310-332.pdf
23116 2019-03-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Eibensteiner, Hannah     https://efile.fara.gov/docs/6170-Short-Form-20190310-330.pdf
23117 2019-03-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Garcia, Jose Antonio     https://efile.fara.gov/docs/6170-Short-Form-20190310-334.pdf
23118 2019-03-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20190310-336.pdf
23338 2019-03-11 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190311-57.pdf
23339 2019-03-11 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20190311-328.pdf
23340 2019-03-11 Mercury Public Affairs, LLC 6170 6170 Short-Form King, Charles Gordon     https://efile.fara.gov/docs/6170-Short-Form-20190311-326.pdf
23680 2018-03-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180313-40.pdf
23681 2018-03-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20180313-160.pdf
23733 2020-03-13 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200313-76.pdf
24365 2016-03-16 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Cpin, John     https://efile.fara.gov/docs/6170-Short-Form-20160316-96.pdf
24366 2016-03-16 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Toomey, Molly     https://efile.fara.gov/docs/6170-Short-Form-20160316-98.pdf
24404 2020-03-16 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200316-77.pdf
24531 2016-03-17 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Copper, Tarrah     https://efile.fara.gov/docs/6170-Short-Form-20160317-100.pdf
25151 2019-03-20 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190320-58.pdf
25529 2017-03-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170322-23.pdf
26337 2020-03-26 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200326-78.pdf
26853 2019-03-28 Mercury Public Affairs, LLC 6170 6170 Short-Form Smith II, Robert Leverett     https://efile.fara.gov/docs/6170-Short-Form-20190328-338.pdf
27067 2018-03-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Garcia, Jose Antonio     https://efile.fara.gov/docs/6170-Short-Form-20180329-178.pdf
27087 2019-03-29 Mercury Public Affairs, LLC 6170 6170 Short-Form Murphy, Christopher     https://efile.fara.gov/docs/6170-Short-Form-20190329-340.pdf
27088 2019-03-29 Mercury Public Affairs, LLC 6170 6170 Short-Form Smith II, Robert Leverett     https://efile.fara.gov/docs/6170-Short-Form-20190329-344.pdf
31827 2019-04-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20190401-350.pdf
31828 2019-04-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Lonergan, John     https://efile.fara.gov/docs/6170-Short-Form-20190401-346.pdf
31829 2019-04-01 Mercury Public Affairs, LLC 6170 6170 Short-Form McSherry, Michael     https://efile.fara.gov/docs/6170-Short-Form-20190401-348.pdf
31972 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Braden, Mark     https://efile.fara.gov/docs/6170-Short-Form-20180402-162.pdf
31973 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Hernandez, Michael Anthony     https://efile.fara.gov/docs/6170-Short-Form-20180402-182.pdf
31974 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Kaufmann, Jennifer     https://efile.fara.gov/docs/6170-Short-Form-20180402-192.pdf
31975 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Lewis, Katherine     https://efile.fara.gov/docs/6170-Short-Form-20180402-172.pdf
31976 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Otterbacher, Kaylee     https://efile.fara.gov/docs/6170-Short-Form-20180402-166.pdf
31977 2018-04-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Short-Form Pelton, Erin     https://efile.fara.gov/docs/6170-Short-Form-20180402-190.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 · Query took 915.121ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history