Data set from Children's social work workforce: attrition, caseload, and agency workforce

Time between roles - all movers

Latest data
Last updated

Breakdown of the number of days between social workers leaving one role and starting their next role, for Social Workers who left their role in the year ending 30 September 2021.

Data set details

Children's social care
Children's social work workforce: attrition, caseload, and agency workforce
Release type
Geographic levels
  • Cumulative FTE
  • Cumulative proportion of total FTE
  • FTE
  • Days between roles
Time period

Data set preview

Table showing first 5 rows, from underlying data
National2021Reporting yearE92000001England038.838.83.4
National2021Reporting yearE92000001England1573.3612.153.6
National2021Reporting yearE92000001England247.4659.557.7
National2021Reporting yearE92000001England3132.1791.669.3
National2021Reporting yearE92000001England432.1823.772.1

Variables in this data set

Table showing all 4 variables
Variable nameVariable description
cumulative_fte_countCumulative FTE
cumulative_percentage_daysCumulative proportion of total FTE
daysDays between roles


  1. There were 250 FTE social workers whose new role was recorded as starting before they left their original role. These social workers have been excluded from the figures.
  2. Time between roles is calculated as the time in days (including weekends and bank holidays) between a social worker leaving a role and starting a new role. For example, if a leaver ended a role on a Friday and started new role on a Monday, the time between roles is calculated as 3 days. If a leaver started their new role on the same day that they left their previous role, time between roles calculated as zero days.
  3. There were 50 FTE social workers who left their role on 30 September 2021. These workers have been excluded from the figures, as in each case their time between roles would be calculated as 0 days.
  4. Components may not sum to totals due to rounding.

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool