About this Dataset

California Statewide Inpatient Mortality Rates

The dataset contains risk-adjusted mortality rates, and number of deaths and cases for 6 medical conditions treated (Acute Stroke, Acute Myocardial Infarction, Heart Failure, Gastrointestinal Hemorrhage, Hip Fracture and Pneumonia) and 6 procedures performed (Abdominal Aortic Aneurysm Repair, Carotid Endarterectomy, Craniotomy, Esophageal Resection, Pancreatic Resection, Percutaneous Coronary Intervention) in California hospitals. The 2014 and 2015 IMIs were generated using AHRQ Version 5.0, while the 2012 and 2013 IMIs were generated using AHRQ Version 4.5. The differences in the statistical method employed and inclusion and exclusion criteria using different versions can lead to different results. Users should not compare trends of mortality rates over time. However, many hospitals showed consistent performance over years; “better” performing hospitals may perform better and “worse” performing hospitals may perform worse consistently across years. This dataset does not include conditions treated or procedures performed in outpatient settings. Please refer to hospital table for hospital rates: https://data.chhs.ca.gov/dataset/california-hospital-inpatient-mortality-rates-and-quality-ratings
Organization: State of California
Last updated: 2025-07-23T21:43:48.933933
Tags: aaa-repair, abdominal-aortic-aneurysm, acute-myocardial-infarction, acute-stroke, agency-for-healthcare-research-and-quality, ahrq, ami, angioplasty, brain-surgery, ca-statewide, carotid-endarterectomy, craniotomy, department-of-health-care-access-and-information, esophageal-cancer-surgery, esophageal-resection, gastro-intestinal-hemorrhage, healthcare-quality, heart-failure, hemorrhagic-stroke, hip-fracture, hospital-deaths, hospital-mortality, hospital-quality, imi, inpatient-deaths, inpatient-mortality-indicators, inpatient-quality, inpatient-quality-indicators, ischemic-stroke, pancreatic-cancer-surgery, pancreatic-resection, pci, percutaneous-coronary-intervention, pneumonia, stents, subarachnoid-stroke

Tables

Table 1

@usgov.ca_gov_california_statewide_inpatient_mortality_rates_7037d.table_1

6.4 KB
68 rows
6 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "hospital" VARCHAR,
  "procedure_condition" VARCHAR,
  "risk_adjuested_mortality_rate" DOUBLE,
  "n__of_deaths" BIGINT,
  "n__of_cases" BIGINT
);

Table 2

@usgov.ca_gov_california_statewide_inpatient_mortality_rates_7037d.table_2

3.72 KB
6 rows
4 columns


CREATE TABLE table_2 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);