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

656 rows where Registrant_Name = "Mercury Public Affairs, LLC"

View and edit SQL

Foreign_Principal_Country

Registrant_Name

  • Mercury Public Affairs, LLC · 656
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
2926 2019-01-02 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey - U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190102-51.pdf
3090 2019-01-03 Mercury Public Affairs, LLC 6170 6170 Short-Form Tayla, Suheyla     https://efile.fara.gov/docs/6170-Short-Form-20190103-304.pdf
3095 2020-01-03 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200103-247.pdf
3414 2021-01-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Myagkova, Ekaterina     https://efile.fara.gov/docs/6170-Short-Form-20210105-640.pdf
3610 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
3611 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Exhibit-AB-20200106-74.pdf
3612 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200106-249.pdf
3613 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200106-261.pdf
3614 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form Flotteron, Nicole     https://efile.fara.gov/docs/6170-Short-Form-20200106-544.pdf
3615 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form McCaleb, Ian     https://efile.fara.gov/docs/6170-Short-Form-20200106-542.pdf
3763 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://efile.fara.gov/docs/6170-Informational-Materials-20190107-50.pdf
3764 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lapham, Elizabeth     https://efile.fara.gov/docs/6170-Short-Form-20190107-306.pdf
3765 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
3940 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Denselow, Toby     https://efile.fara.gov/docs/6170-Short-Form-20200108-584.pdf
3941 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Tucker, George     https://efile.fara.gov/docs/6170-Short-Form-20200108-582.pdf
3977 2021-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Boxer, Barbara     https://efile.fara.gov/docs/6170-Short-Form-20210108-642.pdf
4116 2019-01-09 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190109-52.pdf
4117 2019-01-09 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://efile.fara.gov/docs/6170-Informational-Materials-20190109-41.pdf
4131 2020-01-09 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200109-250.pdf
4132 2020-01-09 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200109-251.pdf
4417 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20200110-78.pdf
4418 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
4419 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
4420 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Weber, John     https://efile.fara.gov/docs/6170-Short-Form-20200110-588.pdf
4781 2021-01-12 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210112-93.pdf
4930 2020-01-13 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200113-259.pdf
4931 2020-01-13 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200113-260.pdf
4932 2020-01-13 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Informational-Materials-20200113-252.pdf
5096 2019-01-14 Mercury Public Affairs, LLC 6170 6170 Short-Form Garcia, Jose Antonio     https://efile.fara.gov/docs/6170-Short-Form-20190114-626.pdf
5097 2019-01-14 Mercury Public Affairs, LLC 6170 6170 Short-Form Pelton, Erin     https://efile.fara.gov/docs/6170-Short-Form-20190114-624.pdf
5218 2020-01-15 Mercury Public Affairs, LLC 6170 6170 Short-Form Gallagher, John     https://efile.fara.gov/docs/6170-Short-Form-20200115-546.pdf
5508 2020-01-17 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200117-253.pdf
5959 2021-01-20 Mercury Public Affairs, LLC 6170 6170 Short-Form Passe-Rodriguez, Djenny     https://efile.fara.gov/docs/6170-Short-Form-20210120-644.pdf
6106 2020-01-21 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB BIAFRA https://efile.fara.gov/docs/6170-Informational-Materials-20200121-255.pdf
6278 2020-01-22 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200122-243.pdf
6331 2021-01-22 Mercury Public Affairs, LLC 6170 6170 Short-Form Denselow, Toby     https://efile.fara.gov/docs/6170-Short-Form-20210122-646.pdf
6525 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200123-242.pdf
6526 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200123-560.pdf
6527 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Stach, Deirdre     https://efile.fara.gov/docs/6170-Short-Form-20200123-562.pdf
6732 2020-01-24 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200124-245.pdf
6733 2020-01-24 Mercury Public Affairs, LLC 6170 6170 Short-Form Rynsard, Louis     https://efile.fara.gov/docs/6170-Short-Form-20200124-548.pdf
7141 2021-01-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Cockfield, Amaris     https://efile.fara.gov/docs/6170-Short-Form-20210126-654.pdf
7142 2021-01-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Garcia, Jose Antonio     https://efile.fara.gov/docs/6170-Short-Form-20210126-648.pdf
7143 2021-01-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Murphy, Christopher     https://efile.fara.gov/docs/6170-Short-Form-20210126-650.pdf
7144 2021-01-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Reid, Morris     https://efile.fara.gov/docs/6170-Short-Form-20210126-658.pdf
7145 2021-01-26 Mercury Public Affairs, LLC 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20210126-652.pdf
7338 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200127-256.pdf
7339 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200127-257.pdf
7340 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
7341 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20200127-558.pdf
7342 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Kredisova, Anna     https://efile.fara.gov/docs/6170-Short-Form-20200127-552.pdf
7343 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
7344 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Vilkos, Yulianna     https://efile.fara.gov/docs/6170-Short-Form-20200127-556.pdf
7607 2019-01-28 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://efile.fara.gov/docs/6170-Informational-Materials-20190128-49.pdf
7630 2020-01-28 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200128-272.pdf
7631 2020-01-28 Mercury Public Affairs, LLC 6170 6170 Short-Form Arnaldo, Zharina     https://efile.fara.gov/docs/6170-Short-Form-20200128-564.pdf
7959 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200129-72.pdf
7960 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB BIAFRA https://efile.fara.gov/docs/6170-Informational-Materials-20200129-271.pdf
7961 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200129-270.pdf
7999 2021-01-29 Mercury Public Affairs, LLC 6170 6170 Supplemental Statement       https://efile.fara.gov/docs/6170-Supplemental-Statement-20210129-16.pdf
8472 2019-01-30 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190130-44.pdf
8529 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.pdf
8530 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20200130-75.pdf
8531 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200130-269.pdf
8532 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200130-267.pdf
8533 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Short-Form Tomlin, John     https://efile.fara.gov/docs/6170-Short-Form-20200130-566.pdf
9486 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200131-268.pdf
9487 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200131-266.pdf
9488 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200131-568.pdf
12520 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-54.pdf
12521 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-55.pdf
12522 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   CRRC MA Corporation CHINA https://efile.fara.gov/docs/6170-Exhibit-AB-20190201-55.pdf
12523 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20190201-56.pdf
12524 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20190201-312.pdf
12926 2020-02-03 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200203-264.pdf
12927 2020-02-03 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200203-265.pdf
13141 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Embassy of Republic of Turkey through Amsterdam & Partners, LLP TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190204-43.pdf
13142 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
13143 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Eibensteiner, Hannah     https://efile.fara.gov/docs/6170-Short-Form-20190204-318.pdf
13144 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
13166 2020-02-04 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Informational-Materials-20200204-263.pdf
13167 2020-02-04 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200204-262.pdf
13168 2020-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200204-570.pdf
13403 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200205-273.pdf
13404 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Kimmelman, Alicia     https://efile.fara.gov/docs/6170-Short-Form-20200205-572.pdf
13405 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20200205-574.pdf
13437 2021-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Artunkal, Nijat Tahsin Can     https://efile.fara.gov/docs/6170-Short-Form-20210205-660.pdf
13628 2020-02-06 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200206-274.pdf
13800 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-74.pdf
13801 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-75.pdf
13802 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20200207-77.pdf
13803 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200207-576.pdf
14156 2021-02-09 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20210209-94.pdf
14309 2020-02-10 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200210-276.pdf
14310 2020-02-10 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Informational-Materials-20200210-275.pdf
14469 2020-02-11 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200211-277.pdf
14648 2019-02-12 Mercury Public Affairs, LLC 6170 6170 Short-Form McKeon, Michael     https://efile.fara.gov/docs/6170-Short-Form-20190212-320.pdf
14656 2020-02-12 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200212-278.pdf
14832 2019-02-13 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190213-56.pdf
14833 2019-02-13 Mercury Public Affairs, LLC 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20190213-57.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])
);