Physician Supply and Preventable Hospitalizations by County - Anticipated Retirement of Practicing Physicians
These datasets contain hospitalization rates for seven prevention quality indicators (PQIs) and supply rates for physicians who treat these conditions per county. 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.
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "Department of Health Care Access and Information, Healthcare Analytics Branch",
"@type": "vcard:Contact",
"hasEmail": "mailto:dataandreports@hcai.ca.gov"
}
|
| description | These datasets contain hospitalization rates for seven prevention quality indicators (PQIs) and supply rates for physicians who treat these conditions per county. 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. |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "PQI Physicians Specialities List",
"format": "XLSX",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=364485ed-7f16-4fbf-b9c7-2a95178d6bd7&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/e37375d9-3d35-41ec-9e8d-1de9bcd4f883/download/pqi-physician-specialities-list.xlsx",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Physician Retirement Data Dictionary",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=48f508bc-00ea-4173-bb9d-b2eb8f926850&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/f974c666-af82-40ff-a628-6d61b69c1fda/download/data-dictionary-physicianretirement.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "PQI Physicians Data Dictionary",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=852da2d0-f85f-4ee8-b4de-d70332c5cb17&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/a65ec68a-f459-4775-bfc1-4c46e12e1c7a/download/data-dictionary-pqi-physicians.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "PQI Physicians Data Set",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=ac312482-7d4b-472b-ad9e-07d8d39cb180&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/ca487abe-a1bf-4dc2-9ce7-898a4d0d2738/download/pqiphysicians.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Physician Retirement Data Set",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=c75ef816-3ba5-49a7-9f2c-6d09cb83758f&limit=0",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/00483875-fba9-4189-9109-aee0393a4a6e/download/physicianretirement.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "All resource data",
"format": "ZIP",
"mediaType": "application/zip",
"downloadURL": "https://data.chhs.ca.gov/dataset/c0d55328-c409-4fbb-ac34-7bbb2e322c16/resource/7adb1fd8-e5c8-4ecf-a6e5-10df78987eb0/download/physician-supply-anticipated-retirement-of-practicing-physicians-94chap5n.zip"
}
]
|
| identifier | 9b285889-546b-4304-9212-9dc7243f6779 |
| issued | 2025-10-20T17:06:32.618136 |
| keyword |
[
"ahrq",
"asthma",
"chronic obstructive pulmonary disease",
"copd",
"department of health care access and information",
"diabetes",
"hcai",
"healthcare information",
"heart failure",
"hospitalization",
"outpatient",
"physician",
"pneumonia",
"pqi",
"prevention",
"prevention quality indicator",
"primary care",
"rdc",
"research data center",
"specialist",
"urinary tract infection",
"uti"
]
|
| license | http://www.opendefinition.org/licenses/cc-by |
| modified | 2025-11-07T03:42:20.263510 |
| publisher |
{
"name": "Department of Health Care Access and Information",
"@type": "org:Organization"
}
|
| theme |
[
"Health and Human Services"
]
|
| title | Physician Supply and Preventable Hospitalizations by County - Anticipated Retirement of Practicing Physicians |
