Spend Over £25,000 In DCMS: Tate
Tate
@ukgov.financial_transactions_data_dcms_tate
Tate
@ukgov.financial_transactions_data_dcms_tate
CREATE TABLE n_2019_february (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"trans_no" DOUBLE,
"amount" DOUBLE
);
CREATE TABLE n_2019_january (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"trans_no" DOUBLE,
"amount" DOUBLE
);
CREATE TABLE n_2019_march (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"trans_no" DOUBLE,
"amount" DOUBLE
);
CREATE TABLE spend_over_25_000_in_dcms_tate (
"department_family" VARCHAR,
"entity_t" VARCHAR,
"date" TIMESTAMP,
"expense_type_t" VARCHAR,
"expense_area_t" VARCHAR,
"supplier_t" VARCHAR,
"transaction_no" BIGINT,
"amount" DOUBLE
);
Anyone who has the link will be able to view this.