Rushmoor £250 Spend
Rushmoor Borough Council
@ukgov.rushmoor_250_spend
Rushmoor Borough Council
@ukgov.rushmoor_250_spend
CREATE TABLE n__250_spend_december_2016 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR
);
CREATE TABLE rushmoor_250_spend_april_2022 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"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,
"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,
"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,
"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,
"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,
"supplier_name" TIMESTAMP,
"expense_type" BIGINT,
"unnamed_6" DOUBLE,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE rushmoor_250_spend_august_2021 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"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,
"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,
"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,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR,
"unnamed_10" VARCHAR
);
CREATE TABLE rushmoor_250_spend_december_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"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,
"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,
"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,
"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,
"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,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);
Anyone who has the link will be able to view this.