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

13 rows where Document_Type = "Amendment" and Registration_Number = 3681

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

Foreign_Principal_Name 1

  • - 13

Foreign_Principal_Country 1

  • - 13

Document_Type 1

  • Amendment · 13 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
12078 12078 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKJC01.pdf
12079 12079 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKJO01.pdf
12080 12080 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKK001.pdf
12081 12081 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKKV01.pdf
12082 12082 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKLI01.pdf
12083 12083 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKLU01.pdf
12084 12084 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKMA01.pdf
12085 12085 1990-02-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19900201-D0YKMN01.pdf
46377 46377 1986-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19860501-D0YKXP01.pdf
94725 94725 1993-09-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19930901-D0XQ5R01.pdf
94726 94726 1993-09-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19930901-D0XQ6401.pdf
125708 125708 1986-12-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19861201-D0YKUL01.pdf
126226 126226 1989-12-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Amendment       https://efile.fara.gov/docs/3681-Amendment-19891201-D0YKOE01.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])
);