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

6 rows where package_id = "CHRG-110shrg51815" 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
40601 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Angela S. Baker St. Albans Division of Alcohol and Drug Abuse Programs, Vermont Department of Health, Vermont DIVISION OF ALCOHOL AND DRUG ABUSE PROGRAMS, VERMONT DEPARTMENT OF HEALTH, VERMONT  
40603 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Fred Holmes M.D., Pediatrician and Youth Advocate, St. Albans Vermont VERMONT  
40605 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Gary L. Taylor Chief of Police St. Albans City Police Department ST. ALBANS CITY POLICE DEPARTMENT  
40606 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Hon. Peter Welch   A Representative in Congress from the State of Vermont A REPRESENTATIVE IN CONGRESS FROM THE STATE OF VERMONT  
40604 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Martin Manahan   Mayor, City of St. Albans, Vermont MAYOR, CITY OF ST. ALBANS, VERMONT  
40602 COMMUNITY-BASED SOLUTIONS TO DRUG-RELATED CRIME IN RURAL AMERICA CHRG-110shrg51815 Peter DesLauriers   Chair, St. Albans City Crime Task Force CHAIR, ST. ALBANS CITY CRIME TASK FORCE  

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;