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 URL

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 ▼
72363 2013-08-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20130802-1.pdf
111196 2013-12-11 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20131211-2.pdf
66511 2014-07-22 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20140722-3.pdf
68249 2014-07-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20140730-4.pdf
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
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
41622 2015-05-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150501-7.pdf
45382 2015-05-20 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20150520-8.pdf
93040 2015-10-16 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20151016-9.pdf
103353 2015-11-24 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20151124-10.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
75350 2016-08-19 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20160819-12.pdf
93423 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-13.pdf
93424 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-14.pdf
93425 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-15.pdf
93426 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-16.pdf
93427 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-17.pdf
93428 2016-10-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161018-18.pdf
104165 2016-11-29 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20161129-19.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
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
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
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
32821 2017-04-06 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170406-24.pdf
34222 2017-04-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170413-25.pdf
37158 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-26.pdf
37159 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-27.pdf
37160 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-28.pdf
37161 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-29.pdf
37162 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-30.pdf
37163 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-31.pdf
37164 2017-04-28 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170428-32.pdf
42366 2017-05-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170505-33.pdf
46223 2017-05-24 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170524-34.pdf
55519 2017-06-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170613-35.pdf
57841 2017-06-26 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170626-36.pdf
83386 2017-09-14 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20170914-37.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
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
44428 2018-05-15 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180515-41.pdf
46498 2018-05-25 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180525-42.pdf
53203 2018-06-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180601-44.pdf
53958 2018-06-05 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180605-43.pdf
65559 2018-07-17 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180717-45.pdf
73850 2018-08-09 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180809-46.pdf
75801 2018-08-22 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180822-49.pdf
76109 2018-08-24 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180824-47.pdf
76484 2018-08-27 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180827-48.pdf
84524 2018-09-20 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20180920-50.pdf
92931 2018-10-15 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20181015-51.pdf
92932 2018-10-15 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20181015-52.pdf
93260 2018-10-17 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20181017-53.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
13961 2019-02-13 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190213-56.pdf
23338 2019-03-11 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190311-57.pdf
25151 2019-03-20 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190320-58.pdf
32651 2019-04-05 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190405-59.pdf
33717 2019-04-10 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190410-62.pdf
33905 2019-04-11 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190411-61.pdf
34071 2019-04-12 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190412-60.pdf
35048 2019-04-17 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190417-64.pdf
35049 2019-04-17 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190417-65.pdf
36689 2019-04-26 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190426-63.pdf
45859 2019-05-22 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190522-66.pdf
82643 2019-09-10 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20190910-67.pdf
92771 2019-10-14 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20191014-69.pdf
92948 2019-10-15 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20191015-68.pdf
95211 2019-10-28 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20191028-70.pdf
3556 2020-01-06 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200106-71.pdf
7414 2020-01-29 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200129-72.pdf
7934 2020-01-30 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200130-73.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
23733 2020-03-13 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200313-76.pdf
24404 2020-03-16 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200316-77.pdf
26337 2020-03-26 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200326-78.pdf
33919 2020-04-11 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200411-79.pdf
41680 2020-05-01 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200501-80.pdf
46664 2020-05-26 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200526-81.pdf
47103 2020-05-28 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200528-82.pdf
58346 2020-06-28 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200628-83.pdf
63988 2020-07-07 Mercury Public Affairs, LLC 6170 6170 Amendment       https://efile.fara.gov/docs/6170-Amendment-20200707-84.pdf
44151 2013-05-14 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Mauritius MAURITIUS https://efile.fara.gov/docs/6170-Exhibit-AB-20130514-2.pdf
72364 2013-08-02 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Nigeria, Embassy NIGERIA https://efile.fara.gov/docs/6170-Exhibit-AB-20130802-3.pdf
111197 2013-12-11 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Ministry of Foreign Affairs of the Government of Somaliland SOMALILAND https://efile.fara.gov/docs/6170-Exhibit-AB-20131211-4.pdf
68250 2014-07-30 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Uganda UGANDA https://efile.fara.gov/docs/6170-Exhibit-AB-20140730-5.pdf
72117 2014-08-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Uganda UGANDA https://efile.fara.gov/docs/6170-Exhibit-AB-20140801-6.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
41623 2015-05-01 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Adesina, Akinwumi NIGERIA https://efile.fara.gov/docs/6170-Exhibit-AB-20150501-8.pdf
45383 2015-05-20 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Nigeria, Embassy NIGERIA https://efile.fara.gov/docs/6170-Exhibit-AB-20150520-9.pdf
53586 2015-06-03 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Okinawa Prefecture JAPAN https://efile.fara.gov/docs/6170-Exhibit-AB-20150603-10.pdf
67424 2015-07-27 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Uganda UGANDA https://efile.fara.gov/docs/6170-Exhibit-AB-20150727-11.pdf
74467 2015-08-13 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-20150813-12.pdf
74468 2015-08-13 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Uganda UGANDA https://efile.fara.gov/docs/6170-Exhibit-AB-20150813-13.pdf
103354 2015-11-24 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Government of Uganda UGANDA https://efile.fara.gov/docs/6170-Exhibit-AB-20151124-14.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
24364 2016-03-16 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Embassy of Republic of Turkey through Amsterdam & Partners, LLP TURKEY https://efile.fara.gov/docs/6170-Exhibit-AB-20160316-16.pdf
35181 2016-04-18 Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 6170 6170 Exhibit AB   Okinawa Prefecture JAPAN https://efile.fara.gov/docs/6170-Exhibit-AB-20160418-17.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 909.85ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history