Rates of Preventable Hospitalizations by County

$79 / 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-01-05

Version

2018-01-05

Update Frequency

Never

Temporal Coverage

2005-12-31 to 2016-12-31

Spatial Coverage

California, United States

Source

John Snow Labs => California Health and Human Services Open Data Portal

Source License URL

John Snow Labs Standard License

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_ICD10
2005Alpine7Hypertension979
2008Alpine7Hypertension957
2009Alpine7Hypertension947
2010Alpine7Hypertension895
2005Modoc7Hypertension7407
2008Modoc7Hypertension7469
2009Modoc7Hypertension7565
2010Modoc7Hypertension7599
2014Modoc7Hypertension8570
2006Mono7Hypertension10747