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 Dec 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	PENNINE CARE NHS	Mon Dec 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1666	SERVICE LEVEL AGREEMENTS	V001661317
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	920	DIRECT PAYMENTS	V001684614
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-284.12	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684615
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684616
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684617
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684618
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684619
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684620
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-568.24	CLIENTS CONTRIBUTIONS COMMUNITY CARE	V001684621
ROCHDALE BOROUGH COUNCIL	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	REDACTED - PERSONAL DATA	Fri Dec 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	920	DIRECT PAYMENTS	V001698222


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