2018 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2018_march_return

11.91 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.62 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.36 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.69 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.76 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.57 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.45 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

13.14 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  -- Unnamed: 8
);

2019 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2019_february_return

11.9 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

12.27 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

12.11 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.92 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.38 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

12.24 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

12.21 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.84 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.67 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.39 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

12.2 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  -- Amount In Sterling
);

2020 February Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_february_return

11.88 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.38 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.39 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  -- Amount In Sterling
);

2020 June Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_june_return

12.38 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  -- Amount In Sterling
);

2020 March Return

@ukgov.financial_transactions_the_pennine_acute_hosiptals_nhs_trust.n_2020_march_return

13.22 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.39 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