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-117hhrg50155" 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
98600 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Alejandra Caraballo Clinical Instructor Cyberlaw Clinic, on behalf of Harvard Law School CYBERLAW CLINIC, ON BEHALF OF HARVARD LAW SCHOOL  
98602 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Amanda Tyler Executive Director Baptist Joint Committee for Religious Liberty BAPTIST JOINT COMMITTEE FOR RELIGIOUS LIBERTY  
98601 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Asra Nomani Senior Fellow in the Practice of Journalism Independent Women's Network INDEPENDENT WOMEN'S NETWORK  
98598 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Eric Ward Senior Advisor Western States Center WESTERN STATES CENTER  
98603 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Mary McCord Executive Director Institute for Constitutional Advocacy and Protection, on behalf of Georgetown University Law Center INSTITUTE FOR CONSTITUTIONAL ADVOCACY AND PROTECTION, ON BEHALF OF GEORGETOWN UNIVERSITY LAW CENTER  
98599 CONFRONTING WHITE SUPREMACY (PART VII): THE EVOLUTION OF ANTI-DEMOCRATIC EXTREMIST GROUPS AND THE ONGOING THREAT TO DEMOCRACY CHRG-117hhrg50155 Oren Segal Vice President Center on Extremism, on behalf of Anti-Defamation League CENTER ON EXTREMISM, ON BEHALF OF ANTI-DEFAMATION LEAGUE  

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;