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-107shrg92452" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
15155 TITLE IX AND SCIENCE CHRG-107shrg92452 C. Todd Jones Deputy Assistant Secretary Office for Civil Rights, Department of Education OFFICE FOR CIVIL RIGHTS, DEPARTMENT OF EDUCATION  
15153 TITLE IX AND SCIENCE CHRG-107shrg92452 Dr. April S. Brown Professor and Chair Department of Electrical and Computer Engineering, Duke University DEPARTMENT OF ELECTRICAL AND COMPUTER ENGINEERING, DUKE UNIVERSITY  
15157 TITLE IX AND SCIENCE CHRG-107shrg92452 Dr. Geraldine L. Richmond Richard M. and Patricia H. Noyes Distinguished Professor Department of Chemistry, University of Oregon DEPARTMENT OF CHEMISTRY, UNIVERSITY OF OREGON  
15152 TITLE IX AND SCIENCE CHRG-107shrg92452 Hon. Birch Bayh   Venable, Baetjer, and Howard, LLP VENABLE, BAETJER, AND HOWARD, LLP  
15154 TITLE IX AND SCIENCE CHRG-107shrg92452 Marcia Greenberger Co-President National Women's Law Center NATIONAL WOMEN'S LAW CENTER  
15156 TITLE IX AND SCIENCE CHRG-107shrg92452 Margaret ``Digit'' Murphy Head Coach Women's Ice Hockey, Brown University WOMEN'S ICE HOCKEY, BROWN UNIVERSITY  

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;