About this Dataset

Regional Planning Unit Overviews

The purpose of these reports is to provide employment data at a regional level. Regional Planning Units (RPUs) respect the existing administrative boundaries of counties and Local Workforce Development Boards while providing a foundation upon which to facilitate regional planning under the requirements of the Workforce Innovation and Opportunity Act (WIOA).
Organization: State of California
Last updated: 2024-03-30T00:31:26.923264
Tags: entry-level-education, median-annual-wage, median-hourly-wage, occupations, total-projected-job-openings-2020-2030

Tables

Regional Planning Unit Overviews

@usgov.ca_gov_regional_planning_unit_overviews.regional_planning_unit_overviews

224.83 KB
7469 rows
17 columns


CREATE TABLE regional_planning_unit_overviews (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "period" VARCHAR,
  "standard_occupational_classification_soc_code" VARCHAR,
  "occupational_title" VARCHAR,
  "base_year" BIGINT,
  "projection_employment_estimate" BIGINT,
  "numeric_change" BIGINT,
  "percent_change" DOUBLE,
  "exits" BIGINT,
  "transfers" BIGINT,
  "total_job_openings" BIGINT,
  "median_hourly_wage" VARCHAR,
  "median_annual_wage" VARCHAR,
  "entry_level_education" VARCHAR,
  "work_experience" VARCHAR,
  "job_training" VARCHAR
);