Council Spending
Rochdale Borough Council
@ukgov.council_spending_over_500
Rochdale Borough Council
@ukgov.council_spending_over_500
CREATE TABLE table_122 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_123 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_124 (
"invoice_date" TIMESTAMP,
"supplier_name" VARCHAR,
"proclass_category" VARCHAR,
"service_area" VARCHAR,
"cost_centre_name" VARCHAR,
"invoiced" VARCHAR
);
CREATE TABLE table_125 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_126 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_127 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"service" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" VARCHAR,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_id" VARCHAR
);
CREATE TABLE table_128 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_129 (
"invoice_date" TIMESTAMP,
"supplier_name" VARCHAR,
"proclass_category" VARCHAR,
"service_area" VARCHAR,
"cost_centre_name" VARCHAR,
"invoiced" VARCHAR
);
CREATE TABLE table_13 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_130 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_131 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"service" VARCHAR,
"supplier_name" VARCHAR,
"paid_date" TIMESTAMP,
"net_amount" DOUBLE,
"purpose" VARCHAR,
"transaction_number" VARCHAR
);
CREATE TABLE table_132 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_133 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_134 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_135 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_136 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_137 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_138 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_14 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_15 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_16 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"service" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_17 (
"invoice_date" TIMESTAMP,
"supplier_name" VARCHAR,
"proclass_category" VARCHAR,
"service_area" VARCHAR,
"cost_centre_name" VARCHAR,
"invoiced" VARCHAR
);
CREATE TABLE table_18 (
"organisation_name" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_19 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
CREATE TABLE table_2 (
"organisation_name" VARCHAR,
"efefctive_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"date_paid" TIMESTAMP,
"amount" DOUBLE,
"purpose" VARCHAR,
"transaction_no" VARCHAR
);
Anyone who has the link will be able to view this.