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 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PIONEER TREE SERVICES LIMITED	Wed Aug 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	480	CONTRACTS	V001651604
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	15.59	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	23.99	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	41.95	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	69.95	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	10.07	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	56.95	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	169.62	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	6.5	EQUIPMENT - GENERAL	V001683259
ROCHDALE BOROUGH COUNCIL	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	21.98	EQUIPMENT - GENERAL	V001683259


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