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

14 rows where package_id = "CHRG-113shrg92906" 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
71560 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Anthony J. Preite Rural Development State Director for Montana United States Department of Agriculture UNITED STATES DEPARTMENT OF AGRICULTURE  
71551 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. A.T. Stafne Chairman Assiniboine and Sioux Tribes of the Fort Peck Reservation ASSINIBOINE AND SIOUX TRIBES OF THE FORT PECK RESERVATION  
71552 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. Angela McLean Lieutenant Governor State of Montana STATE OF MONTANA  
71559 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. Craig Anderson Sheriff Dawson County, Montana DAWSON COUNTY, MONTANA  
71555 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. Michael W. Cotter   United States Attorney, District of Montana, U.S. Department of Justice UNITED STATES ATTORNEY, DISTRICT OF MONTANA, U.S. DEPARTMENT OF JUSTICE  
71554 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. Rick Norby   Mayor, Sidney, Montana MAYOR, SIDNEY, MONTANA  
71558 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Hon. Tim Fox   Attorney General, State of Montana ATTORNEY GENERAL, STATE OF MONTANA  
71562 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 John K. Dynneson Deputy Sheriff, Richland County Sheriff's Department      
71553 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Leslie Messer Executive Director Richland Economic Development Corp RICHLAND ECONOMIC DEVELOPMENT CORP  
71564 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Loren Young Chairman Richland County Commission RICHLAND COUNTY COMMISSION  
71556 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Michael K. Gottlieb National Director High Intensity Drug Trafficking Areas (HIDTA) Program, Office of National Drug Control Policy HIGH INTENSITY DRUG TRAFFICKING AREAS (HIDTA) PROGRAM, OFFICE OF NATIONAL DRUG CONTROL POLICY  
71561 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Mike Tooley Director Montana Department of Transportation MONTANA DEPARTMENT OF TRANSPORTATION  
71563 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Paul Groshart Director Richland County Housing Authority RICHLAND COUNTY HOUSING AUTHORITY  
71557 THE BAKKEN: EXAMINING EFFORTS TO ADDRESS LAW ENFORCEMENT, INFRASTRUCTURE AND ECONOMIC DEVELOPMENT NEEDS CHRG-113shrg92906 Scott Vito Assistant Special Agent in Charge Salt Lake City Division, Federal Bureau of Investigation SALT LAKE CITY DIVISION, FEDERAL BUREAU OF INVESTIGATION  

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;