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	Tue Feb 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	PEARSON EDUCATION LIMITED	Tue Feb 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-184.2	EQUIPMENT - GENERAL	V001551696
ROCHDALE BOROUGH COUNCIL	Tue Feb 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	PEARSON EDUCATION LIMITED	Tue Feb 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-155.8	EQUIPMENT - GENERAL	V001551696
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1206	SELF - FUNDING DEFERRED PAYMENTS	V001559463
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1206	SELF - FUNDING DEFERRED PAYMENTS	V001564578
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1206	SELF - FUNDING DEFERRED PAYMENTS	V001568722
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1206	SELF - FUNDING DEFERRED PAYMENTS	V001575047
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1206	SELF - FUNDING DEFERRED PAYMENTS	V001579031
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	48	SELF - FUNDING DEFERRED PAYMENTS	V001584818
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	48	SELF - FUNDING DEFERRED PAYMENTS	V001584819
ROCHDALE BOROUGH COUNCIL	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	MARIPOSA CARE GROUP LTD	Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	48	SELF - FUNDING DEFERRED PAYMENTS	V001584820


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