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

8 rows where package_id = "CHRG-108hhrg96506" 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
18501 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Hon. John Peterson Co- Chairman U.S. House of Representatives (PA-5), House Rural Caucus U.S. HOUSE OF REPRESENTATIVES (PA-5), HOUSE RURAL CAUCUS  
18507 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. Bill Prindle Deputy Director American Council for an Energy Efficient Economy AMERICAN COUNCIL FOR AN ENERGY EFFICIENT ECONOMY  
18505 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. Billy Willard President, Willard Agri-Service of Frederick Inc INC  
18503 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. Brent Rockhold   National Association of Corn Growers NATIONAL ASSOCIATION OF CORN GROWERS  
18502 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. Hal Swaney   Missouri Farm Bureau MISSOURI FARM BUREAU  
18504 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. J. Fletcher Smoak Chairman & CEO Old Virginia Brick, Inc OLD VIRGINIA BRICK, INC  
18506 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Mr. Peter Huntsman   Huntsman, LLC HUNTSMAN, LLC  
18500 HEARING ON IMPACT OF HIGH NATURAL GAS PRICES ON SMALL FARMERS AND MANUFACTURERS CHRG-108hhrg96506 Page King Hon. Steve, Co- Founder U.S. House of Representatives (IA-5), House Agriculture Energy Users Caucus U.S. HOUSE OF REPRESENTATIVES (IA-5), HOUSE AGRICULTURE ENERGY USERS CAUCUS  

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;