About this Dataset

Spend Over £25,000 In Plymouth Hospitals NHS Trust

Details of expenditure over £25,000 in Plymouth Hospitals NHS Trust. Published as part of the Government's commitment to transparency in expenditure.
Publisher name: Plymouth Hospitals NHS Trust
Last updated: 2025-04-04T04:00:18Z

Tables

Expenditure Over £25k - October 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2020

15.33 KB
130 rows
10 columns


CREATE TABLE expenditure_over_25k_october_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Expenditure Over £25k - September 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2014

10.39 KB
104 rows
8 columns


CREATE TABLE expenditure_over_25k_september_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2015

10.51 KB
106 rows
8 columns


CREATE TABLE expenditure_over_25k_september_2015 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2016

11.05 KB
106 rows
10 columns


CREATE TABLE expenditure_over_25k_september_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

Expenditure Over £25k - September 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2017

10.42 KB
108 rows
8 columns


CREATE TABLE expenditure_over_25k_september_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2018

9.9 KB
87 rows
8 columns


CREATE TABLE expenditure_over_25k_september_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25K - September 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2019

10.94 KB
130 rows
8 columns


CREATE TABLE expenditure_over_25k_september_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2020

15.48 KB
152 rows
10 columns


CREATE TABLE expenditure_over_25k_september_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Expense Over £25k - February 2021

@ukgov.phnt_financial_transactions_over_25k.expense_over_25k_february_2021

18.32 KB
186 rows
10 columns


CREATE TABLE expense_over_25k_february_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Spend Over 25K February 2023

@ukgov.phnt_financial_transactions_over_25k.spend_over_25k_february_2023

17.64 KB
205 rows
10 columns


CREATE TABLE spend_over_25k_february_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_no" BIGINT,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Spend Over 25k - June 2020

@ukgov.phnt_financial_transactions_over_25k.spend_over_25k_june_2020

16.25 KB
145 rows
10 columns


CREATE TABLE spend_over_25k_june_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);