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

2010 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_april_return
  • 16.19 kB
  • 181 rows
  • 12 columns
Loading... 
CREATE TABLE n_2010_april_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "unnamed_3" DOUBLE  -- Unnamed: 3,
  "expense_type" VARCHAR,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "expense_area" VARCHAR,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "expense_area_1" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE
);

2010 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_august_return
  • 10.8 kB
  • 147 rows
  • 8 columns
Loading... 
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
);

2010 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_december_return
  • 10.35 kB
  • 155 rows
  • 8 columns
Loading... 
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
);

2010 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_july_return
  • 10.39 kB
  • 143 rows
  • 8 columns
Loading... 
CREATE TABLE n_2010_july_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE
);

2010 June Return

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

2010 May Return

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

2010 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_november_return
  • 9.97 kB
  • 138 rows
  • 8 columns
Loading... 
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
);

2010 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_october_return
  • 10.62 kB
  • 165 rows
  • 8 columns
Loading... 
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
);

2010 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2010_september_return
  • 10.31 kB
  • 92 rows
  • 8 columns
Loading... 
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
);

2011 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_april_return
  • 11.2 kB
  • 157 rows
  • 8 columns
Loading... 
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
);

2011 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_august_return
  • 11.23 kB
  • 129 rows
  • 9 columns
Loading... 
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  -- Unnamed: 8
);

2011 December Return

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

2011 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_february_return
  • 9.98 kB
  • 122 rows
  • 8 columns
Loading... 
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
);

2011 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_january_return
  • 10.51 kB
  • 110 rows
  • 9 columns
Loading... 
CREATE TABLE n_2011_january_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" DOUBLE,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount_in_sterling" DOUBLE,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

2011 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_july_return
  • 10.72 kB
  • 139 rows
  • 8 columns
Loading... 
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
);

2011 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_june_return
  • 12.6 kB
  • 200 rows
  • 10 columns
Loading... 
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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2011 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_march_return
  • 11.24 kB
  • 197 rows
  • 8 columns
Loading... 
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
);

2011 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_may_return
  • 10.17 kB
  • 125 rows
  • 8 columns
Loading... 
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
);

2011 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_november_return
  • 10.24 kB
  • 105 rows
  • 8 columns
Loading... 
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
);

2011 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_october_return
  • 11.32 kB
  • 127 rows
  • 9 columns
Loading... 
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
);

2011 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2011_september_return
  • 11.37 kB
  • 127 rows
  • 9 columns
Loading... 
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  -- Unnamed: 8
);

2012 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_april_return
  • 11.65 kB
  • 198 rows
  • 8 columns
Loading... 
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
);

2012 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_august_return
  • 11.89 kB
  • 142 rows
  • 10 columns
Loading... 
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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

2012 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_december_return
  • 13.44 kB
  • 107 rows
  • 11 columns
Loading... 
CREATE TABLE n_2012_december_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleardate" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "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 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2012_february_return
  • 10.71 kB
  • 121 rows
  • 9 columns
Loading... 
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  -- Unnamed: 8
);

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.