Apr 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.apr_2020

12.84 KB
161 rows
9 columns


CREATE TABLE apr_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Apr 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.apr_2021

13.75 KB
230 rows
9 columns


CREATE TABLE apr_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

April 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.april_2018

11.46 KB
136 rows
9 columns


CREATE TABLE april_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Aug 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.aug_2020

10.9 KB
99 rows
9 columns


CREATE TABLE aug_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Aug 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.aug_2021

11.64 KB
111 rows
9 columns


CREATE TABLE aug_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

August 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.august_2018

10.62 KB
176 rows
9 columns


CREATE TABLE august_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Dec 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.dec_2020

11.46 KB
130 rows
9 columns


CREATE TABLE dec_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Dec 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.dec_2021

11.84 KB
143 rows
9 columns


CREATE TABLE dec_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

December 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.december_2018

11.82 KB
71 rows
12 columns


CREATE TABLE december_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);

Feb 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.feb_2020

10.68 KB
88 rows
9 columns


CREATE TABLE feb_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Feb 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.feb_2021

11.53 KB
129 rows
9 columns


CREATE TABLE feb_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jan 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jan_2021

11.17 KB
122 rows
9 columns


CREATE TABLE jan_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jan 2022

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jan_2022

13.22 KB
185 rows
9 columns


CREATE TABLE jan_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jul 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jul_2020

10.79 KB
94 rows
9 columns


CREATE TABLE jul_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jul 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jul_2021

12.13 KB
135 rows
9 columns


CREATE TABLE jul_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

July 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.july_2018

10.23 KB
91 rows
9 columns


CREATE TABLE july_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jun 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jun_2020

11.45 KB
103 rows
9 columns


CREATE TABLE jun_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Jun 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.jun_2021

13.24 KB
211 rows
9 columns


CREATE TABLE jun_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

June 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.june_2018

11.02 KB
119 rows
9 columns


CREATE TABLE june_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Mar 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.mar_2020

13.2 KB
231 rows
9 columns


CREATE TABLE mar_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "n__line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Mar 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.mar_2021

15.25 KB
304 rows
9 columns


CREATE TABLE mar_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

March 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.march_2018

11.24 KB
131 rows
9 columns


CREATE TABLE march_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

May 2018

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.may_2018

11.44 KB
149 rows
9 columns


CREATE TABLE may_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

May 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.may_2020

11.63 KB
131 rows
9 columns


CREATE TABLE may_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" BIGINT,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

May 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.may_2021

11.81 KB
208 rows
9 columns


CREATE TABLE may_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "cleared_date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "reference" DOUBLE,
  "line_value" DOUBLE,
  "vat_reg_no" VARCHAR
);

Spend Over £25000 In Maidstone And Tunbridge Wells NHS Trust

About this Dataset