MOD: Workforce Management Information January To December 2019
Ministry of Defence
@ukgov.mod_workforce_management_information_january_to_december_2019
Ministry of Defence
@ukgov.mod_workforce_management_information_january_to_december_2019
CREATE TABLE mod_s_workforce_management_information_april_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_august_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE
);
CREATE TABLE mod_s_workforce_management_information_december_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_february_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_january_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_july_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_june_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_march_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_may_2019 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_november_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_october_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE
);
CREATE TABLE mod_s_workforce_management_information_september_2019 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"payroll_staff" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"number_of_non_payroll_staff_contingent_labour_and_cons_6d32feb9" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"grand_total_workforce_numbers" VARCHAR,
"unnamed_28" VARCHAR,
"payroll_staff_costs" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"non_payroll_staff_contingent_labour_consultancy_costs" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE
);
Anyone who has the link will be able to view this.