Expenditure Over £500
Stockport Metropolitan Borough Council
@ukgov.stockport_council_expenditure_over_500
Stockport Metropolitan Borough Council
@ukgov.stockport_council_expenditure_over_500
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
);
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.