Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Calendar Year 2015

health.data.ny.gov | Last Updated 29 Jun 2017

This is one of two datasets that contain observed and expected rates for Agency for Healthcare Research and Quality Prevention Quality Indicators – Adult (AHRQ PQI) for calendar year 2015. This dataset is at the zip code level. The Agency for Healthcare Research and Quality (AHRQ) Prevention Quality Indicators (PQIs) are a set of population based measures that can be used with hospital inpatient discharge data to identify ambulatory care sensitive conditions. These are conditions where 1) the need for hospitalization is potentially preventable with appropriate outpatient care, or 2) conditions that could be less severe if treated early and appropriately. All PQIs apply only to adult populations (over the age of 18 years). The rates were calculated using Statewide Planning and Research Cooperative System (SPARCS) inpatient data and Claritas population information. The observed rates and expected rates for each AHRQ PQI is presented by either resident county (including a statewide total) or resident zip code (including a statewide total).

Tags: quality-safety-costs, strategic initiatives, sparcs, pqi, prevention quality indicator, efficiency, all payer, zip code, dsrip

This dataset has the following 9 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
YearyearnumberThe year of both the hospital PQI discharge and the zip code population used in calculation of rates.
Software Versionsoftware_versiontextAHRQ software version used to produce quality indicators for this year.
Patient Zipcodepatient_zipcodetextThe patient’s zip code residence 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.
PQI Namepqi_nametextThe descriptive name of the PQI measure.
Observed Rate Per 100,000 Peopleobserved_rate_per_100_000_peoplenumberThe number of PQI discharges in the zip code divided by the zip code population, multiplied by 100,000.
Expected Rate Per 100,000 Peopleexpected_rate_per_100_000_peoplenumberThe expected number of 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, multiplied by the statewide PQI rate.
Difference in Ratesdifference_in_ratesnumberObserved rate minus expected rate.