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

6 rows where Foreign_Principal_Country = "GREAT BRITAIN" and Registration_Number = 3492

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 6

  • AIRSHIP INDUSTRIES, LTD. 1
  • BNS, INC. 1
  • GRAND METROPOLITAN, PLC 1
  • INTELSAT 1
  • PLESSEY COMPANY, PLC 1
  • TATE & LYLE, PLC 1

Registrant_Name 1

  • AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 6

Foreign_Principal_Country 1

  • GREAT BRITAIN · 6 ✖

Document_Type 1

  • Exhibit AB 6
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
37324 37324 1988-04-03 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   TATE & LYLE, PLC GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19880403-D0UBFA01.pdf
39410 39410 1988-04-11 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   BNS, INC. GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19880411-D0UBBA01.pdf
71135 71135 1983-07-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   INTELSAT GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19830701-D0UD5U01.pdf
103914 103914 1986-10-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   AIRSHIP INDUSTRIES, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19861001-D0UBSK01.pdf
104199 104199 1988-10-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   GRAND METROPOLITAN, PLC GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19881001-D0UB2J01.pdf
125942 125942 1988-12-01 AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 Exhibit AB   PLESSEY COMPANY, PLC GREAT BRITAIN https://efile.fara.gov/docs/3492-Exhibit-AB-19881201-D0UB8L01.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 691.197ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history