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_2010_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"unnamed_3" DOUBLE,
"expense_type" VARCHAR,
"unnamed_5" VARCHAR,
"expense_area" VARCHAR,
"unnamed_7" VARCHAR,
"expense_area_1" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2010_august_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_2010_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2010_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"unnamed_3" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2010_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_2010_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
);
CREATE TABLE n_2010_november_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2010_october_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2010_september_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_2011_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2011_august_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"newcldate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR
);
CREATE TABLE n_2011_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"newcldate" TIMESTAMP,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR
);
CREATE TABLE n_2011_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2011_january_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"unnamed_3" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR
);
CREATE TABLE n_2011_july_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_2011_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE n_2011_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2011_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2011_november_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_2011_october_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" DOUBLE,
"newcldate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2011_september_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,
"unnamed_8" VARCHAR
);
CREATE TABLE n_2012_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"newcldate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE
);
CREATE TABLE n_2012_august_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"newcldate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE n_2012_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"cleardate" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"unnamed_5" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount_in_sterling" DOUBLE,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR
);
CREATE TABLE n_2012_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"clear_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE,
"unnamed_8" VARCHAR
);
Anyone who has the link will be able to view this.