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 Science, Innovation and Technology	UK Shared Business Services Ltd	Thu Aug 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Everwell Occupational Health Ltd	100250850	1620	Professional Services	CW11 3AE
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Thu Aug 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Talent International (UK) Ltd	100250902	3690	Recruitment Services	B3 2BJ
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Thu Aug 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	Major Programmes	Unspecified	100251071	13.5	Mileage - Car (excl Home to Office)	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Thu Aug 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Public Transport	Major Programmes	Unspecified	100251071	25.2	Public Transport - Taxi Fare (Actuals)	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 2	Reed Specialist Recruitment Ltd	100251102	422.16	Recruitment Services	SW20 0BA
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	Risk, Information & Security Compliance	AM Health & Safety Ltd	100252093	189	Professional Services	SN5 6BD
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	Production Services	Softcat plc	100252204	328.88	Computing Software	SL7 1LW
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	D&I Operations	Unspecified	100252404	57.15	Mileage - Car (excl Home to Office)	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	SIAM	Unspecified	100252405	27	Mileage - Car (excl Home to Office)	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Aug 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Agenda Resource Management Ltd	100251155	241.7	Professional Services	HU12 8YJ


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