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 n__250_spend_december_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 n__250_spend_november_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_april_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_april_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_april_2017 (
"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_april_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_april_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_april_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_april_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,
"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
);CREATE TABLE rushmoor_250_spend_april_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_august_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_august_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_august_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_august_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_august_2020 (
"capital_revenue" VARCHAR,
"cost_centre" VARCHAR,
"organisation" BIGINT,
"transaction_no" VARCHAR -- Transaction No.,
"supplier_name" TIMESTAMP,
"expense_type" BIGINT,
"unnamed_6" DOUBLE -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE rushmoor_250_spend_august_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_december_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_december_2017 (
"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_december_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,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE rushmoor_250_spend_december_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_december_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_december_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_december_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_february_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_february_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
);Anyone who has the link will be able to view this.