About this Dataset

CA Surgeon Risk-Adjusted Operative Mortality Rates For Coronary Artery Bypass Graft (CABG) Surgery

This dataset provides performance ratings for California Surgeons for Risk-Adjusted Operative Mortality Rates for Coronary Artery Bypass Graft (CABG) Surgery from 2011 to 2018. It also includes the number of isolated CABG surgery cases and deaths that each surgeon performed as well as the location of hospitals where the surgeon performed CABG surgery.
Organization: State of California
Last updated: 2025-07-23T21:43:40.022286
Tags: cabg, cardiac-bypass, cardiac-surgery, coronary-artery-bypass-graft, deaths, department-of-health-care-access-and-information, healthcare, healthcare-quality, heart-bypass, measures, mortality-rate, outcome, patient, performance-rating, risk-adjusted-rate, surgeon-quality

Tables

California-surgeon-performance-ratings-for-cabg-2011-2016

@usgov.ca_gov_ca_surgeon_risk_adjusted_operative_mortality_ra_db628cd5.california_surgeon_performance_ratings_for_cabg_2011_2016

48.1 kB
2,484 rows
11 columns

CREATE TABLE california_surgeon_performance_ratings_for_cabg_2011_2016 (
  "year" VARCHAR,
  "surgeon_id" VARCHAR,
  "surgeon_name" VARCHAR,
  "hospital" VARCHAR,
  "oshpd_id" DOUBLE,
  "total_operative_cases" DOUBLE,
  "cases_of_operative_death" VARCHAR,
  "operative_mortality_risk_adjusted_rate" VARCHAR  -- Operative Mortality Risk Adjusted Rate (%),
  "performance_rating" VARCHAR,
  "longitude" VARCHAR,
  "latitude" VARCHAR
);

2017-2018 California Surgeon Performance Ratings

@usgov.ca_gov_ca_surgeon_risk_adjusted_operative_mortality_ra_db628cd5.n_2017_2018_california_surgeon_performance_ratings

55.17 kB
547 rows
28 columns

CREATE TABLE n_2017_2018_california_surgeon_performance_ratings (
  "year" VARCHAR,
  "surgeon_id" VARCHAR,
  "surgeon_name" VARCHAR,
  "statewide_all_cabg_cases" BIGINT,
  "statewide_isolated_cabg_cases" BIGINT,
  "statewide_isolated_cabg_deaths" BIGINT,
  "statewide_observed_mortality_rate" DOUBLE  -- Statewide Observed Mortality Rate(%),
  "n__surgeon_total_cabg_cases" BIGINT  -- Surgeon Total CABG Cases,
  "n__surgeon_total_isolated_cabg_cases" VARCHAR  -- Surgeon Total Isolated CABG Cases,
  "n__surgeon_total_isolated_cabg_deaths" VARCHAR  -- Surgeon Total Isolated CABG Deaths,
  "overall_surgeon_operative_mortality_risk_adjusted_rate" VARCHAR  -- Overall Surgeon Operative Mortality Risk Adjusted Rate (%),
  "overall_surgeon_lcl" DOUBLE,
  "overall_surgeon_ucl" DOUBLE,
  "overall_performance_rating" VARCHAR,
  "all_cabg_cases_per_hospital" BIGINT,
  "isolated_cabg_cases_per_hospital" VARCHAR,
  "isolated_cabg_deaths_per_hospital" VARCHAR,
  "observed_mortality_rate_per_hospital" VARCHAR  -- Observed Mortality Rate(%) Per Hospital,
  "expected_mortality_rate_per_hospital" VARCHAR  -- Expected Mortality Rate(%) Per Hospital,
  "risk_adjusted_mortality_rate_per_hospital" VARCHAR  -- Risk-Adjusted Mortality Rate(%) Per Hospital,
  "lower_95_ci_per_hospital" VARCHAR,
  "upper_95_ci_per_hospital" VARCHAR,
  "n__performance_rating_per_hospital" VARCHAR  -- Performance Rating Per Hospital,
  "county" VARCHAR,
  "hospital" VARCHAR,
  "oshpd_id" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);