Baselight
Sign In

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

Loading...
Loading...

About this Dataset

Spend Over £25,000 In The Pennine Acute Hospitals 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

Tables

2012 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_january_return
  • 12.19 KB
  • 128 rows
  • 11 columns
Loading... 

CREATE TABLE n_2012_january_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "unnamed_4" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);

2012 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_july_return
  • 11.1 KB
  • 152 rows
  • 8 columns
Loading... 

CREATE TABLE n_2012_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
);

2012 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_june_return
  • 9.64 KB
  • 98 rows
  • 8 columns
Loading... 

CREATE TABLE n_2012_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
);

2012 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_march_return
  • 11.52 KB
  • 185 rows
  • 8 columns
Loading... 

CREATE TABLE n_2012_march_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2012 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_may_return
  • 13.57 KB
  • 211 rows
  • 11 columns
Loading... 

CREATE TABLE n_2012_may_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" BIGINT,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);

2012 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_november_return
  • 12.12 KB
  • 127 rows
  • 11 columns
Loading... 

CREATE TABLE n_2012_november_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);

2012 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_october_return
  • 10.76 KB
  • 118 rows
  • 9 columns
Loading... 

CREATE TABLE n_2012_october_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
);

2012 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_september_return
  • 11.15 KB
  • 119 rows
  • 10 columns
Loading... 

CREATE TABLE n_2012_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,
  "unnamed_9" VARCHAR
);

2013 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_april_return
  • 12.64 KB
  • 209 rows
  • 9 columns
Loading... 

CREATE TABLE n_2013_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,
  "unnamed_8" VARCHAR
);

2013 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_august_return
  • 10.66 KB
  • 83 rows
  • 10 columns
Loading... 

CREATE TABLE n_2013_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_9" VARCHAR
);

2013 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_december_return
  • 10.83 KB
  • 163 rows
  • 9 columns
Loading... 

CREATE TABLE n_2013_december_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,
  "unnamed_8" VARCHAR
);

2013 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_february_return
  • 12.19 KB
  • 139 rows
  • 11 columns
Loading... 

CREATE TABLE n_2013_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_9" VARCHAR,
  "unnamed_10" VARCHAR
);

2013 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_january_return
  • 11.26 KB
  • 181 rows
  • 8 columns
Loading... 

CREATE TABLE n_2013_january_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2013 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_july_return
  • 11.94 KB
  • 172 rows
  • 10 columns
Loading... 

CREATE TABLE n_2013_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,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

2013 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_june_return
  • 10.67 KB
  • 177 rows
  • 8 columns
Loading... 

CREATE TABLE n_2013_june_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2013 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_march_return
  • 10.87 KB
  • 163 rows
  • 8 columns
Loading... 

CREATE TABLE n_2013_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
);

2013 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_may_return
  • 9.97 KB
  • 164 rows
  • 8 columns
Loading... 

CREATE TABLE n_2013_may_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_7" VARCHAR
);

2013 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_november_return
  • 10.02 KB
  • 107 rows
  • 8 columns
Loading... 

CREATE TABLE n_2013_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
);

2013 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_october_return
  • 10.98 KB
  • 115 rows
  • 10 columns
Loading... 

CREATE TABLE n_2013_october_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "clear_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

2013 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_september_return
  • 11.46 KB
  • 132 rows
  • 11 columns
Loading... 

CREATE TABLE n_2013_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_9" VARCHAR,
  "unnamed_10" VARCHAR
);

2014 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_april_return
  • 10.75 KB
  • 148 rows
  • 8 columns
Loading... 

CREATE TABLE n_2014_april_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2014 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_august_return
  • 16.93 KB
  • 139 rows
  • 16 columns
Loading... 

CREATE TABLE n_2014_august_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "unnamed_4" VARCHAR,
  "expense_area" VARCHAR,
  "unnamed_6" VARCHAR,
  "expense_area_1" VARCHAR,
  "unnamed_8" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE,
  "status" VARCHAR,
  "clear_ref" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);

2014 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_december_return
  • 11.96 KB
  • 176 rows
  • 10 columns
Loading... 

CREATE TABLE n_2014_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,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

2014 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_february_return
  • 13.81 KB
  • 220 rows
  • 14 columns
Loading... 

CREATE TABLE n_2014_february_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_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

2014 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_january_return
  • 11.86 KB
  • 194 rows
  • 10 columns
Loading... 

CREATE TABLE n_2014_january_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

Share link

Anyone who has the link will be able to view this.