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

9 rows where package_id = "CHRG-105hhrg63934" 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
2438 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Health Care Financing Administration Deputy Administrator Michael Hash MICHAEL HASH  
2442 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Home Care Association of Louisiana   John L. Indest JOHN L. INDEST  
2440 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Medicare Payment Advisory Commission Ph.D., Deputy Director Hon. Gail R. Wilensky, Chair; accompanied by Stuart Guterman HON. GAIL R. WILENSKY, CHAIR; ACCOMPANIED BY STUART GUTERMAN  
2443 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 National Association for Home Care   and California Home Care and Hospice, Inc., Denise Palsgaard AND CALIFORNIA HOME CARE AND HOSPICE, INC., DENISE PALSGAARD  
2444 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Texas Association for Home Care   and Guardian Homecare, Inc., Mary Ann Brock AND GUARDIAN HOMECARE, INC., MARY ANN BROCK  
2445 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Tri County Visiting Nurse Association and Visiting Nurse Service System Ruth Odgren RUTH ODGREN  
2441 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 U.S. Department of Health and Human Services Inspector General Hon. June Gibbs Brown HON. JUNE GIBBS BROWN  
2439 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 U.S. General Accounting Office Ph.D., Director, and Human Services Division William J. Scanlon, Health Financing and Systems Issues, Health, Education WILLIAM J. SCANLON, HEALTH FINANCING AND SYSTEMS ISSUES, HEALTH, EDUCATION  
2446 PAYMENT SYSTEMS FOR MEDICARE'S HOME HEALTH BENEFIT CHRG-105hhrg63934 Visiting Nurse Associations of America   and Visiting Nurse Health System, Jerry Knight AND VISITING NURSE HEALTH SYSTEM, JERRY KNIGHT  

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;