UKSBS Monthly Spend
UK Shared Business Services
@ukgov.uk_sbs_monthly_spend
UK Shared Business Services
@ukgov.uk_sbs_monthly_spend
UKSBS Monthly Spend
Publisher name: UK Shared Business Services
Last updated: 2025-01-08T04:00:14Z
CREATE TABLE april_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE april_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE april_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE august_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE august_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE august_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE december_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE december_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE february_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE february_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE february_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE january_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE january_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE january_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE july_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE july_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE july_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE june_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE june_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE june_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE march_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE march_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE march_2024 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE may_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);CREATE TABLE may_2023 (
"department" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"supplier_postcode" VARCHAR
);Anyone who has the link will be able to view this.