Rushmoor £250 Spend
Rushmoor Borough Council
@ukgov.rushmoor_250_spend
Rushmoor Borough Council
@ukgov.rushmoor_250_spend
Spend by Rushmoor Borough Council over £250, as specified in the Transparency Code 2014 NB: Before October 2014 Rushmoor published spend above £500, These datasets can be found here: http://data.gov.uk/dataset/rushmoor-500-spend All transactions include non-recoverable VAT. Where we made the payment to an individual or it is commercially sensitive, we have removed the names of suppliers and replaced them with either "Redacted personal data" or "Redacted commercially sensitive". The Data currently follows our own schema - future releases will be migrated to the LGA recommended schema when possible.
Publisher name: Rushmoor Borough Council
Last updated: 2025-01-26T04:02:43Z
CREATE TABLE rushmoor_250_spend_june_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_june_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" VARCHAR -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_june_2021 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" DOUBLE,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2015 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2016 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2017 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2018 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2021 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_march_2022 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2015 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2016 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2017 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2018 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" DOUBLE,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" DOUBLE,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" VARCHAR -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_may_2021 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2015 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2017 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2018 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" DOUBLE,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_november_2021 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);CREATE TABLE rushmoor_250_spend_october_2015 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" DOUBLE,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" DOUBLE -- Transaction No.,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);Anyone who has the link will be able to view this.