Spend Over £25,000 In Norfolk And Suffolk NHS Foundation Trust
Norfolk and Suffolk NHS Foundation Trust
@ukgov.https_www_nsft_nhs_uk_spending_over_25k
Norfolk and Suffolk NHS Foundation Trust
@ukgov.https_www_nsft_nhs_uk_spending_over_25k
CREATE TABLE november_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE october_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE october_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE october_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE september_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE september_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
CREATE TABLE september_2022 (
"department_family" VARCHAR,
"entity" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"purchase_invoice_number" VARCHAR,
"n__amount" VARCHAR,
"date_paid" TIMESTAMP
);
Anyone who has the link will be able to view this.