Https://www.uhcw.nhs.uk/download/clientfiles/files/Government%20Transparency%20Data%20Dec%202017.csv
University Hospitals Coventry and Warwickshire NHS Trust
@ukgov.https_www_uhcw_nhs_uk_download_clientfiles_files_gover_da62cb8c
University Hospitals Coventry and Warwickshire NHS Trust
@ukgov.https_www_uhcw_nhs_uk_download_clientfiles_files_gover_da62cb8c
CREATE TABLE n_2017_dec (
"dept_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE
);
CREATE TABLE n_2018_jan (
"dept_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE
);
Anyone who has the link will be able to view this.