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

11 rows where Document_Type = "Exhibit AB" and Registration_Number = 3681

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Country 6

Registrant_Name 1

Document_Type 1

  • Exhibit AB · 11 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
23286 23286 1992-03-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   INSTITUTE OF INTERNATIONAL BANKERS INTERNATIONAL https://efile.fara.gov/docs/3681-Exhibit-AB-19920301-D0XWI801.pdf
34633 34633 1986-04-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   KOREA WONYANG FISHERIES CO., LTD. KOREA SOUTH https://efile.fara.gov/docs/3681-Exhibit-AB-19860401-D0YKYC01.pdf
34634 34634 1986-04-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   MARCONI UNDERWATER SYSTEMS, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3681-Exhibit-AB-19860401-D0YKZG01.pdf
34635 34635 1986-04-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   NIPPON KOKAN K.K. JAPAN https://efile.fara.gov/docs/3681-Exhibit-AB-19860401-D0YKYW01.pdf
46292 46292 1985-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   KOREA WONYANG FISHERIES COMPANY, LTD. KOREA SOUTH https://efile.fara.gov/docs/3681-Exhibit-AB-19850501-D0YL0W01.pdf
46555 46555 1987-05-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   KINGDOM OF TONGA TONGA https://efile.fara.gov/docs/3681-Exhibit-AB-19870501-D0YKSL01.pdf
71607 71607 1987-07-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   TOKYO ELECTRIC COMPANY, LTD. JAPAN https://efile.fara.gov/docs/3681-Exhibit-AB-19870701-D0YL8I01.pdf
73490 73490 1992-07-02 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   MARTINI & ROSSI CORPORATION SWITZERLAND https://efile.fara.gov/docs/3681-Exhibit-AB-19920702-D0XXZN01.pdf
75795 75795 1992-07-13 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   MARTINI & ROSSI CORPORATION SWITZERLAND https://efile.fara.gov/docs/3681-Exhibit-AB-19920713-D0XM5P01.pdf
104264 104264 1988-10-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   GUINNESS, PLC GREAT BRITAIN https://efile.fara.gov/docs/3681-Exhibit-AB-19881001-D0YL1F01.pdf
115114 115114 1988-11-01 KELLEY, DRYE & WARREN Kelley, Drye & Warren 3681 Exhibit AB   FUJI ELECTRIC COMPANY, LTD. JAPAN https://efile.fara.gov/docs/3681-Exhibit-AB-19881101-D0YKFW01.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])
);