About this Dataset

BEIS: Spend Control Data

This dataset is also known as Exceptions to cross-government moratoria on spend or exceptions to spending controls. From Q2 (Finance year 2020-21) BEIS will only publish a single csv format file with mandated details. Files previously released list items of spend that have been allowed via the Cabinet Office Approval process by departments since the announcement (24 May 2010) of six cross-government moratoria: ICT spend above £1m; Advertising and marketing; Consultancy; Commercial; Property leases & lease extensions; and Civil Service recruitment. Exceptions to spend requests may not be required for each sector every quarter by the Department. Datasets for Departments for Energy and Climate Change; and Business, Innovation and Skills are available as separate entity names.
Publisher name: Department for Business, Energy and Industrial Strategy
Last updated: 2023-10-21T04:17:20Z

Tables

BEIS Contingent Labour April To June 2022

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_contingent_labour_april_to_june_2022

5.99 kB
5 rows
8 columns

CREATE TABLE beis_contingent_labour_april_to_june_2022 (
  "q1_22_23" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

BEIS Contingent Labour January To March 2022

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_contingent_labour_january_to_march_2022

5.98 kB
5 rows
8 columns

CREATE TABLE beis_contingent_labour_january_to_march_2022 (
  "q4_21_22" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

BEIS Exceptions To Spending Controls: Advertising And Marketing, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_advertising_and_m_405e9dfb

6.65 kB
2 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_advertising_and_m_405e9dfb (
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "n__case_name" VARCHAR  -- Case Name,
  "n__case_details" VARCHAR  -- Case Details,
  "n__value" VARCHAR  -- Value (£),
  "n__approval_date" TIMESTAMP  -- Approval Date
);

BEIS Exceptions To Spending Controls: Advertising And Marketing, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_advertising_and_m_4821b54f

5.59 kB
4 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_advertising_and_m_4821b54f (
  "owning_dept_alb_department" VARCHAR,
  "alb" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Advertising And Marketing, October To December 2018

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_advertising_and_m_8cd4116c

4.22 kB
999 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_advertising_and_m_8cd4116c (
  "dept" VARCHAR,
  "alb" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "requested_value" VARCHAR,
  "date" VARCHAR
);

BEIS Exceptions To Spending Controls, April To June 2022

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_april_to_june_2022

6.89 kB
36 rows
5 columns

CREATE TABLE beis_exceptions_to_spending_controls_april_to_june_2022 (
  "owning_dept_alb_department" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Commercial, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_commercial_januar_dad91b99

6.56 kB
2 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_commercial_januar_dad91b99 (
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "n__case_name" VARCHAR  -- Case Name,
  "n__case_details" VARCHAR  -- Case Details,
  "n__value" VARCHAR  -- Value (Ł),
  "n__approval_date" TIMESTAMP  -- Approval Date
);

BEIS Exceptions To Spending Controls: Commercial, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_commercial_july_t_bcc0447e

5.47 kB
3 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_commercial_july_t_bcc0447e (
  "owning_dept_alb_department" VARCHAR,
  "alb" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Consultancy, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_consultancy_janua_08338447

7.18 kB
3 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_consultancy_janua_08338447 (
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "n__case_name" VARCHAR  -- Case Name,
  "n__case_details" VARCHAR  -- Case Details,
  "n__value" VARCHAR  -- Value (£),
  "n__approval_date" TIMESTAMP  -- Approval Date
);

BEIS Exceptions To Spending Controls: Consultancy, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_consultancy_july__d6a9e166

5.36 kB
2 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_consultancy_july__d6a9e166 (
  "owning_dept_alb_department" VARCHAR,
  "alb" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Information And Communications Technology, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_information_and_c_19c31abc

5.64 kB
1 row
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_information_and_c_19c31abc (
  "owning_dept_alb_department" VARCHAR,
  "alb" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (È) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Information And Communications Technology, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_information_and_c_f07a3e7f

4.6 kB
1 row
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_information_and_c_f07a3e7f (
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "n__case_name" VARCHAR  -- Case Name,
  "n__case_details" VARCHAR  -- Case Details,
  "n__value" VARCHAR  -- Value (Ł),
  "n__approval_date" VARCHAR  -- Approval Date
);

BEIS Exceptions To Spending Controls, January To March 2022

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_january_to_march_2022

6.22 kB
24 rows
5 columns

CREATE TABLE beis_exceptions_to_spending_controls_january_to_march_2022 (
  "owning_dept_alb_department" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls, October To December 2021

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_october_to_december_2021

6.45 kB
958 rows
5 columns

CREATE TABLE beis_exceptions_to_spending_controls_october_to_december_2021 (
  "owning_dept_alb_department" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" TIMESTAMP,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Property, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_property_january__5d0c7983

6.56 kB
3 rows
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_property_january__5d0c7983 (
  "owning_dept_alb_department" VARCHAR,
  "control" VARCHAR,
  "n__case_name" VARCHAR  -- Case Name,
  "n__case_details" VARCHAR  -- Case Details,
  "n__value" VARCHAR  -- Value (£),
  "n__approval_date" TIMESTAMP  -- Approval Date
);

BEIS Exceptions To Spending Controls: Property, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_property_july_to__48cd3487

4.65 kB
1 row
6 columns

CREATE TABLE beis_exceptions_to_spending_controls_property_july_to__48cd3487 (
  "owning_dept_alb_department" VARCHAR,
  "alb" VARCHAR,
  "case_name" VARCHAR,
  "value_excluding_vat" VARCHAR  -- Value (£) (excluding VAT),
  "approval_date" VARCHAR,
  "control" VARCHAR
);

BEIS Exceptions To Spending Controls: Recruitment, January To March 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_recruitment_janua_ca76ec1f

16.45 kB
5 rows
24 columns

CREATE TABLE beis_exceptions_to_spending_controls_recruitment_janua_ca76ec1f (
  "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
);

BEIS Exceptions To Spending Controls: Recruitment, July To September 2019

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_exceptions_to_spending_controls_recruitment_july__69f43dd5

13.21 kB
5 rows
19 columns

CREATE TABLE beis_exceptions_to_spending_controls_recruitment_july__69f43dd5 (
  "department" VARCHAR,
  "organisation_name" VARCHAR,
  "civil_service_grade_fte" VARCHAR  -- Civil Service Grade (FTE),
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "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,
  "civil_service_grade_headcount" VARCHAR  -- Civil Service Grade (Headcount),
  "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,
  "total_approvals_headcount" DOUBLE  -- Total Approvals (Headcount),
  "total_approvals_fte" DOUBLE  -- Total Approvals (FTE),
  "date_of_approval" VARCHAR
);

BEIS: Spend Control Data

@ukgov.beis_exceptions_to_spending_controls_for_july_september_2016.beis_spend_control_data

15.16 kB
15 rows
22 columns

CREATE TABLE beis_spend_control_data (
  "recruitment" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "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,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);