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-107shrg89115" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: organization_normalized

id package_id name ▼ title organization organization_normalized location
14675 THE TENNESSEE VALLEY AUTHORITY AND FINANCIAL DISCLOSURE CHRG-107shrg89115 Alan L. Beller Esq., Director Division of Corporate Finance, U.S. Securities and Exchange Commission DIVISION OF CORPORATE FINANCE, U.S. SECURITIES AND EXCHANGE COMMISSION  
14677 THE TENNESSEE VALLEY AUTHORITY AND FINANCIAL DISCLOSURE CHRG-107shrg89115 Allan G. Pulsipher Executive Director, Marathon Oil Company Professor of Energy Policy Center for Energy Studies, Louisiana State University CENTER FOR ENERGY STUDIES, LOUISIANA STATE UNIVERSITY  
14676 THE TENNESSEE VALLEY AUTHORITY AND FINANCIAL DISCLOSURE CHRG-107shrg89115 Craven Crowell Chairman, GCW Consulting; former Chairman Tennessee Valley Authority TENNESSEE VALLEY AUTHORITY  
14678 THE TENNESSEE VALLEY AUTHORITY AND FINANCIAL DISCLOSURE CHRG-107shrg89115 Daniel Gates Managing Director, Moody's Investors Service      
14674 THE TENNESSEE VALLEY AUTHORITY AND FINANCIAL DISCLOSURE CHRG-107shrg89115 Skila Harris Director Tennessee Valley Authority TENNESSEE VALLEY AUTHORITY  

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;