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	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	79386.11	AWS Consumption Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	22269.85	Enhanced Managed Service April 2022 - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	2543.52	Enhanced Managed Service May 2022 - Mar 2023 - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	441.92	Managed Anti-Malware Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	204	Managed Backup - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	3186	Managed Database - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	3234.08	NREN Fee Apr 2022 - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776965	435.5	NREN Fee May 2022 - Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776968	13462.48	AWS Consumption Year 1	BS1 6NB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99776968	2728.72	Enhanced Managed Service May 2022 - Mar 2023 - Year 1	BS1 6NB


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