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 Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	OFFICE SUPPLIES NOW LTD	Mon Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	89	FURNITURE - GENERAL	V001528655
ROCHDALE BOROUGH COUNCIL	Fri Dec 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Fri Dec 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12.66	CLEANING EQUIPMENT	V001553646
ROCHDALE BOROUGH COUNCIL	Mon Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PATTERSONS BRISTOL LTD	Mon Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	101.5	CLEANING MATERIALS	V001594809
ROCHDALE BOROUGH COUNCIL	Mon Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PATTERSONS BRISTOL LTD	Mon Dec 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	142.13	CLEANING MATERIALS	V001594809
ROCHDALE BOROUGH COUNCIL	Tue Dec 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHRED STATION	Tue Dec 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	223.3	CONTRACTS	V001602648
ROCHDALE BOROUGH COUNCIL	Thu Dec 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	UNITY PARTNERSHIP LTD	Thu Dec 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4075.6	MINOR BUILDING WORKS	V001602698
ROCHDALE BOROUGH COUNCIL	Tue Dec 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Tue Dec 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40.84	CLEANING EQUIPMENT	V001612758
ROCHDALE BOROUGH COUNCIL	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ALLIANCE DISPOSABLES LIMITED	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	81	CLEANING EQUIPMENT	V001612974
ROCHDALE BOROUGH COUNCIL	Tue Dec 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Tue Dec 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	35.46	CLEANING EQUIPMENT	V001613299
ROCHDALE BOROUGH COUNCIL	Wed Dec 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Wed Dec 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	36.1	CLEANING EQUIPMENT	V001613300


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