Go back to the interactive dataset

Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by County (SPARCS): Beginning 2009

Row numberYearPatient CountyPQI NumberPQI NameObserved Rate Per 100,000 PeopleExpected Rate Per 100,000 People
12013AlbanyPQI_01Diabetes Short-Term Complications76.3357.58
22012ALBANYPQI_01Diabetes Short-term Complications44.3357.42
32011ALBANYPQI_01Diabetes Short-term Complications6654.34
42010ALBANYPQI_01Diabetes Short-term Complications66.4449.61
52009ALBANYPQI_01Diabetes Short-term Complications54.4549.5
62013AlbanyPQI_03Diabetes Long-Term Complications84.12110.17
72012ALBANYPQI_03Diabetes Long-term Complications66.33114.62
82011ALBANYPQI_03Diabetes Long-term Complications113.74118.8
92010ALBANYPQI_03Diabetes Long-term Complications102.08117.04
102009ALBANYPQI_03Diabetes Long-term Complications97.68119.02
112013AlbanyPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults413.96429.05
122012ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults374.11466.51
132011ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults505.56488.18
142010ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults548.79484.33
152009ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults536.14523.93
162013AlbanyPQI_07Hypertension50.0652.70
172012ALBANYPQI_07Hypertension44.3361.05
182011ALBANYPQI_07Hypertension57.0959.73
192010ALBANYPQI_07Hypertension57.259.62
202009ALBANYPQI_07Hypertension54.8960.83
212013AlbanyPQI_08Heart Failure276.17303.64
222012ALBANYPQI_08Heart Failure240.02298.87
232011ALBANYPQI_08Heart Failure301.18310.42
242010ALBANYPQI_08Heart Failure280.72324.5
252009ALBANYPQI_08Heart Failure282.04362.34
262013AlbanyPQI_10Dehydration89.4699.61
272012ALBANYPQI_10Dehydration109.45114.62
282011ALBANYPQI_10Dehydration132.88122.76
292010ALBANYPQI_10Dehydration110.99125.73
302009ALBANYPQI_10Dehydration144.1141.57
312013AlbanyPQI_11Bacterial Pneumonia159.22217.63
322012ALBANYPQI_11Bacterial Pneumonia134.75233.31
332011ALBANYPQI_11Bacterial Pneumonia238.59256.85
342010ALBANYPQI_11Bacterial Pneumonia250.03248.49
352009ALBANYPQI_11Bacterial Pneumonia258.94285.23
362013AlbanyPQI_12Urinary Tract Infection145.27149.38
372012ALBANYPQI_12Urinary Tract Infection145.09161.81
382011ALBANYPQI_12Urinary Tract Infection192.17166.1
392010ALBANYPQI_12Urinary Tract Infection180.73169.29
402009ALBANYPQI_12Urinary Tract Infection163.02170.28
412013AlbanyPQI_13Angina Without Procedure7.8016.19
422012ALBANYPQI_13Angina Without Procedure5.3918.59
432011ALBANYPQI_13Angina Without Procedure7.2620.13
442010ALBANYPQI_13Angina Without Procedure6.2723.21
452009ALBANYPQI_13Angina Without Procedure11.7728.27
462013AlbanyPQI_14Uncontrolled Diabetes6.5716.45
472012ALBANYPQI_14Uncontrolled Diabetes15.2920.57
482011ALBANYPQI_14Uncontrolled Diabetes13.6420.57
492010ALBANYPQI_14Uncontrolled Diabetes10.8922
502009ALBANYPQI_14Uncontrolled Diabetes14.6325.74

About

Open Data NY - DOH Open Data NY - DOH

created Apr 14, 2014

updated Jun 02, 2015

View Full Page
Description

This 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. This dataset is at the county 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. For more information, check out: http://www.health.ny.gov/statistics/sparcs/ or go to the "About" tab. 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).

Activity
Community Rating
Current value: 0.0 out of 5
Your Rating
Raters
0
Visits
18625
Downloads
581
Comments
0
Contributors
0
Meta
Category
Health
Permissions
Public
Tags
quality-safety-costs, strategic initiatives, sparcs, pqi, prevention quality indicator, efficiency, all payer, county, dsrip
Row Label
Row Count
5670
Licensing and Attribution
Data Provided By
New York State Department of Health
Source Link
http://www.health.ny.gov/statistics/sparcs/
Dataset Summary
Organization
Office of Quality and Patient Safety
Time Period
Rates are based on hospital inpatient discharges and county or zip code population for each calendar year beginning with 2009.
Posting Frequency
Annually
Data Frequency
Monthly
Dataset Owner
Bureau of Health Informatics
Coverage
Statewide
Granularity
County
Units
PQI Measure/Discharges
Notes
Notes
These datasets use version 4.5 of the PQI software. To calculate rates, New York State county or zip code population was used in the denominator. Rates were adjusted using age group, gender and race/ethnicity.
Disclaimers
Limitations
Hospital discharges that did not have an accurate New York State zip code were excluded from the zip code analysis dataset. Hospital discharges that did not have an accurate New York State county were excluded from the county analysis dataset. Due to this nuance, the statewide rates differ slightly between the zip code and county datasets.
Dataset Information
Agency
Health, Department of

Filter

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Sort

  • ;
  • ;
  • ;
  • ;
  • ;
  • ;

Search

Saved Views

Sharing

This dataset is public

Publishing

See Preview