About this Dataset

Rates Of Preventable Hospitalizations For Selected Medical Conditions By County (LGHC Indicator)

The dataset contains hospitalization counts and rates, statewide and by county, for 10 ambulatory care sensitive conditions plus 4 composite measures. Hospitalizations due to these medical conditions are potentially preventable through access to high-quality outpatient care. The conditions include: diabetes short-term complications; diabetes long-term complications; chronic obstructive pulmonary disease (COPD) or asthma in older adults (age 40 and over); hypertension; heart failure; community-acquired pneumonia; urinary tract infection; uncontrolled diabetes; asthma in younger adults (age 18-39); and lower-extremity amputation among patients with diabetes. The composite measures include overall, acute conditions, chronic conditions, and diabetes (new, 2016). The data provides a good starting point for assessing quality of health services in the community. The data does not measure hospital quality. Note: In 2015, HCAI (formerly OSHPD) only released the first three quarters of data due to a change in the reporting of diagnoses from ICD-9-CM to ICD-10-CM codes, effective October 1, 2015. Due to the significant differences resulting from the code change, the ICD-9-CM data is distinguished from the ICD-10-CM data in the data file beginning in 2016.
Organization: State of California
Last updated: 2025-07-23T20:55:42.588074
Tags: amputation, angina, asthma, bronchitis, california, chest-pain, chf, complications, congestive-heart-failure, copd, dehydration, department-of-health-care-access-and-information, diabetes, early-intervention, emphysema, hcai, healthcare-information, heart-failure, high-blood-pressure, hospitalization, hypertension, lets-get-healthy-california, lghc, pneumonia, pqi, prevention, prevention-quality-indicator, primary-care, ruptured-appendix, urinary-tract-infection, uti

Tables

Preventable Hospitalizations Data Dictionary

@usgov.ca_gov_rates_of_preventable_hospitalizations_for_selec_6d9ac071.preventable_hospitalizations_data_dictionary

6.58 kB
16 rows
5 columns

CREATE TABLE preventable_hospitalizations_data_dictionary (
  "n__dictionary_rates_of_preventable_hospitalizations_fo_4a402c47" VARCHAR  -- DATA DICTIONARY - Rates Of Preventable Hospitalizations For Selected Medical Conditions By County,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Table 1

@usgov.ca_gov_rates_of_preventable_hospitalizations_for_selec_6d9ac071.table_1

236.5 kB
16,992 rows
14 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "county" VARCHAR,
  "pqi" BIGINT,
  "pqidescription" VARCHAR,
  "count_icd9" DOUBLE,
  "population_icd9" DOUBLE,
  "obsrate_icd9" DOUBLE,
  "riskadjrate_icd9" DOUBLE,
  "count_icd10" DOUBLE,
  "population_icd10" DOUBLE,
  "obsrate_icd10" DOUBLE,
  "riskadjrate_icd10" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);