About this Dataset

Number Of Selected Inpatient Medical Procedures In California Hospitals

This dataset contains the number (volume) of 6 selected inpatient procedures (Esophageal Resection, Pancreatic Resection, Abdominal Aortic Aneurysm Repairs (AAA Repairs), Carotid Endarterectomy, Coronary Artery Bypass Graft Surgery, Percutaneous Coronary Intervention) performed in California hospitals. Data are reported for January – September 2015 due to coding changes from ICD-9-CM to ICD-10-CM/PCS for procedures, which began 10/1/2015. Comparisons across years should be made with caution since other years’ results are based on 12 months of data, while 2015 analysis is based on 9 months of data. The data starting 2015 may differ from previous years due to the coding change. This dataset does not include procedures performed in outpatient settings.
Organization: State of California
Last updated: 2023-10-13T18:11:21.713724
Tags: aaa-repair, abdominal-aortic-aneurysm-repair, agency-for-healthcare-research-and-quality, ahrq, angioplasty, cabg, carotid-endarterectomy, coronary-artery-bypass-graft-surgery, department-of-health-care-access-and-information, esophageal-cancer-surgery, esophageal-resection, healthcare-quality, heart-bypass, hospital-quality, hospital-volume, indicators, inpatient-quality, inpatient-quality-indicators, pancreatic-cancer-surgery, pancreatic-resection, pci, percutaneous-coronary-intervention, stents, volume

Tables

Table 2

@usgov.ca_gov_number_of_selected_inpatient_medical_procedures_977152b4.table_2

125.83 kB
49,896 rows
9 columns

CREATE TABLE table_2 (
  "year" BIGINT,
  "county" VARCHAR,
  "hospital_name" VARCHAR,
  "oshpdid" DOUBLE,
  "procedure" VARCHAR,
  "volume" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR
);