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

20 rows where package_id = "CHRG-107shrg86217" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
13868 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Al Davis   Rancher, Hyannis, Nebraska RANCHER, HYANNIS, NEBRASKA  
13870 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Arthur Duvall   Soybean Grower, on behalf of Nebraska Soybean Association, Ord, Nebraska SOYBEAN GROWER, ON BEHALF OF NEBRASKA SOYBEAN ASSOCIATION, ORD, NEBRASKA  
13857 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Brian Wolford State Executive Director, Nebraska Farm Service Agency      
13869 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Dale Dueland McCook Farmer, Nebraska FARMER, NEBRASKA  
13859 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 David Bruntz Past President Nebraska Cattlemen, Inc NEBRASKA CATTLEMEN, INC  
13858 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Don Batie   Farmer, Dawson County, Nebraska; on behalf of the Nebraska Farm Bureau FARMER, DAWSON COUNTY, NEBRASKA; ON BEHALF OF THE NEBRASKA FARM BUREAU  
13866 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 James Vonderstrasse Vice President for Legislation National Grain Sorghum Producers NATIONAL GRAIN SORGHUM PRODUCERS  
13871 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Jeremie Kerkman   on behalf of the Central Nebraska Public Power and Irrigation District ON BEHALF OF THE CENTRAL NEBRASKA PUBLIC POWER AND IRRIGATION DISTRICT  
13860 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 John K. Hansen President Nebraska Farmers Union, Lincoln, Nebraska NEBRASKA FARMERS UNION, LINCOLN, NEBRASKA  
13861 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Joy M. Philippi Board Member National Pork Producers Council NATIONAL PORK PRODUCERS COUNCIL  
13862 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Keith J. Dittrich President American Corn Growers Association AMERICAN CORN GROWERS ASSOCIATION  
13863 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Lee Klein Immediate Past President National Corn Growers Association NATIONAL CORN GROWERS ASSOCIATION  
13864 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Mark Schweers President American Corn Growers Association AMERICAN CORN GROWERS ASSOCIATION  
13853 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Merlyn Carlson Director Nebraska Department of Agriculture NEBRASKA DEPARTMENT OF AGRICULTURE  
13855 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Rebecca Davis Director of the Topeka Regional Office Risk Management Agency, U.S. Department of Agriculture RISK MANAGEMENT AGENCY, U.S. DEPARTMENT OF AGRICULTURE  
13867 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Ron Cacek Manager, and Chairman, Natural Resources District Managers Committee North Platte Natural Resources District NORTH PLATTE NATURAL RESOURCES DISTRICT  
13865 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Ron Stoddard Executive Director Nebraska Wheat Board NEBRASKA WHEAT BOARD  
13854 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Stephen K. Chick USDA-Natural Resources Conservation Service State Conservationist STATE CONSERVATIONIST  
13856 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Susan France Division Manager of Water Administration State Department of Natural Resources STATE DEPARTMENT OF NATURAL RESOURCES  
13872 HEARING ON DROUGHT CONDITIONS CHRG-107shrg86217 Vern Steinman OGT Volunteer Manager Operation Hay and Grain Lift, Norfolk, Nebraska OPERATION HAY AND GRAIN LIFT, NORFOLK, NEBRASKA  

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;