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_february_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_february_2018 (
"capital_revenue" VARCHAR,
"cost_centre" VARCHAR,
"organisation" DOUBLE,
"transaction_no" VARCHAR -- Transaction No.,
"supplier_name" TIMESTAMP,
"expense_type" DOUBLE,
"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_february_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_february_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_february_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_february_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,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE rushmoor_250_spend_january_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_january_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_january_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_january_2018 (
"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_january_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_january_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_january_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_january_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_july_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
);CREATE TABLE rushmoor_250_spend_july_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_july_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_july_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_july_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_july_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_july_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_june_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
);CREATE TABLE rushmoor_250_spend_june_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_june_2017 (
"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_june_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
);Anyone who has the link will be able to view this.