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 Nov 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	ADT FIRE & SECURITY PLC	Tue Nov 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	57.37	SECURITY	V001668636
ROCHDALE BOROUGH COUNCIL	Thu Nov 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	NATRE	Thu Nov 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	110	SUBSCRIPTIONS	V001703738
ROCHDALE BOROUGH COUNCIL	Wed Nov 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MANCHESTER UNIVERSITY NHS FOUNDATION TRUST MFT	Wed Nov 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-1268.46	CHILDRENS POST MORTEMS	V001725004
ROCHDALE BOROUGH COUNCIL	Wed Nov 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MANCHESTER UNIVERSITY NHS FOUNDATION TRUST MFT	Wed Nov 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	109	CHILDRENS POST MORTEMS	V001726912
ROCHDALE BOROUGH COUNCIL	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1200	TRAINING	V001728368
ROCHDALE BOROUGH COUNCIL	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1200	TRAINING	V001728368
ROCHDALE BOROUGH COUNCIL	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-3800	TRAINING	V001728813
ROCHDALE BOROUGH COUNCIL	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Mon Nov 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-3800	TRAINING	V001728813
ROCHDALE BOROUGH COUNCIL	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	124.88	HYGIENE EQUIPMENT	V001730999
ROCHDALE BOROUGH COUNCIL	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	645.17	HYGIENE EQUIPMENT	V001731005


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