Exceptions To Cross-Government Moratoria On Spend In The Department For Work And Pensions
Department for Work and Pensions
@ukgov.exceptions_to_government_moratoria_department_work_and_pensions
Department for Work and Pensions
@ukgov.exceptions_to_government_moratoria_department_work_and_pensions
This dataset is a list of those items of spend that have been allowed in the Department for Work and Pensions since the announcement (24 May 2010) of five cross-government moratoria: ICT spend above £1m; Advertising & Marketing; consultancy; Property leases & lease extensions; and Civil Service recruitment.
Publisher name: Department for Work and Pensions
Last updated: 2024-06-14T04:02:56Z
CREATE TABLE advertising_marketing_and_commercial_jul_to_sep_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR -- Value (ś) (excluding VAT),
"approval_date" TIMESTAMP,
"control" VARCHAR
);CREATE TABLE advertising_marketing_apr_to_jun_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"control_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);CREATE TABLE advertising_marketing_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR -- Value (Ł),
"n__approval_date" TIMESTAMP -- Approval Date
);CREATE TABLE advertising_marketing_jan_to_mar_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR -- Value (£),
"n__approval_date" TIMESTAMP -- Approval Date
);CREATE TABLE advertising_marketing_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);CREATE TABLE commercial_apr_to_jun_2018 (
"updated_dwp_commercial_transparency_2018_19_q1_april_t_ab208e8b" VARCHAR -- Updated DWP Commercial Transparency Data 2018-19 Q1 (April To June 2018),
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE commercial_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR -- Value (Ł),
"n__approval_date" TIMESTAMP -- Approval Date
);CREATE TABLE commercial_oct_to_dec_2018 (
"updated_dwp_commercial_transparency_2018_19_q3_oct_to_dec_2018" VARCHAR -- Updated DWP Commercial Transparency Data 2018-19 Q3 (Oct To Dec 2018),
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE consultancy_apr_to_jun_2018 (
"reference_number" VARCHAR,
"case_name" VARCHAR,
"case_description" VARCHAR,
"department" VARCHAR,
"alb" VARCHAR,
"lead_control" VARCHAR,
"controls_entry_stage" VARCHAR,
"total_value_approved_revised_value" VARCHAR -- Total Value Approved (Revised Value),
"decision" VARCHAR,
"decision_sent_to_department" TIMESTAMP
);CREATE TABLE consultancy_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);CREATE TABLE consultancy_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);CREATE TABLE exceptions_for_jul_to_sep_2022 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" BIGINT -- Value (Ł) (excluding VAT),
"approval_date" TIMESTAMP,
"control" VARCHAR
);CREATE TABLE exceptions_to_cross_government_moratoria_on_spend_in_t_cb269e7d (
"department" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"project_name" VARCHAR,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"basis_for" VARCHAR,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"total_value" VARCHAR,
"unnamed_9" VARCHAR -- Unnamed: 9,
"date_of_approval" VARCHAR
);CREATE TABLE ict_apr_to_jun_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"control_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);CREATE TABLE ict_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR -- Value (È),
"n__approval_date" VARCHAR -- Approval Date
);CREATE TABLE ict_jan_to_mar_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR -- Value (Ł),
"n__approval_date" TIMESTAMP -- Approval Date
);CREATE TABLE ict_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);CREATE TABLE ict_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);CREATE TABLE property_apr_to_jun_2018 (
"reference_number" VARCHAR,
"case_name" VARCHAR,
"case_description" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"lead_control" VARCHAR,
"controls_entry_stage" VARCHAR,
"total_value_approved_revised_value" VARCHAR -- Total Value Approved (Revised Value),
"decision" VARCHAR,
"decision_sent_to_department" VARCHAR
);CREATE TABLE property_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);CREATE TABLE property_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);CREATE TABLE recruitment_apr_to_jun_2018 (
"departmernt" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_apporved" DOUBLE -- Total Value Apporved (Ł),
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_full_time_equivalent" VARCHAR -- Civil Service Grade (full Time Equivalent),
"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,
"civil_service_grade_headcount" VARCHAR -- Civil Service Grade (headcount),
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"total_approvals_headcount" DOUBLE -- Total Approvals (headcount),
"total_approvals_full_time_equivalent" DOUBLE -- Total Approvals (full Time Equivalent),
"date_of_approval" TIMESTAMP
);CREATE TABLE recruitment_apr_to_jun_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" DOUBLE -- Total Value Approved (£),
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR -- Civil Service Grade (FTE),
"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,
"civil_service_grade_headcount" VARCHAR -- Civil Service Grade (Headcount),
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"total_approvals_headcount" DOUBLE -- Total Approvals (Headcount),
"total_approvals_fte" DOUBLE -- Total Approvals (FTE),
"date_of_approval" TIMESTAMP
);CREATE TABLE recruitment_jan_to_mar_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" DOUBLE -- Total Value Approved (£),
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR -- Civil Service Grade (FTE),
"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,
"civil_service_grade_headcount" VARCHAR -- Civil Service Grade (Headcount),
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"total_approvals_headcount" DOUBLE -- Total Approvals (Headcount),
"total_approvals_fte" DOUBLE -- Total Approvals (FTE),
"date_of_approval" TIMESTAMP
);CREATE TABLE recruitment_jul_to_sep_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" VARCHAR -- Total Value Approved (œ),
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR -- Civil Service Grade (FTE),
"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,
"civil_service_grade_headcount" VARCHAR -- Civil Service Grade (Headcount),
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"total_approvals_headcount" DOUBLE -- Total Approvals (Headcount),
"total_approvals_fte" DOUBLE -- Total Approvals (FTE),
"date_of_approval" VARCHAR
);Anyone who has the link will be able to view this.