Academic year 2019/20

Education, children’s social care and offending: local authority level dashboard

An examination of the education, children's social care background of children cautioned or sentenced for offences at national and local authority level. 

Get email alerts

Latest releaseAll releases in this series

Download all data (ZIP)Create your own tables

• Produced by: Department for Education
• Published: 30 March 2023

On this page

Skip in page navigation

Explore data used in this release

This page provides a range of routes to access data from within this statistical release to suit different users.

Download all data (ZIP)

This includes all data sets, guidance files and any supporting files

More options

• Data sets: download or create tables

  Data sets present comprehensive open data from which users can create their own tables using the EES table tool or download a zipped CSV file.

• Data dashboards

  Data dashboards provide an alternative route to explore a statistical release's data, presenting key statistics and further insights, often via graphical visualisations.

• Data guidance

  Description of the data sets included in this release, including information on data sources, coverage, quality and any data conventions used.

• Data catalogue

  Alternatively use our data catalogue to search and filter for specific data sets from this release or our entire library, providing full data summaries, data previews and access to API data sets.

---

Data sets: download or create tables

Data sets present comprehensive open data from which users can create their own tables using the EES table tool or download a zipped CSV file.

28 data sets available for download

Download all (ZIP)

• Number of children within offending and pupil groups at local authority and national level

  Local authority, National

  Number and percentage of children within offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 906
  • Indicators:
    • Number of children in offending or pupil group
    • Percentage of all pupils in offending group
  • Filters:
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Number of children who live and go to school in a different local authority

  Local authority

  Number and percentage of children who live and go to school in a different local authority, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 900
  • Indicators:
    • Number of children in offending or pupil group that live and go to school in different local authorities
    • Percentage of children in offending or pupil group that live and go to school in different local authorities
    • Percentage of that live and go to school in different local authorities and also offend
  • Filters:
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Number of children cautioned or sentenced for an offence prior to their first serious violence offence at local authority and national level

  Local authority, National

  Number and percentage of children cautioned or sentenced for an offence prior to their first serious violence offence at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 302
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence
    • Number of children who had been cautioned or sentenced for an offence prior to their first serious violence offence
    • Percentage of children who had been cautioned or sentenced for an offence prior to their first serious violence offence
  • Filters:
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Gender by offending and pupil groups at local authority and national level

  Local authority, National

  Gender by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1,812
  • Indicators:
    • Number of children with specified gender by offending and pupil group
    • Percentage of children with specified gender by offending and pupil group
    • Percentage of children with specified gender that also offend
  • Filters:
    • Gender
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Age at first offence by offending and pupil groups at local authority and national level

  Local authority, National

  Age at first offence by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 5,436
  • Indicators:
    • Number of children with specified age of first offence in offending group
    • Percentage of children with specified age of first offence in offending group
  • Filters:
    • Age of first offence
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Ethnic group major by offending and pupil groups at local authority and national level

  Local authority, National

  Ethnic group major by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 6,342
  • Indicators:
    • Number of children with specified ethnic group major by offending and pupil group
    • Percentage of children with specified ethnic group major by offending and pupil group
    • Percentage of children with specified ethnic group major that also offend
  • Filters:
    • Ethnic group major
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Ethnic group minor by offending and pupil groups at local authority and national level

  Local authority, National

  Ethnic group minor by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 18,120
  • Indicators:
    • Number of children with specified ethnic group minor by offending and pupil group
    • Percentage of children with specified ethnic group minor by offending and pupil group
    • Percentage of children with specified ethnic group minor that also offend
  • Filters:
    • Ethnic group minor
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Free school meal (FSM) eligibility by offending and pupil groups at local authority and national level

  Local authority, National

  Free school meal (FSM) eligibility by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 906
  • Indicators:
    • Number of children in offending or pupil group that were ever eligible for free school meals
    • Percentage of children ever eligible for free school meals that also offended
    • Percentage of children in offending or pupil group that were ever eligible for free school meals
  • Filters:
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• KS2 attainment by offending and pupil groups at local authority and national level - for pupils matched to KS2 academic year 201213 only

  Local authority, National

  KS2 attainment by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2017/18.

  • Number of rows: 3,624
  • Indicators:
    • Number of children with specified KS2 benchmark by offending and pupil group
    • Percentage of children with specified KS2 benchmark by offending and pupil group
    • Percentage of children with specified KS2 benchmark that also offend
  • Filters:
    • KS2 benchmark
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• KS4 attainment by offending and pupil groups at local authority and national level

  Local authority, National

  KS4 attainment by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 2,718
  • Indicators:
    • Number of children with specified KS4 benchmark by offending and pupil group
    • Percentage of children with specified KS4 benchmark by offending and pupil group
    • Percentage of children with specified KS4 benchmark that also offend
  • Filters:
    • KS4 benchmark
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Persistent absence by offending and pupil groups at local authority and national level

  Local authority, National

  Persistent absence by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 14,496
  • Indicators:
    • Number of children with specified absence reason by offending and pupil group
    • Percentage of children with specified absence reason by offending and pupil group
    • Percentage of children with specified absence reason that also offend
  • Filters:
    • Offending or pupil group
    • Persistent absence reason
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Timing of serious violence offence for children who had been persistently absent at local authority and national level

  Local authority, National

  Timing of serious violence offence for children who had been persistently absent at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1,812
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence with specified absence timing
    • Percentage of children cautioned or sentenced for a serious violence offence with specified absence timing
  • Filters:
    • Persistent absence timing relative to first serious violence offence
    • Persistent type
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• School exclusions by offending and pupil groups at local authority and national level

  Local authority, National

  School exclusions by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1,812
  • Indicators:
    • Number of children with specified exclusion type by offending and pupil group
    • Percentage of children with specified exclusion type by offending and pupil group
    • Percentage of children with specified exclusion type that also offend
  • Filters:
    • Exclusion type
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Period between school exclusions and serious violence offence at local authority and national level

  Local authority, National

  Period between school exclusions and serious violence offence at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 18,120
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence with specified exclusion type and timing
    • Percentage of children cautioned or sentenced for a serious violence with specified exclusion type and timing
  • Filters:
    • Exclusion type
    • First or closest exclusion type relative to first serious violence offence
    • Order of events
  • Time period: 2019/20

  Data set information page
  Create table

• Alternative provision by offending and pupil groups at local authority and national level

  Local authority, National

  Alternative provision by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 906
  • Indicators:
    • Number of children that had ever attended alternative provision by offending and pupil group
    • Percentage of children that had ever attended alternative provision by offending and pupil group
    • Percentage of children that had ever attended alternative provision that also offend
  • Filters:
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Timing of serious violence offence for children registered at alternative provision at local authority and national level

  Local authority, National

  Timing of serious violence offence for children registered at alternative provision at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 906
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence with alternative provision timing
    • Percentage of children cautioned or sentenced for a serious violence offence with alternative provision timing
  • Filters:
    • Alternative provision timing relative to first serious violence offence
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Special educational needs (SEN) by offending and pupil groups at local authority and national level

  Local authority, National

  Special educational needs (SEN) by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 2,718
  • Indicators:
    • Number of children with SEN status by offending and pupil group
    • Percentage of children with SEN status by offending and pupil group
    • Percentage of children with SEN status that also offend
  • Filters:
    • Offending or pupil group
    • Special education needs (SEN) status of pupils whose SEN status is known
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Types of special educational needs (SEN) by offending and pupil groups at local authority and national level

  Local authority, National

  Types of special educational needs (SEN) by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 10,872
  • Indicators:
    • Number of children with SEN type by offending and pupil group
    • Percentage of children with SEN type by offending and pupil group
    • Percentage of children with SEN type that also offend
  • Filters:
    • Offending or pupil group
    • SEN type
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Timing of serious violence offence for children recorded with special educational needs (SEN) at local authority and national level

  Local authority, National

  Timing of serious violence offence for children recorded with special educational needs (SEN) at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1,812
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence with SEN timing
    • Percentage of children cautioned or sentenced for a serious violence offence with SEN timing
  • Filters:
    • First SEN/EHC plan timing relative to their first serious violence offence
    • Special education needs (SEN) status of pupils whose SEN status is known
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Timing of serious violence offence for children recorded with social, emotional and mental health needs (SEMH) at local authority and national level

  Local authority, National

  Timing of serious violence offence for children recorded with social, emotional and mental health needs (SEMH) at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 906
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence with SEMH timing
    • Percentage of children cautioned or sentenced for a serious violence offence with SEMH timing
  • Filters:
    • First record of social, emotional and mental health needs (SEMH) relative to their first serious violence offence
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Children in need (CIN) and children who are looked after (CLA) by offending and pupil groups at local authority and national level

  Local authority, National

  Children in need (CIN) and children who are looked after (CLA) by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1,812
  • Indicators:
    • Number of children recorded as being CSC classification by offending and pupil group
    • Percentage of children recoded as being CSC classificatio that also offend
    • Percentage of children recorded as being CSC classification by offending and pupil group
  • Filters:
    • Children's social care (CSC) classification - Children in need (CIN) and Children who are looked after (CLA)
    • Offending or pupil group
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Timing of serious violence offence for children in need, children who are looked after or children on child protection plan at local authority and national level

  Local authority, National

  Timing of serious violence offence for children in need, children who are looked after or children on child protection plan at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 2,718
  • Indicators:
    • Number of children cautioned or sentenced for a serious violence offence with CSC timing
    • Percentage of children cautioned or sentenced for a serious violence offence with CSC timing
  • Filters:
    • CSC classification relative to first serious violence offence
    • Children's social care (CSC) classification - Children in need (CIN), Children who are looked after (CLA) and Child protection plan (CPP)
    • indicator
  • Time period: 2019/20

  Data set information page
  Create table

• Percentage of children cautioned or sentenced for a serious violence offence in England

  National

  Percentage of children cautioned or sentenced for a serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Proportion of children cautioned or sentenced for a serious violence offence
  • Time period: 2019/20

  Data set information page
  Create table

• Percentage of children cautioned or sentenced for any offence prior to their first serious violence offence in England

  National

  Percentage of children cautioned or sentenced for any offence prior to their first serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Proportion of children cautioned or sentenced for any offence prior to their first serious violence offence
  • Time period: 2019/20

  Data set information page
  Create table

• Percentage of children cautioned or sentenced for a serious violence offence and permanently excluded in England

  National

  Percentage of children cautioned or sentenced for a serious violence offence and permanently excluded in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Proportion of children cautioned or sentenced for a serious violence offence and ever permanently excluded
  • Time period: 2019/20

  Data set information page
  Create table

• Period between school exclusions and serious violence offence in England

  National

  Period between school exclusions and serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Proportion of children cautioned or sentenced for a serious violence offence and ever permanently excluded who received their first permanent exclusion after their first serious violence offence
  • Time period: 2019/20

  Data set information page
  Create table

• Percentage of children cautioned or sentenced for a serious violence offence and known to children's social care in England

  National

  Percentage of children cautioned or sentenced for a serious violence offence and known to children's social care in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Proportion of children cautioned or sentenced for a serious violence offence and ever known to children's social care
  • Time period: 2019/20

  Data set information page
  Create table

• Peak age of first serious violence offence in England

  National

  Peak age of first serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

  • Number of rows: 1
  • Indicators:
    • Peak age of first serious violence offence
  • Time period: 2019/20

  Data set information page
  Create table

---

Data dashboards

Data dashboards provide an alternative route to explore a statistical release's data, presenting key statistics and further insights, often via graphical visualisations.

Education, children's social care and offending: local authority level dashboard  (opens in new tab)

The dashboard differs from the previously published figures (opens in new tab) as it provides descriptive analysis for an additional 3 cohorts of children due to the update of the DfE-MoJ data share. This release covers offending data up to the end of 2020 and education data up to the end of the 2019/20 academic year. Additionally, this is the first time that the matched dataset has been used to provide local authority level breakdowns, for each local authority in England, where possible.

To view the underlying data used to build the dashboard please see “Explore data and files” section of this page. 

---

Data guidance

Description of the data sets included in this release, including information on data sources, coverage, quality and any data conventions used.

Description

This document describes the data included in the Education, children's social care and offending: local authority level dashboard's underlying data files. 

Coverage

This release covers cohorts of children who finished key stage 2 (KS2) in 2007/08 - 2012/13, and were aged 10 at the start of these academic years. Therefore, this cohort has a key stage 4 (KS4) academic year of 2012/13 - 2017/18.

The second iteration of the DfE-MoJ data share that was completed in 2022 was used in this analysis. It includes offending data up to the end of 2020 and education data up to end of the 2019/20 academic year. 

File formats and conventions

Rounding  

Percentages have been rounded to 1 decimal place (1dp).

Conventions

The following convention is used throughout the underlying data.

‘z’ Not applicable 

‘c’ Confidential data 

---

Contact us

If you have a specific enquiry about Education, children’s social care and offending: local authority level dashboard statistics and data:

Serious Violence Research and Analysis

Email: SV.RESEARCH@EDUCATION.GOV.UK
Contact name: Serious Violence Research and Analysis
Telephone: 02076546001  

Press office

If you have a media enquiry:

Telephone: 020 7783 8300

Public enquiries

If you have a general enquiry about the Department for Education (DfE) or education:

Phone: 0370 000 2288

Opening times

Monday to Friday from 9.30am to 5.30pm (closed on bank holidays)