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-115hhrg36787" 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
85804 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Brooke Coleman Executive Director Advanced Biofuels Business Council ADVANCED BIOFUELS BUSINESS COUNCIL  
85803 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Chet Thompson President and Chief Executive Officer American Fuel and Petrochemical Manufacturers AMERICAN FUEL AND PETROCHEMICAL MANUFACTURERS  
85807 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 David Fialkov Vice President, Government Relations/Legislative and Regulatory Counsel National Association of Truckstop Owners NATIONAL ASSOCIATION OF TRUCKSTOP OWNERS  
85801 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Emily Skor Chief Executive Officer Growth Energy GROWTH ENERGY  
85802 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Geoff Cooper President and Chief Executive Officer Renewable Fuels Association RENEWABLE FUELS ASSOCIATION  
85808 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Kurt Kovarik Vice President of Federal Affairs National Biodiesel Board NATIONAL BIODIESEL BOARD  
85806 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Manning Feraci Director of Federal Affairs Coalition for Renewable Natural Gas COALITION FOR RENEWABLE NATURAL GAS  
85805 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Michael McAdams President Advanced Biofuels Association ADVANCED BIOFUELS ASSOCIATION  
85799 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 R. Timothy Columbus Counsel National Association of Convenience Stores and Society of Independent Gasoline Marketers of America NATIONAL ASSOCIATION OF CONVENIENCE STORES AND SOCIETY OF INDEPENDENT GASOLINE MARKETERS OF AMERICA  
85798 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Steve Zimmer Executive Director United States Council for Automotive Research UNITED STATES COUNCIL FOR AUTOMOTIVE RESEARCH  
85800 DISCUSSION DRAFT: THE 21ST CENTURY TRANSPORTATION FUELS ACT CHRG-115hhrg36787 Wesley Spurlock Past President and Chairman National Corn Growers Association NATIONAL CORN GROWERS ASSOCIATION  

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;