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.55 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

6.08 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.63 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.91 kB
25 rows
6 columns

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

Workforce Gender Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_gender_trend

5.18 kB
10 rows
6 columns

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

Workforce Job Category Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_job_category_trend

14.52 kB
7 rows
18 columns

CREATE TABLE workforce_job_category_trend (
  "fiscal_year" BIGINT,
  "fy_end_count" BIGINT,
  "officials_administrators" BIGINT  -- Officials & Administrators,
  "n__officials_administrators" VARCHAR  -- % Officials & Administrators,
  "professionals" BIGINT,
  "n__professionals" VARCHAR  -- % Professionals,
  "technicians" BIGINT,
  "n__technicians" VARCHAR  -- % Technicians,
  "protective_service_workers" BIGINT,
  "n__protective_service_workers" VARCHAR  -- % Protective Service Workers,
  "paraprofessionals" BIGINT,
  "n__paraprofessionals" VARCHAR  -- % Paraprofessionals,
  "officials_clerical" BIGINT,
  "n__officials_clerical" VARCHAR  -- % Officials-Clerical,
  "skilled_craft" BIGINT,
  "n__skilled_craft" VARCHAR  -- % Skilled Craft,
  "service_maintenance" BIGINT,
  "n__service_maintenance" VARCHAR  -- % Service/Maintenance
);

Workforce Service Time Trend

@usgov.state_of_oklahoma_workforce_demographics.workforce_service_time_trend

10.85 kB
6 rows
14 columns

CREATE TABLE workforce_service_time_trend (
  "fiscal_year" BIGINT,
  "end_fy_count" BIGINT,
  "n__3_years" BIGINT  -- < 3 Years,
  "n__3_years_de87e5" VARCHAR  -- % < 3 Years,
  "n_3_5_years" BIGINT  -- 3-5 Years,
  "n__3_5_years" VARCHAR  -- % 3-5 Years,
  "n_5_10_years" BIGINT  -- 5-10 Years,
  "n__5_10_years" VARCHAR  -- % 5-10 Years,
  "n_10_15_years" BIGINT  -- 10-15 Years,
  "n__10_15_years" VARCHAR  -- % 10-15 Years,
  "n_15_20_years" BIGINT  -- 15-20 Years,
  "n__15_20_years" VARCHAR  -- % 15-20 Years,
  "n__20_years" BIGINT  -- > 20 Years,
  "n__20_years_d60799" VARCHAR  -- % > 20 Years
);