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

6 rows where package_id = "CHRG-114shrg21998" 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
78694 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Chad Earl Director of Marketing and Business Development ORDERS Construction Company, Inc ORDERS CONSTRUCTION COMPANY, INC  
78697 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Dan Poling Business Manager/Secretary-Treasurer District Council 53, International Union of Painters and Allied Trades DISTRICT COUNCIL 53, INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES  
78692 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Dr. Brian Anderson Director West Virginia University Energy Institute WEST VIRGINIA UNIVERSITY ENERGY INSTITUTE  
78693 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Dr. John Deskins Director West Virginia University Bureau of Business & Economic Research WEST VIRGINIA UNIVERSITY BUREAU OF BUSINESS & ECONOMIC RESEARCH  
78696 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Jeffery Keffer President and Chief Executive Officer Longview Power, LLC LONGVIEW POWER, LLC  
78695 THE ECONOMIC IMPORTANCE OF MODERN, RELIABLE ENERGY INFRASTRUCTURE TO WEST VIRGINIA AND THE UNITED STATES CHRG-114shrg21998 Steve Hedrick President and Chief Executive Officer Mid- Atlantic Technology, Research & Innovation Center (MATRIC) MID- ATLANTIC TECHNOLOGY, RESEARCH & INNOVATION CENTER (MATRIC)  

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;