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 Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	GOOD SHEPHERD	Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	100	ROOM HIRE	V001436821
ROCHDALE BOROUGH COUNCIL	Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	GOOD SHEPHERD	Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	100	ROOM HIRE	V001440526
ROCHDALE BOROUGH COUNCIL	Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POLLOCK LIFTS	Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	15534.18	TRANSACTIONS-EXPENDITURE	V001470459
ROCHDALE BOROUGH COUNCIL	Tue Mar 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TEACRATE RENTALS LTD	Tue Mar 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	420	EQUIPMENT - GENERAL	V001476964
ROCHDALE BOROUGH COUNCIL	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	PENNINE CARE NHS	Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1240.74	A & C - BASIC SALARIES	V001480061
ROCHDALE BOROUGH COUNCIL	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PHS GROUP PLC	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	60	EQUIPMENT - GENERAL	V001482907
ROCHDALE BOROUGH COUNCIL	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	RPS CONSULTING SERVICES LTD	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45	MINOR BUILDING WORKS	V001483482
ROCHDALE BOROUGH COUNCIL	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	AECOM LIMITED	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	19815	MINOR BUILDING WORKS	V001495747
ROCHDALE BOROUGH COUNCIL	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	AECOM LIMITED	Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	418.3	MINOR BUILDING WORKS	V001495747
ROCHDALE BOROUGH COUNCIL	Tue Mar 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BANNER GROUP LIMITED	Tue Mar 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-8.04	PRINTING & STATIONERY	V001500852


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