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 Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	108.84	EQUIPMENT - GENERAL	V001497508
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	34	EQUIPMENT - GENERAL	V001498214
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	103.91	EQUIPMENT - GENERAL	V001498281
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	23.14	EQUIPMENT - GENERAL	V001498319
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	20.89	EQUIPMENT - GENERAL	V001498320
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	77.3	TRANSACTIONS-EXPENDITURE	V001499603
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	10.4	TRANSACTIONS-EXPENDITURE	V001499603
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	31.6	PROPERTY - WORKS ELEMENT	V001499759
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1.37	PROPERTY - WORKS ELEMENT	V001499760
ROCHDALE BOROUGH COUNCIL	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	H ROTHWELL AND CO LTD	Thu Jul 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	49.12	PROPERTY - WORKS ELEMENT	V001500129


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