Expenditure Of £25k - August 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_of_25k_august_2019

10.63 KB
120 rows
8 columns


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

Expenditure Over £25,000 - January 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25_000_january_2019

10.92 KB
139 rows
8 columns


CREATE TABLE expenditure_over_25_000_january_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 - April 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2014

10.88 KB
119 rows
8 columns


CREATE TABLE expenditure_over_25k_april_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 - April 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2015

11.15 KB
133 rows
8 columns


CREATE TABLE expenditure_over_25k_april_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 - April 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2016

11.31 KB
135 rows
8 columns


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

Expenditure Over £25k - April 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2017

11.51 KB
144 rows
8 columns


CREATE TABLE expenditure_over_25k_april_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 - April 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2018

11.13 KB
129 rows
8 columns


CREATE TABLE expenditure_over_25k_april_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 - April 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2019

11.78 KB
148 rows
8 columns


CREATE TABLE expenditure_over_25k_april_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 - April 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_april_2020

12.9 KB
195 rows
8 columns


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

Expenditure Over £25k - August 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2014

9.92 KB
95 rows
8 columns


CREATE TABLE expenditure_over_25k_august_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 - August 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2015

10.84 KB
132 rows
8 columns


CREATE TABLE expenditure_over_25k_august_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 - August 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2016

11.21 KB
139 rows
8 columns


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

Expenditure Over £25k - August 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2017

10.55 KB
116 rows
8 columns


CREATE TABLE expenditure_over_25k_august_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 - August 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2018

11.26 KB
144 rows
8 columns


CREATE TABLE expenditure_over_25k_august_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 - August 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2020

15.63 KB
134 rows
10 columns


CREATE TABLE expenditure_over_25k_august_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 - August 2021

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_august_2021

16.09 KB
131 rows
10 columns


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

Expenditure Over £25k - December 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december_2014

10.78 KB
114 rows
8 columns


CREATE TABLE expenditure_over_25k_december_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 - December 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december_2015

10.54 KB
111 rows
8 columns


CREATE TABLE expenditure_over_25k_december_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 - December 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december_2016

10.24 KB
95 rows
8 columns


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

Expenditure Over £25k - December 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december_2017

10.17 KB
101 rows
8 columns


CREATE TABLE expenditure_over_25k_december_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 - December 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december_2018

10.41 KB
111 rows
8 columns


CREATE TABLE expenditure_over_25k_december_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 - December2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_december2019

10.8 KB
118 rows
8 columns


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

Expenditure Over £25k - February 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2014

9.86 KB
89 rows
8 columns


CREATE TABLE expenditure_over_25k_february_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 - February 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2015

10.65 KB
110 rows
8 columns


CREATE TABLE expenditure_over_25k_february_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 - February 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2016

10.27 KB
117 rows
8 columns


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

Spend Over £25,000 In Plymouth Hospitals NHS Trust

About this Dataset