Dataset: California Hospital Inpatient Mortality Rates And Quality Ratings

About this Dataset

California Hospital Inpatient Mortality Rates And Quality Ratings

The dataset contains risk-adjusted mortality rates, quality ratings, 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 5 procedures performed (Abdominal Aortic Aneurysm Repair, Unruptured/Open, Abdominal Aortic Aneurysm Repair, Unruptured/Endovascular, Carotid Endarterectomy, Pancreatic Resection, Percutaneous Coronary Intervention) in California hospitals. The 2022 IMIs were generated using AHRQ Version 2023, while previous years' IMIs were generated with older versions of AHRQ software (2021 IMIs by Version 2022, 2020 IMIs by Version 2021, 2019 IMIs by Version 2020, 2016-2018 IMIs by Version 2019, 2014 and 2015 IMIs by Version 5.0, and 2012 and 2013 IMIs by 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 statewide table for California overall rates: https://data.chhs.ca.gov/dataset/california-hospital-inpatient-mortality-rates-and-quality-ratings/resource/af88090e-b6f5-4f65-a7ea-d613e6569d96
Organization: State of California
Last updated: 2024-11-27T01:07:32.726864
Tags: aaa-repair, abdominal-aortic-aneurysm, acute-myocardial-infarction, acute-stroke, agency-for-healthcare-research-and-quality, ahrq, ami, angioplasty, brain-surgery, 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 2

@usgov.ca_gov_california_hospital_inpatient_mortality_rates_a_a829a653.table_2

147.09 KB
30238 rows
11 columns


CREATE TABLE table_2 (
  "year" BIGINT,
  "county" VARCHAR,
  "hospital" VARCHAR,
  "oshpdid" VARCHAR,
  "procedure_condition" VARCHAR,
  "risk_adjuested_mortality_rate" VARCHAR,
  "n__of_deaths" VARCHAR,
  "n__of_cases" VARCHAR,
  "hospital_ratings" VARCHAR,
  "longitude" VARCHAR,
  "latitude" VARCHAR
);