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.48 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  -- Unnamed: 4,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

2012 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_july_return
  • 11.37 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.87 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.8 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.89 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: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

2012 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_november_return
  • 12.41 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: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

2012 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_october_return
  • 11.02 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  -- Unnamed: 8
);

2012 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_september_return
  • 11.41 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2013 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_april_return
  • 12.95 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  -- Unnamed: 8
);

2013 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_august_return
  • 10.91 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2013 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_december_return
  • 11.09 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  -- Amount In Sterling,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

2013 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_february_return
  • 12.48 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

2013 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_january_return
  • 11.53 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
  • 12.22 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2013 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_june_return
  • 10.92 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
  • 11.13 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
  • 10.21 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  -- Unnamed: 7
);

2013 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_november_return
  • 10.26 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
  • 11.24 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2013 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2013_september_return
  • 11.73 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

2014 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_april_return
  • 11.01 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
  • 17.33 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  -- Unnamed: 4,
  "expense_area" VARCHAR,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "expense_area_1" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE,
  "status" VARCHAR,
  "clear_ref" VARCHAR,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

2014 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_december_return
  • 12.25 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2014 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_february_return
  • 14.14 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: 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
);

2014 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_january_return
  • 12.14 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: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Share link

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