About this Dataset

Ofwat Workforce Management Information

Monthly management information on staff numbers and paybill costs in Civil Service departments, their agencies and their executive NDPBs.
Publisher name: Water Services Regulation Authority (Ofwat)
Last updated: 2025-04-26T04:03:10Z

Tables

Workforce Management Information August 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_august_2019

31.07 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_august_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information December 2018

@ukgov.ofwat_workforce_management_information.workforce_management_information_december_2018

31.09 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_december_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information February 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_february_2019

31.08 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_february_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information January 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_january_2019

31.09 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_january_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information July 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_july_2019

31.08 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_july_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information March 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_march_2019

31.09 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_march_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information November 2018

@ukgov.ofwat_workforce_management_information.workforce_management_information_november_2018

31.09 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_november_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information October 2018

@ukgov.ofwat_workforce_management_information.workforce_management_information_october_2018

31.09 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_october_2018 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);

Workforce Management Information September 2019

@ukgov.ofwat_workforce_management_information.workforce_management_information_september_2019

31.08 kB
3 rows
42 columns

CREATE TABLE workforce_management_information_september_2019 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department:,
  "payroll_staff" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR  -- Number Of Non-payroll Staff (contingent Labour And Consultants/consultancy),
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "grand_total_workforce_numbers" VARCHAR  -- Grand Total (workforce Numbers),
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "payroll_staff_costs" VARCHAR,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR  -- Non-Payroll Staff (contingent Labour/consultancy) Costs,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" VARCHAR  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments_nb_these_will_be_published_alongside_your_of__629e2e5c" VARCHAR  -- Comments (NB: These Will Be Published Alongside Your Row Of Information),
  "notes_for_cabinet_office_not_for_publication" VARCHAR  -- Notes For Cabinet Office (Not For Publication)
);