Spend Over £25000 In Maidstone And Tunbridge Wells NHS Trust
Maidstone and Tunbridge Wells NHS Trust
@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust
Maidstone and Tunbridge Wells NHS Trust
@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust
CREATE TABLE nov_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE nov_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE november_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE oct_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE oct_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE october_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE sep_2020 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE sep_2021 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" BIGINT,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
CREATE TABLE september_2018 (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleared_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"reference" VARCHAR,
"line_value" DOUBLE,
"vat_reg_no" VARCHAR
);
Anyone who has the link will be able to view this.