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 Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	15.9	BUILDING MATERIALS	V001252515
ROCHDALE BOROUGH COUNCIL	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	6.84	BUILDING MATERIALS	V001252516
ROCHDALE BOROUGH COUNCIL	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5.11	BUILDING MATERIALS	V001252517
ROCHDALE BOROUGH COUNCIL	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	3.49	BUILDING MATERIALS	V001252518
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	8.99	BUILDING MATERIALS	V001252519
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	13.1	BUILDING MATERIALS	V001252520
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	36.7	BUILDING MATERIALS	V001252521
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	12.08	BUILDING MATERIALS	V001252522
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	23.8	BUILDING MATERIALS	V001252523
ROCHDALE BOROUGH COUNCIL	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	TRAVIS PERKINS TRADING CO LTD	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	33.73	BUILDING MATERIALS	V001252524


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