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
Published
Last updated
Episodes of need ending during the year by duration of episode of need.

Data set details

Theme
Children's social care
Publication
Children in need
Release type
Number of rows
1,475
Geographic levels
Local authority, National, Regional
Indicators
  • 1 year but less than 2 years - number
  • 1 year but less than 2 years - percentage
  • 2 years and over - number
  • 2 years and over - percentage
  • 3 months or less - number
  • 3 months or less - percentage
  • More than 3 months but less than or equal to 6 months - number
  • More than 3 months but less than or equal to 6 months - percentage
  • More than 6 months but less than 1 year - number
  • More than 6 months but less than 1 year - percentage
  • Number of episodes ending during the year to 31 March
Time period
2013 to 2021

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namecategoryEnded_episodes3_months_or_less3_months_or_less_percentmore_than_3_months_6_monthsmore_than_3_months_6_months_percentmore_than_6_months_less_than_1_yearmore_than_6_months_less_than_1_year_percent1_year_less_than_2_years1_year_less_than_2_years_percent2years+2years+_percent
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 all 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
3_months_or_less_percent3 months or less - percentage
Ended_episodesNumber of episodes ending during the year to 31 March
more_than_3_months_6_monthsMore than 3 months but less than or equal to 6 months - number
more_than_3_months_6_months_percentMore than 3 months but less than or equal to 6 months - percentage
more_than_6_months_less_than_1_yearMore than 6 months but less than 1 year - number
more_than_6_months_less_than_1_year_percentMore than 6 months but less than 1 year - percentage

Footnotes

  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

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/85166251-b9f7-4eb4-a760-d62aa106ac13/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/85166251-b9f7-4eb4-a760-d62aa106ac13/csv")

Contact us

If you have a specific enquiry about B5 Duration of episodes of need ending in the year to 31 March by local authority, England 2013 to 2021 statistics and data:

Children’s Services Statistics Team

Email: cin.stats@education.gov.uk
Contact name: Andy Brook