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 Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ROYAL MAIL GROUP LTD	Fri Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	68	POSTAGE	V001960058
ROCHDALE BOROUGH COUNCIL	Fri Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ROYAL MAIL GROUP LTD	Fri Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	68	POSTAGE	V001963414
ROCHDALE BOROUGH COUNCIL	Fri Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ROYAL MAIL GROUP LTD	Fri Jan 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	78	POSTAGE	V002010991
ROCHDALE BOROUGH COUNCIL	Tue Jan 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CROWTHER AND SHAW LTD	Tue Jan 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-64	REPAIRS & ALTS OF BUILDINGS	V002015908
ROCHDALE BOROUGH COUNCIL	Fri Jan 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	YORKSHIRE PURCHASING ORGANISATION	Fri Jan 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	18.99	ARTS & CRAFTS	V002027421
ROCHDALE BOROUGH COUNCIL	Fri Jan 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	YORKSHIRE PURCHASING ORGANISATION	Fri Jan 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4.95	ARTS & CRAFTS	V002027421
ROCHDALE BOROUGH COUNCIL	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TAYLOR AND FRANCIS GROUP	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	83.23	EQUIPMENT - GENERAL	V002041151
ROCHDALE BOROUGH COUNCIL	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TAYLOR AND FRANCIS GROUP	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	128.23	EQUIPMENT - GENERAL	V002042048
ROCHDALE BOROUGH COUNCIL	Wed Jan 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	RANDSTAD SOLUTIONS LTD	Wed Jan 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	360	CURRICULUM DEVELOPMENT	V002042991
ROCHDALE BOROUGH COUNCIL	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TAYLOR AND FRANCIS GROUP	Tue Jan 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-834.59	EQUIPMENT - GENERAL	V002043466


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