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_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.