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 Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Softcat plc	100174951	22284.72	Computer Consumables	SL7 1LW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Softcat plc	100174955	777841.6	Computer Consumables	SL7 1LW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Corporate Events	Project Office	Calder Conference Ltd	100207931	230	Conference & Venues	LS16 6RF
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Jun 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Precision Resource Group Ltd T/A iO	100207953	7200	Recruitment Services	BS1 2NH
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Phoenix Software Ltd	100206823	16903.95	Computing Software	YO42 1NS
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Bytes Software Services Ltd	100207242	230.89	Computing Software	KT22 7TW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Bytes Software Services Ltd	100207242	47384.53	Computing Software	KT22 7TW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Bytes Software Services Ltd	100207242	501.96	Computing Software	KT22 7TW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	100207254	6930.6	Recruitment Services	EC2M 5TQ
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Jun 04 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Grants CRs	Alexander Mann Solutions Ltd	100207269	3465.3	Recruitment Services	EC2M 5TQ


CREATE TABLE june_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
);