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	Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	THE PENNINE ACUTE HOSPITALS NHS TRUST	Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1666.66	SERVICE LEVEL AGREEMENTS	V001343875
ROCHDALE BOROUGH COUNCIL	Tue Aug 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	NISBETS PLC	Tue Aug 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	26.98	EQUIPMENT - GENERAL	V001366266
ROCHDALE BOROUGH COUNCIL	Tue Aug 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	NISBETS PLC	Tue Aug 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5	EQUIPMENT - GENERAL	V001366266
ROCHDALE BOROUGH COUNCIL	Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	CICELEY COMMERCIALS LIMITED	Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	-94.58	VEHICLE MAINTENANCE	V001369494
ROCHDALE BOROUGH COUNCIL	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	SIMON JERSEY LIMITED	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	700.83	CLOTHES, UNIFORM AND LAUNDRY	V001416201
ROCHDALE BOROUGH COUNCIL	Wed Aug 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	CRESTA WORLD TRAVEL LIMITED	Wed Aug 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	56.8	STAFF TRAVELLING EXPENSES	V001417710
ROCHDALE BOROUGH COUNCIL	Mon Aug 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ISAAC BUTTERWORTH IRONFOUNDERS LIMITED	Mon Aug 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2348.4	ACTIVITIES	V001418100
ROCHDALE BOROUGH COUNCIL	Mon Aug 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	ISAAC BUTTERWORTH IRONFOUNDERS LIMITED	Mon Aug 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	844.8	ACTIVITIES	V001418101
ROCHDALE BOROUGH COUNCIL	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PRICE AND MYERS	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4610	CONSULTANTS FEES	V001418204
ROCHDALE BOROUGH COUNCIL	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	PRICE AND MYERS	Tue Aug 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4610	CONSULTANTS FEES	V001418207


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