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-105hhrg63454" 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
2360 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 American Health Care Association and Integrated Health Services Mary K. Ousley MARY K. OUSLEY  
2361 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 American Hospital Association   and Sentara Health System, David L. Bernd AND SENTARA HEALTH SYSTEM, DAVID L. BERND  
2362 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Blue Cross and Blue Shield Association   and Blue Cross and Blue Shield of Florida, Bruce Davidson AND BLUE CROSS AND BLUE SHIELD OF FLORIDA, BRUCE DAVIDSON  
2364 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Federation of American Health Systems   and Lutheran Hospital of Indiana, Thomas Miller AND LUTHERAN HOSPITAL OF INDIANA, THOMAS MILLER  
2358 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Health Care Financing Administration Administrator Hon. Nancy-Ann Min DeParle HON. NANCY-ANN MIN DEPARLE  
2365 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Hon. Michael Pappas   a Representative in Congress from the State of New Jersey A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW JERSEY  
2363 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Hon. Susan M. Collins   a United States Senator from the State of Maine A UNITED STATES SENATOR FROM THE STATE OF MAINE  
2359 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 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  
2366 ADMINISTRATION'S PLAN TO DELAY IMPLEMENTATION OF THE BALANCED BUDGET ACT OF 1997 CHRG-105hhrg63454 Visiting Nurse Associations of America and Visiting Nurse Service of New York Carol Raphael CAROL RAPHAEL  

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;