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 May 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	SAICA NATUR UK LTD	Thu May 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	40	DISPOSAL OF CONFIDENTIAL EQUIPMENT AND W	V001799546
ROCHDALE BOROUGH COUNCIL	Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CAIR UK LTD	Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	275	PURCHASE OF FURNITURE AND EQUIPMENT	V001812621
ROCHDALE BOROUGH COUNCIL	Thu May 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CRESTA WORLD TRAVEL LIMITED	Thu May 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	20	PUBLIC TRANSPORT	V001819437
ROCHDALE BOROUGH COUNCIL	Wed May 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	HOWARTH TIMBER AND BUILDING SUPPLIES LTD	Wed May 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-29.04	ADAPTATIONS	V001823726
ROCHDALE BOROUGH COUNCIL	Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	HOWDENS JOINERY CO LIMITED	Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-60.92	PROPERTY - WORKS ELEMENT	V001823760
ROCHDALE BOROUGH COUNCIL	Thu May 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	HAGS SMP LTD	Thu May 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	500	ENVIRONMENTAL WORKS LANDSCAPE	V001824314
ROCHDALE BOROUGH COUNCIL	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ROCHDALE TOWN TAXIS LTD	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	585	PUBLIC TRANSPORT	V001829249
ROCHDALE BOROUGH COUNCIL	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ROCHDALE TOWN TAXIS LTD	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	585	PUBLIC TRANSPORT	V001829249
ROCHDALE BOROUGH COUNCIL	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ROCHDALE TOWN TAXIS LTD	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	585	PUBLIC TRANSPORT	V001829249
ROCHDALE BOROUGH COUNCIL	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ROCHDALE TOWN TAXIS LTD	Thu May 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	925	PUBLIC TRANSPORT	V001829250


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