About this Dataset

Healthcare Workforce Geography Crosswalk

This dataset identifies which census tracts comprise the various geographies used to study the healthcare workforce. Medical Service Study Areas (MSSA) are sub-county geographies used to study medical service in California. Registered Nurse (RN) Areas, which can cross county lines, are used to study the RN workforce. These custom geographies are approved by the California Healthcare Workforce Policy Commission.
Organization: State of California
Last updated: 2023-08-12T12:09:38.377997
Tags: area, department-of-health-care-access-and-information, geography, hpsa, map, medical, mssa, rnsa, service, shape, shortage, study, underserved

Tables

Geography Crosswalk

@usgov.ca_gov_healthcare_workforce_geography_crosswalk_ddfe8.geography_crosswalk

136.54 kB
8,036 rows
8 columns

CREATE TABLE geography_crosswalk (
  "census_tract" BIGINT,
  "aland" BIGINT,
  "county" VARCHAR,
  "mssa_id" VARCHAR,
  "mssa_name" VARCHAR,
  "mssa_type" VARCHAR,
  "rn_area_id" BIGINT,
  "rn_area_name" VARCHAR
);