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	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PEEL GRAPHICS LIMITED	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15	PRINTING & STATIONERY	V001853033
ROCHDALE BOROUGH COUNCIL	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PEEL GRAPHICS LIMITED	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15	PRINTING & STATIONERY	V001853033
ROCHDALE BOROUGH COUNCIL	Tue Aug 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	UPS BUILDING AND MAINTENANCE LTD	Tue Aug 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2078.52	MINOR BUILDING WORKS	V001854192
ROCHDALE BOROUGH COUNCIL	Tue Aug 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	JGM AGENCY	Tue Aug 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4938.75	PUBLICITY	V001861159
ROCHDALE BOROUGH COUNCIL	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	GMCA	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1161.45	MINOR BUILDING WORKS	V001864218
ROCHDALE BOROUGH COUNCIL	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TOTALENERGIES GAS AND POWER LIMITED	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-13.5	GAS	V001870067
ROCHDALE BOROUGH COUNCIL	Wed Aug 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BELMONT SCHOOL LIMITED	Wed Aug 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	13994.47	OTHER EST - SEN PROVISION	V001870154
ROCHDALE BOROUGH COUNCIL	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	KEDLESTON MILL SCHOOL LTD	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	920	OTHER LA`S - SEN PROVISION	V001870399
ROCHDALE BOROUGH COUNCIL	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	VISION FOR EDUCATION LIMITED	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	350	CURRICULUM DEVELOPMENT	V001870742
ROCHDALE BOROUGH COUNCIL	Fri Aug 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	AGENCIA CONSULTING LTD	Fri Aug 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	8450	CONSULTANT FEES	V001870748


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