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 Feb 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ROCHDALE TOWN CENTRE MANAGEMENT LTD	Mon Feb 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	50	EXPENSES - GENERAL	V001271380
ROCHDALE BOROUGH COUNCIL	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	UK TELEMATICS LTD	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5946.45	EQUIPMENT - GENERAL	V001302570
ROCHDALE BOROUGH COUNCIL	Mon Feb 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TFG STAGE TECHNOLOGY LTD	Mon Feb 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	220	EXPENSES - GENERAL	V001303575
ROCHDALE BOROUGH COUNCIL	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	UK TELEMATICS LTD	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-89.99	EQUIPMENT - GENERAL	V001307669
ROCHDALE BOROUGH COUNCIL	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	UK TELEMATICS LTD	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	919.93	EQUIPMENT - GENERAL	V001311994
ROCHDALE BOROUGH COUNCIL	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	UK TELEMATICS LTD	Thu Feb 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	89.99	EQUIPMENT - GENERAL	V001311994
ROCHDALE BOROUGH COUNCIL	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	40	TRAINING	V001318287
ROCHDALE BOROUGH COUNCIL	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	40	TRAINING	V001318288
ROCHDALE BOROUGH COUNCIL	Thu Feb 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	NISBETS PLC	Thu Feb 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	30.58	HEALTH AND SAFETY	V001318962
ROCHDALE BOROUGH COUNCIL	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE UNIVERSITY OF MANCHESTER	Thu Feb 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	200	TRAINING	V001319868


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