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

6 rows where Foreign_Principal_Country = "UNITED ARAB EMIRATES", Registrant_Name = "DLA Piper US LLP" and Registration_Number = 3712

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 2

Registrant_Name 1

  • DLA Piper US LLP · 6 ✖

Foreign_Principal_Country 1

  • UNITED ARAB EMIRATES · 6 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
67639 67639 2008-06-26 DLA Piper US LLP DLA Piper US LLP 3712 Exhibit AB   Executive Office of Dubai UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Exhibit-AB-20080626-9.pdf
96548 96548 2008-09-09 DLA Piper US LLP DLA Piper US LLP 3712 Exhibit AB   Executive Office of Dubai UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Exhibit-AB-20080909-11.pdf
102558 102558 2017-09-30 DLA Piper US LLP DLA Piper US LLP 3712 Informational Materials   Embassy of the United Arab Emirates UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Informational-Materials-20170930-4.pdf
116974 116974 2007-11-02 DLA Piper US LLP DLA Piper US LLP 3712 Exhibit AB   Borse Dubai Limited UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Exhibit-AB-20071102-7.pdf
120824 120824 2006-11-20 DLA Piper US LLP DLA Piper US LLP 3712 Exhibit AB   Sheik Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates, et al UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Exhibit-AB-20061120-3.pdf
131107 131107 2008-12-15 DLA Piper US LLP DLA Piper US LLP 3712 Exhibit AB   Embassy of the United Arab Emirates UNITED ARAB EMIRATES https://efile.fara.gov/docs/3712-Exhibit-AB-20081215-12.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])
);