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
12012ALBANYPQI_01Diabetes Short-term Complications44.3357.42
22011ALBANYPQI_01Diabetes Short-term Complications6654.34
32010ALBANYPQI_01Diabetes Short-term Complications66.4449.61
42009ALBANYPQI_01Diabetes Short-term Complications54.4549.5
52012ALBANYPQI_03Diabetes Long-term Complications66.33114.62
62011ALBANYPQI_03Diabetes Long-term Complications113.74118.8
72010ALBANYPQI_03Diabetes Long-term Complications102.08117.04
82009ALBANYPQI_03Diabetes Long-term Complications97.68119.02
92012ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults374.11466.51
102011ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults505.56488.18
112010ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults548.79484.33
122009ALBANYPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults536.14523.93
132012ALBANYPQI_07Hypertension44.3361.05
142011ALBANYPQI_07Hypertension57.0959.73
152010ALBANYPQI_07Hypertension57.259.62
162009ALBANYPQI_07Hypertension54.8960.83
172012ALBANYPQI_08Heart Failure240.02298.87
182011ALBANYPQI_08Heart Failure301.18310.42
192010ALBANYPQI_08Heart Failure280.72324.5
202009ALBANYPQI_08Heart Failure282.04362.34
212012ALBANYPQI_10Dehydration109.45114.62
222011ALBANYPQI_10Dehydration132.88122.76
232010ALBANYPQI_10Dehydration110.99125.73
242009ALBANYPQI_10Dehydration144.1141.57
252012ALBANYPQI_11Bacterial Pneumonia134.75233.31
262011ALBANYPQI_11Bacterial Pneumonia238.59256.85
272010ALBANYPQI_11Bacterial Pneumonia250.03248.49
282009ALBANYPQI_11Bacterial Pneumonia258.94285.23
292012ALBANYPQI_12Urinary Tract Infection145.09161.81
302011ALBANYPQI_12Urinary Tract Infection192.17166.1
312010ALBANYPQI_12Urinary Tract Infection180.73169.29
322009ALBANYPQI_12Urinary Tract Infection163.02170.28
332012ALBANYPQI_13Angina Without Procedure5.3918.59
342011ALBANYPQI_13Angina Without Procedure7.2620.13
352010ALBANYPQI_13Angina Without Procedure6.2723.21
362009ALBANYPQI_13Angina Without Procedure11.7728.27
372012ALBANYPQI_14Uncontrolled Diabetes15.2920.57
382011ALBANYPQI_14Uncontrolled Diabetes13.6420.57
392010ALBANYPQI_14Uncontrolled Diabetes10.8922
402009ALBANYPQI_14Uncontrolled Diabetes14.6325.74
412012ALBANYPQI_15Asthma in Younger Adults50.4960.83
422011ALBANYPQI_15Asthma in Younger Adults50.8259.4
432010ALBANYPQI_15Asthma in Younger Adults57.5360.83
442009ALBANYPQI_15Asthma in Younger Adults65.4577.33
452012ALBANYPQI_16Lower-Extremity Amputation among Patients with Diabetes10.3412.54
462011ALBANYPQI_16Lower-Extremity Amputation among Patients with Diabetes12.7612.32
472010ALBANYPQI_16Lower-Extremity Amputation among Patients with Diabetes10.5611.88
482009ALBANYPQI_16Lower-Extremity Amputation among Patients with Diabetes11.7712.54
492012ALBANYPQI_90Prevention Quality Overall Composite1058.091394.03
502011ALBANYPQI_90Prevention Quality Overall Composite1455.31455.08

About

Open Data NY - DOH Open Data NY - DOH

created Apr 14, 2014

updated Mar 10, 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
Current value: out of 5
Raters
0
Visits
16359
Downloads
467
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 Count
4536
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