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	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	28.99	CLOTHES, UNIFORM AND LAUNDRY	V001229582
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	330	MOBILE PHONE	V001318950
ROCHDALE BOROUGH COUNCIL	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	30	CLOTHES, UNIFORM AND LAUNDRY	V001326377
ROCHDALE BOROUGH COUNCIL	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ARCO GROUP LIMITED	Mon May 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	38.99	EQUIPMENT - GENERAL	V001326378
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133
ROCHDALE BOROUGH COUNCIL	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-50	MOBILE PHONE	V001338133


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