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 Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100041919	11548.62	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100054379	3079.63	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100060049	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100062860	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100066807	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100071152	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Other Staff Benefits	People	Amazon EU SARL	100073665	2125	ZZ-Employee Benefits	EC2A 2FA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100074788	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100079471	3849.54	Professional Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	SHARP	Alexander Mann Solutions Ltd	100083421	3849.54	Professional Services	EC2N 3AQ


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