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_april_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_april_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_april_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_april_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_august_2018 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_august_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_august_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_august_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_december_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_december_2019 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE expenditure_over_500_december_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_february_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_february_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_january_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_january_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_january_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_july_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_july_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_july_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_july_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_june_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_june_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_june_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_june_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_march_2018 (
"merchant_category" VARCHAR,
"supplier_name" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"net_amount" DOUBLE
);Anyone who has the link will be able to view this.