Data set from Children in need

B5 Duration of episodes of need ending during year to 31 March by local authority

Latest data
Last updated

Episodes of need ending during the year by duration of episode of need.

Data set details

Children's social care
Children in need
Release type
Geographic levels
Local authority, National, Regional
  • 1 year but less than 2 years - number
  • 1 year but less than 2 years - percentage
  • 2 years and over - number
Time period
2013 to 2023

Data set preview

Table showing first 5 rows, from underlying data
2023Reporting yearNationalE92000001EnglandDuration of ended episode36296016908046.65752015.85774015.94403012.1346109.5
2023Reporting yearRegionalE92000001EnglandE12000001North EastDuration of ended episode20880822039.3359017.2381018.2302014.4225010.8
2023Reporting yearRegionalE92000001EnglandE12000002North WestDuration of ended episode505002213043.8944018.7777015.4584011.6532010.5
2023Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The HumberDuration of ended episode409601791043.7736018682016.7510012.537709.2
2023Reporting yearRegionalE92000001EnglandE12000004East MidlandsDuration of ended episode261301092041.8450017.2472018.1342013.125709.8

Variables in this data set

Table showing first 5 of 11 variables
Variable nameVariable description
1_year_less_than_2_years1 year but less than 2 years - number
1_year_less_than_2_years_percent1 year but less than 2 years - percentage
2years+2 years and over - number
2years+_percent2 years and over - percentage
3_months_or_less3 months or less - number


  1. The duration of episode of need ending in the year is calculated as the difference between the referral date and closure date.
  2. Data for the years ending 31 March 2021 and 2022 is not available for Hackney local authority, therefore 2020 data for Hackney has been included in 2021 and 2022 national totals, and regional totals for inner London and London. Refer to the methodology section for more information.

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