Spend Over £25,000 In The Pennine Acute Hospitals NHS Trust
The Pennine Acute Hospitals NHS Trust
@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust
The Pennine Acute Hospitals NHS Trust
@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust
CREATE TABLE n_2020_november_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2020_october_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2020_september_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2021_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2021_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2021_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2021_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2021_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
Anyone who has the link will be able to view this.