Expenditure Over £25k - February 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2017

11.05 KB
136 rows
8 columns


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

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2018

10.67 KB
118 rows
8 columns


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

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2019

10.73 KB
119 rows
8 columns


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

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2020

10.55 KB
117 rows
8 columns


CREATE TABLE expenditure_over_25k_february_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 - January 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2014

9.98 KB
77 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2015

10.09 KB
91 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2016

10.69 KB
107 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2017

11.11 KB
128 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2018

10.76 KB
109 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2020

11.54 KB
139 rows
8 columns


CREATE TABLE expenditure_over_25k_january_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 - January 2021

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_january_2021

16.65 KB
162 rows
10 columns


CREATE TABLE expenditure_over_25k_january_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 - July 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2014

9.94 KB
84 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - July 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2015

10.38 KB
101 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - July 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2016

10.6 KB
128 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - July 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2017

10.09 KB
100 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - July 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2018

10.47 KB
101 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - July 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_july_2019

11.47 KB
134 rows
8 columns


CREATE TABLE expenditure_over_25k_july_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 - June 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2014

10.09 KB
90 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 - June 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2015

11.33 KB
124 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 - June 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2016

10.36 KB
97 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 - June 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2017

10.52 KB
120 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 - June 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2018

10.23 KB
105 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 - June 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_june_2019

10.79 KB
115 rows
8 columns


CREATE TABLE expenditure_over_25k_june_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 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2014

11.35 KB
122 rows
8 columns


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

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2015

12.34 KB
165 rows
8 columns


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