About this Dataset

Long-Term Occupational Employment Projections

Long-term Occupational Projections for a 10-year time horizon are provided for the State and its labor market regions to provide individuals and organizations with an occupational outlook to make informed decisions on individual career and organizational program development. Long-term projections are revised annually. Data are not available for geographies below the labor market regions. Detail may not add to summary lines due to suppression of data because of confidentiality and/or quality.
Organization: State of California
Last updated: 2025-07-23T19:05:43.770788
Tags: 2022, 2022-2032, 2023, 2023-2033, 2032, 2033, bachelors-degree, california-employment-development-department, doctoral-or-professional-degree, employment, employment-projections, forecast, growth-estimate, masters-degree, no-degree, occupation, outlook, sacramento-area-in-demand-jobs, some-college, top-annual-job-openings, top-jobs-in-sacramento-metropolitan-area

Tables

Data Dictionary - Long-Term Occupational Employment Projections

@usgov.ca_gov_long_term_occupational_employment_projections.data_dictionary_long_term_occupational_employment_projections

5.4 kB
18 rows
4 columns

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

Long-Term Occupational Employment Projections

@usgov.ca_gov_long_term_occupational_employment_projections.long_term_occupational_employment_projections

444.71 kB
17,781 rows
18 columns

CREATE TABLE long_term_occupational_employment_projections (
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "period" VARCHAR,
  "soc_level" BIGINT,
  "standard_occupational_classification_soc" VARCHAR  -- Standard Occupational Classification (SOC),
  "occupational_title" VARCHAR,
  "base_year_employment_estimate" BIGINT,
  "projected_year_employment_estimate" BIGINT,
  "numeric_change" BIGINT,
  "percentage_change" DOUBLE,
  "exits" BIGINT,
  "transfers" BIGINT,
  "total_job_openings" BIGINT,
  "median_hourly_wage" DOUBLE,
  "median_annual_wage" BIGINT,
  "entry_level_education" VARCHAR,
  "work_experience" VARCHAR,
  "job_training" VARCHAR
);