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	Mon Oct 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ROCHDALE TOWN CENTRE MANAGEMENT LTD	Mon Oct 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1225	MARKETING EXPENDITURE	V000974014
ROCHDALE BOROUGH COUNCIL	Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	REACH PUBLISHING SERVICES LTD	Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	58	ADVERTISING	V001448440
ROCHDALE BOROUGH COUNCIL	Wed Oct 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Wed Oct 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1.43	CLEANING MATERIALS	V001508610
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	32.19	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12.99	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3.24	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1.28	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1.28	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1.79	ARTS & CRAFTS	V001520225
ROCHDALE BOROUGH COUNCIL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	35.77	ARTS & CRAFTS	V001520225


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