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 = "SHER & BLACKWELL"
This data as json, CSV (advanced)
Registrant_Name 1
- SHER & BLACKWELL · 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 |
---|---|---|---|---|---|---|---|---|---|
83549 | 83549 | 1991-08-01 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | JEFFREY F. LAWRENCE | Available-FARA-Public-Office | ||
83550 | 83550 | 1991-08-01 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | WILLIAM W. POLLOCK | Available-FARA-Public-Office | ||
106541 | 106541 | 1991-10-04 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | DAVID F. SMITH | Available-FARA-Public-Office | ||
106542 | 106542 | 1991-10-04 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | MARC J. FINK | Available-FARA-Public-Office | ||
112443 | 112443 | 1992-10-30 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | ROBERT J. BLACKWELL | Available-FARA-Public-Office | ||
112444 | 112444 | 1992-10-30 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | STANLEY O. SHER | Available-FARA-Public-Office | ||
112445 | 112445 | 1992-10-30 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | TORBJORN SJOGREN | Available-FARA-Public-Office | ||
133629 | 133629 | 1994-12-27 | SHER & BLACKWELL | Sher & Blackwell 4576 | Short-Form | PHILIP A. BANGERT | 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]) );