Baselight
Sign In

Workforce By Agency

State of Oklahoma

@usgov.state_of_oklahoma_workforce_by_agency

Loading...
Loading...

About this Dataset

Workforce By Agency

Information that summarizes the State of Oklahoma workforce data by agency.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:59:49.704530
Tags: agency, data, retirement, turnover, workforce-planning

Tables

FY 2013 Agency Workforce Summary

@usgov.state_of_oklahoma_workforce_by_agency.fy_2013_agency_workforce_summary
  • 65.39 KB
  • 120 rows
  • 58 columns
Loading... 

CREATE TABLE fy_2013_agency_workforce_summary (
  "co" BIGINT,
  "agency_name" VARCHAR,
  "fy_2013_emp_count" BIGINT,
  "avg_years_of_service" DOUBLE,
  "avg_age" DOUBLE,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "traditional" BIGINT,
  "percent_traditional" VARCHAR,
  "early_boomer" BIGINT,
  "percent_early_boomer" VARCHAR,
  "late_boomer" BIGINT,
  "percent_late_boomer" VARCHAR,
  "gen_x" BIGINT,
  "percent_gen_x" VARCHAR,
  "millennials" BIGINT,
  "percent_millennial" VARCHAR,
  "voluntary_turnover" VARCHAR,
  "involuntary_turnover" VARCHAR,
  "total_turnover" VARCHAR,
  "male" BIGINT,
  "percent_male" VARCHAR,
  "female" BIGINT,
  "percent_female" VARCHAR,
  "white" BIGINT,
  "percent_white" VARCHAR,
  "african_american" BIGINT,
  "percent_african_american" VARCHAR,
  "american_indian" BIGINT,
  "percent_american_indian" VARCHAR,
  "hispanic" BIGINT,
  "percent_hispanic" VARCHAR,
  "asian" BIGINT,
  "percent_asian" VARCHAR,
  "pacific_islander" BIGINT,
  "percent_pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "percent_not_specified" VARCHAR,
  "percent_minority" VARCHAR,
  "officials_administrators" BIGINT,
  "percent_officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "percent_professionals" VARCHAR,
  "technicians" BIGINT,
  "percent_technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "percent_protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "percent_paraprofessionals" VARCHAR,
  "office_clerical" BIGINT,
  "percent_office_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "percent_skilled_craft" VARCHAR,
  "service_maintence" BIGINT,
  "percent_service_maintence" VARCHAR,
  "cabinet" VARCHAR
);

FY 2014 Agency Workforce Summary

@usgov.state_of_oklahoma_workforce_by_agency.fy_2014_agency_workforce_summary
  • 62.72 KB
  • 120 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2014_agency_workforce_summary (
  "co" BIGINT,
  "agency_name" VARCHAR,
  "fy_2014_emp_count" BIGINT,
  "average_age" DOUBLE,
  "average_years_of_service" DOUBLE,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "traditional" BIGINT,
  "percent_traditional" VARCHAR,
  "boomer" BIGINT,
  "percent_boomer" VARCHAR,
  "gen_x" BIGINT,
  "percent_gen_x" VARCHAR,
  "millennials" BIGINT,
  "percent_millennials" VARCHAR,
  "voluntary_turnover" VARCHAR,
  "involuntary_turnover" VARCHAR,
  "total_turnover" VARCHAR,
  "male" BIGINT,
  "percent_male" VARCHAR,
  "female" BIGINT,
  "percent_female" VARCHAR,
  "white" BIGINT,
  "percent_white" VARCHAR,
  "african_american" BIGINT,
  "percent_african_american" VARCHAR,
  "american_indian" BIGINT,
  "percent_american_indian" VARCHAR,
  "hispanic" BIGINT,
  "percent_hispanic" VARCHAR,
  "asian" BIGINT,
  "percent_asian" VARCHAR,
  "pacific_islander" BIGINT,
  "percent_pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "percent_not_specified" VARCHAR,
  "percent_minority" VARCHAR,
  "officials_administrators" BIGINT,
  "percent_officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "percent_professionals" VARCHAR,
  "technicians" BIGINT,
  "percent_technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "percent_protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "percent_paraprofessionals" VARCHAR,
  "office_clerical" BIGINT,
  "percent_office_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "percent_skilled_craft" VARCHAR,
  "service_maintence" BIGINT,
  "percent_service_maintence" VARCHAR,
  "cabinet" VARCHAR
);

FY 2015 Agency Workforce Summary

@usgov.state_of_oklahoma_workforce_by_agency.fy_2015_agency_workforce_summary
  • 63.33 KB
  • 119 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2015_agency_workforce_summary (
  "co" BIGINT,
  "agency_name" VARCHAR,
  "fy_2015_emp_count" BIGINT,
  "average_age" DOUBLE,
  "average_years_of_service" DOUBLE,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "traditional" BIGINT,
  "percent_traditional" VARCHAR,
  "boomer" BIGINT,
  "percent_boomer" VARCHAR,
  "gen_x" BIGINT,
  "percent_gen_x" VARCHAR,
  "millennials" BIGINT,
  "percent_millennials" VARCHAR,
  "voluntary_turnover" VARCHAR,
  "involuntary_turnover" VARCHAR,
  "total_turnover" VARCHAR,
  "male" BIGINT,
  "percent_male" VARCHAR,
  "female" BIGINT,
  "percent_female" VARCHAR,
  "white" BIGINT,
  "percent_white" VARCHAR,
  "african_american" BIGINT,
  "percent_african_american" VARCHAR,
  "american_indian" BIGINT,
  "percent_american_indian" VARCHAR,
  "hispanic" BIGINT,
  "percent_hispanic" VARCHAR,
  "asian" BIGINT,
  "percent_asian" VARCHAR,
  "pacific_islander" BIGINT,
  "percent_pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "percent_not_specified" VARCHAR,
  "percent_minority" VARCHAR,
  "officials_administrators" BIGINT,
  "percent_officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "percent_professionals" VARCHAR,
  "technicians" BIGINT,
  "percent_technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "percent_protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "percent_paraprofessionals" VARCHAR,
  "office_clerical" BIGINT,
  "percent_office_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "percent_skilled_craft" VARCHAR,
  "service_maintence" BIGINT,
  "percent_service_maintence" VARCHAR,
  "cabinet" VARCHAR
);

FY 2016 Agency Workforce Summary

@usgov.state_of_oklahoma_workforce_by_agency.fy_2016_agency_workforce_summary
  • 67.1 KB
  • 116 rows
  • 60 columns
Loading... 

CREATE TABLE fy_2016_agency_workforce_summary (
  "co" BIGINT,
  "agency_name" VARCHAR,
  "fy_2016_end_count" BIGINT,
  "classified" BIGINT,
  "percent_classified" VARCHAR,
  "unclassified" BIGINT,
  "percent_unclassified" VARCHAR,
  "average_years_of_service" DOUBLE,
  "average_age" DOUBLE,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "traditional" BIGINT,
  "percent_traditional" VARCHAR,
  "boomer" BIGINT,
  "percent_boomer" VARCHAR,
  "gen_x" BIGINT,
  "percent_gen_x" VARCHAR,
  "millennials" BIGINT,
  "percent_millennials" VARCHAR,
  "voluntary_turnover" VARCHAR,
  "involuntary_turnover" VARCHAR,
  "total_turnover" VARCHAR,
  "male" BIGINT,
  "percent_male" VARCHAR,
  "female" BIGINT,
  "percent_female" VARCHAR,
  "white" BIGINT,
  "percent_white" VARCHAR,
  "african_american" BIGINT,
  "percent_african_american" VARCHAR,
  "american_indian" BIGINT,
  "percent_american_indian" VARCHAR,
  "hispanic" BIGINT,
  "percent_hispanic" VARCHAR,
  "asian" BIGINT,
  "percent_asian" VARCHAR,
  "pacific_islander" BIGINT,
  "percent_pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "percent_not_specified" VARCHAR,
  "percent_minority" VARCHAR,
  "officials_administrators" BIGINT,
  "percent_officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "percent_professionals" VARCHAR,
  "technicians" BIGINT,
  "percent_technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "percent_protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "percent_paraprofessionals" VARCHAR,
  "office_clerical" BIGINT,
  "percent_office_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "percent_skilled_craft" VARCHAR,
  "service_maintence" BIGINT,
  "percent_service_maintence" VARCHAR,
  "cabinet" VARCHAR
);

FY 2017 Agency Workforce Summary

@usgov.state_of_oklahoma_workforce_by_agency.fy_2017_agency_workforce_summary
  • 66.98 KB
  • 114 rows
  • 60 columns
Loading... 

CREATE TABLE fy_2017_agency_workforce_summary (
  "co" BIGINT,
  "agency_name" VARCHAR,
  "fy_2017_end_count" BIGINT,
  "classified" BIGINT,
  "percent_classified" VARCHAR,
  "unclassified" BIGINT,
  "percent_unclassified" VARCHAR,
  "average_years_of_service" DOUBLE,
  "average_age" DOUBLE,
  "number_eligible_to_retire" BIGINT,
  "percent_eligible_to_retire" VARCHAR,
  "number_eligible_to_retire_in_5_years" BIGINT,
  "percent_eligible_to_retire_in_5_years" VARCHAR,
  "traditional" BIGINT,
  "percent_traditional" VARCHAR,
  "boomer" BIGINT,
  "percent_boomer" VARCHAR,
  "gen_x" BIGINT,
  "percent_gen_x" VARCHAR,
  "millennials" BIGINT,
  "percent_millennials" VARCHAR,
  "voluntary_turnover" VARCHAR,
  "involuntary_turnover" VARCHAR,
  "total_turnover" VARCHAR,
  "male" BIGINT,
  "percent_male" VARCHAR,
  "female" BIGINT,
  "percent_female" VARCHAR,
  "white" BIGINT,
  "percent_white" VARCHAR,
  "african_american" BIGINT,
  "percent_african_american" VARCHAR,
  "american_indian" BIGINT,
  "percent_american_indian" VARCHAR,
  "hispanic" BIGINT,
  "percent_hispanic" VARCHAR,
  "asian" BIGINT,
  "percent_asian" VARCHAR,
  "pacific_islander" BIGINT,
  "percent_pacific_islander" VARCHAR,
  "not_specified" BIGINT,
  "percent_not_specified" VARCHAR,
  "percent_minority" VARCHAR,
  "officials_administrators" BIGINT,
  "percent_officials_administrators" VARCHAR,
  "professionals" BIGINT,
  "percent_professionals" VARCHAR,
  "technicians" BIGINT,
  "percent_technicians" VARCHAR,
  "protective_service_workers" BIGINT,
  "percent_protective_service_workers" VARCHAR,
  "paraprofessionals" BIGINT,
  "percent_paraprofessionals" VARCHAR,
  "office_clerical" BIGINT,
  "percent_office_clerical" VARCHAR,
  "skilled_craft" BIGINT,
  "percent_skilled_craft" VARCHAR,
  "service_maintence" BIGINT,
  "percent_service_maintence" VARCHAR,
  "cabinet" VARCHAR
);

Share link

Anyone who has the link will be able to view this.