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

17 rows where package_id = "CHRG-110hhrg36572" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized, location

id package_id name ▼ title organization organization_normalized location
31006 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 A. Gary Muller president and chief executive officer     West Jefferson Medical Center Marrero, LA
31005 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Alan Miller Ph.D., M.D., interim senior vice president for health sciences Tulane University Health Sciences Center TULANE UNIVERSITY HEALTH SCIENCES CENTER New Orleans, LA
30996 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Bryan Bertucci M.D. coroner/family physician, St. Bernard Health Center CORONER/FAMILY PHYSICIAN, ST. BERNARD HEALTH CENTER Chalmette, LA
31000 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Cathi Fontenot M.D., medical director Medical Center of Louisiana at New Orleans MEDICAL CENTER OF LOUISIANA AT NEW ORLEANS New Orleans, LA
31009 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Diane Rowland executive vice president the Henry J. Kaiser Family Foundation THE HENRY J. KAISER FAMILY FOUNDATION Washington, DC
31010 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Donald R. Smithburg executive vice president, chief executive officer, Health Care Services Division Louisiana State University LOUISIANA STATE UNIVERSITY Baton Rouge, LA
30999 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Donald T. Erwin M.D., president and chief executive officer St. Thomas Community Health Center ST. THOMAS COMMUNITY HEALTH CENTER New Orleans, LA
31001 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Evangeline R. Franklin M.D., director of Clinical Services and Employee Health City of New Orleans Health Department CITY OF NEW ORLEANS HEALTH DEPARTMENT New Orleans, LA
30997 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Fred Cerise M.D., M.P.H., secretary Louisiana Department of Health and Hospitals LOUISIANA DEPARTMENT OF HEALTH AND HOSPITALS Baton Rouge, LA
31012 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Gary Wiltz M.D. chairperson CHAIRPERSON Region 3 Consortium Franklin, LA
30998 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Karen DeSalvo M.D., executive director Tulane University Community Health Center at Covenant House TULANE UNIVERSITY COMMUNITY HEALTH CENTER AT COVENANT HOUSE New Orleans, LA
31011 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Kevin U. Stephens Sr., M.D., J.D., director city of New Orleans Health Department CITY OF NEW ORLEANS HEALTH DEPARTMENT New Orleans, LA
31002 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Leslie D. Hirsch president and chief executive officer Touro Infirmary TOURO INFIRMARY New Orleans, LA
31007 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Leslie Norwalk acting administrator, Centers for Medicare and Medicaid Services     Washington, DC
31008 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Patrick Quinlan M.D., chief executive officer Ochsner Health System OCHSNER HEALTH SYSTEM New Orleans, LA
31004 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Robert Lynch M.D., director South Central Veterans Affairs Health Care SOUTH CENTRAL VETERANS AFFAIRS HEALTH CARE Jackson, MS
31003 POST KATRINA HEALTH CARE: CONTINUING CONCERNS AND IMMEDIATE NEEDS IN THE NEW ORLEANS REGION CHRG-110hhrg36572 Thomas Koehl director Operation Blessing Disaster Relief Medical Center OPERATION BLESSING DISASTER RELIEF MEDICAL CENTER New Orleans, LA

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;