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-105hhrg50579" 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
1160 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Anthony Lesperance Ph.D., Elko County Commissioner      
1157 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Assemblyman John Carpenter   Nevada Assemblyman NEVADA ASSEMBLYMAN  
1156 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Cathy Barcomb Executive Director Commission for the Preservation of Wild Horses COMMISSION FOR THE PRESERVATION OF WILD HORSES  
1164 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 David C.J. Tattam Field Director National Wild Horse Association NATIONAL WILD HORSE ASSOCIATION  
1158 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Demar Dahl   Rancher RANCHER  
1163 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Duane L. Shroufe Director Arizona Game & Fish Department ARIZONA GAME & FISH DEPARTMENT  
1155 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 John Balliette Eureka County Natural Resources Manager      
1159 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Rey Flake Lincoln County Commissioner      
1154 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Robert V. Abbey Nevada State Director BLM BLM  
1161 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Senator Dean Rhoads Chairman of the Senate Natural Resources Committee Nevada Legislature NEVADA LEGISLATURE  
1162 RANGE ISSUES AND PROBLEMS WITH THE WILD HORSE AND BURRO ACT AND ITS IMPLEMENTATION CHRG-105hhrg50579 Sheila Hughes Rodriguez Counsel Animal Protection Institute ANIMAL PROTECTION INSTITUTE  

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;