Data set from Children in need

B4 Children in need by duration of episode and local authority

Not the latest data
Last updated

Children in need 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 2022

Data set preview

Table showing first 5 rows, from underlying data
2022Reporting yearNationalE92000001EnglandDuration of open episode40431011061027.44649011.55464013.55411013.413846034.2
2022Reporting yearRegionalE92000001EnglandE12000001North EastDuration of open episode25120676026.9297011.8339013.5334013.3866034.5
2022Reporting yearRegionalE92000001EnglandE12000002North WestDuration of open episode603901504024.9613010.2748012.4793013.12381039.4
2022Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The HumberDuration of open episode416001197028.8535012.8564013.6561013.51304031.3
2022Reporting yearRegionalE92000001EnglandE12000004East MidlandsDuration of open episode28820799027.7358012.4418014.5413014.3894031

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 episodes open at 31 March is calculated as the difference between 31 March of the reporting year and the referral 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