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
A monthly-updated list of all financial transactions spending over £25,000 made by The Pennine Acute Hospitals NHS Trust, as part of the Government's commitment to transparency in expenditure.
Publisher name: The Pennine Acute Hospitals NHS Trust
Last updated: 2024-02-07T04:00:02Z
CREATE TABLE n_2014_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" DOUBLE,
"expense_type_1" VARCHAR,
"expense_area" VARCHAR,
"expense_area_1" VARCHAR,
"expense_area_2" VARCHAR,
"expense_area_3" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount_in_sterling" DOUBLE,
"status" VARCHAR,
"clear_ref" VARCHAR
);CREATE TABLE n_2014_june_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_2014_march_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_2014_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,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE n_2014_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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE n_2014_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_2014_september_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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE n_2015_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling
);CREATE TABLE n_2015_august_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_2015_december_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_2015_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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE n_2015_january_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_2015_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13
);CREATE TABLE n_2015_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling
);CREATE TABLE n_2015_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling
);CREATE TABLE n_2015_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE n_2015_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,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE n_2015_october_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_2015_september_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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE n_2016_april_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_2016_august_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 -- Unnamed: 8
);CREATE TABLE n_2016_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date_of_payment" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"n__amount_in_sterling" DOUBLE -- Amount In Sterling,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE n_2016_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,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE n_2016_january_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_2016_july_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.