About this Dataset

Elective Percutaneous Coronary Intervention (PCI) Program Reports

This dataset contains the location of California hospitals that are certified to perform elective percutaneous coronary interventions (PCIs) without on-site cardiac surgery. The data provides performance ratings for three outcome measures: mortality, post-PCI stroke, and post-PCI emergency coronary artery bypass graft surgery. It includes the number of cases, adverse events and risk-adjusted rates for certified hospitals compared to the overall observed statewide rates.
Organization: State of California
Last updated: 2025-07-23T14:59:00.258210
Tags: cardiac-surgery, deaths, department-of-health-care-access-and-information, elective-pci, healthcare, hospital-quality, measures, pci, pci-mortality, performance-rating, post-pci-cabg-surgery, post-pci-stroke, primary-pci, ratings, risk-adjusted

Tables

Elective Percutaneous Coronary Interventions (PCIs) Without On-Site Cardiac Surgery

@usgov.ca_gov_elective_percutaneous_coronary_intervention_pci_576c4f2a.elective_percutaneous_coronary_interventions_pcis_with_9f19783a

29.27 kB
804 rows
19 columns

CREATE TABLE elective_percutaneous_coronary_interventions_pcis_with_9f19783a (
  "year" BIGINT,
  "county" VARCHAR,
  "hospital" VARCHAR,
  "hospital_id" BIGINT,
  "performance_measure" VARCHAR,
  "statewide_all_pci_cases" BIGINT,
  "statewide_elective_pcis" BIGINT,
  "statewide_adverse_events" VARCHAR,
  "statewide_observedadverse_events_rate" VARCHAR  -- Statewide ObservedAdverse Events Rate (%),
  "hospital_total_pci_cases" BIGINT,
  "hospital_all_elective_pci_cases" BIGINT,
  "hospital_elective_pci_cases" BIGINT,
  "hospital_primary_pci_cases" BIGINT,
  "n__hospital_adverse_events" BIGINT  -- Hospital Adverse Events,
  "hospital_observedadverse_events_rate" VARCHAR  -- Hospital ObservedAdverse Events Rate (%),
  "n__hospital_expected_adverse_events_rate" VARCHAR  -- Hospital Expected Adverse Events Rate (%),
  "hospital_risk_adjusted_adverse_events_rate_raaer" VARCHAR  -- Hospital Risk-Adjusted Adverse Events Rate (%, RAAER),
  "latitude" DOUBLE,
  "longitude" DOUBLE
);