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 Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Risk, Information & Security Compliance	Risk Evolves Ltd	99648711	420	Consultancy Services	CV31 1XT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Risk, Information & Security Compliance	Risk Evolves Ltd	99648711	1260	Consultancy Services	CV31 1XT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Corporate HR	Agenda Resource Management Ltd	99760755	707.86	Professional Services	HU12 8YJ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99760903	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99762058	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Jul 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99762061	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Corporate Finance	C and D Group Ltd t/a Thrive Group	99751047	1497.8	SR 11138346 VAT ONLY INVOICE	SN3 4UQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	HR Ops & Specialists	Unspecified	99760133	65	Home-working Equipment	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	99761322	3387.66	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Corporate Commercial	Alexander Mann Solutions Ltd	99761336	2521.25	Recruitment Services	EC2N 3AQ


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