Valuation Office Agency - Monthly Spend Exceeding £25,000
Valuation Office Agency
@ukgov.voa_spending_over_25000
Valuation Office Agency
@ukgov.voa_spending_over_25000
CREATE TABLE voa_spending_data_over_25000_may_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_november_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_november_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_november_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_october_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_october_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_october_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_september_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_september_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_september_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
Anyone who has the link will be able to view this.