Academic year 2019/20

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

Data guidance

Published 30 March 2023

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

All data files associated with this releases are listed below with guidance on their content. To download any of these files, please visit our data catalogue.

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

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:

  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

Variable names and descriptions for this file are provided below:

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