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	Thu Jun 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVOLUTION AUTOMATIC DOORS LTD	Thu Jun 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	130	ELECTRICAL	V001673377
ROCHDALE BOROUGH COUNCIL	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TASC LTD	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	480	TRAINING	V001678974
ROCHDALE BOROUGH COUNCIL	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TASC LTD	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-432.15	TRAINING	V001679328
ROCHDALE BOROUGH COUNCIL	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TASC LTD	Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2475	TRAINING-QUALIFICATION	V001679679
ROCHDALE BOROUGH COUNCIL	Mon Jun 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BANNER GROUP LIMITED	Mon Jun 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	38.02	PRINTING & STATIONERY	V001679698
ROCHDALE BOROUGH COUNCIL	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	YORKSHIRE PURCHASING ORGANISATION	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	305.32	EQUIPMENT - GENERAL	V001679699
ROCHDALE BOROUGH COUNCIL	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	YORKSHIRE PURCHASING ORGANISATION	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	64.95	EQUIPMENT - GENERAL	V001679699
ROCHDALE BOROUGH COUNCIL	Mon Jun 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	BEYOND PSYCHOLOGY LTD	Mon Jun 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	760	FEES / COMMISSION	V001683061
ROCHDALE BOROUGH COUNCIL	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CARRICK SIGNS LTD	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	205	PRINTING	V001683283
ROCHDALE BOROUGH COUNCIL	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CARRICK SIGNS LTD	Mon Jun 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	90	PRINTING	V001683283


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