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

2 rows where Foreign_Principal_Country = "UNITED ARAB EMIRATES" and Registrant_Name = "Levick Strategic Communications"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • Levick Strategic Communications · 2 ✖

Foreign_Principal_Country 1

  • UNITED ARAB EMIRATES · 2 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
19981 19981 2007-02-28 Levick Strategic Communications Levick Strategic Communications 5649 Exhibit AB   Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai) UNITED ARAB EMIRATES https://efile.fara.gov/docs/5649-Exhibit-AB-20070228-10.pdf
55178 55178 2008-05-27 Levick Strategic Communications Levick Strategic Communications 5649 Exhibit AB   The Executive Office (Dubai) UNITED ARAB EMIRATES https://efile.fara.gov/docs/5649-Exhibit-AB-20080527-11.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])
);