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	Fri Jul 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LEARNING DIS & MENTAL HEALTH	CREATIVE SUPPORT LTD	Fri Jul 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	840.48	PERSONAL BUDGETS - MANAGED	V001202782
ROCHDALE BOROUGH COUNCIL	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13.86	CONSUMABLES	V001678246
ROCHDALE BOROUGH COUNCIL	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8.95	CLEANING MATERIALS	V001678246
ROCHDALE BOROUGH COUNCIL	Mon Jul 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	XMA LIMITED	Mon Jul 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	346.42	PURCHASE OF ICT HARDWARE	V001678468
ROCHDALE BOROUGH COUNCIL	Wed Jul 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Wed Jul 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	89.95	EQUIPMENT - GENERAL	V001690195
ROCHDALE BOROUGH COUNCIL	Tue Jul 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	YORKSHIRE PURCHASING ORGANISATION	Tue Jul 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	56.97	ACTIVITIES	V001690496
ROCHDALE BOROUGH COUNCIL	Wed Jul 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	INTEGRATED SKILLS LIMITED	Wed Jul 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8415	SOFTWARE	V001694966
ROCHDALE BOROUGH COUNCIL	Fri Jul 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	SPECIALIST COMPUTER CENTRES PLC	Fri Jul 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1062.7	IT EQUIPMENT	V001695195
ROCHDALE BOROUGH COUNCIL	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REACH PUBLISHING SERVICES LTD	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	111.47	PROFESSIONAL FEES	V001699113
ROCHDALE BOROUGH COUNCIL	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EXCLUSEC	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	275	SECURITY	V001700736


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