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_april_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE valuation_office_agency_monthly_spend_exceeding_25_000 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR
);
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_january_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_february_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_february_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_july_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_may_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_january_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_april_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_april_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_january_2021 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_march_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_july_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" DOUBLE
);
CREATE TABLE voa_spending_data_over_25000_june_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_august_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"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_march_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_august_2019 (
"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_september_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_may_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_december_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_august_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"transaction" DOUBLE
);
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_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_december_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
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_june_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_june_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_july_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);
CREATE TABLE voa_spending_data_over_25000_december_2018 (
"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_november_2018 (
"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.