Data set from Children in need

B5 Duration of episodes of need ending in the year to 31 March by local authority, England 2013 to 2021

Not the 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 2021

Data set preview

Table showing first 5 rows, from underlying data
2021Reporting yearNationalE92000001EnglandDuration of ended episode33995016225047.74932014.55352015.74398012.9308709.1
2021Reporting yearRegionalE92000001EnglandE12000001North EastDuration of ended episode18950794041.9303016319016.8294015.518509.7
2021Reporting yearRegionalE92000001EnglandE12000002North WestDuration of ended episode508702329045.8874017.2829016.3605011.944908.8
2021Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The HumberDuration of ended episode392901761044.8672017.1643016.4518013.233408.5
2021Reporting yearRegionalE92000001EnglandE12000004East MidlandsDuration of ended episode250101003040.1433017.3493019.7347013.922609

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. A child can have more than one episode of need throughout the year, but episodes should not overlap.
  3. Data for the year ending 31 March 2021 is not available for Hackney local authority, therefore 2020 data for Hackney has been included in the 2021 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