Council Spending

organisation_name ORGANISATION NAME	efefctive_date EFEFCTIVE DATE	directorate DIRECTORATE	supplier_name SUPPLIER NAME	date_paid DATE PAID	amount AMOUNT (Ł)	purpose PURPOSE	transaction_no TRANSACTION No.
ROCHDALE BOROUGH COUNCIL	Thu May 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	FISHERS CLEANING SERVICES LIMITED	Thu May 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	120	PFI SCHEMES RPIX	V001606802
ROCHDALE BOROUGH COUNCIL	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TOTAL GAS AND POWER LIMITED	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-229.97	ELECTRICITY	V001652192
ROCHDALE BOROUGH COUNCIL	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TOTAL GAS AND POWER LIMITED	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	11.27	ELECTRICITY	V001656825
ROCHDALE BOROUGH COUNCIL	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TOTAL GAS AND POWER LIMITED	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9.75	ELECTRICITY	V001656827
ROCHDALE BOROUGH COUNCIL	Tue May 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	EVOLUTION AUTOMATIC DOORS LTD	Tue May 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	104	ELECTRICAL	V001673376
ROCHDALE BOROUGH COUNCIL	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	TOTAL GAS AND POWER LIMITED	Mon May 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	71.26	ELECTRICITY	V001677697
ROCHDALE BOROUGH COUNCIL	Mon May 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PIONEER TREE SERVICES LIMITED	Mon May 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1000	CONTRACTS	V001677751
ROCHDALE BOROUGH COUNCIL	Fri May 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	ARGOS BUSINESS SOLUTIONS LIMITED	Fri May 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	31.58	EQUIPMENT - GENERAL	V001678972
ROCHDALE BOROUGH COUNCIL	Thu May 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	GENR8 ROCHDALE LTD	Thu May 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	106792.34	CONSULTANTS FEES	V001679658
ROCHDALE BOROUGH COUNCIL	Thu May 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPERTY AND HIGHWAYS	JENKINSON OFFICE SUPPLIES	Thu May 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2626.68	MINOR BUILDING WORKS	V001680823


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