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

7 rows where package_id = "CHRG-114hhrg21616" 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
73221 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Alexandra Sandoval Director New Mexico Department of Game & Fish, Santa Fe, New Mexico NEW MEXICO DEPARTMENT OF GAME & FISH, SANTA FE, NEW MEXICO  
73216 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Brian Bean   Owner, Lava Lake Land & Livestock LLC and Lava Lake Lamb, Hailey, Idaho OWNER, LAVA LAKE LAND & LIVESTOCK LLC AND LAVA LAKE LAMB, HAILEY, IDAHO  
73219 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Gordon Myers Executive Director North Carolina Wildlife Resources Commission, Raleigh, North Carolina NORTH CAROLINA WILDLIFE RESOURCES COMMISSION, RALEIGH, NORTH CAROLINA  
73222 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 John Vucetich Associate Professor School of Forest Resources and Environmental Science, Michigan Technological University, Houghton, Michigan SCHOOL OF FOREST RESOURCES AND ENVIRONMENTAL SCIENCE, MICHIGAN TECHNOLOGICAL UNIVERSITY, HOUGHTON, MICHIGAN  
73217 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Steve Guertin Deputy Director for Policy, U.S. Fish and Wildlife Service U.S. Department of the Interior U.S. DEPARTMENT OF THE INTERIOR Washington, DC
73220 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Tom Paterson   Owner, Spur Ranch Cattle Company LLC, Luna, New Mexico OWNER, SPUR RANCH CATTLE COMPANY LLC, LUNA, NEW MEXICO  
73218 THE STATUS OF THE FEDERAL GOVERNMENT'S MANAGEMENT OF WOLVES CHRG-114hhrg21616 Virgil Moore Director Idaho Department of Fish and Game, Boise, Idaho IDAHO DEPARTMENT OF FISH AND GAME, BOISE, IDAHO  

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;