Council Spending
Rochdale Borough Council
@ukgov.council_spending_over_500
Rochdale Borough Council
@ukgov.council_spending_over_500
CREATE TABLE table_90 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_91 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_92 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_94 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" VARCHAR,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_95 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"service" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"net_amount" DOUBLE,
"purpose" VARCHAR,
"transaction_number" VARCHAR
);
CREATE TABLE table_97 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_98 (
"invoice_date" TIMESTAMP,
"supplier_name" VARCHAR,
"proclass_category" VARCHAR,
"service_area" VARCHAR,
"cost_centre_name" VARCHAR,
"invoiced" VARCHAR
);
CREATE TABLE table_99 (
"organisation" VARCHAR,
"invoice_date" TIMESTAMP,
"supplier_name" VARCHAR,
"proclass_category" VARCHAR,
"service_area" VARCHAR,
"cost_centre_name" VARCHAR,
"invoiced" VARCHAR
);
Anyone who has the link will be able to view this.