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	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100108399	66	Computing Software	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100108400	1173	bandwidth per port	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100108401	2791.78	Computing Hardware	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Grants CRs	Alexander Mann Solutions Ltd	100110001	1386.12	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	100110006	2887.75	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	100110006	577.55	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	100110015	2438.05	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	100110015	487.61	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Communications	Alexander Mann Solutions Ltd	100110020	3150.3	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	100110024	3695.58	Recruitment Services	EC2N 3AQ


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