About this Dataset

California Hospital Performance Ratings

The dataset provides performance ratings for coronary artery bypass graft (CABG) surgery, inpatient mortality indicators (IMIs), and elective percutaneous coronary intervention (PCI). The outcome measures include: operative mortality for isolated CABG; inpatient mortality for acute stroke, acute myocardial infarction, heart failure, gastrointestinal hemorrhage, hip fracture, pneumonia, abdominal aortic aneurysm repair, carotid endarterectomy, esophageal resection, pancreatic resection, percutaneous coronary intervention; three outcome measures for elective PCI without on-site cardiac surgery: mortality, post-PCI stroke, and post-PCI emergency coronary artery bypass graft surgery; postoperative sepsis following elective surgeries. It includes risk-adjusted rates, number of adverse events and cases.
Organization: State of California
Last updated: 2025-07-23T15:33:36.257858
Tags: aaa-repair, abdominal-aortic-aneurysm, acute-myocardial-infarction, acute-stroke, agency-for-healthcare-research-and-quality, ahrq, ami, angioplasty, brain-surgery, cardiac-bypass, cardiac-surgery, carotic-endarterectomy, coronary-artery-bypass-graft, department-of-health-care-access-and-information, elective-pci, gastro-intestinal-hemorrhage, healthcare, healthcare-quality, heart-bypass, heart-failure, hemorrhagic-stroke, hip-fracture, hospital-quality, inpatient-quality-indicators, ischemic-stroke, measures, mortality, outcome, pancreatic-resection, patient, pci, pci-mortality, percutaneous-coronary-intervention, performance-rating, pneumonia, postoperative-sepsis, risk-adjusted-rate, stents, subarachnoid-stroke

Tables

California Hospital Performance Ratings 2016-2021

@usgov.ca_gov_california_hospital_performance_ratings_c3975.california_hospital_performance_ratings_2016_2021

200.64 kB
27,279 rows
18 columns

CREATE TABLE california_hospital_performance_ratings_2016_2021 (
  "county" VARCHAR,
  "oshpdid" BIGINT,
  "performance_measure" VARCHAR,
  "risk_adjusted_rate" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "type_of_report" VARCHAR,
  "hospital_ratings" VARCHAR,
  "n__of_cases" DOUBLE  -- # Of Cases,
  "n__of_adverse_events" DOUBLE  -- # Of Adverse Events,
  "year" BIGINT,
  "cnt_worse" BIGINT,
  "cnt_better" BIGINT,
  "rating" VARCHAR,
  "procedure_condition" VARCHAR,
  "performance_measure2" VARCHAR,
  "hospital" VARCHAR,
  "system" VARCHAR
);

California Hospital Performance Ratings 2017-2022

@usgov.ca_gov_california_hospital_performance_ratings_c3975.california_hospital_performance_ratings_2017_2022

170.42 kB
27,428 rows
13 columns

CREATE TABLE california_hospital_performance_ratings_2017_2022 (
  "year" BIGINT,
  "county" VARCHAR,
  "hospital" VARCHAR,
  "oshpdid" BIGINT,
  "system" VARCHAR,
  "type_of_report" VARCHAR,
  "performance_measure" VARCHAR,
  "n__of_adverse_events" DOUBLE  -- # Of Adverse Events,
  "n__of_cases" DOUBLE  -- # Of Cases,
  "risk_adjusted_rate" DOUBLE,
  "hospital_ratings" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);