Medicaid Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Patient Zip Code: Beginning 2011 | Last Updated 13 Dec 2016

The datasets contain number of Medicaid PQI hospitalizations (numerator), county Medicaid population (denominator), observed rate, expected number of hospitalizations and rate, and risk-adjusted rate for Agency for Healthcare Research and Quality Prevention Quality Indicators – Adult (AHRQ PQI) for Medicaid enrollees beginning in 2011.

Tags: quality-safety-costs, strategic initiatives, medicaid, pqi, prevention quality indicator, efficiency, dsrip

This dataset has the following 12 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Discharge Yeardischarge_yearnumberThe year of both the hospital PQI discharge and the zip code population used in calculation of rates.
Zip Codezip_codetextThe patient’s zip code at time of discharge. Hospital discharges that did not have an accurate New York State zip code were excluded.
PQI Numberpqi_numbertextThe value code assigned to the PQI measure. Values: PQI_01, PQI_03, PQI_05, PQI_07, PQI_08, PQI_10, PQI_11, PQI_12, PQI_13, PQI_14, PQI_15, PQI_16, PQI_90, PQI_91, PQI_92, PQI_S01, PQI_S02, PQI_S03
PQI Namepqi_nametextThe descriptive name of the PQI measure.
Medicaid PQI Hospitalizationsmedicaid_pqi_hospitalizationsnumberTotal number of Medicaid enrollee admissions in a zip code population that meet the criteria for a specific PQI.
Zip Code Medicaid Populationzip_code_medicaid_populationnumberTotal number of Medicaid enrollees in a zip code population.
Observed Rate per 100,000 peopleobserved_rate_per_100_000_peoplenumberThe number of PQI hospitalizations divided by the zip code population, multiplied by 100,000
Expected PQI Hospitalizationsexpected_pqi_hospitalizationsnumberTotal number of expected admissions based on the characteristics of the county that would meet the criteria for a specific PQI.
Expected Rate per 100,000 peopleexpected_rate_per_100_000_peoplenumberThe number of expected PQI discharges in the zip code, adjusted by age, gender and race/ethnicity divided by the zip code population, multiplied by 100,000
Risk Adjusted Rate per 100,000 peoplerisk_adjusted_rate_per_100_000_peoplenumberThe observed PQI rate divided by the expected PQI rate, multiplied by the statewide PQI rate.
Difference in Hospitalizationsdifference_in_hospitalizationsnumberThe difference between the observed number of PQI hospitalizations and the expected number of PQI hospitalizations.
Dual Statusdual_statustextIndicates discharges where enrollee was enrolled in both Medicaid and Medicare (Dual), only Medicaid (Non-dual) and a sum of dual and non-dual (Total).