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

7 rows where package_id = "CHRG-107shrg90080" 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
14915 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 Edmund Mierzwinski Consumer Program Director U.S. Public Interest Research Group; on behalf of: Consumer Action, Consumer Federation of America, Consumer Task Force on Automotive Issues, Consumers Union, Electronic Privacy Information Center, Identity Theft Resource Center, Junkbusters, Inc., Privacy Rights Clearinghouse, Private Citizen, Inc., and U.S. Public Interest Research Group U.S. PUBLIC INTEREST RESEARCH GROUP; ON BEHALF OF: CONSUMER ACTION, CONSUMER FEDERATION OF AMERICA, CONSUMER TASK FORCE ON AUTOMOTIVE ISSUES, CONSUMERS UNION, ELECTRONIC PRIVACY INFORMATION CENTER, IDENTITY THEFT RESOURCE CENTER, JUNKBUSTERS, INC., PRIVACY RIGHTS CLEARINGHOUSE, PRIVATE CITIZEN, INC., AND U.S. PUBLIC INTEREST RESEARCH GROUP  
14910 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 Fred H. Cate Professor of Law Indiana University School of Law INDIANA UNIVERSITY SCHOOL OF LAW  
14913 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 James M. Kasper Member House of Representatives, The State of North Dakota HOUSE OF REPRESENTATIVES, THE STATE OF NORTH DAKOTA  
14911 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 John C. Dugan Covington & Burling; on behalf of the Financial Services Coordinating Council Partner PARTNER  
14912 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 Mike Hatch   Attorney General, The State of Minnesota ATTORNEY GENERAL, THE STATE OF MINNESOTA  
14914 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 Phyllis Schlafly President Eagle Forum EAGLE FORUM  
14909 FINANCIAL PRIVACY AND CONSUMER PROTECTION CHRG-107shrg90080 William H. Sorrell   Attorney General, The State of Vermont ATTORNEY GENERAL, THE STATE OF VERMONT  

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;