Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Beginning 2009
health.data.ny.gov | Last Updated 27 Jan 2023This 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).
This dataset has the following 7 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Year | year | number | The year of both the hospital PQI discharge and the zip code population used in calculation of rates. | 2014 2013 2009 2011 2012 view top 100 |
| Software Version | software_version | text | AHRQ software version used to produce quality indicators for this year. | 4.5 5.0 v2021 v2018 7.0 view top 100 |
| Patient Zipcode | patient_zipcode | text | The 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. | 13790 10001 10002 10003 10004 view top 100 |
| PQI Number | pqi_number | text | The value code assigned to the PQI measure. | PQI_16 PQI_03 PQI_90 PQI_07 PQI_08 view top 100 |
| PQI Name | pqi_name | text | The descriptive name of the PQI measure. | Urinary Tract Infection Lower-Extremity Amputation among Patients with Diabetes Prevention Quality Acute Composite Prevention Quality All Circulatory Composite Prevention Quality All Diabetes Composite view top 100 |
| Observed Rate Per 100,000 People | observed_rate_per_100_000_people | number | The number of PQI discharges in the zip code divided by the county population, multiplied by 100,000. | 0 540.54 12.54 17.82 23.43 view top 100 |
| Expected Rate Per 100,000 People | expected_rate_per_100_000_people | number | The 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. | 11.44 11.66 12.1 12.87 12.43 view top 100 |