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	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	FISHERS CLEANING SERVICES LIMITED	Fri Apr 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	564	CLEANING AND DOMESTIC SUPPLIES	V001606804
ROCHDALE BOROUGH COUNCIL	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	74.4	TRANSLATION & INTERPRETATION	V001629521
ROCHDALE BOROUGH COUNCIL	Thu Apr 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	GMCA	Thu Apr 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-6250	CONSULTANTS FEES	V001651554
ROCHDALE BOROUGH COUNCIL	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	CIVICA UK LIMITED	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	4200	CONSULTANT FEES	V001657387
ROCHDALE BOROUGH COUNCIL	Tue Apr 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POLLOCK LIFTS	Tue Apr 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	13136.58	MINOR BUILDING WORKS	V001666203
ROCHDALE BOROUGH COUNCIL	Mon Apr 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CDW LTD	Mon Apr 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	3762.26	SOFTWARE	V001666760
ROCHDALE BOROUGH COUNCIL	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BLOOM PROCUREMENT SERVICES LTD	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	5216.5	EQUIPMENT - GENERAL	V001667155
ROCHDALE BOROUGH COUNCIL	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	42.8	TRANSLATION & INTERPRETATION	V001667804
ROCHDALE BOROUGH COUNCIL	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	48.8	TRANSLATION & INTERPRETATION	V001667809
ROCHDALE BOROUGH COUNCIL	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Fri Apr 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	11.2	TRANSLATION & INTERPRETATION	V001667810


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