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. | 2011 2012 2013 2014 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. | 111 112 113 114 115 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_03 PQI_05 PQI_07 PQI_08 view top 100 |
| PQI Name | pqi_name | text | The descriptive name of the PQI measure. | Diabetes Short-term Complications Diabetes Long-term Complications Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults Hypertension Heart Failure 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. | 2 1 3 0 4 view top 100 |
| Zip Code Medicaid Population | zip_code_medicaid_population | number | Total number of Medicaid enrollees in a zip code population. | 38641 14278 52919 17973 6321 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 488.36 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. | 2699 5239 5028 4790 9818 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 | 294.69 114.97 138.1 523 215.46 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 97.4 454.75 169.22 18.43 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.5299999999999998 -0.16000000000000014 0.29000000000000004 0.25999999999999979 -0.27 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 Dual Non-dual NON-DUAL DUAL view top 100 |