FARA_All_RegistrantDocs

Table actions
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

26 rows where Foreign_Principal_Country = "ZIMBABWE", Registrant_Name = "Mercury Public Affairs, LLC" and Registration_Number = 6170

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped

Document_Type 2

Registrant_Name 1

  • Mercury Public Affairs, LLC · 26 ✖

Foreign_Principal_Country 1

  • ZIMBABWE · 26 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5272 5272 2020-01-13 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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
13494 13494 2022-02-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Actum International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Informational-Materials-20220201-1084.pdf
14208 14208 2020-02-04 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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
15530 15530 2020-02-10 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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
25219 25219 2020-03-04 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20200304-302.pdf
33413 33413 2020-03-31 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20200331-348.pdf
37275 37275 2020-04-02 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20200402-361.pdf
53248 53248 2020-05-19 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20200519-442.pdf
53249 53249 2020-05-19 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20200519-443.pdf
62286 62286 2022-06-02 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Actum International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Informational-Materials-20220602-1093.pdf
67026 67026 2021-06-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Exhibit-AB-20210623-99.pdf
68306 68306 2020-06-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Exhibit-AB-20200628-85.pdf
78240 78240 2021-07-23 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20210723-990.pdf
88392 88392 2021-08-18 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20210818-1000.pdf
97120 97120 2019-09-11 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Exhibit-AB-20190911-68.pdf
98512 98512 2019-09-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20190917-170.pdf
108750 108750 2019-10-14 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) ZIMBABWE https://efile.fara.gov/docs/6170-Exhibit-AB-20191014-70.pdf
109604 109604 2019-10-18 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191018-195.pdf
110261 110261 2019-10-21 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191021-196.pdf
116786 116786 2019-11-01 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191101-204.pdf
117742 117742 2019-11-05 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191105-216.pdf
117910 117910 2019-11-06 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191106-213.pdf
118092 118092 2019-11-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191107-227.pdf
120684 120684 2019-11-19 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191119-219.pdf
120913 120913 2019-11-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191120-217.pdf
122170 122170 2019-11-27 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 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-20191127-229.pdf

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])
);