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-113hhrg91663" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
69041 IS ACADEMIC FREEDOM THREATENED BY CHINA'S INFLUENCE ON U.S. UNIVERSITIES? CHRG-113hhrg91663 Perry Link Ph.D. chancellorial chair for innovative teaching, University of California, Riverside CHANCELLORIAL CHAIR FOR INNOVATIVE TEACHING, UNIVERSITY OF CALIFORNIA, RIVERSIDE  
69044 IS ACADEMIC FREEDOM THREATENED BY CHINA'S INFLUENCE ON U.S. UNIVERSITIES? CHRG-113hhrg91663 Sophie Richardson Ph.D., China director Human Rights Watch HUMAN RIGHTS WATCH  
69042 IS ACADEMIC FREEDOM THREATENED BY CHINA'S INFLUENCE ON U.S. UNIVERSITIES? CHRG-113hhrg91663 Thomas Cushman Ph.D. Deffenbaugh de Hoyos Carlson chair in the social sciences, Wellesley College DEFFENBAUGH DE HOYOS CARLSON CHAIR IN THE SOCIAL SCIENCES, WELLESLEY COLLEGE  
69043 IS ACADEMIC FREEDOM THREATENED BY CHINA'S INFLUENCE ON U.S. UNIVERSITIES? CHRG-113hhrg91663 Xia Yeliang Ph.D. visiting fellow, Center for Global Liberty and Prosperity, Cato Institute VISITING FELLOW, CENTER FOR GLOBAL LIBERTY AND PROSPERITY, CATO INSTITUTE  

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;