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	Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	INTEGRATED WATER SERVICES LIMITED	Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3466.85	PROPERTY - WORKS ELEMENT	V001430315
ROCHDALE BOROUGH COUNCIL	Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	INTEGRATED WATER SERVICES LIMITED	Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2509.8	PROPERTY - WORKS ELEMENT	V001430315
ROCHDALE BOROUGH COUNCIL	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-96.4	STAFF TRAVELLING EXPENSES	V001533937
ROCHDALE BOROUGH COUNCIL	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	HOWDENS JOINERY CO LIMITED	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-78.77	PROPERTY - WORKS ELEMENT	V001563715
ROCHDALE BOROUGH COUNCIL	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HOWDENS JOINERY CO LIMITED	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-213.74	REPAIRS & ALTS OF BUILDINGS	V001563718
ROCHDALE BOROUGH COUNCIL	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	HOWDENS JOINERY CO LIMITED	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5.52	PROPERTY - WORKS ELEMENT	V001563720
ROCHDALE BOROUGH COUNCIL	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HOWDENS JOINERY CO LIMITED	Wed Sep 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-67.2	REPAIRS & ALTS OF BUILDINGS	V001563750
ROCHDALE BOROUGH COUNCIL	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5	EXTERNAL HIRE	V001567689
ROCHDALE BOROUGH COUNCIL	Thu Sep 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MHR	Thu Sep 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	19089.55	SOFTWARE	V001568154
ROCHDALE BOROUGH COUNCIL	Thu Sep 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	MHR	Thu Sep 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3221.6	SOFTWARE	V001568155


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