Council Spending

organisation_name ORGANISATION NAME	effective_date EFFECTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION NO.
ROCHDALE BOROUGH COUNCIL	Fri Nov 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Fri Nov 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	8385.67	INDEPENDENT UNITS	V001395743
ROCHDALE BOROUGH COUNCIL	Fri Nov 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Fri Nov 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	85.99	CLOTHES, UNIFORM AND LAUNDRY	V001437877
ROCHDALE BOROUGH COUNCIL	Thu Nov 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TRAVIS PERKINS TRADING CO LTD	Thu Nov 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-52.43	EQUIPMENT - GENERAL	V001440016
ROCHDALE BOROUGH COUNCIL	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	VESTACARE UK LTD	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	768	PERSONAL BUDGETS - MANAGED	V001441451
ROCHDALE BOROUGH COUNCIL	Fri Nov 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	BANNER GROUP LIMITED	Fri Nov 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	82.02	PRINTING & STATIONERY	V001449461
ROCHDALE BOROUGH COUNCIL	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	VESTACARE UK LTD	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	576	PERSONAL BUDGETS - MANAGED	V001452922
ROCHDALE BOROUGH COUNCIL	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	VESTACARE UK LTD	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	768	PERSONAL BUDGETS - MANAGED	V001452923
ROCHDALE BOROUGH COUNCIL	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	VESTACARE UK LTD	Fri Nov 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-576	PERSONAL BUDGETS - MANAGED	V001452924
ROCHDALE BOROUGH COUNCIL	Tue Nov 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FILMBANKMEDIA	Tue Nov 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	150	ACTIVITIES	V001458105
ROCHDALE BOROUGH COUNCIL	Tue Nov 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	LOCAL GOVERNMENT ASSOCIATION	Tue Nov 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	229	CONFERENCE	V001458746


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