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

9 rows where package_id = "CHRG-113shrg92904" 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
71541 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Alice M. Rivlin Ph.D., Senior Fellow and Leonard D. Schaeffer Chair in Health Policy Studies The Brookings Institute THE BROOKINGS INSTITUTE  
71537 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Eleanor Holmes Norton   Delegate of The District of Columbia, U.S. House of Representatives DELEGATE OF THE DISTRICT OF COLUMBIA, U.S. HOUSE OF REPRESENTATIVES  
71545 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Michael D. Brown   Shadow Senator, District of Columbia SHADOW SENATOR, DISTRICT OF COLUMBIA  
71544 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Paul Strauss   Shadow Senator, District of Columbia SHADOW SENATOR, DISTRICT OF COLUMBIA  
71539 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Philip H. Mendelson Chairman Council of the District of Columbia COUNCIL OF THE DISTRICT OF COLUMBIA  
71540 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Viet D. Dinh Professor Georgetown University Law School GEORGETOWN UNIVERSITY LAW SCHOOL  
71538 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Hon. Vincent C. Gray   Mayor, District of Columbia MAYOR, DISTRICT OF COLUMBIA  
71543 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Roger Pilon Ph.D., J.D. Vice President for Legal Affairs and B. Kenneth Simon Chair in Constitutional Studies Cato Institute CATO INSTITUTE  
71542 EQUALITY FOR THE DISTRICT OF COLUMBIA: DISCUSSING THE IMPLICATIONS OF S. 132, THE NEW COLUMBIA ADMISSION ACT OF 2013 CHRG-113shrg92904 Wade Henderson President Leadership Conference on Civil and Human Rights LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS  

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;