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-111hhrg58409" 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
47769 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. David Schellhase Executive Vice President and General Counsel Salesforce.Com SALESFORCE.COM  
47766 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Edward W. Felten Director Center for Information Technology Policy, Princeton University CENTER FOR INFORMATION TECHNOLOGY POLICY, PRINCETON UNIVERSITY  
47773 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Fred H. Cate Professor, Director Center for Applied Cybersecurity Research, Indiana University CENTER FOR APPLIED CYBERSECURITY RESEARCH, INDIANA UNIVERSITY  
47772 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Kevin Werbach Professor The Wharton School, University of Pennsylvania THE WHARTON SCHOOL, UNIVERSITY OF PENNSYLVANIA  
47775 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Kurt F. Schmid Executive Director Chicago High Intensity Drug Trafficking Area Program CHICAGO HIGH INTENSITY DRUG TRAFFICKING AREA PROGRAM  
47776 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Marc J. Zwillinger   Zwillinger Genetski, LLP ZWILLINGER GENETSKI, LLP  
47768 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Mike Hintze Associate General Counsel Microsoft Corporation MICROSOFT CORPORATION  
47771 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Paul Misener Vice President for Global Public Policy, Amazon.Com      
47770 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Perry Robinson Associate General Counsel Rackspace Hosting RACKSPACE HOSTING  
47767 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Richard Salgado Senior Counsel Law Enforcement and Information Security, Google, Inc. LAW ENFORCEMENT AND INFORMATION SECURITY, GOOGLE, INC.  
47774 ECPA REFORM AND THE REVOLUTION IN CLOUD COMPUTING CHRG-111hhrg58409 Mr. Thomas B. Hurbanek Senior Investigator Computer Crime Unit, New YorK State Police COMPUTER CRIME UNIT, NEW YORK STATE POLICE  

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;