Expenditure Over 500
Manchester City Council
@ukgov.expenditure_over_500
Manchester City Council
@ukgov.expenditure_over_500
CREATE TABLE expenditure_exceeding_over_500_october_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_march_2025 (
"body_name" VARCHAR,
"business_area_and_description" BIGINT,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_over_500_april_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" DOUBLE,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_over_500_june_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_over_500_july_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_august_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_september_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_february_2025 (
"body_name" VARCHAR,
"business_area_and_description" BIGINT,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_november_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_december_2024 (
"body_name" VARCHAR,
"business_area_and_description" DOUBLE,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_over_500_may_2024 (
"body_name" VARCHAR,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE expenditure_exceeding_over_500_january_2025 (
"body_name" VARCHAR,
"business_area_and_description" BIGINT,
"service_area" VARCHAR,
"expenses_type" VARCHAR,
"invoice_payment_date" TIMESTAMP,
"transaction_number" BIGINT,
"supplier_name" VARCHAR,
"net_amount" VARCHAR
);
Anyone who has the link will be able to view this.