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

2014 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_july_return
  • 16.95 kB
  • 165 rows
  • 14 columns
Loading... 
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
);

2014 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_june_return
  • 10.71 kB
  • 119 rows
  • 8 columns
Loading... 
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
);

2014 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_march_return
  • 11.17 kB
  • 186 rows
  • 8 columns
Loading... 
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
);

2014 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_may_return
  • 10.87 kB
  • 114 rows
  • 9 columns
Loading... 
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
);

2014 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_november_return
  • 12.74 kB
  • 235 rows
  • 11 columns
Loading... 
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
);

2014 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_october_return
  • 11.61 kB
  • 178 rows
  • 8 columns
Loading... 
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
);

2014 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2014_september_return
  • 12.76 kB
  • 169 rows
  • 11 columns
Loading... 
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
);

2015 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_april_return
  • 12.15 kB
  • 235 rows
  • 8 columns
Loading... 
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
);

2015 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_august_return
  • 10.73 kB
  • 151 rows
  • 8 columns
Loading... 
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
);

2015 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_december_return
  • 10.9 kB
  • 179 rows
  • 8 columns
Loading... 
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
);

2015 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_february_return
  • 11.89 kB
  • 128 rows
  • 10 columns
Loading... 
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
);

2015 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_january_return
  • 11.1 kB
  • 227 rows
  • 8 columns
Loading... 
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
);

2015 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_july_return
  • 15.39 kB
  • 179 rows
  • 14 columns
Loading... 
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
);

2015 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_june_return
  • 11.99 kB
  • 213 rows
  • 8 columns
Loading... 
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
);

2015 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_march_return
  • 12.99 kB
  • 305 rows
  • 8 columns
Loading... 
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
);

2015 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_may_return
  • 10.93 kB
  • 111 rows
  • 9 columns
Loading... 
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
);

2015 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_november_return
  • 12.1 kB
  • 201 rows
  • 9 columns
Loading... 
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
);

2015 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_october_return
  • 11.48 kB
  • 184 rows
  • 8 columns
Loading... 
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
);

2015 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2015_september_return
  • 11.75 kB
  • 123 rows
  • 10 columns
Loading... 
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
);

2016 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_april_return
  • 13.49 kB
  • 274 rows
  • 8 columns
Loading... 
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
);

2016 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_august_return
  • 12.13 kB
  • 151 rows
  • 9 columns
Loading... 
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
);

2016 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_december_return
  • 12.89 kB
  • 270 rows
  • 9 columns
Loading... 
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
);

2016 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_february_return
  • 12.54 kB
  • 188 rows
  • 10 columns
Loading... 
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
);

2016 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_january_return
  • 11.54 kB
  • 232 rows
  • 8 columns
Loading... 
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
);

2016 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_july_return
  • 11.42 kB
  • 185 rows
  • 8 columns
Loading... 
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
);

2016 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_june_return
  • 14.6 kB
  • 145 rows
  • 14 columns
Loading... 
CREATE TABLE n_2016_june_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,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

2016 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_march_return
  • 12.35 kB
  • 201 rows
  • 9 columns
Loading... 
CREATE TABLE n_2016_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,
  "clear_ref" VARCHAR
);

2016 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_may_return
  • 12.44 kB
  • 163 rows
  • 10 columns
Loading... 
CREATE TABLE n_2016_may_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
);

2016 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_november_return
  • 12.13 kB
  • 165 rows
  • 9 columns
Loading... 
CREATE TABLE n_2016_november_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
);

2016 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_october_return
  • 11.74 kB
  • 159 rows
  • 9 columns
Loading... 
CREATE TABLE n_2016_october_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" 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
);

2016 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2016_september_return
  • 11.91 kB
  • 165 rows
  • 9 columns
Loading... 
CREATE TABLE n_2016_september_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleareddate" 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
);

2017 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_april_return
  • 11.95 kB
  • 212 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_april_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE
);

2017 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_august_return
  • 11.77 kB
  • 187 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_december_return
  • 11.48 kB
  • 122 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_december_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
);

2017 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_february_return
  • 11.59 kB
  • 170 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_january_return
  • 10.13 kB
  • 248 rows
  • 7 columns
Loading... 
CREATE TABLE n_2017_january_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT
);

2017 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_july_return
  • 11.39 kB
  • 181 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_june_return
  • 11.58 kB
  • 157 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_june_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2017 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_march_return
  • 12.83 kB
  • 233 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_may_return
  • 10.98 kB
  • 134 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_may_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "newcldate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount_in_sterling" DOUBLE
);

2017 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_november_return
  • 11.01 kB
  • 105 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_october_return
  • 10.99 kB
  • 102 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2017 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2017_september_return
  • 7.98 kB
  • 29 rows
  • 8 columns
Loading... 
CREATE TABLE n_2017_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
);

2018 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_april_return
  • 11.55 kB
  • 119 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_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
);

2018 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_august_return
  • 12.36 kB
  • 153 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_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
);

2018 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_december_return
  • 11.96 kB
  • 132 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_december_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
);

2018 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_february_return
  • 12.06 kB
  • 151 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_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
);

2018 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_january_return
  • 11.71 kB
  • 119 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_january_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
);

2018 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_july_return
  • 12.73 kB
  • 168 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_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
);

2018 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_june_return
  • 12.59 kB
  • 148 rows
  • 8 columns
Loading... 
CREATE TABLE n_2018_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
);

Share link

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