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

5 rows where package_id = "CHRG-113shrg21221" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
69639 WHY NET NEUTRALITY MATTERS: PROTECTING CONSUMERS AND COMPETITION THROUGH MEANINGFUL OPEN INTERNET RULES CHRG-113shrg21221 Bradford Burnham   Managing Partner, Union Square Ventures, LLC, New York, New York MANAGING PARTNER, UNION SQUARE VENTURES, LLC, NEW YORK, NEW YORK  
69642 WHY NET NEUTRALITY MATTERS: PROTECTING CONSUMERS AND COMPETITION THROUGH MEANINGFUL OPEN INTERNET RULES CHRG-113shrg21221 Hon. Robert M. McDowell Former Commissioner Federal Communications Commission, and Partner, Wiley Rein LLP FEDERAL COMMUNICATIONS COMMISSION, AND PARTNER, WILEY REIN LLP Washington, DC
69640 WHY NET NEUTRALITY MATTERS: PROTECTING CONSUMERS AND COMPETITION THROUGH MEANINGFUL OPEN INTERNET RULES CHRG-113shrg21221 Jeffrey A. Eisenach Ph.D. Visiting Scholar, American Enterprise Institute Center for Internet, Communications and Technology Policy VISITING SCHOLAR, AMERICAN ENTERPRISE INSTITUTE CENTER FOR INTERNET, COMMUNICATIONS AND TECHNOLOGY POLICY Washington, DC
69643 WHY NET NEUTRALITY MATTERS: PROTECTING CONSUMERS AND COMPETITION THROUGH MEANINGFUL OPEN INTERNET RULES CHRG-113shrg21221 Nuala O'Connor President and Chief Executive Officer Center for Democracy and Technology CENTER FOR DEMOCRACY AND TECHNOLOGY Washington, DC
69641 WHY NET NEUTRALITY MATTERS: PROTECTING CONSUMERS AND COMPETITION THROUGH MEANINGFUL OPEN INTERNET RULES CHRG-113shrg21221 Ruth Livier   Writer, Independent Producer, and Actress, Pacific Palisades, California WRITER, INDEPENDENT PRODUCER, AND ACTRESS, PACIFIC PALISADES, CALIFORNIA  

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;