2018 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_march_return

11.63 KB
138 rows
8 columns


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

2018 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_may_return

11.35 KB
125 rows
8 columns


CREATE TABLE n_2018_may_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 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_november_return

11.09 KB
103 rows
8 columns


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

2018 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_october_return

12.39 KB
141 rows
8 columns


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

2018 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_september_return

11.48 KB
125 rows
8 columns


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

2019 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_april_return

11.3 KB
105 rows
8 columns


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

2019 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_august_return

12.16 KB
142 rows
8 columns


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

2019 December Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_december_return

12.83 KB
156 rows
9 columns


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

2019 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_february_return

11.62 KB
127 rows
8 columns


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

2019 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_january_return

11.98 KB
145 rows
8 columns


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

2019 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_july_return

11.82 KB
132 rows
8 columns


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

2019 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_june_return

11.64 KB
137 rows
8 columns


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

2019 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_march_return

13.06 KB
201 rows
8 columns


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

2019 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_may_return

11.95 KB
139 rows
8 columns


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

2019 November Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_november_return

11.93 KB
144 rows
8 columns


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

2019 October Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_october_return

12.54 KB
169 rows
8 columns


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

2019 September Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_september_return

11.39 KB
117 rows
8 columns


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

2020 April Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_april_return

14.05 KB
225 rows
8 columns


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

2020 August Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_august_return

11.92 KB
139 rows
8 columns


CREATE TABLE n_2020_august_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount_in_sterling" DOUBLE
);

2020 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_february_return

11.6 KB
143 rows
8 columns


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

2020 January Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_january_return

12.09 KB
141 rows
8 columns


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

2020 July Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_july_return

12.1 KB
151 rows
8 columns


CREATE TABLE n_2020_july_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount_in_sterling" DOUBLE
);

2020 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_june_return

12.09 KB
151 rows
8 columns


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

2020 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_march_return

12.91 KB
194 rows
8 columns


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

2020 May Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_may_return

12.1 KB
145 rows
8 columns


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

Spend Over £25,000 In The Pennine Acute Hospitals NHS Trust

About this Dataset