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	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LAKESIDE INVESTMENTS LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3	RENTS	V001584094
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001617719
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001617719
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001683766
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001683766
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LAKESIDE INVESTMENTS LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3	RENTS	V001733079
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001755547
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001755547
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001848778
ROCHDALE BOROUGH COUNCIL	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Thu Feb 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V001848778


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