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 Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	NORTH CHADDERTON SCHOOL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	4112.08	OTHER EST - SEN PROVISION	V001706858
ROCHDALE BOROUGH COUNCIL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	NORTH CHADDERTON SCHOOL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6160	OTHER EST - SEN PROVISION	V001706858
ROCHDALE BOROUGH COUNCIL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	NORTH CHADDERTON SCHOOL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-4934.5	OTHER EST - SEN PROVISION	V001709601
ROCHDALE BOROUGH COUNCIL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	NORTH CHADDERTON SCHOOL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-6579.34	OTHER EST - SEN PROVISION	V001709602
ROCHDALE BOROUGH COUNCIL	Tue Jan 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	TSOM GROUP	Tue Jan 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3600	EBD (EMOT & BEHAV DIFF) PLACEMENTS	V001722786
ROCHDALE BOROUGH COUNCIL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	7742	HYGIENE EQUIPMENT	V001730997
ROCHDALE BOROUGH COUNCIL	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	645.17	HYGIENE EQUIPMENT	V001731007
ROCHDALE BOROUGH COUNCIL	Tue Jan 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	TSOM GROUP	Tue Jan 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2640	EBD (EMOT & BEHAV DIFF) PLACEMENTS	V001734772
ROCHDALE BOROUGH COUNCIL	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	3 B TRAINING	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-495	EQUIPMENT - GENERAL	V001757057
ROCHDALE BOROUGH COUNCIL	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	STANNAH LIFT SERVICES LTD	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6704	TRANSACTIONS-EXPENDITURE	V001777721


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