About this Dataset

BEIS Departmental Spending Over £25,000

The Department for Business, Energy and Industrial Strategy (BEIS) publishes details of all departmental spending over £25,000 on a monthly basis. BEIS has chosen to publish all departmental spend regardless of amount.
Publisher name: Department for Business, Energy and Industrial Strategy
Last updated: 2024-09-14T03:05:14Z

Tables

BEIS: All Spending, August 2018

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_august_2018

84.27 kB
3,260 rows
14 columns

CREATE TABLE beis_all_spending_august_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: All Spending, December 2018

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_december_2018

88.05 kB
3,762 rows
14 columns

CREATE TABLE beis_all_spending_december_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" DOUBLE
);

BEIS: All Spending, January 2019

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_january_2019

92.58 kB
3,712 rows
14 columns

CREATE TABLE beis_all_spending_january_2019 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: All Spending, November 2018

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_november_2018

89.45 kB
4,492 rows
14 columns

CREATE TABLE beis_all_spending_november_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" DOUBLE
);

BEIS: All Spending, October 2018

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_october_2018

88.03 kB
4,388 rows
14 columns

CREATE TABLE beis_all_spending_october_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: All Spending, September 2018

@ukgov.beis_departmental_spending_over_25_000.beis_all_spending_september_2018

75.41 kB
2,670 rows
14 columns

CREATE TABLE beis_all_spending_september_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS Departmental Spending Over £25,000

@ukgov.beis_departmental_spending_over_25_000.beis_departmental_spending_over_25_000

80.55 kB
3,008 rows
14 columns

CREATE TABLE beis_departmental_spending_over_25_000 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: Spending Over £25,000, February 2018

@ukgov.beis_departmental_spending_over_25_000.beis_spending_over_25_000_february_2018

74.94 kB
2,998 rows
14 columns

CREATE TABLE beis_spending_over_25_000_february_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: Spending Over £25,000, January 2018

@ukgov.beis_departmental_spending_over_25_000.beis_spending_over_25_000_january_2018

82.99 kB
3,163 rows
14 columns

CREATE TABLE beis_spending_over_25_000_january_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);

BEIS: Spending Over £25,000, March 2018

@ukgov.beis_departmental_spending_over_25_000.beis_spending_over_25_000_march_2018

103.14 kB
4,263 rows
14 columns

CREATE TABLE beis_spending_over_25_000_march_2018 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR
);