Preventable Hospitalizations Data Dictionary
Preview
Published by:
Department of Health Care Access and Information
Last updated:
April 9, 2025
File details:
N/A
Access data:
Description:
Data preview
You’re previewing the first 50 rows of this file.
Field Title
Field Name
Data Type
Description
Year
Year
Number
Year of inpatient discharge.
County
County
Plain Text
County in which the patient resided.
Prevention Quality Indicator Code
PQI
Number
AHRQ Prevention Quality Indicator Code.
Prevention Quality Indicator Description
PQIDescription
Plain Text
AHRQ Prevention Quality Indicator Description.
Count (ICD-9-CM)
Count_ICD9
Number
[2005-2015] Count of hospitalizations with selected medical conditions. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, Counts < 11 are not displayed.
Population (ICD-9-CM)
Population_ICD9
Number
[2005-2015] Population at risk. For PQI #2-Perforated Appendix, the Population is the number of appendicitis cases. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, the Population is not displayed when Counts < 11.
Observed Rate (ICD-9-CM)
ObsRate_ICD9
Number
[2005-2015] Observed rate per 100,000 population (count/population x 100,000). For PQI #2-Perforated Appendix, the observed rate is reported "per 100" appendicitis cases (count/population x 100).
Risk-Adjusted Rate (ICD-9-CM)
RiskAdjRate_ICD9
Number
[2005-2015] Risk-adjusted rate per 100,000 population. For PQI #2-Perforated Appendix, the risk-adjusted rate is reported "per 100" appendicitis cases. 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. 2010 State Inpatient Database (numerator), 2010 U.S. Census population (denominator)).
Count (ICD-10-CM)
Count_ICD10
Number
[Beginning 2016] Count of hospitalizations with selected medical conditions. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, Counts < 11 are not displayed. This also applies to PQI #90-Overall Composite and PQI #92-Chronic Composite as they contain PQI #5 and PQI #15 components.
Population (ICD-10-CM)
Population_ICD10
Number
[Beginning 2016] Population at risk. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, the Population is not displayed when Counts < 11. This also applies to PQI #90-Overall Composite and PQI #92-Chronic Composite as they contain PQI #5 and PQI #15 components.
Observed Rate (ICD-10-CM)
ObsRate_ICD10
Number
[Beginning 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.
Rows per page:
100
1–14 of 14
Data dictionary
You’re previewing the first 50 rows of this data dictionary.
Field Title
Field Name
Data Type
Description
Year
Year
Number
Year of inpatient discharge.
County
County
Plain Text
County in which the patient resided.
Prevention Quality Indicator Code
PQI
Number
AHRQ Prevention Quality Indicator Code.
Prevention Quality Indicator Description
PQIDescription
Plain Text
AHRQ Prevention Quality Indicator Description.
Count (ICD-9-CM)
Count_ICD9
Number
[2005-2015] Count of hospitalizations with selected medical conditions. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, Counts < 11 are not displayed.
Rows per page:
100
1–14 of 14