Council Spending

organisation_name ORGANISATION NAME	effective_date EFFECTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION No.
ROCHDALE BOROUGH COUNCIL	Mon Apr 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SHENSTONE PROPERTIES LTD	Mon Apr 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2.73	RENTS	V002042291
ROCHDALE BOROUGH COUNCIL	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	ASSOCIATED CLEANING CONTRACTORS	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	135	REPAIRS & ALTS OF BUILDINGS	V002042326
ROCHDALE BOROUGH COUNCIL	Tue Apr 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	EARLY BREAK	Tue Apr 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-95692	CONTRACTED SERVICES	V002054056
ROCHDALE BOROUGH COUNCIL	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	ASSOCIATED CLEANING CONTRACTORS	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	135	REPAIRS & ALTS OF BUILDINGS	V002055495
ROCHDALE BOROUGH COUNCIL	Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	FINDEL EDUCATION LIMITED	Tue Apr 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	50.97	EQUIPMENT - GENERAL	V002060153
ROCHDALE BOROUGH COUNCIL	Mon Apr 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	CDER GROUP LTD	Mon Apr 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		INPUT VAT - ADJUSTMENTS	V002065398
ROCHDALE BOROUGH COUNCIL	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	ASSOCIATED CLEANING CONTRACTORS	Fri Apr 12 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	135	REPAIRS & ALTS OF BUILDINGS	V002077693
ROCHDALE BOROUGH COUNCIL	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	RUSHTONS DEVELOPMENTS LTD	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-3300	MINOR BUILDING WORKS	V002078592
ROCHDALE BOROUGH COUNCIL	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	RUSHTONS DEVELOPMENTS LTD	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-2200	MINOR BUILDING WORKS	V002078592
ROCHDALE BOROUGH COUNCIL	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	GEZE UK LTD	Wed Apr 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	76.07	REPAIRS & ALTS OF BUILDINGS	V002079378


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