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 Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HSS HIRE SERVICE GROUP LIMITED	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	-220	EQUIPMENT - GENERAL	V001263783
ROCHDALE BOROUGH COUNCIL	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HSS HIRE SERVICE GROUP LIMITED	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	-110	EQUIPMENT - GENERAL	V001263784
ROCHDALE BOROUGH COUNCIL	Fri Dec 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	DEMCO EUROPE LIMITED	Fri Dec 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	59.45	EQUIPMENT - GENERAL	V001277182
ROCHDALE BOROUGH COUNCIL	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HSS HIRE SERVICE GROUP LIMITED	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	-11	EQUIPMENT - GENERAL	V001278164
ROCHDALE BOROUGH COUNCIL	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	488.62	CLOTHES, UNIFORM AND LAUNDRY	V001282566
ROCHDALE BOROUGH COUNCIL	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	37.08	CLOTHES, UNIFORM AND LAUNDRY	V001282567
ROCHDALE BOROUGH COUNCIL	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	64.14	CLOTHES, UNIFORM AND LAUNDRY	V001282568
ROCHDALE BOROUGH COUNCIL	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Mon Dec 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	86.88	CLOTHES, UNIFORM AND LAUNDRY	V001285351
ROCHDALE BOROUGH COUNCIL	Fri Dec 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	COMPASS MINERALS UK LIMITED	Fri Dec 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1320.4	MAINTENANCE	V001290756
ROCHDALE BOROUGH COUNCIL	Mon Dec 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	RIPON FARM SERVICES	Mon Dec 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	35.59	VEHICLE MAINTENANCE	V001298432


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