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

17 rows where Document_Type = "Supplemental Statement" and Registration_Number = 3681

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • KELLEY, DRYE & WARREN 17

Foreign_Principal_Name 1

  • - 17

Foreign_Principal_Country 1

  • - 17

Document_Type 1

  • Supplemental Statement · 17 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
46378 46378 1986-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19860501-D0YKUT01.pdf
46557 46557 1987-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19870501-D0YL7701.pdf
46683 46683 1988-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19880501-D0YL2401.pdf
46835 46835 1989-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19890501-D0YKP101.pdf
46994 46994 1990-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19900501-D0YKHO01.pdf
47251 47251 1991-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19910501-D0XUWM01.pdf
47713 47713 1992-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19920501-D0XL0701.pdf
48224 48224 1993-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19930501-D0XW5401.pdf
114813 114813 1985-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19851101-D0YKW501.pdf
114906 114906 1986-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19861101-D0YKTG01.pdf
115019 115019 1987-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19871101-D0YL4J01.pdf
115115 115115 1988-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19881101-D0YKQD01.pdf
115251 115251 1989-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19891101-D0YKMZ01.pdf
115408 115408 1990-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19901101-D0YKGC01.pdf
115724 115724 1991-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19911101-D0XKAB01.pdf
116150 116150 1992-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19921101-D0XM7K01.pdf
116499 116499 1993-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Supplemental Statement       https://efile.fara.gov/docs/3681-Supplemental-Statement-19931101-D0XZF501.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 751.532ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history