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	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	100002583	2772.24	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	100006178	3465.3	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	100006640	3465.3	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Printing & Stationery	Finance Operations 1	Rapid Electronics Ltd	100008668	12.83	Office Supplies	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Printing & Stationery	Finance Operations 1	Rapid Electronics Ltd	100008668	12.77	Office Supplies	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100009599	1173	bandwidth per port	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100009614	3908.5	Computing Hardware	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100009619	6	Computing Hardware	SMARTFORM
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100009619	287.93	Computing Hardware	SMARTFORM
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	100010319	2772.24	Recruitment Services	EC2N 3AQ


CREATE TABLE august_2023 (
  "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
);