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

10 rows where package_id = "CHRG-115shrg55981" 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
88069 THE STATE OF OUR SALMON CHRG-115shrg55981 Bill Templin M.S., Chief Fisheries Scientist Division of Commercial Fisheries, Alaska Department of Fish and Game DIVISION OF COMMERCIAL FISHERIES, ALASKA DEPARTMENT OF FISH AND GAME  
88067 THE STATE OF OUR SALMON CHRG-115shrg55981 Chris Oliver Assistant Administrator for Fisheries, National Marine Fisheries Service National Oceanic and Atmospheric Administration, U.S. Department of Commerce NATIONAL OCEANIC AND ATMOSPHERIC ADMINISTRATION, U.S. DEPARTMENT OF COMMERCE  
88076 THE STATE OF OUR SALMON CHRG-115shrg55981 Danielle Dickson Senior Program Manager, Chief Officer for Collaboration and Synthesis North Pacific Research Board NORTH PACIFIC RESEARCH BOARD  
88072 THE STATE OF OUR SALMON CHRG-115shrg55981 Dr. Matthew Baker Ph.D., Science Director North Pacific Research Board NORTH PACIFIC RESEARCH BOARD  
88071 THE STATE OF OUR SALMON CHRG-115shrg55981 Dr. Milo Adkison Ph.D., Professor and Chair Department of Fisheries College of Fisheries and Ocean Sciences, University of Alaska Fairbanks COLLEGE OF FISHERIES AND OCEAN SCIENCES, UNIVERSITY OF ALASKA FAIRBANKS  
88070 THE STATE OF OUR SALMON CHRG-115shrg55981 James Hasbrouck Ph.D., Chief Fisheries Scientist Division of Sportfish, Alaska Department of Fish and Game DIVISION OF SPORTFISH, ALASKA DEPARTMENT OF FISH AND GAME  
88073 THE STATE OF OUR SALMON CHRG-115shrg55981 Karen Gillis Executive Director Bering Sea Fishermen's Association BERING SEA FISHERMEN'S ASSOCIATION  
88074 THE STATE OF OUR SALMON CHRG-115shrg55981 Katrina Hoffman M.S., President and CEO Prince William Sound Science Center PRINCE WILLIAM SOUND SCIENCE CENTER  
88075 THE STATE OF OUR SALMON CHRG-115shrg55981 Mary Sattler Peltola Executive Director Kuskokwim River Inter- Tribal Fish Commission KUSKOKWIM RIVER INTER- TRIBAL FISH COMMISSION  
88068 THE STATE OF OUR SALMON CHRG-115shrg55981 Sam Cotten Commissioner Alaska Department of Fish and Game ALASKA DEPARTMENT OF FISH AND GAME  

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;