Medicaid Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Patient Zip Code: Beginning 2011
health.data.ny.gov | Last Updated 13 Dec 2016The 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.
This dataset has the following 12 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Discharge Year | discharge_year | number | The year of both the hospital PQI discharge and the zip code population used in calculation of rates. | 2014 2013 2012 2011 view top 100 |
| Zip Code | zip_code | 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. | 103 101 102 131 138 view top 100 |
| PQI Number | pqi_number | text | The 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_01 PQI_07 PQI_15 PQI_90 PQI_92 view top 100 |
| PQI Name | pqi_name | text | The descriptive name of the PQI measure. | Angina Without Procedure Asthma in Younger Adults Bacterial Pneumonia Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults Dehydration view top 100 |
| Medicaid PQI Hospitalizations | medicaid_pqi_hospitalizations | number | Total number of Medicaid enrollee admissions in a zip code population that meet the criteria for a specific PQI. | 1 3 2 4 5 view top 100 |
| Zip Code Medicaid Population | zip_code_medicaid_population | number | Total number of Medicaid enrollees in a zip code population. | 4021 9334 11546 9221 154954 view top 100 |
| Observed Rate per 100,000 people | observed_rate_per_100_000_people | number | The number of PQI hospitalizations divided by the zip code population, multiplied by 100,000 | 0 64.91 134.41 123.19 4.93 view top 100 |
| Expected PQI Hospitalizations | expected_pqi_hospitalizations | number | Total number of expected admissions based on the characteristics of the county that would meet the criteria for a specific PQI. | 3.33 5.96 2.15 5.16 7.93 view top 100 |
| Expected Rate per 100,000 people | expected_rate_per_100_000_people | number | The number of expected PQI discharges in the zip code, adjusted by age, gender and race/ethnicity divided by the zip code population, multiplied by 100,000 | 124.36 135.48 251.15 107.84 18.96 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 rate, multiplied by the statewide PQI rate. | 0 7.75 55.18 32.03 15.29 view top 100 |
| Difference in Hospitalizations | difference_in_hospitalizations | number | The difference between the observed number of PQI hospitalizations and the expected number of PQI hospitalizations. | 0 -1.96 -1.17 -0.51 2.61 view top 100 |
| Dual Status | dual_status | text | Indicates discharges where enrollee was enrolled in both Medicaid and Medicare (Dual), only Medicaid (Non-dual) and a sum of dual and non-dual (Total). | Total NON-DUAL TOTAL DUAL Dual view top 100 |