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 Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99890394	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99895476	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99898774	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99903899	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99912061	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99921202	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99925459	6960	Professional Services General Consultancy - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99926447	3649.14	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	99928430	1697.11	Professional Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Apr 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	99928436	3017.09	Professional Services	KT3 4QF


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