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

32 rows where Foreign_Principal_Country = "ZIMBABWE", Registrant_Name = 6170 and Registration_Number = 6170

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Document_Type

Registrant_Name 1

  • 6170 · 32 ✖

Foreign_Principal_Country 1

  • ZIMBABWE · 32 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
24959 24959 2021-03-03 6170 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-20210303-867.pdf
25237 25237 2021-03-04 6170 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-20210304-869.pdf
25475 25475 2020-03-05 6170 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-20200305-306.pdf
25735 25735 2020-03-06 6170 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-20200306-310.pdf
26504 26504 2020-03-09 6170 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-20200309-316.pdf
51754 51754 2021-05-13 6170 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-20210513-930.pdf
54529 54529 2021-05-24 6170 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-20210524-938.pdf
54530 54530 2021-05-24 6170 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-20210524-939.pdf
54531 54531 2021-05-24 6170 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-20210524-940.pdf
54532 54532 2021-05-24 6170 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-20210524-941.pdf
76372 76372 2020-07-15 6170 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-20200715-493.pdf
95241 95241 2020-09-02 6170 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-20200902-638.pdf
98049 98049 2019-09-15 6170 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-20190915-692.pdf
98054 98054 2020-09-15 6170 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-20200915-676.pdf
101257 101257 2020-09-28 6170 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-20200928-695.pdf
110507 110507 2020-10-22 6170 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-20201022-750.pdf
110508 110508 2020-10-22 6170 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-20201022-751.pdf
110943 110943 2019-10-24 6170 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-20191024-681.pdf
111178 111178 2019-10-25 6170 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-20191025-535.pdf
111179 111179 2019-10-25 6170 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-20191025-664.pdf
112226 112226 2019-10-29 6170 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-20191029-533.pdf
112227 112227 2019-10-29 6170 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-20191029-644.pdf
112228 112228 2019-10-29 6170 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-20191029-645.pdf
117727 117727 2019-11-05 6170 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-532.pdf
117728 117728 2019-11-05 6170 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-643.pdf
117748 117748 2020-11-05 6170 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-20201105-762.pdf
118788 118788 2020-11-11 6170 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-20201111-766.pdf
119047 119047 2020-11-12 6170 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-20201112-764.pdf
119048 119048 2020-11-12 6170 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-20201112-765.pdf
128639 128639 2020-12-02 6170 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-99991231-778.pdf
130733 130733 2019-12-13 6170 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-20191213-591.pdf
131628 131628 2019-12-17 6170 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-20191217-523.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])
);