FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Document_Type = "Short-Form" and Registrant_Name = "Lipstein, Jaffe & Lawson, L.L.P."
This data as json, CSV (advanced)
Registrant_Name 1
- Lipstein, Jaffe & Lawson, L.L.P. · 8 ✖
Foreign_Principal_Name 1
- - 8
Foreign_Principal_Country 1
- - 8
Document_Type 1
- Short-Form · 8 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
112053 | 112053 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Fazzone,Patrick B. | Available-FARA-Public-Office | ||
112054 | 112054 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Fazzone,Patrick B. | Available-FARA-Public-Office | ||
112055 | 112055 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Jaffe,Matthew P. | Available-FARA-Public-Office | ||
112056 | 112056 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Jaffe,Matthew P. | Available-FARA-Public-Office | ||
112057 | 112057 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Lawson,Grace W. | Available-FARA-Public-Office | ||
112058 | 112058 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Lawson,Grace W. | Available-FARA-Public-Office | ||
112059 | 112059 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Lipstein,Robert A. | Available-FARA-Public-Office | ||
112060 | 112060 | 1999-10-29 | Lipstein, Jaffe & Lawson, L.L.P. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | Short-Form | Lipstein,Robert A. | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
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]) );