Excel · dataset · 2025
Physician Supply and Preventable Hospitalizations by County - Anticipated Retirement of Practicing Physicians
Listed in California Open Data
These datasets contain hospitalization rates for seven prevention quality indicators (PQIs) and supply rates for physicians who treat these conditions per county.
Description
The conditions include: chronic obstructive pulmonary disease (COPD); hypertension; heart failure; community-acquired pneumonia; urinary tract infection (UTI); asthma in younger adults; and diabetes. Hospitalizations due to these medical conditions are potentially preventable through access to high-quality outpatient care.
Rates are displayed per 100,000 population. Anticipated retirement of practicing physician specialists who provide direct patient care is also shown by county. See the PQI to physician area of practice list below to see which specialists would be needed to prevent and/or treat each PQI.
Links
Get the data
- PQI Physicians Data Set data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/ca487abe… ↗
download · from data ca gov
- Physician Retirement Data Set data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/00483875… ↗
download · from data ca gov
- PQI Physicians Data Dictionary data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/a65ec68a… ↗
download · from data ca gov
- Physician Retirement Data Dictionary data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/f974c666… ↗
download · from data ca gov
- PQI Physicians Specialities List data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/e37375d9… ↗
download · from data ca gov
- All resource data data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/7adb1fd8… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/physician-supply-and-preventable-hospitalizations-by-c… ↗
landing page · from data ca gov
Documentation and papers
- Publisher page hcai.ca.gov/visualizations ↗
documentation · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=9b285889-546b-4304-9212-9dc7243f6… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Health and Human Services
- From keywords
- Medicine & Health
Provenance · 1 source records, 11 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | 9b285889-546b-4304-9212-9dc7243f6779 | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[anatomy].local:anatomy:heart | enrichment · data ca gov | keyword-concept-rules@1.0.0 | title+description (75%) |
| concepts[disease].local:disease:disease | enrichment · data ca gov | keyword-concept-rules@1.0.0 | title+description (75%) |
| concepts[field].local:field:medicine-health | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:health-human-services | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| license_text | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |