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	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	PS&P LTD	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		INPUT VAT - ADJUSTMENTS	V001872042
ROCHDALE BOROUGH COUNCIL	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	MHR	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	485	SOFTWARE	V001945644
ROCHDALE BOROUGH COUNCIL	Thu Feb 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	TTS GROUP LIMITED	Thu Feb 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	241.13	ARTS & CRAFTS	V001963709
ROCHDALE BOROUGH COUNCIL	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	MHR	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	485	SOFTWARE	V001965189
ROCHDALE BOROUGH COUNCIL	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	MHR	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	485	SOFTWARE	V002021806
ROCHDALE BOROUGH COUNCIL	Fri Feb 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PTSG ELECTRICAL SERVICES LTD	Fri Feb 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	385	REPAIRS & ALTS OF BUILDINGS	V002041541
ROCHDALE BOROUGH COUNCIL	Wed Feb 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	MHR	Wed Feb 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	485	SOFTWARE	V002065404
ROCHDALE BOROUGH COUNCIL	Thu Feb 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Thu Feb 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	35	TRANSLATION & INTERPRETATION	V002095356
ROCHDALE BOROUGH COUNCIL	Wed Feb 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	EQUITA LIMITED	Wed Feb 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	183	CONTRACTED SERVICES	V002101630
ROCHDALE BOROUGH COUNCIL	Wed Feb 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	EQUITA LIMITED	Wed Feb 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	183	CONTRACTED SERVICES	V002101630


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