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 Apr 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	AVK SEG UK LTD	Tue Apr 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	650	REPAIRS & ALTS OF BUILDINGS	V001448420
ROCHDALE BOROUGH COUNCIL	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-374.9	EQUIPMENT - GENERAL	V001497433
ROCHDALE BOROUGH COUNCIL	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	SALFORD ROYAL NHS FOUNDATION TRUST	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-416723	PH PENNINE CARE CONTRACT	V001516011
ROCHDALE BOROUGH COUNCIL	Wed Apr 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	THE PENNINE ACUTE HOSPITALS NHS TRUST	Wed Apr 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-33226	AGENCY STAFF	V001517537
ROCHDALE BOROUGH COUNCIL	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	NHS HEYWOOD MIDDLETON AND ROCHDALE CCG	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4216.46	AGENCY STAFF	V001518095
ROCHDALE BOROUGH COUNCIL	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REDACTED - PERSONAL DATA	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4447	MEDICAL FEES	V001518195
ROCHDALE BOROUGH COUNCIL	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REDACTED - PERSONAL DATA	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	683	MEDICAL FEES	V001518195
ROCHDALE BOROUGH COUNCIL	Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	NHS HEYWOOD MIDDLETON AND ROCHDALE CCG	Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4216.46	AGENCY STAFF	V001518240
ROCHDALE BOROUGH COUNCIL	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MANTRA LEARNING LTD	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-1075	TRAINING	V001518336
ROCHDALE BOROUGH COUNCIL	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MANTRA LEARNING LTD	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-210.45	TRAINING	V001518336


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