Spend Over £25,000 In Salisbury NHS Foundation Trust
Salisbury NHS Foundation Trust
@ukgov.financial_transactions_data_salisbury_nhs_foundation_trust
Salisbury NHS Foundation Trust
@ukgov.financial_transactions_data_salisbury_nhs_foundation_trust
CREATE TABLE n_2019_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_aug_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_dec_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_january_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_nov_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_oct_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2019_sept_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_feb_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_jan_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE n_2020_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE spend_over_25_000_in_salisbury_nhs_foundation_trust (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
Anyone who has the link will be able to view this.