Council Spending

organisation_name ORGANISATION NAME	effective_date EFFECTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION NO.
ROCHDALE BOROUGH COUNCIL	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MWUK LTD	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	81.81	EQUIPMENT - GENERAL	V001224727
ROCHDALE BOROUGH COUNCIL	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MWUK LTD	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	54.54	EQUIPMENT - GENERAL	V001224728
ROCHDALE BOROUGH COUNCIL	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MWUK LTD	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	136.35	EQUIPMENT - GENERAL	V001224730
ROCHDALE BOROUGH COUNCIL	Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SAFEGARD SOLUTIONS LTD	Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	115	SECURITY	V001332147
ROCHDALE BOROUGH COUNCIL	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	AQUACOOL LTD	Mon Apr 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	26	EXPENSES - GENERAL	V001333287
ROCHDALE BOROUGH COUNCIL	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	SWIFT SECURITY PRODUCTS LTD	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	60	SECURITY	V001335089
ROCHDALE BOROUGH COUNCIL	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	SWIFT SECURITY PRODUCTS LTD	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	35	SECURITY	V001335090
ROCHDALE BOROUGH COUNCIL	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	SWIFT SECURITY PRODUCTS LTD	Tue Apr 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	120	SECURITY	V001335091
ROCHDALE BOROUGH COUNCIL	Thu Apr 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SAFEGARD SOLUTIONS LTD	Thu Apr 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	127.92	REPAIRS & ALTS OF BUILDINGS	V001338169
ROCHDALE BOROUGH COUNCIL	Mon Apr 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	GMCA	Mon Apr 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	366	MINOR BUILDING WORKS	V001343569


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