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 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	VPS UK LTD	Mon Dec 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-43.79	SECURITY	V001890018
ROCHDALE BOROUGH COUNCIL	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	GAMMA BUSINESS COMMUNICATIONS	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3261.62	TRANSACTIONS-EXPENDITURE	V001891189
ROCHDALE BOROUGH COUNCIL	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	GAMMA BUSINESS COMMUNICATIONS	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	0.15	TRANSACTIONS-EXPENDITURE	V001891189
ROCHDALE BOROUGH COUNCIL	Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	GAMMA BUSINESS COMMUNICATIONS	Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3459.71	TRANSACTIONS-EXPENDITURE	V001910708
ROCHDALE BOROUGH COUNCIL	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BELMONT SCHOOL LIMITED	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-900	OTHER EST - SEN PROVISION	V001917457
ROCHDALE BOROUGH COUNCIL	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BELMONT SCHOOL LIMITED	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-1710	OTHER EST - SEN PROVISION	V001917458
ROCHDALE BOROUGH COUNCIL	Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	-61.92	TRANSACTIONS-EXPENDITURE	V001926000
ROCHDALE BOROUGH COUNCIL	Thu Dec 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Thu Dec 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	238	TRANSLATION & INTERPRETATION	V001934406
ROCHDALE BOROUGH COUNCIL	Fri Dec 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BANNER GROUP LIMITED	Fri Dec 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	133.11	PRINTING & STATIONERY	V001934811
ROCHDALE BOROUGH COUNCIL	Thu Dec 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	D A LANGUAGES LIMITED	Thu Dec 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	225	TRANSLATION & INTERPRETATION	V001934832


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