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	Wed Aug 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ALLIANCE DISPOSABLES LIMITED	Wed Aug 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-47.9	CONSUMABLES	V002078614
ROCHDALE BOROUGH COUNCIL	Tue Aug 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FIVE RIVERS CHILD CARE LTD	Tue Aug 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-1050	OTHER EST - SEN PROVISION	V002083526
ROCHDALE BOROUGH COUNCIL	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	KIRKLEES COLLEGE	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	7539.5	OTHER EST - SEN PROVISION	V002093156
ROCHDALE BOROUGH COUNCIL	Thu Aug 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	XMA LIMITED	Thu Aug 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	95	IT EQUIPMENT	V002095103
ROCHDALE BOROUGH COUNCIL	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	KIRKLEES COLLEGE	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-12063.2	OTHER EST - SEN PROVISION	V002103354
ROCHDALE BOROUGH COUNCIL	Tue Aug 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	E ON ENERGY SOLUTIONS LTD HIGHWAY LIGHTING	Tue Aug 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-415.31	GAS	V002124182
ROCHDALE BOROUGH COUNCIL	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	GM BUSINESS SUPPORT LIMITED	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-32	CONSULTANTS FEES	V002131122
ROCHDALE BOROUGH COUNCIL	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EAGLE CONTAINERS LIMITED	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	60	EQUIPMENT - GENERAL	V002135629
ROCHDALE BOROUGH COUNCIL	Tue Aug 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	STANNAH LIFT SERVICES LTD	Tue Aug 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	6939	TRANSACTIONS-EXPENDITURE	V002141803
ROCHDALE BOROUGH COUNCIL	Thu Aug 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Thu Aug 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	165	TRANSLATION & INTERPRETATION	V002151203


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