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	Thu Sep 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	R & M ROOFING & BUILDING SUPPLIES LTD	Thu Sep 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	69.44	PROPERTY - WORKS ELEMENT	V001332925
ROCHDALE BOROUGH COUNCIL	Tue Sep 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	NISBETS PLC	Tue Sep 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	71.9	EQUIPMENT - GENERAL	V001343777
ROCHDALE BOROUGH COUNCIL	Mon Sep 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BARTEC AUTO ID LTD	Mon Sep 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5950	EQUIPMENT - GENERAL	V001383725
ROCHDALE BOROUGH COUNCIL	Tue Sep 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	DELMATIC LIGHTING MANAGEMENT	Tue Sep 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1336.2	SPECIFIED MAINTENANCE	V001404456
ROCHDALE BOROUGH COUNCIL	Thu Sep 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	AXIOM EDUCATION ROCHDALE LIMITED	Thu Sep 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-98497.49	PFI SCHEMES RPIX	V001413641
ROCHDALE BOROUGH COUNCIL	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	100	TRAINING	V001424917
ROCHDALE BOROUGH COUNCIL	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	RENRAY HEALTHCARE LTD	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	804.7	PURCHASE OF FURNITURE AND EQUIPMENT	V001425643
ROCHDALE BOROUGH COUNCIL	Wed Sep 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	BANNER GROUP LIMITED	Wed Sep 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	170.62	PRINTING & STATIONERY	V001425777
ROCHDALE BOROUGH COUNCIL	Wed Sep 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	PEARSON EDUCATION LIMITED	Wed Sep 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-376	EQUIPMENT - GENERAL	V001427372
ROCHDALE BOROUGH COUNCIL	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	CARTWHEEL ARTS	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	338	ACTIVITIES	V001427582


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