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

938 rows where Registration_Number = 6170

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
2910 2015-01-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20150102-7.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
2923 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
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
3086 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
3558 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
3559 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
3560 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
3561 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
3562 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form Flotteron, Nicole     https://efile.fara.gov/docs/6170-Short-Form-20200106-544.pdf
3563 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Short-Form McCaleb, Ian     https://efile.fara.gov/docs/6170-Short-Form-20200106-542.pdf
3696 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
3697 2019-01-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lapham, Elizabeth     https://efile.fara.gov/docs/6170-Short-Form-20190107-306.pdf
3698 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
3845 2020-01-08 6170 6170 6170 Informational Materials   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB BIAFRA https://efile.fara.gov/docs/6170-Informational-Materials-20200108-319.pdf
3846 2020-01-08 6170 6170 6170 Informational Materials   Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB BIAFRA https://efile.fara.gov/docs/6170-Informational-Materials-20200108-320.pdf
3848 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Denselow, Toby     https://efile.fara.gov/docs/6170-Short-Form-20200108-584.pdf
3849 2020-01-08 Mercury Public Affairs, LLC 6170 6170 Short-Form Tucker, George     https://efile.fara.gov/docs/6170-Short-Form-20200108-582.pdf
3962 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
3993 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
3994 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
4008 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
4009 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
4262 2020-01-10 6170 6170 6170 Informational Materials   Government of National Accord Libya, Office of the Prime Minister LIBYA https://efile.fara.gov/docs/6170-Informational-Materials-20200110-317.pdf
4280 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
4281 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
4282 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
4283 2020-01-10 Mercury Public Affairs, LLC 6170 6170 Short-Form Weber, John     https://efile.fara.gov/docs/6170-Short-Form-20200110-588.pdf
4749 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
4750 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
4751 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
4983 2015-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150115-6.pdf
4984 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
5000 2016-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20160115-11.pdf
5001 2016-01-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20160115-15.pdf
5008 2019-01-15 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Turkey - U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190115-39.pdf
5012 2020-01-15 Mercury Public Affairs, LLC 6170 6170 Short-Form Gallagher, John     https://efile.fara.gov/docs/6170-Short-Form-20200115-546.pdf
5142 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
5148 2019-01-16 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://efile.fara.gov/docs/6170-Informational-Materials-20190116-47.pdf
5253 2019-01-17 mercury 6170 6170 Informational Materials   Presidency of the Republic of Haiti (through Mercury International UK Ltd) HAITI https://efile.fara.gov/docs/6170-Informational-Materials-20190117-45.pdf
5260 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
5801 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
5954 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
6146 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
6147 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200123-560.pdf
6148 2020-01-23 Mercury Public Affairs, LLC 6170 6170 Short-Form Stach, Deirdre     https://efile.fara.gov/docs/6170-Short-Form-20200123-562.pdf
6345 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
6346 2020-01-24 Mercury Public Affairs, LLC 6170 6170 Short-Form Rynsard, Louis     https://efile.fara.gov/docs/6170-Short-Form-20200124-548.pdf
6682 2020-01-26 6170 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200126-318.pdf
6872 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
6873 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
6874 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
6875 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20200127-558.pdf
6876 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Kredisova, Anna     https://efile.fara.gov/docs/6170-Short-Form-20200127-552.pdf
6877 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
6878 2020-01-27 Mercury Public Affairs, LLC 6170 6170 Short-Form Vilkos, Yulianna     https://efile.fara.gov/docs/6170-Short-Form-20200127-556.pdf
7117 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
7141 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
7142 2020-01-28 Mercury Public Affairs, LLC 6170 6170 Short-Form Arnaldo, Zharina     https://efile.fara.gov/docs/6170-Short-Form-20200128-564.pdf
7326 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
7419 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200129-72.pdf
7420 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
7421 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
7823 2017-01-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170130-20.pdf
7824 2017-01-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6170-Exhibit-AB-20170130-21.pdf
7882 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
7939 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.pdf
7940 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
7941 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
7942 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
7943 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Short-Form Tomlin, John     https://efile.fara.gov/docs/6170-Short-Form-20200130-566.pdf
8863 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
8864 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
8865 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200131-568.pdf
11889 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-54.pdf
11890 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-55.pdf
11891 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
11892 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
11893 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20190201-312.pdf
12257 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
12258 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
12435 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
12451 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
12452 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
12453 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Eibensteiner, Hannah     https://efile.fara.gov/docs/6170-Short-Form-20190204-318.pdf
12454 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
12475 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
12476 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
12477 2020-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200204-570.pdf
12675 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
12676 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Kimmelman, Alicia     https://efile.fara.gov/docs/6170-Short-Form-20200205-572.pdf
12677 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20200205-574.pdf
12872 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
13032 2019-02-07 Mercury Public Affairs, LLC 6170 6170 Informational Materials   Lord Gregory Barker of Battle PC RUSSIA https://efile.fara.gov/docs/6170-Informational-Materials-20190207-46.pdf
13043 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-74.pdf
13044 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-75.pdf
13045 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
13046 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Short-Form Lanza, Bryan     https://efile.fara.gov/docs/6170-Short-Form-20200207-576.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 667.401ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history