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

7 rows where package_id = "CHRG-113hhrg92328" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
69155 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Dr. Guinevere Eden Director, Center for the Study of Learning (CSL) and Professor Department of Pediatrics, Georgetown University Medical Center DEPARTMENT OF PEDIATRICS, GEORGETOWN UNIVERSITY MEDICAL CENTER  
69154 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Dr. Peter Eden President Landmark College LANDMARK COLLEGE  
69151 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Dr. Sally Shaywitz Audrey G. Ratner Professor in Learning Development, Yale University School of Medicine and Co- Director Yale Center for Dyslexia and Creativity, Yale University YALE CENTER FOR DYSLEXIA AND CREATIVITY, YALE UNIVERSITY  
69149 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Hon. Bill Cassidy Member U.S. House of Representatives U.S. HOUSE OF REPRESENTATIVES  
69150 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Hon. Julia Brownley Member U.S. House of Representatives U.S. HOUSE OF REPRESENTATIVES  
69152 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Mr. Max Brooks   Author and Screenwriter AUTHOR AND SCREENWRITER  
69153 THE SCIENCE OF DYSLEXIA CHRG-113hhrg92328 Ms. Stacy Antie Parent and Advocate      

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;