Expenditure Over £25k - March 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2016

11.04 KB
129 rows
8 columns


CREATE TABLE expenditure_over_25k_march_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 - March 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2017

12.25 KB
175 rows
8 columns


CREATE TABLE expenditure_over_25k_march_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 - March 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2018

12.09 KB
163 rows
8 columns


CREATE TABLE expenditure_over_25k_march_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 - March 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2019

12.23 KB
171 rows
8 columns


CREATE TABLE expenditure_over_25k_march_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 - March 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2020

12.24 KB
179 rows
8 columns


CREATE TABLE expenditure_over_25k_march_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 - May 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2014

9.67 KB
84 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - May 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2015

9.83 KB
78 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - May 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2016

10.09 KB
97 rows
8 columns


CREATE TABLE expenditure_over_25k_may_2016 (
  "department_family" VARCHAR,
  "ledger_description" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

Expenditure Over £25k - May 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2017

10.47 KB
106 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - May 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2018

10.81 KB
123 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - May 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2019

10.54 KB
118 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - May 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2020

11.6 KB
143 rows
8 columns


CREATE TABLE expenditure_over_25k_may_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 - November 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2014

10.06 KB
96 rows
8 columns


CREATE TABLE expenditure_over_25k_november_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 - November 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2015

10.55 KB
111 rows
8 columns


CREATE TABLE expenditure_over_25k_november_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 - November 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2016

10.75 KB
120 rows
8 columns


CREATE TABLE expenditure_over_25k_november_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 - November 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2017

10.78 KB
123 rows
8 columns


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

Expenditure Over £25k - November 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2018

11.22 KB
135 rows
8 columns


CREATE TABLE expenditure_over_25k_november_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 - November 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2019

11.13 KB
121 rows
8 columns


CREATE TABLE expenditure_over_25k_november_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 - November 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2020

16.05 KB
136 rows
10 columns


CREATE TABLE expenditure_over_25k_november_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 - October 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2014

10.52 KB
107 rows
8 columns


CREATE TABLE expenditure_over_25k_october_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 - October 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2015

10.65 KB
129 rows
8 columns


CREATE TABLE expenditure_over_25k_october_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 - October 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2016

10.48 KB
101 rows
8 columns


CREATE TABLE expenditure_over_25k_october_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 - October 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2017

10.08 KB
111 rows
8 columns


CREATE TABLE expenditure_over_25k_october_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 - October 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2018

11 KB
140 rows
8 columns


CREATE TABLE expenditure_over_25k_october_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 - October 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2019

11.47 KB
125 rows
8 columns


CREATE TABLE expenditure_over_25k_october_2019 (
  "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