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	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	109.36	CLEANING MATERIALS	V001516974
ROCHDALE BOROUGH COUNCIL	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	120.88	CLEANING MATERIALS	V001541167
ROCHDALE BOROUGH COUNCIL	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	PATTERSONS BRISTOL LTD	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	63.12	CLEANING MATERIALS	V001542179
ROCHDALE BOROUGH COUNCIL	Mon Nov 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TRANSPORT FOR GREATER MANCHESTER	Mon Nov 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2950	CONSULTANTS FEES	V001542646
ROCHDALE BOROUGH COUNCIL	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TRANSPORT FOR GREATER MANCHESTER	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	7499.95	CONSULTANTS FEES	V001546440
ROCHDALE BOROUGH COUNCIL	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TRANSPORT FOR GREATER MANCHESTER	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	56850.05	CONSULTANTS FEES	V001546440
ROCHDALE BOROUGH COUNCIL	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	JULIE STIRPE ASSOCIATES LIMITED	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	-831.4	ACTIVITIES	V001557771
ROCHDALE BOROUGH COUNCIL	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	MILLENNIUM TRANSLATIONS LTD	Fri Nov 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	96	TRANSLATION & INTERPRETATION	V001563511
ROCHDALE BOROUGH COUNCIL	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ENABLING FUTURES LTD	Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	10457.14	EBD (EMOT & BEHAV DIFF) PLACEMENTS	V001577906
ROCHDALE BOROUGH COUNCIL	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	JULIE STIRPE ASSOCIATES LIMITED	Fri Nov 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	291.2	ACTIVITIES	V001578010


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