FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Document_Type = "Short-Form" and Registrant_Name = "O'CONNOR & HANNAN"
This data as json, CSV (advanced)
Registrant_Name 1
- O'CONNOR & HANNAN · 16 ✖
Foreign_Principal_Name 1
- - 16
Foreign_Principal_Country 1
- - 16
Document_Type 1
- Short-Form · 16 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
51338 | 51338 | 1988-05-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS J. FRANZEN | Available-FARA-Public-Office | ||
51339 | 51339 | 1988-05-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS M. CARNIVAL | Available-FARA-Public-Office | ||
51340 | 51340 | 1988-05-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | NORMA SCHUMACHER | Available-FARA-Public-Office | ||
62080 | 62080 | 1989-06-02 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS J. FRANZEN | Available-FARA-Public-Office | ||
62081 | 62081 | 1989-06-02 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS M. CARNIVAL | Available-FARA-Public-Office | ||
62082 | 62082 | 1989-06-02 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | KATHLEEN M. LAMB | Available-FARA-Public-Office | ||
62083 | 62083 | 1989-06-02 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | WILLIAM R. MCGRANN | Available-FARA-Public-Office | ||
64927 | 64927 | 1989-06-14 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS J. FRANZEN | Available-FARA-Public-Office | ||
64928 | 64928 | 1989-06-14 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS M. CARNIVAL | Available-FARA-Public-Office | ||
64929 | 64929 | 1989-06-14 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | KATHLEEN M. LAMB | Available-FARA-Public-Office | ||
64930 | 64930 | 1989-06-14 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | WILLIAM R. MCGRANN | Available-FARA-Public-Office | ||
125937 | 125937 | 1988-12-01 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | WILLIAM R. MCGRANN | Available-FARA-Public-Office | ||
130457 | 130457 | 1989-12-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS J. FRANZEN | Available-FARA-Public-Office | ||
130458 | 130458 | 1989-12-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | DOUGLAS M. CARNIVAL | Available-FARA-Public-Office | ||
130459 | 130459 | 1989-12-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | KATHLEEN M. LAMB | Available-FARA-Public-Office | ||
130460 | 130460 | 1989-12-12 | O'CONNOR & HANNAN | O'Connor & Hannan 4142 | Short-Form | WILLIAM R. MCGRANN | 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]) );