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

30 rows where package_id = "CHRG-105hhrg51600" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, title, organization_normalized

id package_id name ▼ title organization organization_normalized location
1400 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Bob Hale   Hale Farms, Hermiston, Oregon HALE FARMS, HERMISTON, OREGON  
1401 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Charles D. Kilbury   Mayor, City of Pasco, Washington MAYOR, CITY OF PASCO, WASHINGTON  
1395 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Clyde Ballard   Speaker of the House, Washington State Legislature SPEAKER OF THE HOUSE, WASHINGTON STATE LEGISLATURE  
1404 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Darryll Olsen Ph.D. The Pacific Northwest Project, Kennewick, Washington THE PACIFIC NORTHWEST PROJECT, KENNEWICK, WASHINGTON  
1403 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Dave Mastin Chairman, House-Senate Executive Branch Task Force on Salmon Recovery Washington State Legislature WASHINGTON STATE LEGISLATURE  
1410 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 David Doeringsfeld Manager Port of Lewiston PORT OF LEWISTON  
1418 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Dell Raybould Chairman Committee of Nine, Water District 1 COMMITTEE OF NINE, WATER DISTRICT 1  
1407 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Fred Ziari Chairman Eastern Oregon Irrigation Association, Hermiston, Oregon EASTERN OREGON IRRIGATION ASSOCIATION, HERMISTON, OREGON  
1392 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 James D. Anderson Ph.D., Associate Professor School of Fisheries, University of Washington, Seattle, Washington SCHOOL OF FISHERIES, UNIVERSITY OF WASHINGTON, SEATTLE, WASHINGTON  
1396 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jeff Curtis Western Conservation Director Trout Unlimited, Portland, Oregon TROUT UNLIMITED, PORTLAND, OREGON  
1413 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jerry Klemm President Pulp and Paperworkers Resource Council PULP AND PAPERWORKERS RESOURCE COUNCIL  
1393 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jim Baker Northwest Salmon Campaign Coordinator Sierra Club, Pullman, Washington SIERRA CLUB, PULLMAN, WASHINGTON  
1394 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jim Baker Northwest Salmon Campaign Coordinator Sierra Club, Pullman, Washington SIERRA CLUB, PULLMAN, WASHINGTON  
1415 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jim Little   Idaho Cattle Association IDAHO CATTLE ASSOCIATION  
1399 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 John Givens Executive Director Port of Kennewick, Kennewick, Washington PORT OF KENNEWICK, KENNEWICK, WASHINGTON  
1406 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Jr. Stelle Regional Administrator, National Marine Fisheries Service William, Seattle, Washington WILLIAM, SEATTLE, WASHINGTON  
1402 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Lynn Lundquist   Speaker of the House, Oregon State Legislature SPEAKER OF THE HOUSE, OREGON STATE LEGISLATURE  
1414 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Mark Limbaugh Executive Director Payette River Water Users Association, Inc PAYETTE RIVER WATER USERS ASSOCIATION, INC  
1417 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Mark Pollot   Foundation for Constitutional Law FOUNDATION FOR CONSTITUTIONAL LAW  
1419 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Mitch Sanchotena Executive Director, Idaho Steelhead and Salmon Unlimited      
1411 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Olivia James President The River Company THE RIVER COMPANY  
1408 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Philip E. Batt   Governor, State of Idaho GOVERNOR, STATE OF IDAHO  
1397 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Richard Erickson Secretary/Manager East Columbia Basin Irrigation District, Othello, Washington EAST COLUMBIA BASIN IRRIGATION DISTRICT, OTHELLO, WASHINGTON  
1405 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Rob Phillips Director Northwest Sport Fishing Industry Association, Oregon City, Oregon NORTHWEST SPORT FISHING INDUSTRY ASSOCIATION, OREGON CITY, OREGON  
1416 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Robert A. Maynard   Perkins Coie, LLP PERKINS COIE, LLP  
1409 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Shawn Cantrell Northwest Regional Director Friends of the Earth FRIENDS OF THE EARTH  
1398 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Ted Ferrioli   Oregon State Senate OREGON STATE SENATE  
1412 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Thomas Kerr Commissioner Valley County, Idaho VALLEY COUNTY, IDAHO  
1421 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Tom Stuart Board President Idaho Rivers United IDAHO RIVERS UNITED  
1420 NATIONAL MARINE FISHERIES SERVICE'S IMPLEMENTATION OF THE ENDANGERED SPECIES ACT CHRG-105hhrg51600 Will Stelle National Marine Fisheries Service      

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;