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

16 rows where Document_Type = "Exhibit AB" and Registration_Number = 3076

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 14

  • TRANSCANADA PIPELINES, LTD. 3
  • ACCOUNTANTS' LIABILITY ASSURANCE COMPANY, LTD. 1
  • ATTORNEYS' LIABILITY ASSURANCE SOCIETY, LTD. 1
  • BANK FOR FOREIGN ECONOMIC AFFAIRS OF RUSSIA 1
  • BRAMBLES USA, LTD. 1
  • DEUTSCHE BUNDESPOST TELEKOM 1
  • DEUTSCHE LUFTHANSA, A.G. 1
  • EMBASSY OF CANADA 1
  • HARRIS TRUST SAVINGS BANK 1
  • LEHNDORFF & BABSON REAL ESTATE COUNSEL 1
  • LONDON METAL EXCHANGE, LTD. 1
  • MITSUBISHI GAS CHEMICAL AMERICA, INC. 1
  • SERVICIOS FINANCIEROS QUADRUM, S.A. 1
  • STC, PLC 1

Foreign_Principal_Country 8

  • CANADA 5
  • GERMANY 3
  • BERMUDA 2
  • GREAT BRITAIN 2
  • AUSTRALIA 1
  • JAPAN 1
  • MEXICO 1
  • RUSSIA 1

Registrant_Name 1

  • MAYER, BROWN & PLATT 16

Document_Type 1

  • Exhibit AB · 16 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
1424 1424 1989-01-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   TRANSCANADA PIPELINES, LTD. CANADA https://efile.fara.gov/docs/3076-Exhibit-AB-19890101-D0K89002.pdf
11310 11310 1984-02-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   EMBASSY OF CANADA CANADA https://efile.fara.gov/docs/3076-Exhibit-AB-19840201-D0K94I02.pdf
11797 11797 1988-02-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   ACCOUNTANTS' LIABILITY ASSURANCE COMPANY, LTD. BERMUDA https://efile.fara.gov/docs/3076-Exhibit-AB-19880201-D0K87902.pdf
12415 12415 1991-02-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   STC, PLC GREAT BRITAIN https://efile.fara.gov/docs/3076-Exhibit-AB-19910201-D0K7C902.pdf
16208 16208 1994-02-14 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   DEUTSCHE LUFTHANSA, A.G. GERMANY https://efile.fara.gov/docs/3076-Exhibit-AB-19940214-DQSJD003.pdf
22142 22142 1988-03-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   LEHNDORFF & BABSON REAL ESTATE COUNSEL GERMANY https://efile.fara.gov/docs/3076-Exhibit-AB-19880301-D0K83I02.pdf
35279 35279 1990-04-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   BANK FOR FOREIGN ECONOMIC AFFAIRS OF RUSSIA RUSSIA https://efile.fara.gov/docs/3076-Exhibit-AB-19900401-D0K7JW02.pdf
59746 59746 1989-06-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   LONDON METAL EXCHANGE, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3076-Exhibit-AB-19890601-D0K7U802.pdf
92767 92767 1986-09-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   ATTORNEYS' LIABILITY ASSURANCE SOCIETY, LTD. BERMUDA https://efile.fara.gov/docs/3076-Exhibit-AB-19860901-D0K8E302.pdf
96305 96305 1989-09-08 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   BRAMBLES USA, LTD. AUSTRALIA https://efile.fara.gov/docs/3076-Exhibit-AB-19890908-D0K7PO02.pdf
114497 114497 1981-11-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   TRANSCANADA PIPELINES, LTD. CANADA https://efile.fara.gov/docs/3076-Exhibit-AB-19811101-D0K92502.pdf
116530 116530 1993-11-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   SERVICIOS FINANCIEROS QUADRUM, S.A. MEXICO https://efile.fara.gov/docs/3076-Exhibit-AB-19931101-D0K9TE02.pdf
118002 118002 1994-11-07 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   DEUTSCHE BUNDESPOST TELEKOM GERMANY https://efile.fara.gov/docs/3076-Exhibit-AB-19941107-DQSI1R03.pdf
121204 121204 1995-11-22 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   HARRIS TRUST SAVINGS BANK CANADA https://efile.fara.gov/docs/3076-Exhibit-AB-19951122-DJMVE704.pdf
124799 124799 1979-12-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   TRANSCANADA PIPELINES, LTD. CANADA https://efile.fara.gov/docs/3076-Exhibit-AB-19791201-D0K97902.pdf
127636 127636 1992-12-01 MAYER, BROWN & PLATT Mayer, Brown & Platt 3076 Exhibit AB   MITSUBISHI GAS CHEMICAL AMERICA, INC. JAPAN https://efile.fara.gov/docs/3076-Exhibit-AB-19921201-D0K9HC02.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 558.197ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history