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 Jun 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MWUK LTD	Mon Jun 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	394.5	EQUIPMENT - GENERAL	V001116183
ROCHDALE BOROUGH COUNCIL	Mon Jun 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MWUK LTD	Mon Jun 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	373.5	EQUIPMENT - GENERAL	V001116203
ROCHDALE BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	ACCESS DOOR SYSTEMS LTD	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	390	REPAIRS & ALTS OF BUILDINGS	V001297449
ROCHDALE BOROUGH COUNCIL	Thu Jun 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Thu Jun 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	41.8	CLEANING MATERIALS	V001331017
ROCHDALE BOROUGH COUNCIL	Fri Jun 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SKYLINE LTD	Fri Jun 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	365	REPAIRS & ALTS OF BUILDINGS	V001333376
ROCHDALE BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	R & M ROOFING & BUILDING SUPPLIES LTD	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	82.11	BUILDING MATERIALS	V001342811
ROCHDALE BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	44.5	PUBLIC TRANSPORT	V001354406
ROCHDALE BOROUGH COUNCIL	Thu Jun 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PPL PRS LIMITED	Thu Jun 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1704.47	LICENCE	V001356093
ROCHDALE BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	R & M ROOFING & BUILDING SUPPLIES LTD	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	16.43	BUILDING MATERIALS	V001356514
ROCHDALE BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	STOCKPORT METROPOLITAN BOROUGH COUNCIL	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	356.24	OCCUPATIONAL HEALTH	V001358224


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