Others titles
- Rates of Preventable Hospitalizations for Selected Medical Conditions by County
- Hospitalization Counts and Rates by California County
Keywords
- Hospitalization
- Preventable Hospitalization
- Hospitalization Counts and Rates
- International Classification of Diseases
- Medical Conditions
- Quality of Health Services
- ICD-10-CM Codes
Rates of Preventable Hospitalizations by County
The dataset contains hospitalization counts and rates, statewide and by county, for 12 ambulatory care sensitive conditions plus 4 composite measures.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
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.
About this Dataset
Data Info
Date Created | 2017-06-16 |
---|---|
Last Modified | 2023-11-21 |
Version | 2023-11-21 |
Update Frequency |
Irregular |
Temporal Coverage |
2005 to 2022 |
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 |
N/A |
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 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Year | Year of inpatient discharge from 2005 to 2016. | date | - |
County | Counties in California where the patient resided. | string | - |
Prevention_Quality_Indicator_Code | Prevention 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. | integer | level : Nominal |
Prevention_Quality_Indicator_Description | Prevention 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_ICD9 | Count 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. | integer | level : Ratio |
Population_ICD9 | The 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: Integer | integer | level : Ratio |
Observed_Rate_ICD9 | Observed 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: Integer | number | level : Ratio |
Risk_Adjusted_Rate_ICD9 | Risk-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" | number | level : Ratio |
Count_ICD10 | Count of hospitalizations with selected medical conditions beginning 2016. For PQI #5-COPD or Asthma in Older Adults and PQI #15-Asthma in Younger Adults, | integer | level : Ratio |
Population_ICD10 | The 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 Older | integer | level : Ratio |
Observed_Rate_ICD10 | Observed rate per 100,000 population (count/population x 100,000) beginning 2016. For PQI #2-Perforated Appendix, the observed rate is reported "per 100" | number | level : Ratio |
Risk_Adjusted_Rate_ICD10 | Risk-adjusted rate per 100,000 population. The risk-adjusted rate is the rate the state/county would have if it had an age-sex-poverty case mix like the Reference population (i.e. 2016 State Inpatient Database (numerator), 2016 U.S. Census population. | number | level : Ratio |
Data Preview
Year | County | Prevention Quality Indicator Code | Prevention Quality Indicator Description | Count ICD9 | Population ICD9 | Observed Rate ICD9 | Risk Adjusted Rate ICD9 | Count ICD10 | Population ICD10 | Observed Rate ICD10 | Risk Adjusted Rate ICD10 |
2008 | Alameda | 1 | Diabetes Short-term Complications | 531.0 | 1136417.0 | 46.7 | 45.5 | ||||
2009 | Alameda | 1 | Diabetes Short-term Complications | 586.0 | 1155287.0 | 50.7 | 49.4 | ||||
2010 | Alameda | 1 | Diabetes Short-term Complications | 614.0 | 1169910.0 | 52.5 | 51.3 | ||||
2011 | Alameda | 1 | Diabetes Short-term Complications | 607.0 | 1186810.0 | 51.1 | 50.1 | ||||
2012 | Alameda | 1 | Diabetes Short-term Complications | 598.0 | 1173980.0 | 50.9 | 50.9 | ||||
2013 | Alameda | 1 | Diabetes Short-term Complications | 612.0 | 1197759.0 | 51.1 | 51.2 | ||||
2014 | Alameda | 1 | Diabetes Short-term Complications | 601.0 | 1192027.0 | 50.4 | 50.2 | ||||
2015 | Alameda | 1 | Diabetes Short-term Complications | 454.0 | 923607.0 | 49.2 | 49.9 | ||||
2016 | Alameda | 1 | Diabetes Short-term Complications | 442.0 | 1304840.0 | 33.9 | 40.91033768 | ||||
2017 | Alameda | 1 | Diabetes Short-term Complications | 447.0 | 1314687.0 | 34.0 | 41.17313988 |