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	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	XMA LIMITED	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-96.55	IT EQUIPMENT	V002049078
ROCHDALE BOROUGH COUNCIL	Tue Nov 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	WATER PLUS	Tue Nov 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-402.17	EQUIPMENT - GENERAL	V002092385
ROCHDALE BOROUGH COUNCIL	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ASSOCIATED CLEANING CONTRACTORS	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	55	WINDOW CLEANING AND EQUIPMENT	V002137216
ROCHDALE BOROUGH COUNCIL	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	TF JONES PROPERTY SERVICES LTD	Tue Nov 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	5457.42	MINOR BUILDING WORKS	V002141861
ROCHDALE BOROUGH COUNCIL	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	ROCHDALE TOWN TAXIS LTD	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	205.8	TAXI HIRE	V002145372
ROCHDALE BOROUGH COUNCIL	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	ROCHDALE TOWN TAXIS LTD	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	205.8	TAXI HIRE	V002145372
ROCHDALE BOROUGH COUNCIL	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	ROCHDALE TOWN TAXIS LTD	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	205.8	TAXI HIRE	V002145372
ROCHDALE BOROUGH COUNCIL	Mon Nov 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	STANNAH LIFT SERVICES LTD	Mon Nov 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	7186	MINOR BUILDING WORKS	V002153451
ROCHDALE BOROUGH COUNCIL	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	P CASEY LAND RECLAMATION LTD	Thu Nov 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	448	HIRE OF EQUIPMENT	V002160467
ROCHDALE BOROUGH COUNCIL	Wed Nov 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	PATTERSONS BRISTOL LTD	Wed Nov 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	17.4	CONSUMABLES	V002164801


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
);