FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Document_Type = "Short-Form" and Registrant_Name = "BERLINER, CORCORAN & ROWE"
This data as json, CSV (advanced)
Registrant_Name 1
- BERLINER, CORCORAN & ROWE · 10 ✖
Foreign_Principal_Name 1
- - 10
Foreign_Principal_Country 1
- - 10
Document_Type 1
- Short-Form · 10 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
22061 | 22061 | 1988-03-01 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CLEMENS J.M. KOCHINKE | Available-FARA-Public-Office | ||
31125 | 31125 | 1985-03-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CLEMENS J.M. KOCHINKE | Available-FARA-Public-Office | ||
31126 | 31126 | 1985-03-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CONSTANTINE G. PAPAVIZAS | Available-FARA-Public-Office | ||
46435 | 46435 | 1987-05-01 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CLEMENS J.M. KOCHINKE | Available-FARA-Public-Office | ||
82307 | 82307 | 1983-08-01 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | BRUCE ZAGARIS | Available-FARA-Public-Office | ||
103922 | 103922 | 1986-10-01 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | LOUIS E. EMERY | Available-FARA-Public-Office | ||
133601 | 133601 | 1985-12-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | BRUCE ZAGARIS | Available-FARA-Public-Office | ||
133602 | 133602 | 1985-12-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CLEMENS J.M. KOCHINKE | Available-FARA-Public-Office | ||
133603 | 133603 | 1985-12-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CONSTANTINE G. PAPAVIZAS | Available-FARA-Public-Office | ||
133604 | 133604 | 1985-12-27 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | JAY A. ROSENTHAL | 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]) );