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	Wed Aug 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	XMA LIMITED	Wed Aug 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	135.18	IT EQUIPMENT	V002002957
ROCHDALE BOROUGH COUNCIL	Tue Aug 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	SAICA NATUR UK LTD	Tue Aug 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	45	REFUSE DISPOSAL	V002027456
ROCHDALE BOROUGH COUNCIL	Fri Aug 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	ADT FIRE & SECURITY PLC	Fri Aug 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	151.25	SECURITY	V002028058
ROCHDALE BOROUGH COUNCIL	Mon Aug 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BANNER GROUP LIMITED	Mon Aug 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	34.64	PRINTING & STATIONERY	V002029418
ROCHDALE BOROUGH COUNCIL	Mon Aug 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BANNER GROUP LIMITED	Mon Aug 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	34.64	PRINTING & STATIONERY	V002029418
ROCHDALE BOROUGH COUNCIL	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	THE BIG WORD	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	46	TRANSLATION & INTERPRETATION	V002039587
ROCHDALE BOROUGH COUNCIL	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	THE BIG WORD	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.88	TRANSLATION & INTERPRETATION	V002039587
ROCHDALE BOROUGH COUNCIL	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	THE BIG WORD	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.5	TRANSLATION & INTERPRETATION	V002039587
ROCHDALE BOROUGH COUNCIL	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	THE BIG WORD	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	34.5	TRANSLATION & INTERPRETATION	V002039587
ROCHDALE BOROUGH COUNCIL	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	THE BIG WORD	Thu Aug 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.88	TRANSLATION & INTERPRETATION	V002039587


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