Expenditure Over £25k - February 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_february_2017

11.32 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.93 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.98 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.8 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

10.22 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.33 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.95 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.38 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

11.02 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.81 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

17.05 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

10.18 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.63 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.86 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.33 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.72 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.75 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.34 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.6 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.61 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.78 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.47 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

11.04 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.62 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.63 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