Spend Over £25,000 In NHSBSA
NHS Business Services Authority
@ukgov.financial_transactions_data_nhsbsa
NHS Business Services Authority
@ukgov.financial_transactions_data_nhsbsa
CREATE TABLE spend_november_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_october_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_for_april_2025 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_for_january_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_for_april_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_for_may_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
CREATE TABLE spend_for_february_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"paid_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_no" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR,
"post_code" VARCHAR
);
Anyone who has the link will be able to view this.