Education, children’s social care and offending: local authority level dashboard
Academic year 2019/20

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

Data files

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

Filename: ees_table_1_no_pupils.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
-----------  |  ----------------------------------------------
count        |  Number of children in offending or pupil group
indicator    |  indicator
perc         |  Percentage of all pupils in offending group
pupil_group  |  Offending or pupil group


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

Filename: ees_table_2_home_vs_school_la.csv
Geographic levels: Local authority
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name         |  Variable description
--------------------  |  ------------------------------------------------------------------------------------------------------------
count_dif             |  Number of children in offending or pupil group that live and go to school in different local authorities
indicator             |  indicator
perc_dif              |  Percentage of children in offending or pupil group that live and go to school in different local authorities
perc_dif_that_offend  |  Percentage of that live and go to school in different local authorities and also offend
pupil_group           |  Offending or pupil group


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

Filename: ees_table_3_sv_with_prior_offence.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name           |  Variable description
----------------------  |  -----------------------------------------------------------------------------------------------------------------------
count_previous_offence  |  Number of children who had been cautioned or sentenced for an offence prior to their first serious violence offence
count_sv                |  Number of children cautioned or sentenced for a serious violence offence
indicator               |  indicator
perc_previous_offence   |  Percentage of children who had been cautioned or sentenced for an offence prior to their first serious violence offence


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

Filename: ees_table_4_gender_breakdown.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: Gender by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

Variable names and descriptions for this file are provided below:

Variable name                 |  Variable description
----------------------------  |  -------------------------------------------------------------------------
count                         |  Number of children with specified gender by offending and pupil group
gender                        |  Gender
indicator                     |  indicator
perc                          |  Percentage of children with specified gender by offending and pupil group
perc_with_gender_that_offend  |  Percentage of children with specified gender that also offend
pupil_group                   |  Offending or pupil group


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

Filename: ees_table_5_age_at_first_offence.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name         |  Variable description
--------------------  |  -----------------------------------------------------------------------------
age_at_first_offence  |  Age of first offence
count                 |  Number of children with specified age of first offence in offending group
indicator             |  indicator
perc                  |  Percentage of children with specified age of first offence in offending group
pupil_group           |  Offending or pupil group


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

Filename: ees_table_6_ethnicity_major.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                      |  Variable description
---------------------------------  |  -------------------------------------------------------------------------------------
count                              |  Number of children with specified ethnic group major by offending and pupil group
ethnicity_major                    |  Ethnic group major
indicator                          |  indicator
perc                               |  Percentage of children with specified ethnic group major by offending and pupil group
perc_with_major_group_that_offend  |  Percentage of children with specified ethnic group major that also offend
pupil_group                        |  Offending or pupil group


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

Filename: ees_table_7_ethnicity_minor.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                      |  Variable description
---------------------------------  |  -------------------------------------------------------------------------------------
count                              |  Number of children with specified ethnic group minor by offending and pupil group
ethnicity_minor                    |  Ethnic group minor
indicator                          |  indicator
perc                               |  Percentage of children with specified ethnic group minor by offending and pupil group
perc_with_minor_group_that_offend  |  Percentage of children with specified ethnic group minor that also offend
pupil_group                        |  Offending or pupil group


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

Filename: ees_table_8_fsm.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                  |  Variable description
-----------------------------  |  ------------------------------------------------------------------------------------------------
count_eligible_fsm             |  Number of children in offending or pupil group that were ever eligible for free school meals
indicator                      |  indicator
perc_eligible_fsm              |  Percentage of children in offending or pupil group that were ever eligible for free school meals
perc_eligible_fsm_that_offend  |  Percentage of children ever eligible for free school meals that also offended
pupil_group                    |  Offending or pupil group


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

Filename: ees_table_9_ks2_attainment.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: KS2 attainment by offending and pupil groups at local authority and national level, for all pupils matched to KS4 academic year 2017/18.

Variable names and descriptions for this file are provided below:

Variable name                  |  Variable description
-----------------------------  |  --------------------------------------------------------------------------------
count_at_benchmark             |  Number of children with specified KS2 benchmark by offending and pupil group
indicator                      |  indicator
ks2_benchmark                  |  KS2 benchmark
perc_at_benchmark              |  Percentage of children with specified KS2 benchmark by offending and pupil group
perc_at_benchmark_that_offend  |  Percentage of children with specified KS2 benchmark that also offend
pupil_group                    |  Offending or pupil group


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

Filename: ees_table_10_ks4_attainment.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                  |  Variable description
-----------------------------  |  --------------------------------------------------------------------------------
count_at_benchmark             |  Number of children with specified KS4 benchmark by offending and pupil group
indicator                      |  indicator
ks4_benchmark                  |  KS4 benchmark
perc_at_benchmark              |  Percentage of children with specified KS4 benchmark by offending and pupil group
perc_at_benchmark_that_offend  |  Percentage of children with specified KS4 benchmark that also offend
pupil_group                    |  Offending or pupil group


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

Filename: ees_table_11_persistent_absence.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                  |  Variable description
-----------------------------  |  ---------------------------------------------------------------------------------
absence_type                   |  Persistent absence reason
count_with_absence             |  Number of children with specified absence reason by offending and pupil group
indicator                      |  indicator
perc_with_absence              |  Percentage of children with specified absence reason by offending and pupil group
perc_with_absence_that_offend  |  Percentage of children with specified absence reason that also offend
pupil_group                    |  Offending or pupil group


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

Filename: ees_table_12_persistent_absence_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name              |  Variable description
-------------------------  |  ----------------------------------------------------------------------------------------------------------
absence_type               |  Persistent type
count_with_absence_timing  |  Number of children cautioned or sentenced for a serious violence offence with specified absence timing
indicator                  |  indicator
perc_with_absence_timing   |  Percentage of children cautioned or sentenced for a serious violence offence with specified absence timing
timing                     |  Persistent absence timing relative to first serious violence offence


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

Filename: ees_table_13_exclusions.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                         |  Variable description
------------------------------------  |  ---------------------------------------------------------------------------------
count_with_exclusion_type             |  Number of children with specified exclusion type by offending and pupil group
exclusion_type                        |  Exclusion type
indicator                             |  indicator
perc_with_exclusion_type              |  Percentage of children with specified exclusion type by offending and pupil group
perc_with_exclusion_type_that_offend  |  Percentage of children with specified exclusion type that also offend
pupil_group                           |  Offending or pupil group


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

Filename: ees_table_14_exclusions_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                     |  Variable description
--------------------------------  |  -------------------------------------------------------------------------------------------------------------
count_with_exclusion_type_timing  |  Number of children cautioned or sentenced for a serious violence with specified exclusion type and timing
exclusion_type                    |  Exclusion type
first_or_closest                  |  First or closest exclusion type relative to first serious violence offence
grouped_overall                   |  Time period between events
indicator                         |  indicator
perc_with_exclusion_type_timing   |  Percentage of children cautioned or sentenced for a serious violence with specified exclusion type and timing
time_group                        |  Order of events


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

Filename: ees_table_15_alternative_provision.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name             |  Variable description
------------------------  |  ------------------------------------------------------------------------------------------------
count_ever_ap             |  Number of children that had ever attended alternative provision by offending and pupil group
indicator                 |  indicator
perc_ever_ap              |  Percentage of children that had ever attended alternative provision by offending and pupil group
perc_ever_ap_that_offend  |  Percentage of children that had ever attended alternative provision that also offend
pupil_group               |  Offending or pupil group


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

Filename: ees_table_16_alternative_provision_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name         |  Variable description
--------------------  |  --------------------------------------------------------------------------------------------------------------
count_with_ap_timing  |  Number of children cautioned or sentenced for a serious violence offence with alternative provision timing
indicator             |  indicator
perc_with_ap_timing   |  Percentage of children cautioned or sentenced for a serious violence offence with alternative provision timing
timing_of_ap          |  Alternative provision timing relative to first serious violence offence


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

Filename: ees_table_17_sen.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                   |  Variable description
------------------------------  |  ------------------------------------------------------------------------
counts_with_sen_type            |  Number of children with SEN status by offending and pupil group
indicator                       |  indicator
perc_with_sen_type              |  Percentage of children with SEN status by offending and pupil group
perc_with_sen_type_that_offend  |  Percentage of children with SEN status that also offend
pupil_group                     |  Offending or pupil group
sen_status                      |  Special education needs (SEN) status of pupils whose SEN status is known


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

Filename: ees_table_18_sen_types.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                   |  Variable description
------------------------------  |  -----------------------------------------------------------------
count_with_sen_type             |  Number of children with SEN type by offending and pupil group
indicator                       |  indicator
perc_with_sen_type              |  Percentage of children with SEN type by offending and pupil group
perc_with_sen_type_that_offend  |  Percentage of children with SEN type that also offend
pupil_group                     |  Offending or pupil group
sen_type                        |  SEN type


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

Filename: ees_table_19_sen_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name          |  Variable description
---------------------  |  --------------------------------------------------------------------------------------------
count_with_sen_timing  |  Number of children cautioned or sentenced for a serious violence offence with SEN timing
indicator              |  indicator
perc_with_sen_timing   |  Percentage of children cautioned or sentenced for a serious violence offence with SEN timing
sen_status             |  Special education needs (SEN) status of pupils whose SEN status is known
timing                 |  First SEN/EHC plan timing relative to their first serious violence offence


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

Filename: ees_table_20_semh_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name           |  Variable description
----------------------  |  -----------------------------------------------------------------------------------------------------------------
count_with_semh_timing  |  Number of children cautioned or sentenced for a serious violence offence with SEMH timing
indicator               |  indicator
perc_with_semh_timing   |  Percentage of children cautioned or sentenced for a serious violence offence with SEMH timing
timing                  |  First record of social, emotional and mental health needs (SEMH) relative to their first serious violence offence


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

Filename: ees_table_21_cin_cla.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name                    |  Variable description
-------------------------------  |  ------------------------------------------------------------------------------------------------------------
count_with_csc_class             |  Number of children recorded as being CSC classification by offending and pupil group
csc_class                        |  Children's social care (CSC) classification - Children in need (CIN) and Children who are looked after (CLA)
indicator                        |  indicator
perc_with_csc_class              |  Percentage of children recorded as being CSC classification by offending and pupil group
perc_with_csc_class_that_offend  |  Percentage of children recoded as being CSC classificatio that also offend
pupil_group                      |  Offending or pupil group


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

Filename: ees_table_22_csc_timing.csv
Geographic levels: Local authority; National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name          |  Variable description
---------------------  |  -----------------------------------------------------------------------------------------------------------------------------------------
count_with_csc_timing  |  Number of children cautioned or sentenced for a serious violence offence with CSC timing
csc_class              |  Children's social care (CSC) classification - Children in need (CIN), Children who are looked after (CLA) and Child protection plan (CPP)
indicator              |  indicator
perc_with_csc_timing   |  Percentage of children cautioned or sentenced for a serious violence offence with CSC timing
timing                 |  CSC classification relative to first serious violence offence


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

Filename: ees_england_key_finding_perc_sv.csv
Geographic levels: National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
----  |  ----------------------------------------------------------------------------
perc  |  Proportion of children cautioned or sentenced for a serious violence offence


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

Filename: ees_key_finding_perc_sv_with_prior_offence.csv
Geographic levels: National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
----  |  -----------------------------------------------------------------------------------------------------------
perc  |  Proportion of children cautioned or sentenced for any offence prior to their first serious violence offence


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

Filename: ees_key_finding_perc_sv_that_were_excluded.csv
Geographic levels: National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
----  |  ----------------------------------------------------------------------------------------------------------
perc  |  Proportion of children cautioned or sentenced for a serious violence offence and ever permanently excluded


Period between school exclusions and serious violence offence in England

Filename: ees_key_finding_perc_sv_with_excl_timing.csv
Geographic levels: National
Time period: 2019/20
Content summary: Period between school exclusions and serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
----  |  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
perc  |  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


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

Filename: ees_key_finding_perc_sv_known_to_csc.csv
Geographic levels: National
Time period: 2019/20
Content summary: 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.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
----  |  ---------------------------------------------------------------------------------------------------------------------
perc  |  Proportion of children cautioned or sentenced for a serious violence offence and ever known to children's social care


Peak age of first serious violence offence in England

Filename: ees_key_finding_peak_age_first_sv_offence.csv
Geographic levels: National
Time period: 2019/20
Content summary: Peak age of first serious violence offence in England, for all pupils matched to KS4 academic year 2012/13 - 2017/18.

Variable names and descriptions for this file are provided below:

Variable name  |  Variable description
---  |  ------------------------------------------
age  |  Peak age of first serious violence offence
