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	Mon May 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Mon May 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5	MOBILE PHONE	V001749475
ROCHDALE BOROUGH COUNCIL	Mon May 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	NEIGHBOURHOODS AND ENVIRONMENT	EVERYTHING EVERYWHERE	Mon May 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-5	MOBILE PHONE	V001749476
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	-2475.22	REPAIRS & ALTS OF BUILDINGS	V001889478
ROCHDALE BOROUGH COUNCIL	Thu May 11 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	PUBLIC HEALTH	PHS GROUP PLC	Thu May 11 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	537.33	HYGIENE EQUIPMENT	V001903124
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	36	REPAIRS & ALTS OF BUILDINGS	V001917459
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	28	REPAIRS & ALTS OF BUILDINGS	V001917459
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	EARLY HELP AND SCHOOLS	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	111.86	REPAIRS & ALTS OF BUILDINGS	V001917461
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	64	REPAIRS & ALTS OF BUILDINGS	V001919545
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	64	REPAIRS & ALTS OF BUILDINGS	V001940852
ROCHDALE BOROUGH COUNCIL	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ECONOMY DIRECTORATE	CHUBB FIRE AND SECURITY LIMITED	Fri May 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	64	REPAIRS & ALTS OF BUILDINGS	V001944054


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