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 Apr 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	UPS BUILDING AND MAINTENANCE LTD	Wed Apr 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2284.34	MINOR BUILDING WORKS	V001754608
ROCHDALE BOROUGH COUNCIL	Wed Apr 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	UPS BUILDING AND MAINTENANCE LTD	Wed Apr 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3246.5	MINOR BUILDING WORKS	V001754608
ROCHDALE BOROUGH COUNCIL	Wed Apr 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MEADOWS CARE LIMITED	Wed Apr 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6948.88	EBD (EMOT & BEHAV DIFF) PLACEMENTS	V001768429
ROCHDALE BOROUGH COUNCIL	Thu Apr 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Thu Apr 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	62224.19	INDEPENDENT UNITS	V001792823
ROCHDALE BOROUGH COUNCIL	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	28882	INDEPENDENT UNITS	V001792824
ROCHDALE BOROUGH COUNCIL	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4126	INDEPENDENT UNITS	V001792981
ROCHDALE BOROUGH COUNCIL	Thu Apr 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Thu Apr 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8889.17	INDEPENDENT UNITS	V001792985
ROCHDALE BOROUGH COUNCIL	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	HOWDENS JOINERY CO LIMITED	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-139.99	BUILDING MATERIALS	V001807050
ROCHDALE BOROUGH COUNCIL	Mon Apr 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BANNER GROUP LIMITED	Mon Apr 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	7.1	PRINTING & STATIONERY	V001807115
ROCHDALE BOROUGH COUNCIL	Mon Apr 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Mon Apr 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	30	PUBLIC TRANSPORT	V001809948


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