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 May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	338.31	SERVICE LEVEL AGREEMENTS	V001952596
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3825.3	SERVICE LEVEL AGREEMENTS	V001961546
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	12171.31	SERVICE LEVEL AGREEMENTS	V001963013
ROCHDALE BOROUGH COUNCIL	Mon May 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	XMA LIMITED	Mon May 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	131.68	IT EQUIPMENT	V001972979
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3952.81	SERVICE LEVEL AGREEMENTS	V001976641
ROCHDALE BOROUGH COUNCIL	Mon May 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PROSPERON NETWORKS LTD	Mon May 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4215	TRAINING	V002042948
ROCHDALE BOROUGH COUNCIL	Fri May 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	JONES LANG LASALLE LTD	Fri May 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-184.22	PROPERTY FEES ELEMENT	V002043467
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-1183.25	SERVICE LEVEL AGREEMENTS	V002046865
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-432	SERVICE LEVEL AGREEMENTS	V002048994
ROCHDALE BOROUGH COUNCIL	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	ELDERCARE UK LTD	Fri May 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-11967.76	SERVICE LEVEL AGREEMENTS	V002048997


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