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

4 rows where package_id = "CHRG-114shrg21906" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
78566 LABORATORY TESTING IN THE ERA OF PRECISION MEDICINE CHRG-114shrg21906 Brad Spring Vice President Regulatory Affairs and Compliance, BD Life Sciences REGULATORY AFFAIRS AND COMPLIANCE, BD LIFE SCIENCES Baltimore, MD
78565 LABORATORY TESTING IN THE ERA OF PRECISION MEDICINE CHRG-114shrg21906 David S. Klimstra M.D., Attending Pathologist and Chairman, Professor of Pathology and Laboratory Medicine Department of Pathology, James Ewing Alumni Chair in Pathology, Memorial Sloan Kettering Cancer Center, Weill Medical College of Cornell University DEPARTMENT OF PATHOLOGY, JAMES EWING ALUMNI CHAIR IN PATHOLOGY, MEMORIAL SLOAN KETTERING CANCER CENTER, WEILL MEDICAL COLLEGE OF CORNELL UNIVERSITY New York, NY
78567 LABORATORY TESTING IN THE ERA OF PRECISION MEDICINE CHRG-114shrg21906 Jeff Allen Ph.D., President and CEO Friends of Cancer Research FRIENDS OF CANCER RESEARCH Washington, DC
78568 LABORATORY TESTING IN THE ERA OF PRECISION MEDICINE CHRG-114shrg21906 Karen L. Kaul M.D., Ph.D., Clinical Professor of Pathology Chair, Department of Pathology and Laboratory Medicine, Duckworth Family Chair, NorthShore University HealthSystem, University of Chicago Pritzker School of Medicine CHAIR, DEPARTMENT OF PATHOLOGY AND LABORATORY MEDICINE, DUCKWORTH FAMILY CHAIR, NORTHSHORE UNIVERSITY HEALTHSYSTEM, UNIVERSITY OF CHICAGO PRITZKER SCHOOL OF MEDICINE Evanston, IL

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;