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 Nov 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Wed Nov 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	55.62	TRANSLATION & INTERPRETATION	V001843585
ROCHDALE BOROUGH COUNCIL	Wed Nov 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Wed Nov 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	35	TRANSLATION & INTERPRETATION	V001873887
ROCHDALE BOROUGH COUNCIL	Tue Nov 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BANNER GROUP LIMITED	Tue Nov 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	53.89	EQUIPMENT - GENERAL	V001877581
ROCHDALE BOROUGH COUNCIL	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	XMA LIMITED	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	876.08	EQUIPMENT - GENERAL	V001891098
ROCHDALE BOROUGH COUNCIL	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	XMA LIMITED	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	219.02	EQUIPMENT - GENERAL	V001891098
ROCHDALE BOROUGH COUNCIL	Thu Nov 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EASY AVENUES LTD	Thu Nov 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	623.33	ACTIVITIES	V001914735
ROCHDALE BOROUGH COUNCIL	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	XMA LIMITED	Mon Nov 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	57.72	IT EQUIPMENT	V001915888
ROCHDALE BOROUGH COUNCIL	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	TUNSTALL HEALTHCARE (UK) LTD	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3747	PURCHASE OF FURNITURE AND EQUIPMENT	V001917326
ROCHDALE BOROUGH COUNCIL	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	TUNSTALL HEALTHCARE (UK) LTD	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1500	PURCHASE OF FURNITURE AND EQUIPMENT	V001917326
ROCHDALE BOROUGH COUNCIL	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	TUNSTALL HEALTHCARE (UK) LTD	Tue Nov 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	325	PURCHASE OF FURNITURE AND EQUIPMENT	V001917326


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