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-113shrg91819" 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
71464 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Blayne Smith Executive Director Team Red, White and Blue TEAM RED, WHITE AND BLUE  
71463 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Elspeth Cameron Ritchie M.D., USA (Ret.), Chief Clinical Officer COL, District of Columbia's Department of Mental Health COL, DISTRICT OF COLUMBIA'S DEPARTMENT OF MENTAL HEALTH  
71459 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Harold Kudler M.D., Chief Consultant for Mental Health Services, Ph.D., Deputy Director, M.D., Deputy Director Veterans Health Administration, U.S. Department of Veterans Affairs; accompanied by Caitlin Thompson, Suicide Prevention; and Dean D. Krahn, Office of Mental Health Operations VETERANS HEALTH ADMINISTRATION, U.S. DEPARTMENT OF VETERANS AFFAIRS; ACCOMPANIED BY CAITLIN THOMPSON, SUICIDE PREVENTION; AND DEAN D. KRAHN, OFFICE OF MENTAL HEALTH OPERATIONS  
71458 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Hon. John Walsh   U.S. Senator from Montana U.S. SENATOR FROM MONTANA  
71460 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Susan Selke   mother of Clay Hunt, a deceased Marine Corps veteran MOTHER OF CLAY HUNT, A DECEASED MARINE CORPS VETERAN  
71461 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Valerie Pallotta   mother of Joshua Pallotta, a deceased Vermont National Guard combat veteran MOTHER OF JOSHUA PALLOTTA, A DECEASED VERMONT NATIONAL GUARD COMBAT VETERAN  
71462 MENTAL HEALTH AND SUICIDE AMONG VETERANS CHRG-113shrg91819 Vincent Vanata   MSgt, USMC (Ret.), Combat Stress Recovery Program participant, Wounded Warrior Project MSGT, USMC (RET.), COMBAT STRESS RECOVERY PROGRAM PARTICIPANT, WOUNDED WARRIOR PROJECT  

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;