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 over_500_spend_december_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_december_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_february_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_february_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_february_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_february_2025 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_january_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_january_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_january_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_january_2025 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_july_2022 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_july_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_july_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_june_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_june_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_june_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_march_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_march_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_march_2024 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"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,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95
);CREATE TABLE over_500_spend_march_2025 (
"merchant_category" VARCHAR,
"supplier" VARCHAR,
"service" VARCHAR,
"summary_of_purpose_of_expenditure" VARCHAR,
"invoice_date" TIMESTAMP,
"net_amount" DOUBLE
);CREATE TABLE over_500_spend_may_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_may_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_may_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_november_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_november_2023 (
"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.