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

12 rows where package_id = "CHRG-106hhrg67448" 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
5427 INTERNET TAX ISSUES CHRG-106hhrg67448 60 Plus Association   James L. Martin JAMES L. MARTIN  
5419 INTERNET TAX ISSUES CHRG-106hhrg67448 Bell Atlantic Corporation Victor Gomperts      
5420 INTERNET TAX ISSUES CHRG-106hhrg67448 Citizens for a Sound Economy   Erick Gustafson ERICK GUSTAFSON  
5421 INTERNET TAX ISSUES CHRG-106hhrg67448 Federation of Tax Administrators   Harley T. Duncan HARLEY T. DUNCAN  
5422 INTERNET TAX ISSUES CHRG-106hhrg67448 J. William Harden   Bryan School of Business and Economics, University of North Carolina at Greensboro BRYAN SCHOOL OF BUSINESS AND ECONOMICS, UNIVERSITY OF NORTH CAROLINA AT GREENSBORO  
5429 INTERNET TAX ISSUES CHRG-106hhrg67448 Jeanne Lewis Staples.com        
5425 INTERNET TAX ISSUES CHRG-106hhrg67448 John R. LoGalbo PSINet        
5423 INTERNET TAX ISSUES CHRG-106hhrg67448 League of United Latin American Citizens   Brent A. Wilkes BRENT A. WILKES  
5424 INTERNET TAX ISSUES CHRG-106hhrg67448 National Retail Federation   and Ledger Furniture, Les Ledger AND LEDGER FURNITURE, LES LEDGER  
5430 INTERNET TAX ISSUES CHRG-106hhrg67448 Robert P. Strauss   John Heinz III School of Management and Public Policy, Carnegie-Mellon University JOHN HEINZ III SCHOOL OF MANAGEMENT AND PUBLIC POLICY, CARNEGIE-MELLON UNIVERSITY  
5426 INTERNET TAX ISSUES CHRG-106hhrg67448 Salons 4 U   and Glow Shop, Ronald R. and Margaret Honaker AND GLOW SHOP, RONALD R. AND MARGARET HONAKER  
5428 INTERNET TAX ISSUES CHRG-106hhrg67448 Software Finance and Tax Executives Council   Mark E. Nebergall MARK E. NEBERGALL  

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;