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	Fri Jan 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	PENNINE CARE NHS	43847	9250	RENTS	V001449723
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	21.95	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	52.45	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	18.9	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	18.6	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	40.97	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	126.86	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	18.27	ELECTRICITY	V001462273
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	-16.16	ELECTRICITY	V001462296
ROCHDALE BOROUGH COUNCIL	Thu Jan 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	BRITISH GAS	43846	-13.24	ELECTRICITY	V001462296


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