About this Dataset

Physicians Actively Working By Specialty And Activity Hours

These datasets contain aggregated responses from the HCAI Health Workforce License Renewal Survey for Physician and Surgeon and Osteopathic Physician and Surgeon licensees. The data are limited to physicians whose license was in an Active Status and who indicated they were actively working in a position that required their license as of April 3, 2025.

The license renewal survey utilizes a cell-based weighting methodology to estimate the total count of licensed individuals and accounts for individuals that decline to provide a response or who have not yet taken the survey. The presented estimated counts were calculated by multiplying county level weighted percentages for each metric by the total count of active licenses within each county. If no physicians within a given specialty and county provided a response to the activity hours question, the statewide mode for that specialty was used.

Note: Previous versions of this dataset utilized raw counts rather than a cell-based weighting approach and did not take into account whether physicians were actively working in their field.

In addition, the previous version of this dataset (as of April 3, 2024) contained errors regarding the total number of “Unsurveyed” individuals within each county. For more information regarding this issue, please contact the Workforce Data team using the email address below.
Organization: State of California
Last updated: 2025-08-23T13:01:51.103054
Tags: activity-hours, clearinghouse, department-of-health-care-access-and-information, fte, hcai, healthcare, licensee, md, medical-board, osteopathic, osteopathic-board, physician, practice-location, provider, responses, specialty, survey, workforce

Tables

Data Dictionary - Physicians Actively Working By Specialty And Other Activity Hours

@usgov.ca_gov_physicians_actively_working_by_specialty_and_ac_b63b22c5.n__dictionary_physicians_actively_working_by_specialty_18112ac5

3.91 kB
4 rows
4 columns

CREATE TABLE n__dictionary_physicians_actively_working_by_specialty_18112ac5 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Physicians Actively Working By Specialty And Research Activity Hours

@usgov.ca_gov_physicians_actively_working_by_specialty_and_ac_b63b22c5.n__dictionary_physicians_actively_working_by_specialty_3362c4ea

3.91 kB
4 rows
4 columns

CREATE TABLE n__dictionary_physicians_actively_working_by_specialty_3362c4ea (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Physicians Actively Working By Specialty And Administration Activity Hours

@usgov.ca_gov_physicians_actively_working_by_specialty_and_ac_b63b22c5.n__dictionary_physicians_actively_working_by_specialty_553ed5c8

3.93 kB
4 rows
4 columns

CREATE TABLE n__dictionary_physicians_actively_working_by_specialty_553ed5c8 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Physicians Actively Working By Specialty And Training Activity Hours

@usgov.ca_gov_physicians_actively_working_by_specialty_and_ac_b63b22c5.n__dictionary_physicians_actively_working_by_specialty_86f34634

3.92 kB
4 rows
4 columns

CREATE TABLE n__dictionary_physicians_actively_working_by_specialty_86f34634 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Physicians Actively Working By Specialty And Patient Care Hours

@usgov.ca_gov_physicians_actively_working_by_specialty_and_ac_b63b22c5.n__dictionary_physicians_actively_working_by_specialty_b1733019

3.92 kB
4 rows
4 columns

CREATE TABLE n__dictionary_physicians_actively_working_by_specialty_b1733019 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);