Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

1. Step 1

   • Publication: Children's social work workforce

2. Step 2

   • Data set: Caseloads, absence, vacancies, turnover and agency workers

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford

4. Step 4

   • Time period: 2017 to 2021

5. Step 5

   • Indicators:
     • Average caseload (per FTE)

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   Average caseload (per FTE) for 'Caseloads, absence, vacancies, turnover and agency workers' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 151 other locations between 2017 and 2021

   		2017	2018	2019	2020	2021
   North East	County Durham	18.8	19.7	17.3	15.7	16.7
   	Darlington	12.5	16.4	15.4	14.9	15.7
   	Gateshead	17.3	16.1	17.2	19.1	18.8
   	Hartlepool	16.2	18.5	19.3	17.7	16.5
   	Middlesbrough	17.4	13.2	16.8	23.5	17.8
   	Newcastle upon Tyne	18.0	21.2	18.4	17.0	17.7
   	North Tyneside	18.7	19.2	19.7	17.8	22.4
   	Northumberland	19.3	18.9	16.5	14.9	15.1
   	Redcar and Cleveland	18.5	19.7	24.2	21.4	22.0
   	South Tyneside	17.7	17.8	18.2	18.4	17.9
   	Stockton-on-Tees	19.9	15.5	17.5	18.6	19.2
   	Sunderland	21.6	16.5	20.3	18.4	20.8
   North West	Blackburn with Darwen	23.8	21.4	22.2	17.1	17.0
   	Blackpool	19.3	20.8	20.4	18.0	19.7
   	Bolton	19.6	19.5	17.9	20.3	21.5
   	Bury	20.5	20.2	17.6	19.9	18.9
   	Cheshire East	20.2	22.6	19.0	19.2	17.2
   	Cheshire West and Chester	20.4	20.8	18.6	15.9	17.7
   	Cumbria	19.8	14.3	17.7	17.5	17.0
   	Halton	21.0	21.1	21.2	18.5	18.7
   	Knowsley	16.9	17.0	17.9	16.6	18.1
   	Lancashire	15.5	17.8	16.5	16.0	16.0
   	Liverpool	22.3	21.9	22.6	22.8	24.3
   	Manchester	19.1	19.6	19.1	17.8	17.3
   	Oldham	21.0	17.6	16.7	16.1	17.2
   	Rochdale	17.5	18.4	18.6	17.8	19.0
   	Salford	23.1	22.3	21.8	20.8	20.8
   	Sefton	21.7	25.0	22.1	20.4	21.3
   	St. Helens	22.7	21.3	19.9	16.0	18.3
   	Stockport	20.2	20.4	18.4	20.1	21.8
   	Tameside	19.8	17.9	17.8	18.0	19.0
   	Trafford	16.5	19.6	18.8	16.3	16.5
   	Warrington	22.1	17.6	19.1	17.0	17.4
   	Wigan	18.3	14.4	15.8	16.7	17.1
   	Wirral	16.2	17.3	15.5	13.9	15.6
   Yorkshire and The Humber	Barnsley	20.1	19.6	19.3	21.8	24.3
   	Bradford	18.0	16.5	18.8	18.5	17.8
   	Calderdale	13.3	22.7	14.8	14.3	12.7
   	Doncaster	17.3	19.2	17.4	18.7	17.8
   	East Riding of Yorkshire	18.4	17.3	19.5	17.2	19.2
   	Kingston upon Hull, City of	24.5	19.0	17.5	17.9	17.9
   	Kirklees	17.8	15.1	15.4	14.8	16.0
   	Leeds	16.7	13.8	15.3	15.0	16.1
   	North East Lincolnshire	22.9	26.8	32.7	24.9	20.0
   	North Lincolnshire	18.3	16.8	21.9	18.3	16.5
   	North Yorkshire	19.7	17.5	16.3	15.7	15.4
   	Rotherham	15.1	15.7	15.5	17.2	16.0
   	Sheffield	17.8	19.5	17.2	15.1	15.7
   	Wakefield	17.7	21.9	20.0	14.6	15.0
   	York	15.3	17.7	21.8	17.2	16.1
   East Midlands	Derby	18.2	19.7	18.1	17.4	18.3
   	Derbyshire	21.0	19.1	19.6	20.3	17.5
   	Leicester	17.3	16.5	17.1	16.8	17.1
   	Leicestershire	16.6	17.4	17.4	16.8	14.4
   	Lincolnshire	16.8	15.3	15.7	14.9	16.8
   	North Northamptonshire	no data	no data	no data	no data	17.5
   	Northamptonshire	17.7	18.7	18.8	17.7	no data
   	Nottingham	19.1	18.8	17.2	14.9	15.3
   	Nottinghamshire	19.6	17.6	16.8	15.6	14.6
   	Rutland	16.9	14.9	14.7	12.3	8.4
   	West Northamptonshire	no data	no data	no data	no data	z
   West Midlands	Birmingham	14.7	16.0	15.9	16.6	15.5
   	Coventry	16.8	15.1	13.4	17.0	14.7
   	Dudley	20.2	19.9	19.3	19.9	23.2
   	Herefordshire, County of	16.9	16.5	16.2	14.0	16.7
   	Sandwell	16.3	18.0	19.0	20.1	16.0
   	Shropshire	25.1	17.5	17.2	21.2	23.0
   	Solihull	13.2	15.2	15.5	13.7	16.7
   	Staffordshire	26.4	19.0	18.2	18.1	16.8
   	Stoke-on-Trent	22.0	21.1	19.2	17.7	15.9
   	Telford and Wrekin	17.5	22.3	20.1	15.4	13.7
   	Walsall	18.9	19.9	17.1	13.4	13.3
   	Warwickshire	19.5	18.6	17.1	17.0	15.9
   	Wolverhampton	20.0	19.7	16.0	15.1	17.3
   	Worcestershire	19.7	16.9	18.1	18.4	16.4
   East of England	Bedford	18.9	17.4	18.2	15.3	18.2
   	Cambridgeshire	17.5	17.4	14.3	9.7	17.7
   	Central Bedfordshire	15.2	14.5	15.1	13.4	12.3
   	Essex	14.1	14.0	14.2	13.1	12.6
   	Hertfordshire	12.4	12.8	13.7	13.5	13.4
   	Luton	21.3	23.9	17.2	22.6	18.7
   	Norfolk	18.7	19.0	18.4	16.9	16.4
   	Peterborough	16.6	18.0	17.4	14.2	14.7
   	Southend-on-Sea	20.0	15.3	16.3	15.6	15.6
   	Suffolk	17.2	:	16.7	15.0	15.5
   	Thurrock	16.3	19.7	15.5	14.8	13.4
   South East	Bracknell Forest	16.0	13.8	13.2	16.9	17.3
   	Brighton and Hove	16.0	15.8	14.6	14.8	14.6
   	Buckinghamshire	17.2	20.3	19.6	17.2	19.3
   	East Sussex	16.4	16.6	16.3	17.7	16.4
   	Hampshire	22.8	19.0	17.7	17.4	17.7
   	Isle of Wight	21.8	20.2	19.5	18.9	18.8
   	Kent	19.0	16.9	16.3	16.0	16.4
   	Medway	17.6	18.9	20.3	13.3	12.3
   	Milton Keynes	15.7	16.2	18.0	17.1	16.7
   	Oxfordshire	19.1	16.8	16.7	16.8	14.5
   	Portsmouth	16.7	16.2	15.8	14.1	15.7
   	Reading	19.3	18.4	16.7	17.0	17.5
   	Slough	14.6	13.0	17.5	20.1	18.1
   	Southampton	23.9	19.5	17.3	16.9	26.1
   	Surrey	17.6	17.4	14.1	14.9	15.9
   	West Berkshire	15.0	15.7	14.4	13.3	13.5
   	West Sussex	16.0	16.7	16.8	15.0	16.2
   	Windsor and Maidenhead	15.6	17.3	17.4	18.0	17.3
   	Wokingham	16.3	14.3	16.5	15.1	14.7
   South West	Bath and North East Somerset	17.0	14.0	13.8	12.2	13.2
   	Bournemouth	14.9	19.5	no data	no data	no data
   	Bournemouth, Christchurch and Poole	no data	no data	16.2	14.3	14.3
   	Bristol, City of	20.0	17.5	17.2	15.2	13.8
   	Cornwall	16.2	16.2	15.6	16.7	16.2
   	Devon	19.3	19.6	13.1	13.5	17.8
   	Dorset (E10000009)	15.4	18.0	no data	no data	no data
   	Dorset (E06000059)	no data	no data	17.6	14.6	14.1
   	Gloucestershire	16.2	15.6	13.7	14.4	15.0
   	Isles of Scilly	14.5	13.5	16.0	13.0	16.0
   	North Somerset	20.5	15.1	15.0	14.8	15.6
   	Plymouth	20.7	18.2	19.9	21.3	19.5
   	Poole	15.4	13.6	no data	no data	no data
   	Somerset	13.3	15.3	13.7	13.9	11.8
   	South Gloucestershire	20.8	19.5	16.8	17.0	16.6
   	Swindon	20.4	16.5	15.5	12.8	18.0
   	Torbay	21.0	20.4	17.9	20.8	16.6
   	Wiltshire	19.9	21.3	17.0	16.5	17.1
   Inner London	Camden	13.5	14.4	14.7	14.6	16.1
   	City of London	16.3	15.5	16.0	12.3	11.0
   	Hackney	19.4	17.3	17.6	16.4	14.0
   	Hammersmith and Fulham	13.4	12.9	16.1	13.3	14.3
   	Haringey	19.0	18.1	14.8	15.4	15.8
   	Islington	13.2	14.0	13.2	11.4	12.5
   	Kensington and Chelsea	11.9	12.6	12.1	11.3	13.2
   	Lambeth	15.1	15.3	15.1	12.6	13.6
   	Lewisham	15.9	14.4	14.5	15.3	15.1
   	Newham	17.5	17.9	20.0	16.6	15.3
   	Southwark	14.5	15.8	12.3	13.7	14.7
   	Tower Hamlets	19.3	16.4	13.9	14.6	14.2
   	Wandsworth	15.3	17.4	14.6	14.2	9.8
   	Westminster	16.5	12.7	12.8	10.1	13.6
   Outer London	Barking and Dagenham	19.7	18.3	16.3	15.2	17.5
   	Barnet	19.9	17.2	13.7	11.5	12.2
   	Bexley	14.7	13.9	16.0	16.4	14.7
   	Brent	:	14.5	15.3	16.4	16.2
   	Bromley	13.3	14.7	14.3	15.3	13.8
   	Croydon	18.3	16.6	14.7	15.8	14.9
   	Ealing	15.8	14.8	15.2	14.0	13.8
   	Enfield	18.1	16.9	15.8	13.2	17.6
   	Greenwich	15.4	14.0	14.9	14.4	12.1
   	Harrow	18.2	16.6	18.3	19.3	15.8
   	Havering	14.4	16.0	15.8	12.0	18.7
   	Hillingdon	17.2	16.8	15.2	15.0	13.8
   	Hounslow	15.7	17.1	15.8	14.3	15.8
   	Kingston upon Thames	10.2	12.0	13.8	14.7	14.3
   	Merton	15.1	17.7	12.4	16.8	14.4
   	Redbridge	16.1	16.7	17.9	16.5	15.9
   	Richmond upon Thames	no data	no data	no data	no data	z
   	Sutton	12.9	15.9	12.7	13.7	12.4
   	Waltham Forest	17.0	17.1	19.2	16.3	17.3

   Footnotes

   1. Full-time Equivalent (FTE) figures are calculated by aggregating the total number of hours that social workers are contracted to work and dividing by the standard hours for their grade. FTE figures exclude social workers for whom FTE information was missing or not known.
   2. Caseload is calculated as the total number of cases held by FTE social workers (including agency workers) in post at the 30 September divided by the number of FTE social workers (including agency workers) at 30 September that hold one or more cases.

   Save table

   Related information

   • Release type:
   • Publication: Children's social work workforce, Reporting year 2023

   Our statistical practice is regulated by the Office for Statistics Regulation (OSR)