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: attrition, caseload, and agency workforce

2. Step 2

   • Data set: Agency rates

3. Step 3

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

4. Step 4

   • Time period: 2021

5. Step 5

   • Indicators:
     • Agency-employed Social Worker FTE
     • LA-employed Social Worker FTE
     • Agency Rate
     • Agency Rate Group

6. Step 6 Explore data

   This is the latest data

   'Agency rates' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2021

   	2021
   	Agency-employed Social Worker FTE	LA-employed Social Worker FTE	Agency Rate	Agency Rate Group
   Barking and Dagenham	49.0	193.6	20.2%	20+ - 30%
   Barnet	73.0	161.7	31.1%	30% and Over
   Barnsley	1.0	150.6	0.7%	0+ - 10%
   Bath and North East Somerset	8.0	97.2	7.6%	0+ - 10%
   Bedford	19.0	98.5	16.2%	10+ - 20%
   Bexley	22.0	187.3	10.5%	10+ - 20%
   Birmingham	155.3	693.7	18.3%	10+ - 20%
   Blackburn with Darwen	11.8	132.5	8.2%	0+ - 10%
   Blackpool	31.0	172.7	15.2%	10+ - 20%
   Bolton	39.6	160.9	19.8%	10+ - 20%
   Bournemouth, Christchurch and Poole	118.4	198.4	37.4%	30% and Over
   Bracknell Forest	6.0	63.9	8.6%	0+ - 10%
   Bradford	210.1	336.0	38.5%	30% and Over
   Brent	88.0	152.1	36.7%	30% and Over
   Brighton and Hove	0.0	226.9	0.0%	0%
   Bristol, City of	6.2	295.0	2.1%	0+ - 10%
   Bromley	41.0	188.0	17.9%	10+ - 20%
   Buckinghamshire	107.0	213.6	33.4%	30% and Over
   Bury	44.8	102.4	30.4%	30% and Over
   Calderdale	14.0	148.4	8.6%	0+ - 10%
   Cambridgeshire	33.1	221.1	13.0%	10+ - 20%
   Camden	29.2	185.6	13.6%	10+ - 20%
   Central Bedfordshire	13.3	164.3	7.5%	0+ - 10%
   Cheshire East	15.0	180.1	7.7%	0+ - 10%
   Cheshire West and Chester	15.6	183.0	7.8%	0+ - 10%
   City of London	4.0	10.0	28.6%	20+ - 30%
   Cornwall	13.2	244.7	5.1%	0+ - 10%
   County Durham	31.0	323.9	8.7%	0+ - 10%
   Coventry	71.0	320.7	18.1%	10+ - 20%
   Croydon	53.0	294.4	15.3%	10+ - 20%
   Cumbria	40.9	247.5	14.2%	10+ - 20%
   Darlington	10.8	91.3	10.6%	10+ - 20%
   Derby	21.0	152.0	12.1%	10+ - 20%
   Derbyshire	32.5	424.8	7.1%	0+ - 10%
   Devon	89.0	319.5	21.8%	20+ - 30%
   Doncaster	37.0	190.9	16.2%	10+ - 20%
   Dorset	30.0	206.6	12.7%	10+ - 20%
   Dudley	40.5	161.3	20.1%	20+ - 30%
   Ealing	87.3	197.5	30.7%	30% and Over
   East Riding of Yorkshire	13.8	150.9	8.4%	0+ - 10%
   East Sussex	1.0	331.3	0.3%	0+ - 10%
   Enfield	28.7	184.1	13.5%	10+ - 20%
   Essex	24.9	868.2	2.8%	0+ - 10%
   Gateshead	7.0	160.2	4.2%	0+ - 10%
   Gloucestershire	113.0	360.7	23.9%	20+ - 30%
   Greenwich	20.5	224.5	8.4%	0+ - 10%
   Hackney	53.0	190.6	21.8%	20+ - 30%
   Halton	28.0	74.8	27.2%	20+ - 30%
   Hammersmith and Fulham	20.0	135.5	12.9%	10+ - 20%
   Hampshire	116.9	503.9	18.8%	10+ - 20%
   Haringey	60.0	188.7	24.1%	20+ - 30%
   Harrow	35.2	134.5	20.7%	20+ - 30%
   Hartlepool	1.0	127.7	0.8%	0+ - 10%
   Havering	25.0	112.2	18.2%	10+ - 20%
   Herefordshire, County of	49.8	103.3	32.5%	30% and Over
   Hertfordshire	24.0	490.6	4.7%	0+ - 10%
   Hillingdon	46.0	154.1	23.0%	20+ - 30%
   Hounslow	32.0	155.0	17.1%	10+ - 20%
   Isle of Wight	22.0	76.1	22.4%	20+ - 30%
   Isles of Scilly	1.0	z	0.0%	0%
   Islington	53.0	265.8	16.6%	10+ - 20%
   Kensington and Chelsea	0.0	139.9	0.0%	0%
   Kent	85.0	691.0	11.0%	10+ - 20%
   Kingston upon Hull, City of	56.3	297.2	15.9%	10+ - 20%
   Kingston upon Thames	22.0	138.5	13.7%	10+ - 20%
   Kirklees	0.0	281.7	0.0%	0%
   Knowsley	12.9	104.9	11.0%	10+ - 20%
   Lambeth	87.8	188.1	31.8%	30% and Over
   Lancashire	50.4	459.9	9.9%	0+ - 10%
   Leeds	0.0	647.9	0.0%	0%
   Leicester	43.0	163.9	20.8%	20+ - 30%
   Leicestershire	56.0	286.3	16.4%	10+ - 20%
   Lewisham	53.0	168.9	23.9%	20+ - 30%
   Lincolnshire	34.7	303.9	10.2%	10+ - 20%
   Liverpool	34.0	324.6	9.5%	0+ - 10%
   Luton	65.7	146.5	30.9%	30% and Over
   Manchester	14.0	443.8	3.1%	0+ - 10%
   Medway	48.5	195.0	19.9%	10+ - 20%
   Merton	47.0	93.8	33.4%	30% and Over
   Middlesbrough	70.0	173.5	28.7%	20+ - 30%
   Milton Keynes	18.0	165.2	9.8%	0+ - 10%
   Newcastle upon Tyne	13.0	246.4	5.0%	0+ - 10%
   Newham	142.0	151.5	48.4%	30% and Over
   Norfolk	35.0	444.1	7.3%	0+ - 10%
   North East Lincolnshire	54.0	92.3	36.9%	30% and Over
   North Lincolnshire	3.6	115.4	3.0%	0+ - 10%
   North Northamptonshire	116.0	329.9	26.0%	20+ - 30%
   North Somerset	4.5	85.1	5.0%	0+ - 10%
   North Tyneside	2.0	151.6	1.3%	0+ - 10%
   North Yorkshire	0.0	281.9	0.0%	0%
   Northumberland	21.0	189.9	10.0%	0+ - 10%
   Nottingham	23.9	267.5	8.2%	0+ - 10%
   Nottinghamshire	78.3	471.4	14.2%	10+ - 20%
   Oldham	60.0	179.6	25.0%	20+ - 30%
   Oxfordshire	63.0	394.6	13.8%	10+ - 20%
   Peterborough	9.0	129.5	6.5%	0+ - 10%
   Plymouth	25.0	162.8	13.3%	10+ - 20%
   Portsmouth	7.0	133.6	5.0%	0+ - 10%
   Reading	32.0	102.3	23.8%	20+ - 30%
   Redbridge	22.6	165.3	12.0%	10+ - 20%
   Redcar and Cleveland	17.0	105.1	13.9%	10+ - 20%
   Richmond upon Thames	z	z	z	z
   Rochdale	38.2	162.5	19.0%	10+ - 20%
   Rotherham	17.4	239.1	6.8%	0+ - 10%
   Rutland	0.0	21.7	0.0%	0%
   Salford	25.0	228.8	9.9%	0+ - 10%
   Sandwell	96.0	208.3	31.5%	30% and Over
   Sefton	38.2	155.2	19.8%	10+ - 20%
   Sheffield	64.2	399.2	13.9%	10+ - 20%
   Shropshire	32.0	131.2	19.6%	10+ - 20%
   Slough	62.0	89.4	40.9%	30% and Over
   Solihull	23.0	107.9	17.6%	10+ - 20%
   Somerset	24.9	270.8	8.4%	0+ - 10%
   South Gloucestershire	38.1	121.5	23.9%	20+ - 30%
   South Tyneside	3.0	131.3	2.2%	0+ - 10%
   Southampton	45.7	208.0	18.0%	10+ - 20%
   Southend-on-Sea	18.0	121.0	13.0%	10+ - 20%
   Southwark	122.6	284.8	30.1%	30% and Over
   St. Helens	30.0	143.3	17.3%	10+ - 20%
   Staffordshire	54.1	388.1	12.2%	10+ - 20%
   Stockport	17.5	237.5	6.9%	0+ - 10%
   Stockton-on-Tees	33.3	151.2	18.1%	10+ - 20%
   Stoke-on-Trent	51.0	277.0	15.6%	10+ - 20%
   Suffolk	14.0	378.4	3.6%	0+ - 10%
   Sunderland	3.3	249.2	1.3%	0+ - 10%
   Surrey	142.8	455.6	23.9%	20+ - 30%
   Sutton	40.0	120.5	24.9%	20+ - 30%
   Swindon	82.0	138.2	37.2%	30% and Over
   Tameside	44.0	178.8	19.8%	10+ - 20%
   Telford and Wrekin	4.0	156.1	2.5%	0+ - 10%
   Thurrock	39.0	159.7	19.6%	10+ - 20%
   Torbay	46.4	102.4	31.2%	30% and Over
   Tower Hamlets	86.4	259.4	25.0%	20+ - 30%
   Trafford	63.6	93.6	40.4%	30% and Over
   Wakefield	42.2	254.8	14.2%	10+ - 20%
   Walsall	23.0	218.5	9.5%	0+ - 10%
   Waltham Forest	61.0	141.4	30.1%	30% and Over
   Wandsworth	48.6	206.3	19.1%	10+ - 20%
   Warrington	12.8	128.4	9.1%	0+ - 10%
   Warwickshire	37.0	422.5	8.1%	0+ - 10%
   West Berkshire	16.0	80.7	16.5%	10+ - 20%
   West Northamptonshire	z	z	z	z
   West Sussex	71.2	480.0	12.9%	10+ - 20%
   Westminster	1.0	135.9	0.7%	0+ - 10%
   Wigan	67.0	209.0	24.3%	20+ - 30%
   Wiltshire	10.0	214.5	4.5%	0+ - 10%
   Windsor and Maidenhead	20.0	54.2	26.9%	20+ - 30%
   Wirral	44.0	237.4	15.6%	10+ - 20%
   Wokingham	15.0	87.1	14.7%	10+ - 20%
   Wolverhampton	22.0	198.3	10.0%	0+ - 10%
   Worcestershire	42.1	262.5	13.8%	10+ - 20%
   York	28.3	100.9	21.9%	20+ - 30%

   Footnotes

   1. Components may not sum to totals due to rounding.
   2. Kingston upon Thames and Richmond upon Thames submit a joint return each year, and the numbers are reported against Kingston upon Thames. This arrangement has no impact on regional and national totals.

   Save table

   Related information

   • Release type:
   • Publication: Children's social work workforce: attrition, caseload, and agency workforce, Reporting year 2021

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