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

16 rows where package_id = "CHRG-105hhrg52320" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
1595 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Bruce Ackerman Sterling Professor of Law and Political Science Yale University YALE UNIVERSITY  
1607 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Charles F.C. Ruff Counsel to the President      
1600 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Edward S.G. Dennis Jr. Morgan, Lewis & Bockius MORGAN, LEWIS & BOCKIUS  
1603 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Elizabeth Holtzman Former Member of Congress from Massachusetts      
1598 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Gregory B. Craig Esq., Assistant to the President and Special Counsel      
1604 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Hon. Nicholas Katzenbach Former Attorney General of the United States      
1601 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Hon. Robert J. Drinan S.J., Former Member of Congress from Massachusetts      
1606 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Hon. Wayne Owens former Member of Congress from Utah      
1602 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 James Esq. Hamilton   Swidler, Berlin, Shereff & Friedman SWIDLER, BERLIN, SHEREFF & FRIEDMAN Washington, DC
1597 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Richard Ben-Veniste Former Assistant U.S. Attorney Esquire ESQUIRE  
1599 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Richard J. Davis Esq. Weil, Gotschal & Manges WEIL, GOTSCHAL & MANGES  
1605 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Ronald Noble Esq., Professor of Law New York University Law School NEW YORK UNIVERSITY LAW SCHOOL  
1596 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Samuel H. Beer Eaton Professor of the Science of Government Emeritus Harvard University HARVARD UNIVERSITY  
1609 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Sean Wilentz the Dayton Stockton Professor of History      
1608 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 Thomas P. Sullivan Esq., Former U.S. Attorney Northern District of Illinois NORTHERN DISTRICT OF ILLINOIS  
1610 IMPEACHMENT INQUIRY: WILLIAM JEFFERSON CLINTON, PRESIDENT OF THE UNITED STATES PRESENTATION ON BEHALF OF THE PRESIDENT CHRG-105hhrg52320 William Hon. Weld Former Governor of Massachusetts      

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;