Council Spending

organisation_name ORGANISATION NAME	effective_date EFFECTIVE DATE	service SERVICE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_id Transaction Id
ROCHDALE BOROUGH COUNCIL	Tue Aug 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	AMBEROL LIMITED	30/08/2016	2222.3	ACTIVITIES	V001006230
ROCHDALE BOROUGH COUNCIL	Mon Aug 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	THE PENNINE ACUTE HOSPITALS NHS TRUST	15/08/2016	3827.99	CONTRACTED SERVICES	V001011053
ROCHDALE BOROUGH COUNCIL	Fri Aug 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LANDMARK GROUNDS MAINTENANCE SUPPLIES	19/08/2016	1059	EQUIPMENT - GENERAL	V001017740
ROCHDALE BOROUGH COUNCIL	Fri Aug 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	LANDMARK GROUNDS MAINTENANCE SUPPLIES	19/08/2016	2156.74	EQUIPMENT - GENERAL	V001017740
ROCHDALE BOROUGH COUNCIL	Mon Aug 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	BOLTON IMPACT TRUST	15/08/2016	12537	OTHER EST - SEN PROVISION	V001017750
ROCHDALE BOROUGH COUNCIL	Thu Aug 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	PHYSICAL DIS & OLDER PEOPLE	KINGKRAFT LIMITED	04/08/2016	7440	IMPROVEMENTS-EXTENSIONS & ALTERATIONS	V001019808
ROCHDALE BOROUGH COUNCIL	Fri Aug 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TERBERG MATEC UK LIMITED	19/08/2016	934.39	VEHICLE MAINTENANCE	V001021020
ROCHDALE BOROUGH COUNCIL	Mon Aug 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	PHYSICAL DIS & OLDER PEOPLE	THE UNIVERSITY OF MANCHESTER	01/08/2016	680	TRAINING	V001021068
ROCHDALE BOROUGH COUNCIL	Mon Aug 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	PHYSICAL DIS & OLDER PEOPLE	MWUK LTD	15/08/2016	518.7	CLOTHES, UNIFORM AND LAUNDRY	V001021180
ROCHDALE BOROUGH COUNCIL	Mon Aug 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	LEARNING DIS & MENTAL HEALTH	ROCHDALE BOROUGHWIDE HOUSING	08/08/2016	954.24	EXPENSES - GENERAL	V001024557


CREATE TABLE table_127 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" VARCHAR,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_id" VARCHAR
);

Share link

Anyone who has the link will be able to view this.