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	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	T I S LIMITED	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-4228.94	MINOR BUILDING WORKS	V001572935
ROCHDALE BOROUGH COUNCIL	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	T I S LIMITED	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2840.94	MINOR BUILDING WORKS	V001572937
ROCHDALE BOROUGH COUNCIL	Fri Aug 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	SPIN PRINT SOLUTIONS	Fri Aug 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	53	MINOR BUILDING WORKS	V001583436
ROCHDALE BOROUGH COUNCIL	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	T I S LIMITED	Wed Aug 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	83.8	MINOR BUILDING WORKS	V001586011
ROCHDALE BOROUGH COUNCIL	Tue Aug 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	BANNER GROUP LIMITED	Tue Aug 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3.68	PRINTING & STATIONERY	V001586364
ROCHDALE BOROUGH COUNCIL	Tue Aug 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	BANNER GROUP LIMITED	Tue Aug 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2.16	PRINTING & STATIONERY	V001586364
ROCHDALE BOROUGH COUNCIL	Fri Aug 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	SAICA NATUR UK LTD	Fri Aug 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40	IT EQUIPMENT	V001588023
ROCHDALE BOROUGH COUNCIL	Fri Aug 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	SAICA NATUR UK LTD	Fri Aug 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5	IT EQUIPMENT	V001588023
ROCHDALE BOROUGH COUNCIL	Mon Aug 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	XMA LIMITED	Mon Aug 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4893.44	MINOR BUILDING WORKS	V001593236
ROCHDALE BOROUGH COUNCIL	Mon Aug 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Mon Aug 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2137.08	DIRECT PAYMENTS	V001593573


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