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	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	B R W SPARROW	Thu Mar 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4	RENTS	V001567223
ROCHDALE BOROUGH COUNCIL	Thu Mar 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	MANTRA LEARNING LTD	Thu Mar 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-59	EQUIPMENT - GENERAL	V001601682
ROCHDALE BOROUGH COUNCIL	Mon Mar 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	FISHERS CLEANING SERVICES LIMITED	Mon Mar 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	135	CLEANING AND DOMESTIC SUPPLIES	V001606800
ROCHDALE BOROUGH COUNCIL	Tue Mar 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LS SYSTEMS LTD	Tue Mar 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	107.4	TREES, SHRUBS, PLANTS	V001624934
ROCHDALE BOROUGH COUNCIL	Mon Mar 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Mon Mar 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	45.7	TRANSLATION & INTERPRETATION	V001626335


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