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 Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POSTURITE UK LTD	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	66.01	STATIONERY	V002027419
ROCHDALE BOROUGH COUNCIL	Wed Jul 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	CHILDREN’S SOCIAL CARE	ADOPTION MATTERS NORTHWEST	Wed Jul 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-1878	ADOPTION PAYMENTS	V002031449
ROCHDALE BOROUGH COUNCIL	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	POSTURITE UK LTD	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	97.71	STATIONERY	V002032529
ROCHDALE BOROUGH COUNCIL	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADULT CARE LCO FUNCTIONS	DORO CARE UK LTD	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4765.95	EQUIPMENT - GENERAL	V002065230
ROCHDALE BOROUGH COUNCIL	Tue Jul 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	BANNER GROUP LIMITED	Tue Jul 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4.42	PRINTING & STATIONERY	V002068062
ROCHDALE BOROUGH COUNCIL	Tue Jul 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	SWIFT SECURITY PRODUCTS LTD	Tue Jul 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	250	ELECTRICAL	V002089015
ROCHDALE BOROUGH COUNCIL	Tue Jul 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	SWIFT SECURITY PRODUCTS LTD	Tue Jul 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1094	ELECTRICAL	V002089015
ROCHDALE BOROUGH COUNCIL	Fri Jul 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	REDACTED - PERSONAL DATA	Fri Jul 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	152	PHOTOGRAPHY	V002110891
ROCHDALE BOROUGH COUNCIL	Wed Jul 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	TRANSPORT FOR GREATER MANCHESTER	Wed Jul 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4920	CONSULTANTS FEES	V002118856
ROCHDALE BOROUGH COUNCIL	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	AMAZON BUSINESS	Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	177.07	FURNITURE - GENERAL	V002122310


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