ExperimentalWe used data and feedback to make a user-friendly site. We’d love your feedback.
Back to data.ca.gov.

Data Dictionary Preventable Hospitalizations (Age <18)

Preview

Published by:
Department of Health Care Access and Information
Last updated:
April 10, 2025
File details:
N/A
Access data:
Description:

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.

Data preview

You’re previewing the first 50 rows of this file.

Field Title
Field Name
Data Type
Description
County
County
Plain Text
County in which the patient resided.
Pediatric Quality Indicator Code
PDI
Number
Pediatric Quality Indicator Code.
Pediatric Quality Indicator Description
PDIDescription
Plain Text
Pediatric Quality Indicator Description.
Count (ICD-9-CM)
Count_ICD9
Number
[2005-2015] Count of hospitalizations with selected medical conditions. Counts < 11 are not displayed.
Population (ICD-9-CM)
Population_ICD9
Number
[2005-2015] Population at risk. The Population is not displayed for Counts >0 and <11. For PDI #17-Perforated Appendix, the Population is the number of appendicitis cases. For PQI #9-Low Birth Weight, the Population is the number of newborns.
Observed Rate (ICD-9-CM)
ObsRate_ICD9
Number
[2005-2015] Observed rate per 100,000 population (count/population x 100,000). For PDI #17-Perforated Appendix, the observed rate is reported "per 1000 appendicitis cases" and for PQI #9-Low Birth Weight, "per 1000 newborns" (count/population x 1000).
Risk-Adjusted Rate (ICD-9-CM)
RiskAdjRate_ICD9
Number
[2005-2015, not available in 2016] Risk-adjusted rate per 100,000 population. For PDI #17-Perforated Appendix, the risk-adjusted rate is reported "per 1000" appendicitis cases and for PQI #9-Low Birth Weight, "per 1000 newborns.". The risk-adjusted rate is the rate the state/county would have if it had an age-sex case-mix like the Reference population (i.e. 2012 State Inpatient Database (numerator), 2012 U.S. Census population (denominator)).
Count (ICD-10-CM)
Count_ICD10
Number
[Beginning 2016] Count of hospitalizations with selected medical conditions. Counts < 11 are not displayed.
Population (ICD-10-CM)
Population_ICD10
Number
[Beginning 2016] Population at risk. The Population is not displayed for Counts >0 and <11.
Observed Rate (ICD-10-CM)
ObsRate_ICD10
Number
[Beginning in 2016] Observed rate per 100,000 population (count/population x 100,000).
Risk-Adjusted Rate (ICD-10-CM)
RiskAdjRate_ICD10
Number
[Beginning 2016] Risk-adjusted rate per 100,000 population. The risk-adjusted rate is the rate the state/county would have if it had an age-sex-poverty case mix like the Reference population (i.e. 2021 State Inpatient Database (numerator), 2021 U.S. Census population (denominator)).
Annotation Code (Masking)
AnnotationCode
Number
[Beginning 2016] 1=Cell suppressed for small numbers; 2=Cell suppressed for complementary cell.
Annotation Description (Masking)
AnnotationDesc
Plain Text
[Beginning 2016] 1=Cell suppressed for small numbers; 2=Cell suppressed for complementary cell.

Rows per page:

1–13 of 13

Data dictionary

You’re previewing the first 50 rows of this data dictionary.

Field Title
Field Name
Data Type
Description
County
County
Plain Text
County in which the patient resided.
Pediatric Quality Indicator Code
PDI
Number
Pediatric Quality Indicator Code.
Pediatric Quality Indicator Description
PDIDescription
Plain Text
Pediatric Quality Indicator Description.
Count (ICD-9-CM)
Count_ICD9
Number
[2005-2015] Count of hospitalizations with selected medical conditions. Counts < 11 are not displayed.
Population (ICD-9-CM)
Population_ICD9
Number
[2005-2015] Population at risk. The Population is not displayed for Counts >0 and <11. For PDI #17-Perforated Appendix, the Population is the number of appendicitis cases. For PQI #9-Low Birth Weight, the Population is the number of newborns.

Rows per page:

1–13 of 13

API endpoint

Dataset Name

Use the query web API to retrieve data with a set of basic parameters. Copy the API endpoint you need to start.

Usage documentation