hearing_witnesses

Witnesses who testified at committee hearings, with parsed name, title, organization, and location.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

6 rows where package_id = "CHRG-107hhrg83923" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
10885 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 American Society of Clinical Oncology M.D and University of Colorado, Cancer Center, Paul Bunn AND UNIVERSITY OF COLORADO, CANCER CENTER, PAUL BUNN  
10883 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 Centers for Medicare & Medicaid Services Administrator Hon. Thomas A. Scully HON. THOMAS A. SCULLY  
10886 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 Medical Rights Center   Kim Glaun KIM GLAUN  
10887 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 PacifiCare Health Systems   Inc., and Prescription Solutions, John D. Jones INC., AND PRESCRIPTION SOLUTIONS, JOHN D. JONES  
10888 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 Project HOPE   Michael J. O'Grady MICHAEL J. O'GRADY  
10884 MEDICARE PAYMENTS FOR CURRENTLY COVERED PRESCRIPTION DRUGS CHRG-107hhrg83923 U.S. Department of Health and Human Services Office of Inspector General, Assistant Inspector General; accompanied by Robert Vito, Regional Inspector General Centers for Medicare and Medicaid Audits, George Reeb, Evaluation and Inspections CENTERS FOR MEDICARE AND MEDICAID AUDITS, GEORGE REEB, EVALUATION AND INSPECTIONS Philadelphia, PA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_witnesses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT,
    title TEXT,
    organization TEXT,
    organization_normalized TEXT,
    location TEXT
);
CREATE INDEX idx_hw_package ON hearing_witnesses(package_id);
CREATE INDEX idx_hw_name ON hearing_witnesses(name);
CREATE INDEX idx_hw_org ON hearing_witnesses(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_hw_org_norm ON hearing_witnesses(organization_normalized) WHERE organization_normalized IS NOT NULL;