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 = "Amendment" and Registrant_Name = "Piper Rudnick"

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Document_Type

Registrant_Name 1

  • Piper Rudnick · 12 ✖

Foreign_Principal_Name 1

  • - 12

Foreign_Principal_Country 1

  • - 12
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
18941 18941 2003-02-26 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20030226-HB6KAP03.pdf
26729 26729 2003-03-10 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20030310-HBR4KA05.pdf
37390 37390 2003-04-03 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20030403-HCZ98I03.pdf
62144 62144 2004-06-02 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20040602-HZ3WH105.pdf
62145 62145 2004-06-02 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20040602-HZEX1I04.pdf
87220 87220 2004-08-12 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20040812-I2LJS804.pdf
88279 88279 2003-08-18 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20030818-HJZD0P01.pdf
88280 88280 2003-08-18 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20030818-HNGZQ202.pdf
109515 109515 2002-10-18 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20021018-H4WQ4N03.pdf
110430 110430 2002-10-22 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20021022-H53W5V01.pdf
120567 120567 2002-11-19 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20021119-H5ZL1F01.pdf
133677 133677 2004-12-27 Piper Rudnick DLA Piper US LLP 3712 Amendment       https://efile.fara.gov/docs/3712-Amendment-20041227-I9T5B704.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 1278.001ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history