Medicaid Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Patient County: Beginning 2011

health.data.ny.gov | Last Updated 5 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: medicaid, pqi, prevention quality indicator, efficiency, dsrip, quality-safety-costs, strategic initiatives

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 Medicaid county population used in calculation of rates.
CountycountytextThe patient’s county of residence at time of discharge. Hospital discharges that did not have an accurate New York State county 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 county population that meet the criteria for a specific PQI.
County Medicaid Populationcounty_medicaid_populationnumberTotal number of Medicaid enrollees in a county population.
Observed Rate per 100,000 peopleobserved_rate_per_100_000_peoplenumberThe number of PQI discharges in the county divided by the county 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 county, adjusted by age, gender and race/ethnicity divided by the county 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).