Valuation Office Agency - Monthly Spend Exceeding £25,000
Valuation Office Agency
@ukgov.voa_spending_over_25000
Valuation Office Agency
@ukgov.voa_spending_over_25000
As part of the Government’s Transparency Agenda, the Valuation Office Agency is publishing a profile of the items it spends its budget on which exceed £25,000 in value.
Publisher name: Valuation Office Agency
Last updated: 2022-07-01T04:02:35Z
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: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21
);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_april_2019 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" BIGINT
);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 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_august_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_december_2018 (
"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_december_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_february_2020 (
"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_january_2020 (
"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_july_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" VARCHAR,
"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_july_2020 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"transaction" DOUBLE
);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_june_2019 (
"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_march_2019 (
"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_may_2018 (
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"amount" DOUBLE,
"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
);Anyone who has the link will be able to view this.