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

13 rows where Registrant_Name = "PIERSON & BURNETT, L.L.P." and Registration_Number = 5127

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 4

  • Short-Form 6
  • Supplemental Statement 5
  • Exhibit AB 1
  • Registration Statement 1

Foreign_Principal_Name 2

  • - 12
  • DAIMLER-BENZ AEROSPACE, A.G. 1

Foreign_Principal_Country 2

  • - 12
  • GERMANY 1

Registrant_Name 1

  • PIERSON & BURNETT, L.L.P. · 13 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
19720 19720 1997-02-28 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Supplemental Statement       https://efile.fara.gov/docs/5127-Supplemental-Statement-19970228-EAMZME02.pdf
19758 19758 1998-02-28 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Supplemental Statement       https://efile.fara.gov/docs/5127-Supplemental-Statement-19980228-ES8GJT04.pdf
19799 19799 1999-02-28 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Supplemental Statement       https://efile.fara.gov/docs/5127-Supplemental-Statement-19990228-F9GQON01.pdf
86037 86037 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Exhibit AB   DAIMLER-BENZ AEROSPACE, A.G. GERMANY https://efile.fara.gov/docs/5127-Exhibit-AB-19960807-E1UDY903.pdf
86038 86038 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Registration Statement       Available-FARA-Public-Office
86039 86039 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form B. ELSA ALLISON     Available-FARA-Public-Office
86040 86040 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form BRIAN M. LOWINGER     Available-FARA-Public-Office
86041 86041 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form DAVID L. LIHANI     Available-FARA-Public-Office
86042 86042 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form DENNIS JAMES BURNETT     Available-FARA-Public-Office
86043 86043 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form JULES I. RUBINSTEIN     Available-FARA-Public-Office
86044 86044 1996-08-07 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Short-Form VALERIE M. FURMAN     Available-FARA-Public-Office
90209 90209 1998-08-28 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Supplemental Statement       https://efile.fara.gov/docs/5127-Supplemental-Statement-19980828-F0CTYD02.pdf
91248 91248 1997-08-31 PIERSON & BURNETT, L.L.P. Pierson & Burnett, L.L.P. 5127 Supplemental Statement       https://efile.fara.gov/docs/5127-Supplemental-Statement-19970831-EK5Y3I04.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 612.698ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history