Rates of Preventable Hospitalizations by County

$179 / year

The dataset contains hospitalization counts and rates, statewide and by county, for 12 ambulatory care sensitive conditions plus 4 composite measures.

Complexity

This data provides a good starting point for assessing the quality of health services in the community, however, this data does not measure hospital quality.

This dataset contains data on medical conditions including diabetes short-term complications; perforated appendix; diabetes long-term complications; chronic obstructive pulmonary disease (COPD) or asthma in older adults (age 40 and over); hypertension; heart failure; dehydration; bacterial pneumonia; urinary tract infection; angina without procedure (retired, 2016); uncontrolled diabetes; asthma in younger adults (age 18-39); and lower-extremity amputation among patients with diabetes. The composite measures include overall, acute conditions, chronic conditions, and diabetes (new, 2016). Hospitalizations due to these medical conditions are potentially preventable through access to high-quality outpatient care.

Note that in 2015, California’s Office of Statewide Health Planning and Development (OSHPD) only released the first three-quarters of data due to a change in the reporting of diagnoses from International Classification of Diseases-9-Clinical Modification (ICD-9-CM) to ICD-10-CM codes, effective October 1, 2015. Due to the significant differences resulting from the code change, the ICD-9-CM data is distinguished from the ICD-10-CM data in the data file beginning in 2016.

Date Created

2017-06-16

Last Modified

2018-11-14

Version

2018-11-14

Update Frequency

Irregular

Temporal Coverage

2005-12-31 to 2017-12-31

Spatial Coverage

California, United States

Source

John Snow Labs; California Health and Human Services Open Data Portal;

Source License URL

Source License Requirements

N/A

Source Citation

OSHPD Patient Discharge Data; Agency for Healthcare Research and Quality (AHRQ) Prevention Quality Indicators, SAS Software, Version 5.0 (2005-2015Q3, ICD-9-CM) and Version 6.01 (2016, ICD-10-CM).

Keywords

Hospitalization, Preventable Hospitalization, Hospitalization Counts and Rates, International Classification of Diseases, Medical Conditions, Quality of Health Services, ICD-10-CM Codes

Other Titles

Rates of Preventable Hospitalizations for Selected Medical Conditions by County, Hospitalization Counts and Rates by California County

NameDescriptionTypeConstraints
YearYear of inpatient discharge from 2005 to 2016.date-
CountyCounties in California where the patient resided.string-
Prevention_Quality_Indicator_CodePrevention Quality Indicators (PQIs) identify hospital admissions that evidence suggests may have been avoided through access to high-quality outpatient care. The PQIs are also called "ambulatory care-sensitive conditions" or "preventable hospitalizations." These measures assess the quality of the healthcare system as a whole, especially ambulatory care, in preventing hospitalizations due to potentially-avoidable medical complications.integerlevel : Nominal
Prevention_Quality_Indicator_DescriptionPrevention Quality Indicators (PQIs) identify hospital admissions that evidence suggests may have been avoided through access to high-quality outpatient care. The PQIs are also called "ambulatory care-sensitive conditions" or "preventable hospitalizations." These measures assess the quality of the healthcare system as a whole, especially ambulatory care, in preventing hospitalizations due to potentially-avoidable medical complications.string-
Count_ICD9Count of hospitalizations for 2005-2015 with selected medical conditions. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults.integerlevel : Ratio
Population_ICD9The population at risk for 2005-2015. For PQI #2-Perforated Appendix, the Population is the number of appendicitis cases. For PQI #5-COPD or Asthma in Older Adults Type: Integerintegerlevel : Ratio
Observed_Rate_ICD9Observed rate per 100,000 population (count/population x 100,000) for 2005-2015. For PQI #2-Perforated Appendix, the observed rate is reported "per 100" Type: Integernumberlevel : Ratio
Risk_Adjusted_Rate_ICD9Risk-adjusted rate per 100,000 population 2005-2015 (not available in 2016]). For PQI #2-Perforated Appendix, the risk-adjusted rate is reported "per 100"numberlevel : Ratio
Count_ICD10Count of hospitalizations with selected medical conditions beginning 2016. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults,integerlevel : Ratio
Population_ICD10The population at risk beginning 2016. For PQI #2-Perforated Appendix, the Population is the number of appendicitis cases. For PQI #5-COPD or Asthma in Olderintegerlevel : Ratio
Observed_Rate_ICD10Observed rate per 100,000 population (count/population x 100,000) beginning 2016. For PQI #2-Perforated Appendix, the observed rate is reported "per 100"numberlevel : Ratio
YearCountyPrevention Quality Indicator CodePrevention Quality Indicator DescriptionCount ICD9Population ICD9Observed Rate ICD9Risk Adjusted Rate ICD9Count ICD10Population ICD10Observed Rate ICD10Risk Adjusted Rate ICD10
2005Alameda1Diabetes Short-term Complications53811020684947
2006Alameda1Diabetes Short-term Complications47911068234342
2007Alameda1Diabetes Short-term Complications47511179734341
2008Alameda1Diabetes Short-term Complications53111364174746
2009Alameda1Diabetes Short-term Complications58611552875149
2010Alameda1Diabetes Short-term Complications61411699105351
2011Alameda1Diabetes Short-term Complications60711868105150
2012Alameda1Diabetes Short-term Complications59811739805151
2013Alameda1Diabetes Short-term Complications61211977595151
2014Alameda1Diabetes Short-term Complications60111920275050