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	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Corporate HR	Everwell Occupational Health Ltd	99812592	336	Professional Services	CW11 3AE
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99813267	5108.8	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99813282	8622.94	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	99813284	2710.13	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	People	Alexander Mann Solutions Ltd	99813287	3780.4	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99813289	2648.52	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99813296	6930.6	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99813333	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99813334	504	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99813337	504	Training	MK43 0BT


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