About this Dataset

Rates Of Preventable Hospitalizations (Age<18) For Selected Medical Conditions By County

The dataset currently contains hospitalization counts and rates, statewide and by county, for 4 conditions plus 3 composite measures. Hospitalizations for these conditions are potentially preventable through access to high-quality outpatient care. The conditions include: asthma (age 2-17), diabetes short-term complications (age 6-17), gastroenteritis (age 3 months-17 years), perforated appendix (retired, 2016), urinary tract infections (age 3 months-17 years), and low birth weight (<2500 grams; retired, 2016). The composite measures (age 6-17) include overall, acute conditions, and chronic conditions. 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 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:56.853854
Tags: asthma, california, complications, department-of-health-care-access-and-information, diabetes, early-intervention, gastroenteritis, hcai, healthcare-information, hospitalization, low-birth-weight, office-of-statewide-health-planning-and-development, oshpd, pdi, pediatric-quality-indicator, prevention, primary-care, ruptured-appendix, urinary-tract-infection, uti

Tables

Data Dictionary Preventable Hospitalizations (Age <18)

@usgov.ca_gov_rates_of_preventable_hospitalizations_age18_for_7b5c8784.data_dictionary_preventable_hospitalizations_age_18

5.1 kB
14 rows
4 columns

CREATE TABLE data_dictionary_preventable_hospitalizations_age_18 (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Table 1

@usgov.ca_gov_rates_of_preventable_hospitalizations_age18_for_7b5c8784.table_1

114.72 kB
9,167 rows
14 columns

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