Baselight
Sign In

Classified And Unclassified Workforce Statistics

State of Oklahoma

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5

Loading...
Loading...

About this Dataset

Classified And Unclassified Workforce Statistics

This dataset presents resources that summarize agency workforce characteristics for classified and unclassified employees separately.
Organization: State of Oklahoma
Last updated: 2021-08-07T15:00:04.856266
Tags: no-keyword-provided

Tables

FY 2016 Classified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2016_classified_agency_summary
  • 55.88 KB
  • 116 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2016_classified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2016_classified_end_count" BIGINT,
  "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 2016 Unclassified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2016_unclassified_agency_summary
  • 60.2 KB
  • 116 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2016_unclassified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2016_unclassified_end_count" BIGINT,
  "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 Classified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2017_classified_agency_summary
  • 56.04 KB
  • 114 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2017_classified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2017_classified_end_count" BIGINT,
  "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 Unclassified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2017_unclassified_agency_summary
  • 60.17 KB
  • 114 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2017_unclassified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2017_unclassified_end_count" BIGINT,
  "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 2018 Classified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2018_classified_agency_summary
  • 56.79 KB
  • 117 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2018_classified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2018_classified_end_count" BIGINT,
  "average_years_of_service" VARCHAR,
  "average_age" VARCHAR,
  "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 2018 Unclassified Agency Summary

@usgov.state_of_oklahoma_classified_and_unclassified_workforc_0817baf5.fy_2018_unclassified_agency_summary
  • 62.09 KB
  • 117 rows
  • 56 columns
Loading... 

CREATE TABLE fy_2018_unclassified_agency_summary (
  "co" BIGINT,
  "agency" VARCHAR,
  "fy_2018_unclassified_end_count" BIGINT,
  "average_years_of_service" VARCHAR,
  "average_age" VARCHAR,
  "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" DOUBLE,
  "percent_pacific_islander" VARCHAR,
  "not_specified" DOUBLE,
  "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.