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

861 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
3556 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
3557 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
3558 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
3559 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
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
3694 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
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
3841 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
3842 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
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
3989 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
3990 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
4004 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
4005 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
4258 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
4276 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
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
4745 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
4746 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
4747 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
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
4997 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
5004 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
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
5144 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
5249 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
5256 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
5796 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
5949 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
6141 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
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
6340 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
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
6677 2020-01-26 6170 6170 6170 Informational Materials   Q Cyber Technologies Ltd ISRAEL https://efile.fara.gov/docs/6170-Informational-Materials-20200126-318.pdf
6867 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
6868 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
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
7112 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
7136 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
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
7415 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
7416 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
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
7819 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
7877 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
7935 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.pdf
7936 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
7937 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
7938 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
7939 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Short-Form Tomlin, John     https://efile.fara.gov/docs/6170-Short-Form-20200130-566.pdf
8859 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
8860 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
8861 2020-01-31 Mercury Public Affairs, LLC 6170 6170 Short-Form Lefkowitz, Trent     https://efile.fara.gov/docs/6170-Short-Form-20200131-568.pdf
11885 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-54.pdf
11886 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190201-55.pdf
11887 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
11888 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
11889 2019-02-01 Mercury Public Affairs, LLC 6170 6170 Short-Form Emery, Rodney     https://efile.fara.gov/docs/6170-Short-Form-20190201-312.pdf
12253 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
12254 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
12431 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 Informational Materials   Embassy of Republic of Turkey through Amsterdam & Partners, LLP TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20190204-43.pdf
12448 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
12449 2019-02-04 Mercury Public Affairs, LLC 6170 6170 Short-Form Eibensteiner, Hannah     https://efile.fara.gov/docs/6170-Short-Form-20190204-318.pdf
12450 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
12471 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
12472 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
12473 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 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20200205-273.pdf
12672 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Kimmelman, Alicia     https://efile.fara.gov/docs/6170-Short-Form-20200205-572.pdf
12673 2020-02-05 Mercury Public Affairs, LLC 6170 6170 Short-Form Vitter, David     https://efile.fara.gov/docs/6170-Short-Form-20200205-574.pdf
12868 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
13028 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
13039 2020-02-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200207-74.pdf
13040 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 Exhibit AB   Embassy of the Republic of Turkey TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20200207-77.pdf
13042 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 609.462ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history