Expenditure Over £500
Stockport Metropolitan Borough Council
@ukgov.stockport_council_expenditure_over_500
Stockport Metropolitan Borough Council
@ukgov.stockport_council_expenditure_over_500
Payments over £500 made by Stockport Council. Whilst all transactions are published, certain pieces of personal information within those transactions will redacted, i.e. replaced with general terms, to provide protection under the Data Protection Act.
Publisher name: Stockport Metropolitan Borough Council
Last updated: 2025-04-10T04:00:20Z
CREATE TABLE expenditure_over_500_march_2019 (
"supplier" VARCHAR,
"merchant_category" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_march_2020 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_march_2021 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_may_2018 (
"merchant_category" VARCHAR,
"supplier_name" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_may_2019 (
"supplier" VARCHAR,
"merchant_category" VARCHAR,
"services_to_people" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_may_2020 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_may_2021 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_november_2018 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"n__net_amount" DOUBLE -- Net Amount
);CREATE TABLE expenditure_over_500_november_2019 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_november_2020 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_october_2018 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_october_2019 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_october_2020 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_october_2021 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_september_2018 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_september_2019 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_september_2020 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_september_2021 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_april_2022 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_april_2023 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_april_2024 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_august_2022 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_august_2023 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_august_2024 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_december_2022 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);Anyone who has the link will be able to view this.