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 = "ROSE, SCHMIDT, HASLEY, & DISALLE"
This data as json, CSV (advanced)
Registrant_Name 1
- ROSE, SCHMIDT, HASLEY, & DISALLE · 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 |
---|---|---|---|---|---|---|---|---|---|
11540 | 11540 | 1986-02-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | MICHAEL G. KUSHNICK | Available-FARA-Public-Office | ||
45859 | 45859 | 1979-05-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | WILLIAM J. KENNEY | Available-FARA-Public-Office | ||
57879 | 57879 | 1973-06-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | MILTON P. SEMER | Available-FARA-Public-Office | ||
81997 | 81997 | 1977-08-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | ALBERT D. STURTEVANT | Available-FARA-Public-Office | ||
89401 | 89401 | 1971-08-24 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | ABNER W. SIBAL | Available-FARA-Public-Office | ||
89402 | 89402 | 1971-08-24 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | CRAIG S. BAMBERGER | Available-FARA-Public-Office | ||
89403 | 89403 | 1971-08-24 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | JOHN P. SEARS | Available-FARA-Public-Office | ||
89404 | 89404 | 1971-08-24 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | W.N. HARRELL SMITH | Available-FARA-Public-Office | ||
91790 | 91790 | 1971-09-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | NORMAN S. PAUL | Available-FARA-Public-Office | ||
99273 | 99273 | 1978-09-21 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | ALBERT D. STURTEVANT | Available-FARA-Public-Office | ||
99274 | 99274 | 1978-09-21 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | W.N. HARRELL SMITH | Available-FARA-Public-Office | ||
100237 | 100237 | 1978-09-25 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | JAMES S. HOSTETLER | Available-FARA-Public-Office | ||
100238 | 100238 | 1978-09-25 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | PAUL A. LENZINI | Available-FARA-Public-Office | ||
103394 | 103394 | 1979-10-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | PAUL A. LENZINI | Available-FARA-Public-Office | ||
103461 | 103461 | 1980-10-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | GARY C. HUFBAUER | Available-FARA-Public-Office | ||
103678 | 103678 | 1983-10-01 | ROSE, SCHMIDT, HASLEY, & DISALLE | Rose, Schmidt, Hasley, & DiSalle 2275 | Short-Form | HENRY S. REUSS | 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]) );