Council Spending

organisation_name ORGANISATION NAME	effective_date EFFECTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION NO.
ROCHDALE BOROUGH COUNCIL	Fri Jul 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	LANTEI LTD	Fri Jul 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1392	PROPERTY - WORKS ELEMENT	V001364492
ROCHDALE BOROUGH COUNCIL	Fri Jul 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	LANTEI LTD	Fri Jul 19 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	688	PROPERTY - WORKS ELEMENT	V001389515
ROCHDALE BOROUGH COUNCIL	Thu Jul 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	F BRIERLEY & SON LIMITED	Thu Jul 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	7250	PROPERTY - WORKS ELEMENT	V001391116
ROCHDALE BOROUGH COUNCIL	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	RECLAIM PROJECT LTD	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	25000	CONTRACTED SERVICES	V001395790
ROCHDALE BOROUGH COUNCIL	Fri Jul 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	HORIZON CARE AND EDUCATION	Fri Jul 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	12441	OTHER LA`S - SEN PROVISION	V001401472
ROCHDALE BOROUGH COUNCIL	Mon Jul 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE PENNINE ACUTE HOSPITALS NHS TRUST	Mon Jul 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	3674.31	SERVICE LEVEL AGREEMENTS	V001404264
ROCHDALE BOROUGH COUNCIL	Mon Jul 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Mon Jul 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	315	CLOTHES, UNIFORM AND LAUNDRY	V001404492
ROCHDALE BOROUGH COUNCIL	Mon Jul 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	REACH PUBLISHING SERVICES LTD	Mon Jul 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	153.56	ADVERTISING	V001407457
ROCHDALE BOROUGH COUNCIL	Tue Jul 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Tue Jul 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	625.05	CLOTHES, UNIFORM AND LAUNDRY	V001411925
ROCHDALE BOROUGH COUNCIL	Tue Jul 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REXEL UK LIMITED	Tue Jul 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	423.6	CLOTHES, UNIFORM AND LAUNDRY	V001411926


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