Council Spending

organisation_name ORGANISATION NAME	efefctive_date EFEFCTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION No.
ROCHDALE BOROUGH COUNCIL	Wed Sep 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	CODEBASE8 LTD	Wed Sep 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	SOFTWARE	V001651650
ROCHDALE BOROUGH COUNCIL	Tue Sep 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	MILLENNIUM TRANSLATIONS LTD	Tue Sep 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	53.3	TRANSLATION & INTERPRETATION	V001674616
ROCHDALE BOROUGH COUNCIL	Tue Sep 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	MILLENNIUM TRANSLATIONS LTD	Tue Sep 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	53.3	TRANSLATION & INTERPRETATION	V001676616
ROCHDALE BOROUGH COUNCIL	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	INTEGRATED SKILLS LIMITED	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9945	SOFTWARE	V001694965
ROCHDALE BOROUGH COUNCIL	Wed Sep 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HOPWOOD HALL COLLEGE	Wed Sep 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	199	ROOM HIRE	V001695033
ROCHDALE BOROUGH COUNCIL	Tue Sep 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	QUALSAFE LIMITED	Tue Sep 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	154	REPAIRS & ALTS OF BUILDINGS	V001704718
ROCHDALE BOROUGH COUNCIL	Thu Sep 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	COMPLIANCE365	Thu Sep 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	400	PROPERTY - WORKS ELEMENT	V001709924
ROCHDALE BOROUGH COUNCIL	Thu Sep 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	ROTA ROD LIMITED	Thu Sep 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2500	SPECIFIED MAINTENANCE	V001722812
ROCHDALE BOROUGH COUNCIL	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	18.48	CLOTHES, UNIFORM AND LAUNDRY	V001728030
ROCHDALE BOROUGH COUNCIL	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	18.48	CLOTHES, UNIFORM AND LAUNDRY	V001728030


CREATE TABLE table_56 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);