Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Beginning 2009 | Last Updated 27 Jan 2023

This dataset is one of two datasets that contain observed and expected rates for Agency for Healthcare Research and Quality Prevention Quality Indicators – Adult (AHRQ PQI) beginning in 2009. 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, dsrip

This dataset has the following 7 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 at time of discharge. Hospital discharges that did not have an accurate New York State zip code were excluded from the zip code analysis dataset.
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 county 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 group, gender and race/ethnicity divided by the zip code population, multiplied by 100,000.