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

16 rows where package_id = "CHRG-107shrg78068" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
11777 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 A. Brian Wallace chairman Washoe Tribe of Nevada and California WASHOE TRIBE OF NEVADA AND CALIFORNIA  
11763 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Bob Abbey director Nevada Bureau of Land Management NEVADA BUREAU OF LAND MANAGEMENT  
11774 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Dennis D. Murphy Ph.D. Biodiversity Initiative, University of Nevada BIODIVERSITY INITIATIVE, UNIVERSITY OF NEVADA Reno, NV
11772 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Don Henley   Caddo Lake Institute CADDO LAKE INSTITUTE Karmack, TX
11767 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Elsie Dupree president Nevada Wildlife Federation NEVADA WILDLIFE FEDERATION Reno, NV
11770 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Elsie Dupree Memorandum        
11771 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Gary Graham division director, Texas Parks and Wildlife Service      
11776 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Hon. Max Sandlin   U.S. Representative from the State of Texas U.S. REPRESENTATIVE FROM THE STATE OF TEXAS  
11766 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Karen Denio acting state executive director, Farm Service Agency U.S. Department of Agriculture U.S. DEPARTMENT OF AGRICULTURE  
11773 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Larry Johnson president Nevada Bighorns Unlimited, Reno, Nevada NEVADA BIGHORNS UNLIMITED, RENO, NEVADA  
11764 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Leta Collard   Northeastern Nevada Stewardship Group NORTHEASTERN NEVADA STEWARDSHIP GROUP Elko, NV
11768 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 NWF Works on Sage Grouse Booklet Article        
11769 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Nevada Wildlife Federation Letter        
11775 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Nick Pearson Natural Resources Conservation Service State conservationist, Department of Agriculture STATE CONSERVATIONIST, DEPARTMENT OF AGRICULTURE  
11778 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Robert D. Williams   field supervisor, Nevada Fish and Wildlife Office FIELD SUPERVISOR, NEVADA FISH AND WILDLIFE OFFICE  
11765 STATE WILDLIFE CONSERVATION NEEDS CHRG-107shrg78068 Terry Crawforth administrator Nevada Division of Wildlife NEVADA DIVISION OF WILDLIFE  

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;