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 Jul 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	RSK GEOSCIENCES	Fri Jul 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4250	CONSULTANTS FEES	V001996381
ROCHDALE BOROUGH COUNCIL	Wed Jul 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	EQUITA LIMITED	Wed Jul 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)		REPAIRS & ALTS OF BUILDINGS	V002019376
ROCHDALE BOROUGH COUNCIL	Wed Jul 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	EQUITA LIMITED	Wed Jul 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)		REPAIRS & ALTS OF BUILDINGS	V002019376
ROCHDALE BOROUGH COUNCIL	Mon Jul 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ABC INDUSTRIAL DOORS LTD	Mon Jul 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-680.25	REPAIRS & ALTS OF BUILDINGS	V002019452
ROCHDALE BOROUGH COUNCIL	Mon Jul 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	ERIC WRIGHT GROUP LTD	Mon Jul 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2482.71	RENTS	V002020460
ROCHDALE BOROUGH COUNCIL	Mon Jul 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LICENCE BUREAU LIMITED	Mon Jul 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7.2	POLICE CHECKS ON NEW RECRUITS	V002022655
ROCHDALE BOROUGH COUNCIL	Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	KEOGHS LLP OFFICE ACCOUNT	Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)		INPUT VAT - ADJUSTMENTS	V002029302
ROCHDALE BOROUGH COUNCIL	Mon Jul 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ILLUMAPHONIUM LTD	Mon Jul 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2500	EVENTS	V002034533
ROCHDALE BOROUGH COUNCIL	Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	FORBES SOLICITORS	Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)		INPUT VAT - ADJUSTMENTS	V002035452
ROCHDALE BOROUGH COUNCIL	Thu Jul 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	JGM AGENCY	Thu Jul 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	150	MARKETING EXPENDITURE	V002039541


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