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_october_2016 (
"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_october_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_october_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_october_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_october_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_october_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_december_2014 (
"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_september_2015 (
"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_september_2016 (
"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_september_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_september_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_september_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_september_2020 (
"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_september_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
);Anyone who has the link will be able to view this.