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 Oct 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	CFS CARE LTD	Thu Oct 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	5757.14	FOSTER PARENTS BASIC ALLOWANCE	V001672520
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1107.66	RESIDENTIAL LONG TERM	V001685705
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1107.66	RESIDENTIAL LONG TERM	V001685706
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	366.9	RESIDENTIAL & NURSING TOP UP EXPENDITURE	V001685707
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	366.9	RESIDENTIAL & NURSING TOP UP EXPENDITURE	V001685708
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-75.48	RESIDENTIAL LONG TERM	V001685936
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-1056.72	RESIDENTIAL LONG TERM	V001685937
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-1056.72	RESIDENTIAL LONG TERM	V001685938
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-1107.66	RESIDENTIAL LONG TERM	V001685939
ROCHDALE BOROUGH COUNCIL	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	CALICO HOMES LTD	Fri Oct 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-1107.66	RESIDENTIAL LONG TERM	V001685940


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