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

29 rows where Foreign_Principal_Name = "Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA)" and Registration_Number = 6170

View and edit SQL

Suggested facets: Date_Stamped, Date_Stamped (date)

Document_Type

Foreign_Principal_Name

  • Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) · 29

Foreign_Principal_Country

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
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
12470 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
13510 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
15809 2020-02-24 Test Registrant 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-20200224-284.pdf
21888 2020-03-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-20200304-302.pdf
22077 2020-03-05 6170 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-20200305-306.pdf
22285 2020-03-06 6170 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-20200306-310.pdf
22879 2020-03-09 6170 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-20200309-316.pdf
28295 2020-03-31 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-20200331-348.pdf
32003 2020-04-02 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-20200402-361.pdf
45238 2020-05-19 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-20200519-442.pdf
45239 2020-05-19 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-20200519-443.pdf
58346 2020-06-28 Mercury Public Affairs, LLC 6170 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
82749 2019-09-11 Mercury Public Affairs, LLC 6170 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
83834 2019-09-17 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-20190917-170.pdf
92691 2019-10-14 Mercury Public Affairs, LLC 6170 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
93370 2019-10-18 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-20191018-195.pdf
93852 2019-10-21 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-20191021-196.pdf
94376 2019-10-24 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-20191024-209.pdf
94377 2019-10-24 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-20191024-210.pdf
94588 2019-10-25 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-20191025-199.pdf
99680 2019-11-01 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-20191101-204.pdf
100377 2019-11-05 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-20191105-216.pdf
100493 2019-11-06 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-20191106-213.pdf
100636 2019-11-07 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-20191107-227.pdf
102538 2019-11-19 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-20191119-219.pdf
102722 2019-11-20 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-20191120-217.pdf
103742 2019-11-27 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-20191127-229.pdf
111481 2019-12-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-20191213-236.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)
);
Powered by Datasette · Query took 706.942ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history