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	Mon Jun 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	XMA LIMITED	Mon Jun 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	85	IT EQUIPMENT	V001976581
ROCHDALE BOROUGH COUNCIL	Mon Jun 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	XMA LIMITED	Mon Jun 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	50	IT EQUIPMENT	V001976581
ROCHDALE BOROUGH COUNCIL	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POSTURITE UK LTD	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	56.06	TRAINING	V001994520
ROCHDALE BOROUGH COUNCIL	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POSTURITE UK LTD	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	101.96	TRAINING	V001994520
ROCHDALE BOROUGH COUNCIL	Mon Jun 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	XMA LIMITED	Mon Jun 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	234.78	PURCHASE OF ICT HARDWARE	V002002739
ROCHDALE BOROUGH COUNCIL	Thu Jun 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	HOWDENS JOINERY CO LIMITED	Thu Jun 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-35.84	BUILDING MATERIALS	V002005653
ROCHDALE BOROUGH COUNCIL	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Wed Jun 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	385.66	HYGIENE EQUIPMENT	V002014420
ROCHDALE BOROUGH COUNCIL	Thu Jun 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	SAICA NATUR UK LTD	Thu Jun 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	45	DISPOSAL OF CONFIDENTIAL EQUIPMENT AND W	V002018334
ROCHDALE BOROUGH COUNCIL	Thu Jun 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	LDA DESIGN CONSULTING LTD	Thu Jun 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9314	CONSULTANTS FEES	V002022501
ROCHDALE BOROUGH COUNCIL	Mon Jun 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	CONNECT CARS UK LTD	Mon Jun 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	448	TRAVELLING GENERAL EXPENSES	V002022621


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