UKSBS Monthly Spend

department Department	entity Entity	date_of_payment Date Of Payment	expense_type Expense Type	expense_area Expense Area	supplier Supplier	transaction_number Transaction Number	amount Amount	description Description	supplier_postcode Supplier Postcode
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Indigo Business Services Ltd	100136496	8280	Training	KT2 6EF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Network Improvements	Crown Hosting Data Centres Ltd	100136866	-248.4	Computing Services	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Security Services	HR Training & Specialists	Premier Farnell UK Ltd T/A Farnell Onecall	100140412	26.77	Security Services	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Corporate HR	Agenda Resource Management Ltd	100144617	31.17	Professional Services	HU12 8YJ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Agenda Resource Management Ltd	100144617	117.74	Professional Services	HU12 8YJ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Other Staff Benefits	People	Amazon EU SARL	100144739	25	ZZ-Employee Benefits	EC2A 2FA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100144782	66	Computing Software	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Network Improvements	Crown Hosting Data Centres Ltd	100144783	320.52	Computing Services	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100144784	1173	bandwidth per port	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Mar 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100144785	2791.78	Computing Hardware	SN13 9GB


CREATE TABLE march_2024 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);