Apr 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.apr_2020

13.15 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

14.08 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.74 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

11.16 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.92 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.88 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.73 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

12.13 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

12.11 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: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Feb 2020

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.feb_2020

10.94 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.8 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.43 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.54 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

11.05 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.42 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.48 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.72 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.55 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.29 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.51 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  -- Line Value,
  "vat_reg_no" VARCHAR
);

Mar 2021

@ukgov.financial_transactions_data_maidstone_tunbridge_wells_nhs_trust.mar_2021

15.61 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.51 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.72 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.9 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

12.09 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