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
12014AlbanyPQI_01Diabetes Short-Term Complications50.8659.24
22014AlbanyPQI_03Diabetes Long-Term Complications70.64104.95
32014AlbanyPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults394.47464.25
42014AlbanyPQI_07Hypertension35.5247.44
52014AlbanyPQI_08Heart Failure250.27301.88
62014AlbanyPQI_10Dehydration83.56114.01
72014AlbanyPQI_11Bacterial Pneumonia122.71194.38
82014AlbanyPQI_12Urinary Tract Infection121.50143.98
92014AlbanyPQI_13Angina Without Procedure1.6113.95
102014AlbanyPQI_14Uncontrolled Diabetes5.6513.98
112014AlbanyPQI_15Asthma in Younger Adults37.5053.06
122014AlbanyPQI_16Lower-Extremity Amputation among Patients with Diabetes10.5013.69
132014AlbanyPQI_90Prevention Quality Overall Composite1000.661302.19
142014AlbanyPQI_91Prevention Quality Acute Composite327.77452.37
152014AlbanyPQI_92Prevention Quality Chronic Composite672.89849.84
162014AlbanyPQI_96Prevention Quality All Diabetes Composite133.21186.16
172014AlbanyPQI_97Prevention Quality All Circulatory Composite287.40363.28
182014AlbanyPQI_98Prevention Quality All Respiratory Composite252.28300.47
192014AlleganyPQI_01Diabetes Short-Term Complications23.7249.20
202014AlleganyPQI_03Diabetes Long-Term Complications71.1688.21
212014AlleganyPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults431.11441.85
222014AlleganyPQI_07Hypertension2.6434.00
232014AlleganyPQI_08Heart Failure276.74285.28
242014AlleganyPQI_10Dehydration84.34112.72
252014AlleganyPQI_11Bacterial Pneumonia218.75197.56
262014AlleganyPQI_12Urinary Tract Infection63.25138.37
272014AlleganyPQI_13Angina Without Procedure10.5412.14
282014AlleganyPQI_14Uncontrolled Diabetes5.279.84
292014AlleganyPQI_15Asthma in Younger Adults6.6835.70
302014AlleganyPQI_16Lower-Extremity Amputation among Patients with Diabetes0.0012.41
312014AlleganyPQI_90Prevention Quality Overall Composite1019.981216.05
322014AlleganyPQI_91Prevention Quality Acute Composite366.35448.66
332014AlleganyPQI_92Prevention Quality Chronic Composite653.63767.40
342014AlleganyPQI_96Prevention Quality All Diabetes Composite100.15154.52
352014AlleganyPQI_97Prevention Quality All Circulatory Composite289.92331.42
362014AlleganyPQI_98Prevention Quality All Respiratory Composite263.56281.52
372014BronxPQI_01Diabetes Short-Term Complications118.1284.70
382014BronxPQI_03Diabetes Long-Term Complications267.03167.52
392014BronxPQI_05Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults991.91620.25
402014BronxPQI_07Hypertension135.5185.06
412014BronxPQI_08Heart Failure416.89334.57
422014BronxPQI_10Dehydration143.87111.80
432014BronxPQI_11Bacterial Pneumonia220.37177.57
442014BronxPQI_12Urinary Tract Infection208.11149.65
452014BronxPQI_13Angina Without Procedure27.2719.59
462014BronxPQI_14Uncontrolled Diabetes39.9127.89
472014BronxPQI_15Asthma in Younger Adults220.8496.58
482014BronxPQI_16Lower-Extremity Amputation among Patients with Diabetes36.6820.33
492014BronxPQI_90Prevention Quality Overall Composite2251.631560.33
502014BronxPQI_91Prevention Quality Acute Composite572.36439.02

About

Open Data NY - DOH Open Data NY - DOH

created Apr 14, 2014

updated Apr 25, 2016

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
29680
Downloads
869
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
Row Count
6804
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 Care Analytics
Coverage
Statewide
Granularity
County
Units
PQI Measure/Discharges
Notes
Notes
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
Local Data
County Filter
Yes
County_Column
patient_county

Filter

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

Sort

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

Search

Saved Views

No other views on this dataset

Sharing

This dataset is public

Publishing

See Preview