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	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	CRESTA WORLD TRAVEL LIMITED	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	30	STAFF TRAVELLING EXPENSES	V001766506
ROCHDALE BOROUGH COUNCIL	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	UPS BUILDING AND MAINTENANCE LTD	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	5416.14	MINOR BUILDING WORKS	V001768606
ROCHDALE BOROUGH COUNCIL	Wed Feb 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TSOM GROUP	Wed Feb 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2640	ACTIVITIES	V001770984
ROCHDALE BOROUGH COUNCIL	Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CFS CARE LTD	Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	608.9	FOSTER PARENTS BASIC ALLOWANCE	V001778215
ROCHDALE BOROUGH COUNCIL	Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CFS CARE LTD	Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1013.35	FOSTER PARENTS BASIC ALLOWANCE	V001778217
ROCHDALE BOROUGH COUNCIL	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16.49	TRAVELLING GENERAL EXPENSES	V001778283
ROCHDALE BOROUGH COUNCIL	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	PHS GROUP PLC	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	32.4	PROVISIONS	V001779166
ROCHDALE BOROUGH COUNCIL	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	MILLENNIUM TRANSLATIONS LTD	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	36	ALLOWANCES	V001781121
ROCHDALE BOROUGH COUNCIL	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CICELEY COMMERCIALS LIMITED	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	364	VEHICLE MAINTENANCE	V001781150
ROCHDALE BOROUGH COUNCIL	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CICELEY COMMERCIALS LIMITED	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	39.42	VEHICLE MAINTENANCE	V001781155


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