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: 1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence)

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2017 to 2023

5. Step 5

   • Indicators:
     • Vacancies - FTE (as at 30 September)
     • Vacancy rate - FTE (as at 30 September)
     • Vacancy agency worker cover rate - FTE (as at 30 September)

6. Step 6 Explore data

   This is the latest data

   '1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence)' in England between 2017 and 2023

   	2017	2018	2019	2020	2021	2022	2023
   Vacancies - FTE (as at 30 September)	5,822.6	5,812.4	6,036.6	6,112.6	6,521.9	7,912.9	7,722.7
   Vacancy rate - FTE (as at 30 September)	17.0%	16.5%	16.4%	16.1%	16.7%	20.0%	18.9%
   Vacancy agency worker cover rate - FTE (as at 30 September)	67.5%	72.3%	73.1%	74.1%	69.9%	68.8%	74.4%

   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. The vacancy rate, as at 30 September, is calculated as FTE vacancies divided by the sum of FTE vacancies and FTE social workers.

   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)