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 Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	THE FLOWHESION FOUNDATION	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	16000	ACTIVITIES	V001914934
ROCHDALE BOROUGH COUNCIL	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	THE FLOWHESION FOUNDATION	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-16000	ACTIVITIES	V002005651
ROCHDALE BOROUGH COUNCIL	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	JLA TOTAL CARE LTD	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	350	EQUIPMENT - GENERAL	V002014909
ROCHDALE BOROUGH COUNCIL	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	JLA TOTAL CARE LTD	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	350	EQUIPMENT - GENERAL	V002018266
ROCHDALE BOROUGH COUNCIL	Mon Mar 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HORIZON CARE AND EDUCATION	Mon Mar 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-7480	OTHER LA`S - SEN PROVISION	V002024263
ROCHDALE BOROUGH COUNCIL	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	JLA TOTAL CARE LTD	Thu Mar 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-1050	EQUIPMENT - GENERAL	V002035299
ROCHDALE BOROUGH COUNCIL	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRANSPORT FOR GREATER MANCHESTER	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4800	MINOR BUILDING WORKS	V002046702
ROCHDALE BOROUGH COUNCIL	Mon Mar 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	THE BOND BOARD LIMITED - OPERATIONAL ACCOUNT	Mon Mar 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	12425	BASIC SALARIES	V002082231
ROCHDALE BOROUGH COUNCIL	Wed Mar 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	WATERMAN INFASTRUCTURE AND ENVIRONMENT LTD	Wed Mar 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-4570.89	ENGINEERS FEES	V002083524
ROCHDALE BOROUGH COUNCIL	Fri Mar 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	NORTHERN CARE ALLIANCE NHS FOUNDATION TRUST	Fri Mar 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-3478	PH OTHER CONTRACTS	V002096841


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