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-115hhrg36069" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
85750 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 Curtis Cunningham Vice President, and Assistant Administrator, Division of Medicaid Services, Department of Health Services National Association of States United for Aging and Disabilities (NASUAD), Long-Term Care Benefits And Programs, State of Wisconsin NATIONAL ASSOCIATION OF STATES UNITED FOR AGING AND DISABILITIES (NASUAD), LONG-TERM CARE BENEFITS AND PROGRAMS, STATE OF WISCONSIN  
85754 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 David Yoder Pharm.D., M.B.A., Executive Director of Member Care and Benefits Blue Cross Blue Shield Association's Federal Employee Plan BLUE CROSS BLUE SHIELD ASSOCIATION'S FEDERAL EMPLOYEE PLAN  
85753 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 Derek Schmidt J.D. Attorney General, State of Kansas ATTORNEY GENERAL, STATE OF KANSAS  
85749 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 Hugh M. Chancy and Member, Board of Directors RPH, Owner, Chancy Drugs, Hahira, Georgia, National Community Pharmacists Association RPH, OWNER, CHANCY DRUGS, HAHIRA, GEORGIA, NATIONAL COMMUNITY PHARMACISTS ASSOCIATION  
85751 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 Matt Salo Executive Director, National Association of Medicaid Directors      
85752 OPPORTUNITIES TO IMPROVE HEALTH CARE CHRG-115hhrg36069 Rick Merrill President and CEO, Cook Children's Health Care System Fort Worth, Texas FORT WORTH, TEXAS  

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;