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	05-Dec-24	PROPERTY AND HIGHWAYS	TRANSPORT FOR GREATER MANCHESTER	05-Dec-24	15588.45	MINOR BUILDING WORKS	V002054211
ROCHDALE BOROUGH COUNCIL	05-Dec-24	ADULT CARE LCO FUNCTIONS	STANNAH LIFT SERVICES LTD	05-Dec-24	6813	MINOR BUILDING WORKS	V002092734
ROCHDALE BOROUGH COUNCIL	17-Dec-24	ECONOMY DIRECTORATE	ELEMENT SUSTAINABILITY LTD	17-Dec-24	845	PROFESSIONAL FEES	V002191195
ROCHDALE BOROUGH COUNCIL	10-Dec-24	ECONOMY DIRECTORATE	CLICK 24 LTD	10-Dec-24	375	REPAIRS & ALTS OF BUILDINGS	V002222343
ROCHDALE BOROUGH COUNCIL	20-Dec-24	ECONOMY DIRECTORATE	NPOWER COMMERCIAL GAS	20-Dec-24	56.82	ELECTRICITY	V002222501
ROCHDALE BOROUGH COUNCIL	20-Dec-24	ECONOMY DIRECTORATE	NPOWER COMMERCIAL GAS	20-Dec-24	41.95	ELECTRICITY	V002222649
ROCHDALE BOROUGH COUNCIL	20-Dec-24	ECONOMY DIRECTORATE	NPOWER COMMERCIAL GAS	20-Dec-24	46.08	ELECTRICITY	V002222650
ROCHDALE BOROUGH COUNCIL	20-Dec-24	ECONOMY DIRECTORATE	NPOWER COMMERCIAL GAS	20-Dec-24	54.53	ELECTRICITY	V002222651
ROCHDALE BOROUGH COUNCIL	12-Dec-24	NEIGHBOURHOODS AND ENVIRONMENT	WOLSELEY UK LIMITED	12-Dec-24	155.89	BUILDING MATERIALS	V002225301
ROCHDALE BOROUGH COUNCIL	06-Dec-24	PROPERTY AND HIGHWAYS	CALEDONIAN LIFTS MANCHESTER LTD	06-Dec-24	90	PROPERTY - WORKS ELEMENT	V002229504


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