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 Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	135	EQUIPMENT - GENERAL	V001437876
ROCHDALE BOROUGH COUNCIL	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	135	EQUIPMENT - GENERAL	V001437876
ROCHDALE BOROUGH COUNCIL	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Tue Feb 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	135	EQUIPMENT - GENERAL	V001437876
ROCHDALE BOROUGH COUNCIL	Tue Feb 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	COMPASS MINERALS UK LIMITED	Tue Feb 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1340.68	MATERIAL - GENERAL	V001448437
ROCHDALE BOROUGH COUNCIL	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FORD MOTOR COMPANY LTD	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	14229.85	PURCHASE OF VEHICLES	V001463794
ROCHDALE BOROUGH COUNCIL	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FORD MOTOR COMPANY LTD	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	14229.85	PURCHASE OF VEHICLES	V001463795
ROCHDALE BOROUGH COUNCIL	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FORD MOTOR COMPANY LTD	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	14229.85	PURCHASE OF VEHICLES	V001463796
ROCHDALE BOROUGH COUNCIL	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FORD MOTOR COMPANY LTD	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	14229.85	PURCHASE OF VEHICLES	V001463797
ROCHDALE BOROUGH COUNCIL	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	FORD MOTOR COMPANY LTD	Tue Feb 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	13292.85	PURCHASE OF VEHICLES	V001463798
ROCHDALE BOROUGH COUNCIL	Wed Feb 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RESOURCES	TUSKERDIRECT LIMITED	Wed Feb 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-221.22	TRANSACTIONS-EXPENDITURE	V001476446


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