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

11 rows where package_id = "CHRG-110shrg45240" 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
39897 RESTORING THE RULE OF LAW CHRG-110shrg45240 Charles J. Cooper Cooper & Kirk, D.C Partner, PLLC, Washington PARTNER, PLLC, WASHINGTON  
39901 RESTORING THE RULE OF LAW CHRG-110shrg45240 Elisa Massimino Chief Executive Officer and Executive Director, D.C Human Rights First, Washington HUMAN RIGHTS FIRST, WASHINGTON  
39905 RESTORING THE RULE OF LAW CHRG-110shrg45240 Frederick A.O. Schwarz Jr., Senior Counsel Brennan Center for Justice, New York University School of Law, New York, New York BRENNAN CENTER FOR JUSTICE, NEW YORK UNIVERSITY SCHOOL OF LAW, NEW YORK, NEW YORK  
39900 RESTORING THE RULE OF LAW CHRG-110shrg45240 Harold Hongju Koh Dean and Gerard C. & Bernice Latrobe Smith Professor of International Law Yale Law School, New Haven, Connecticut YALE LAW SCHOOL, NEW HAVEN, CONNECTICUT  
39903 RESTORING THE RULE OF LAW CHRG-110shrg45240 John D. Podesta President and Chief Executive Officer, D.C Center for American Progress Action Fund, Washington CENTER FOR AMERICAN PROGRESS ACTION FUND, WASHINGTON  
39904 RESTORING THE RULE OF LAW CHRG-110shrg45240 Kyndra Rotunda Professor of Law Chapman University School of Law, Orange, California CHAPMAN UNIVERSITY SCHOOL OF LAW, ORANGE, CALIFORNIA  
39899 RESTORING THE RULE OF LAW CHRG-110shrg45240 Mickey Edwards Board of Directors, Princeton University; former Member of Congress 1977- 1993; and former Chairman, D.C The Constitution Project; Lecturer, Woodrow Wilson School of Public and International Affairs, House Republican Policy Committee, Washington THE CONSTITUTION PROJECT; LECTURER, WOODROW WILSON SCHOOL OF PUBLIC AND INTERNATIONAL AFFAIRS, HOUSE REPUBLICAN POLICY COMMITTEE, WASHINGTON  
39902 RESTORING THE RULE OF LAW CHRG-110shrg45240 Patrick F. Philbin D.C Partner, Kirkland & Ellis LLP, Washington PARTNER, KIRKLAND & ELLIS LLP, WASHINGTON  
39907 RESTORING THE RULE OF LAW CHRG-110shrg45240 Robert Turner Professor, Associate Director General Faculty, Center for National Security Law, University of Virginia School of Law, Charlottesville, Virginia GENERAL FACULTY, CENTER FOR NATIONAL SECURITY LAW, UNIVERSITY OF VIRGINIA SCHOOL OF LAW, CHARLOTTESVILLE, VIRGINIA  
39906 RESTORING THE RULE OF LAW CHRG-110shrg45240 Suzanne E. Spaulding D.C Principal, Bingham Consulting Group, Washington PRINCIPAL, BINGHAM CONSULTING GROUP, WASHINGTON  
39898 RESTORING THE RULE OF LAW CHRG-110shrg45240 Walter Dellinger Visiting Professor of Law, former Assistant Attorney General, Office of Legal Counsel (1993-1996), former Acting Solicitor General (1996-1997) Partner, O'Melveny & Myers, LLP, Harvard Law School, Chapel Hill, North Carolina PARTNER, O'MELVENY & MYERS, LLP, HARVARD LAW SCHOOL, CHAPEL HILL, NORTH CAROLINA  

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;