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 Jun 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BETTER CARE FUND POOLED BUDGET	PENNINE CARE NHS	Thu Jun 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	8385.67	CONTRACTS	V001470641
ROCHDALE BOROUGH COUNCIL	Tue Jun 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	PENNINE CARE NHS	Tue Jun 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2481.48	PROJECTS	V001476216
ROCHDALE BOROUGH COUNCIL	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	THE PENNINE ACUTE HOSPITALS NHS TRUST	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	175	MORTUARY CHARGES	V001516587
ROCHDALE BOROUGH COUNCIL	Fri Jun 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PHS GROUP PLC	Fri Jun 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2865	CHRISTMAS DECORATIONS	V001520911
ROCHDALE BOROUGH COUNCIL	Thu Jun 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Thu Jun 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	41	TRANSLATION & INTERPRETATION	V001530494
ROCHDALE BOROUGH COUNCIL	Thu Jun 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Thu Jun 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	71.8	TRANSLATION & INTERPRETATION	V001534686
ROCHDALE BOROUGH COUNCIL	Tue Jun 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Tue Jun 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	51.5	TRANSLATION & INTERPRETATION	V001534694
ROCHDALE BOROUGH COUNCIL	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	ATG ACCESS LTD	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1974.96	MINOR BUILDING WORKS	V001535167
ROCHDALE BOROUGH COUNCIL	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	ATG ACCESS LTD	Mon Jun 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	485	MINOR BUILDING WORKS	V001535187
ROCHDALE BOROUGH COUNCIL	Mon Jun 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Mon Jun 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45.7	TRANSLATION & INTERPRETATION	V001535237


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