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.7 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.64 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.77 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.32 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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Expenditure Over £25k - September 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2017

10.67 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

10.14 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

11.2 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.85 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.76 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

18.07 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.64 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
);