About this Dataset

California Hospital Ratings For Transcatheter Aortic Valve Replacement (TAVR) Procedures

The dataset provides performance ratings for two outcome measures for transcatheter aortic valve replacement (TAVR) procedures: in-hospital/30-day mortality and in-hospital/30-day stroke. It includes the number of cases, adverse events, risk-adjusted rates, and performance ratings for hospitals compared to the overall statewide rates. This dataset also contains the location of hospitals that perform TAVR procedures in California.
Organization: State of California
Last updated: 2025-07-23T16:15:44.029631
Tags: cardiac-intervention, deaths, department-of-health-care-access-and-information, healthcare, healthcare-outcomes, hospital-quality, measure, mortality, performance-ratings, post-operative-stroke, risk-adjusted-rates, tavr, transcatheter-aortic-valve-procedures

Tables

2022-2023 California Hospital Performance Ratings For TAVR Procedures

@usgov.ca_gov_california_hospital_ratings_for_transcatheter_a_e0477e54.n_2022_2023_california_hospital_performance_ratings_fo_08fdf5a4

28.64 kB
336 rows
19 columns

CREATE TABLE n_2022_2023_california_hospital_performance_ratings_fo_08fdf5a4 (
  "year" BIGINT,
  "county" VARCHAR,
  "hospital_system" VARCHAR,
  "hospital" VARCHAR,
  "hospital_id" BIGINT,
  "performance_measure" VARCHAR,
  "total_statewide_tavr_cases" BIGINT,
  "statewide_adverse_events" BIGINT,
  "statewide_observed_adverse_event_rate" DOUBLE  -- Statewide Observed Adverse Event Rate (%),
  "total_hospital_tavr_cases" BIGINT,
  "n__hospital_adverse_events" BIGINT  -- Hospital Adverse Events,
  "hospital_observed_adverse_event_rate" DOUBLE  -- Hospital Observed Adverse Event Rate (%),
  "hospital_expected_adverse_event_rate" DOUBLE  -- Hospital Expected Adverse Event Rate (%),
  "hospital_risk_adjusted_adverse_event_rate_raaer" DOUBLE  -- Hospital Risk-Adjusted Adverse Event Rate (%, RAAER),
  "hospital_lower_95_ci_for_raaer" DOUBLE  -- Hospital Lower 95% CI For RAAER,
  "hospital_upper_95_ci_for_raaer" DOUBLE  -- Hospital Upper 95% CI For RAAER,
  "performance_rating" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);