About this Dataset

Workforce Demographics

The resources in this dataset contain demographic information for the Oklahoma state government workforce. The resources present data from the current fiscal year along with demographic trends over time. The data can be used for workforce planning purposes.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:59:46.088654
Tags: demographics, workforce-planning

Tables

Statewide Headcount Trend

@usgov.state_of_oklahoma_workforce_demographics.statewide_headcount_trend

2.49 KB
10 rows
2 columns


CREATE TABLE statewide_headcount_trend (
  "fiscal_year" BIGINT,
  "end_of_fy_count" BIGINT
);

Workforce At A Glance

@usgov.state_of_oklahoma_workforce_demographics.workforce_at_a_glance

5.94 KB
7 rows
7 columns


CREATE TABLE workforce_at_a_glance (
  "fiscal_year" BIGINT,
  "number_of_full_time_employees" BIGINT,
  "average_age" DOUBLE,
  "percent_female" VARCHAR,
  "percent_minority" VARCHAR,
  "average_service_time" BIGINT,
  "turnover_rate" VARCHAR
);

Workforce By Generation Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_by_generation_trend

4.52 KB
8 rows
5 columns


CREATE TABLE workforce_by_generation_trend (
  "fiscal_year" BIGINT,
  "traditionalists" BIGINT,
  "baby_boomers" BIGINT,
  "gen_x" BIGINT,
  "millennials" BIGINT
);

Workforce Classified/Unclassified Headcount

@usgov.state_of_oklahoma_workforce_demographics.workforce_classified_unclassified_headcount

5.77 KB
25 rows
6 columns


CREATE TABLE workforce_classified_unclassified_headcount (
  "year" BIGINT,
  "total_employees" BIGINT,
  "classified" BIGINT,
  "unclassified" BIGINT,
  "classified_5dbc69" VARCHAR,
  "unclassified_69de82" VARCHAR
);

Workforce Gender Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_gender_trend

5.06 KB
10 rows
6 columns


CREATE TABLE workforce_gender_trend (
  "fiscal_year" BIGINT,
  "fy_end_count" BIGINT,
  "female" BIGINT,
  "n__female" VARCHAR,
  "male" BIGINT,
  "n__male" VARCHAR
);

Workforce Job Category Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_job_category_trend

14.18 KB
7 rows
18 columns


CREATE TABLE workforce_job_category_trend (
  "fiscal_year" BIGINT,
  "fy_end_count" BIGINT,
  "officials_administrators" BIGINT,
  "n__officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "n__professionals" VARCHAR,
  "technicians" BIGINT,
  "n__technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "n__protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "n__paraprofessionals" VARCHAR,
  "officials_clerical" BIGINT,
  "n__officials_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "n__skilled_craft" VARCHAR,
  "service_maintenance" BIGINT,
  "n__service_maintenance" VARCHAR
);

Workforce Service Time Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_service_time_trend

10.6 KB
6 rows
14 columns


CREATE TABLE workforce_service_time_trend (
  "fiscal_year" BIGINT,
  "end_fy_count" BIGINT,
  "n__3_years" BIGINT,
  "n__3_years_de87e5" VARCHAR,
  "n_3_5_years" BIGINT,
  "n__3_5_years" VARCHAR,
  "n_5_10_years" BIGINT,
  "n__5_10_years" VARCHAR,
  "n_10_15_years" BIGINT,
  "n__10_15_years" VARCHAR,
  "n_15_20_years" BIGINT,
  "n__15_20_years" VARCHAR,
  "n__20_years" BIGINT,
  "n__20_years_d60799" VARCHAR
);