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

18 rows where Foreign_Principal_Country = "ETHIOPIA" and Registration_Number = 6170

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 2

Registrant_Name 1

Foreign_Principal_Country 1

  • ETHIOPIA · 18 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
95284 95284 2021-09-02 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Exhibit AB   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Exhibit-AB-20210902-100.pdf
96258 96258 2021-09-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210907-1010.pdf
96259 96259 2021-09-07 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210907-1011.pdf
96453 96453 2021-09-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210908-1013.pdf
97342 97342 2021-09-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210912-1016.pdf
98550 98550 2021-09-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210917-1019.pdf
98551 98551 2021-09-17 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210917-1020.pdf
99250 99250 2021-09-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210920-1021.pdf
99251 99251 2021-09-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210920-1022.pdf
101276 101276 2021-09-28 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20210928-1025.pdf
107620 107620 2021-10-08 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211008-1050.pdf
108394 108394 2021-10-12 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211012-1054.pdf
108623 108623 2021-10-13 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211013-1056.pdf
109622 109622 2021-10-18 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211018-1060.pdf
110117 110117 2021-10-20 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211020-1062.pdf
110531 110531 2021-10-22 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Mercury International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211022-1063.pdf
117532 117532 2021-11-04 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Actum International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211104-1070.pdf
117794 117794 2021-11-05 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Government of Ethiopia (through Actum International UK Ltd.) ETHIOPIA https://efile.fara.gov/docs/6170-Informational-Materials-20211105-1071.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])
);