home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for 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

12 rows where Document_Type = "Exhibit AB" and Registrant_Name = "Piper Rudnick"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 12

  • Foreign Ministry of the Republic of Montenegro 1
  • German State of Rheinland-Pfalz 1
  • Government of Haiti 1
  • Government of Spain, Embassy 1
  • Government of State of Mexico 1
  • Government of Thailand 1
  • Government of the Republic of Cote D'Ivoire, Embassy 1
  • Government of the Republic of Cote d'Ivoire 1
  • President of Kosova 1
  • Republic of China (Taiwan) Taipei Economic and Cultural Representative Office 1
  • Republic of Cyprus Government, Embassy 1
  • Senado de Mexico 1

Foreign_Principal_Country 10

  • COTE D'IVOIRE IVORY COAST 2
  • MEXICO 2
  • CYPRUS 1
  • GERMANY 1
  • HAITI 1
  • KOSOVA 1
  • MONTENEGRO 1
  • SPAIN 1
  • TAIWAN 1
  • THAILAND 1

Registrant_Name 1

  • Piper Rudnick · 12 ✖

Document_Type 1

  • Exhibit AB · 12 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
8184 8184 2004-01-28 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of Spain, Embassy SPAIN https://efile.fara.gov/docs/3712-Exhibit-AB-20040128-HUGXUX03.pdf
13594 13594 2001-02-02 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Republic of Cyprus Government, Embassy CYPRUS https://efile.fara.gov/docs/3712-Exhibit-AB-20010202-HQQ6Z501.pdf
15657 15657 2002-02-11 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Senado de Mexico MEXICO https://efile.fara.gov/docs/3712-Exhibit-AB-20020211-H72RQ201.pdf
30925 30925 2002-03-26 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Foreign Ministry of the Republic of Montenegro MONTENEGRO https://efile.fara.gov/docs/3712-Exhibit-AB-20020326-H8CZVW04.pdf
49981 49981 2003-05-07 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of Haiti HAITI https://efile.fara.gov/docs/3712-Exhibit-AB-20030507-HEMLYT01.pdf
95725 95725 2001-09-05 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Republic of China (Taiwan) Taipei Economic and Cultural Representative Office TAIWAN https://efile.fara.gov/docs/3712-Exhibit-AB-20010905-HF53O004.pdf
95733 95733 2003-09-05 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of the Republic of Cote D'Ivoire, Embassy COTE D'IVOIRE IVORY COAST https://efile.fara.gov/docs/3712-Exhibit-AB-20030905-HOO0BI03.pdf
100325 100325 2003-09-25 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   German State of Rheinland-Pfalz GERMANY https://efile.fara.gov/docs/3712-Exhibit-AB-20030925-HOV2MO03.pdf
111767 111767 2003-10-28 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of Thailand THAILAND https://efile.fara.gov/docs/3712-Exhibit-AB-20031028-HPQJFS03.pdf
112516 112516 2002-10-30 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of the Republic of Cote d'Ivoire COTE D'IVOIRE IVORY COAST https://efile.fara.gov/docs/3712-Exhibit-AB-20021030-HCQBL102.pdf
133387 133387 2003-12-24 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   Government of State of Mexico MEXICO https://efile.fara.gov/docs/3712-Exhibit-AB-20031224-HRJB9802.pdf
133530 133530 2002-12-26 Piper Rudnick DLA Piper US LLP 3712 Exhibit AB   President of Kosova KOSOVA https://efile.fara.gov/docs/3712-Exhibit-AB-20021226-H85PCG02.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 · Queries took 728.978ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history