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 Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	COMMISSIONING AND STATUTORY	UNIQUE ENTERPRISE CENTRE	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	165	ROOM HIRE	V002049104
ROCHDALE BOROUGH COUNCIL	Fri Jun 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	CUTGATE BAPTIST CHURCH	Fri Jun 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	200	ROOM HIRE	V002079260
ROCHDALE BOROUGH COUNCIL	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CHILD ACTION NORTHWEST	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	206.74	SERVICE LEVEL AGREEMENTS	V002120856
ROCHDALE BOROUGH COUNCIL	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CHILD ACTION NORTHWEST	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	206.74	SERVICE LEVEL AGREEMENTS	V002120856
ROCHDALE BOROUGH COUNCIL	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CHILD ACTION NORTHWEST	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	141.45	SERVICE LEVEL AGREEMENTS	V002120856
ROCHDALE BOROUGH COUNCIL	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CHILD ACTION NORTHWEST	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	402.59	SERVICE LEVEL AGREEMENTS	V002120856
ROCHDALE BOROUGH COUNCIL	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CHILD ACTION NORTHWEST	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	130.57	SERVICE LEVEL AGREEMENTS	V002120856
ROCHDALE BOROUGH COUNCIL	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	SPECSAVERS OPTICIANS	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	25	EYE TESTS VDU USERS	V002124197
ROCHDALE BOROUGH COUNCIL	Fri Jun 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	POSSABILITIES CIC TRADING	Fri Jun 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-420	HOME CARE - CHILDRENS SERVICES	V002125990
ROCHDALE BOROUGH COUNCIL	Thu Jun 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	MIDDLETON CARS	Thu Jun 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	330	TAXI HIRE	V002137430


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