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

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

Latest data

Published 30 March 2023

Last updated 30 March 2023

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. 

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Education, children’s social care and offending: local authority level dashboard
• Release: Academic year 2019/20
• Geographic levels: Local authority, National
• 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 preview

Table showing first 5 rows, from underlying data

time_period	time_identifier	geographic_level	country_name	country_code	region_code	region_name	old_la_code	new_la_code	la_name	indicator	timing	count_with_semh_timing	perc_with_semh_timing
201920	Academic year	National	England	E92000001						School	Before the first serious violence offence	16100	83.7
201920	Academic year	National	England	E92000001						School	In the same term as the first serious violence offence	540	2.8
201920	Academic year	National	England	E92000001						School	After the first serious violence offence	2605	13.5
201920	Academic year	Local authority	England	E92000001	E12000007	London	301	E09000002	Barking and Dagenham	School	Before the first serious violence offence	110	79.7
201920	Academic year	Local authority	England	E92000001	E12000007	London	301	E09000002	Barking and Dagenham	School	In the same term as the first serious violence offence	c	c

---

Variables in this data set

Table showing all 4 variables

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

---

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

---