Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Calendar Year 2015
health.data.ny.gov | Last Updated 29 Jun 2017This 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).
This dataset has the following 9 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. | 2015 view top 100 |
Software Version | software_version | text | AHRQ software version used to produce quality indicators for this year. | 6.0 view top 100 |
Patient Zipcode | patient_zipcode | text | The patient’s zip code residence at time of discharge. Hospital discharges that did not have an accurate New York State zip code were excluded. | STATEWIDE 10001 10002 10003 10004 view top 100 |
PQI Number | pqi_number | text | The value code assigned to the PQI measure. | PQI_92 PQI_03 PQI_16 PQI_14 PQI_11 view top 100 |
PQI Name | pqi_name | text | The descriptive name of the PQI measure. | Hypertension Prevention Quality Chronic Composite Urinary Tract Infection Prevention Quality Acute Composite Diabetes Short-Term Complications 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 zip code population, multiplied by 100,000. | 0.00 301.20 324.68 862.07 74.63 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, gender and race/ethnicity divided by the zip code population, multiplied by 100,000. | 0.00 15.24 16.26 14.74 17.65 view top 100 |
Risk Adjusted Rate per 100,000 People | risk_adjusted_rate_per_100_000_people | number | The observed PQI rate divided by the expected PQI, multiplied by the statewide PQI rate. | 0.00 58.01 20.47 109.29 149.54 view top 100 |
Difference in Rates | difference_in_rates | number | Observed rate minus expected rate. | 0.00 -16.26 -17.58 -15.61 -16.90 view top 100 |