Reporting year 2023

Outcomes for children in need, including children looked after by local authorities in England

Data guidance

Published

Description

This document describes the data included in the ‘Outcomes for children in need, including children looked after by local authorities in England: 2023' National Statistics underlying data files. This data is released under the terms of the Open Government License and is intended to meet at least three stars for Open Data.

The methodology should be referenced alongside this release. It provides information on the data sources, their coverage and quality and how the data is produced.

Coverage

This statistical release provides data on outcomes measures for children in need (CIN), including children looked after (CLA) by local authorities in England. Data is provided at national, regional, and local authority level.

Children in need data is not available for Hackney local authority for both the 2020 to 2021 and 2021 to 2022 collection years. Hackney were unable to provide a return for both the 2021 and 2022 children in need census collections, due to a cyberattack which had a significant impact on their management information systems.

The outcome measures cover:

  • special education needs
  • educational attainment (at Key Stage 1, Key Stage 2 and Key Stage 4)
  • educational progress (between Key Stage 1 and Key Stage 2, and between Key Stage 2 and Key Stage 4)
  • destinations from school
  • absence from school
  • permanent exclusions and suspensions from school
  • free school meal eligibility
  • type of school attended.

Detailed information on the social care groups and all pupils comparisons is provided in the methodology.

Abbreviations of social care group names used throughout this release:

  • CIN - children in need, including children on a child protection plan and children looked after. Children in need includes children on child in need plans as well as other types of plan or arrangements. Children in need also includes children awaiting a referral to be considered, an assessment to start or, for an assessment which has started, for the assessment to be completed.
  • CINO - children in need, excluding children on a child protection plan and children looked after.
  • CPPO - children on a child protection plan, excluding children looked after.
  • CLA - children looked after (excludes children who are in respite care in their most recent episode during the reporting year).

Social care groups

Social care groups included within this release are:

  • All pupils comparison - from the national publications.
  • CIN at 31 March
  • CINO at 31 March
  • CPPO at 31 March
  • CLA for 12 months at 31 March
  • CLA less than 12 months at 31 March
  • CIN at any point - ‘any point’ means at any point during the reporting year (including at 31 March).
  • CINO at any point
  • CPPO at any point
  • CLA at any point
  • Ever CIN - last 6 years - children in need, at any point in the last 6 reporting years (including at 31 March).

Note that local authority level data only includes CINO at 31 March, CPPO at 31 March and CLA for at least 12 months  at 31 March and FSM data does not include CLA.

At key stage 4 there are additional groups in the national level data on previously looked after arrangements (PLAA). These are Official Statistics on arrangements for previously looked after children.

  • ‘PLAA - Adoption’ - previously looked after children who left care through an adoption.
  • 'PLAA - SGO' - previously looked after children who left care through a special guardianship order (SGO).
  • ‘PLAA - CAO’ - previously looked after children who left care through a child arrangements order (CAO).
  • ‘PLAA - Total’ - previously looked after children who left care through an adoption, SGO or CAO.

File formats and conventions

Rounding and suppression is applied to the data. The Code of Practice for Statistics requires that reasonable steps should be taken to ensure that all published or disseminated statistics produced by the DfE protect confidentiality. The publications follow the DfE policy statement on confidentiality (opens in a new tab)

National and regional numbers have been rounded to the nearest 10. Local authority numbers are unrounded.

Where a denominator is shown as zero, the original figure submitted was zero. 

Percentages are rounded to one decimal place (except for permanent exclusions and suspensions, where they are rounded to two decimal places).

Average Attainment 8 scores are rounded to one decimal place. EBacc average point scores, Key Stage 2 progress measures and Progress 8 measures are rounded to two decimal places.

As a result of rounding components may not sum to totals and percentages may not sum to 100.

For all attainment measures, values of 0 (zero) are suppressed to protect confidentiality. For all other measures, values of 0 (zero) are not primary suppressed. Prior to 2021, values of 0 (zero) were suppressed for all measures.

The following symbols have been used:

‘c’ to protect confidentiality - secondary suppression may also be applied to figures to protect confidentiality
‘z’ for not applicable
‘x’ for not available (updated in 2021 from a colon in 2020)
‘k’ used when a result that is not 0 (zero) would appear as 0 (zero) due to rounding

Data files

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

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.

National - Suspensions and permanent exclusions

Filename
permanent_exclusions_and_suspensions_national.csv
Geographic levels
National
Time period
2016/17 to 2021/22
Content

Suspensions and permanent exclusions by social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_one_plus_susPercentage of pupils with one or more suspension
pt_perm_exclPercentage of pupils permanently excluded
school_typeSchool type - Filter by school type
social_care_groupSocial care group - Filter by social care group
t_one_plus_susTotal number of pupils with one or more suspension
t_perm_exclTotal number of pupils permanently excluded
t_pupilsTotal number of pupils
Footnotes
  1. The all pupils comparison figures taken from the national publication are produced using a different methodology based on enrolments and the school type is allocated in a different way. As a result of this, the all pupils comparison is not provided by school type as it is not appropriate to compare. More detailed information on the suspensions and permanent exclusions data published within this release is available in the accompanying methodology.
  2. State-funded alternative provision (AP) schools include pupil referral units, alternative provision academies and alternative provision free schools (in previous years this school type was labelled as 'Pupil referral unit' but the inclusion criteria is the same).
  3. While suspensions and permanent exclusions were possible throughout the 2019/20 and 2020/21 academic years, national restrictions will have had an impact on the numbers presented and caution should be taken when comparing across years.

National - Special educational needs (SEN)

Filename
sen_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Special educational need and primary type of special educational need by social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_all_SENPercentage of pupils with SEN
pt_ASD_sePercentage of pupils with statement or EHC plan having primary type of need: Autistic Spectrum Disorder
pt_ASD_ssPercentage of pupils with SEN support having primary type of need: Autistic Spectrum Disorder
pt_HI_sePercentage of pupils with statement or EHC plan having primary type of need: Hearing Impairment
pt_HI_ssPercentage of pupils with SEN support having primary type of need: Hearing Impairment
pt_MLD_sePercentage of pupils with statement or EHC plan having primary type of need: Moderate Learning Difficulty
pt_MLD_ssPercentage of pupils with SEN support having primary type of need: Moderate Learning Difficulty
pt_MSI_sePercentage of pupils with statement or EHC plan having primary type of need: Multi- Sensory Impairment
pt_MSI_ssPercentage of pupils with SEN support having primary type of need: Multi- Sensory Impairment
pt_no_identified_SENPercentage of pupils with no identified SEN
pt_NSA_sePercentage of pupils with statement or EHC plan having primary type of need: SEN support but no specialist assessment of type of need
pt_NSA_ssPercentage of pupils with SEN support having primary type of need: SEN support but no specialist assessment of type of need
pt_OTH_sePercentage of pupils with statement or EHC plan having primary type of need: Other Difficulty/Disability
pt_OTH_ssPercentage of pupils with SEN support having primary type of need: Other Difficulty/Disability
pt_PD_sePercentage of pupils with statement or EHC plan having primary type of need: Physical Disability
pt_PD_ssPercentage of pupils with SEN support having primary type of need: Physical Disability
pt_PMLD_sePercentage of pupils with statement or EHC plan having primary type of need: Profound & Multiple Learning Difficulty
pt_PMLD_ssPercentage of pupils with SEN support having primary type of need: Profound & Multiple Learning Difficulty
pt_SEMH_sePercentage of pupils with statement or EHC plan having primary type of need: Social, Emotional and Mental Health
pt_SEMH_ssPercentage of pupils with SEN support having primary type of need: Social, Emotional and Mental Health
pt_SEN_supportPercentage of pupils with SEN support
pt_SLCN_sePercentage of pupils with statement or EHC plan having primary type of need: Speech, Language and Communications needs
pt_SLCN_ssPercentage of pupils with SEN support having primary type of need: Speech, Language and Communications needs
pt_SLD_sePercentage of pupils with statement or EHC plan having primary type of need: Severe Learning Difficulty
pt_SLD_ssPercentage of pupils with SEN support having primary type of need: Severe Learning Difficulty
pt_SPLD_sePercentage of pupils with statement or EHC plan having primary type of need: Specific Learning Difficulty
pt_SPLD_ssPercentage of pupils with SEN support having primary type of need: Specific Learning Difficulty
pt_statement_or_EHC_planPercentage of pupils with statement or EHC plan
pt_VI_sePercentage of pupils with statement or EHC plan having primary type of need: Visual Impairment
pt_VI_ssPercentage of pupils with SEN support having primary type of need: Visual Impairment
social_care_groupSocial care group - Filter by social care group
t_all_SENTotal number of pupils with SEN
t_ASD_seTotal number of pupils with statement or EHC plan having primary type of need: Autistic Spectrum Disorder
t_ASD_ssTotal number of pupils with SEN support having primary type of need: Autistic Spectrum Disorder
t_HI_seTotal number of pupils with statement or EHC plan having primary type of need: Hearing Impairment
t_HI_ssTotal number of pupils with SEN support having primary type of need: Hearing Impairment
t_MLD_seTotal number of pupils with statement or EHC plan having primary type of need: Moderate Learning Difficulty
t_MLD_ssTotal number of pupils with SEN support having primary type of need: Moderate Learning Difficulty
t_MSI_seTotal number of pupils with statement or EHC plan having primary type of need: Multi- Sensory Impairment
t_MSI_ssTotal number of pupils with SEN support having primary type of need: Multi- Sensory Impairment
t_no_identified_SENTotal number of pupils with no identified SEN
t_NSA_seTotal number of pupils with statement or EHC plan having primary type of need: SEN support but no specialist assessment of type of need
t_NSA_ssTotal number of pupils with SEN support having primary type of need: SEN support but no specialist assessment of type of need
t_OTH_seTotal number of pupils with statement or EHC plan having primary type of need: Other Difficulty/Disability
t_OTH_ssTotal number of pupils with SEN support having primary type of need: Other Difficulty/Disability
t_PD_seTotal number of pupils with statement or EHC plan having primary type of need: Physical Disability
t_PD_ssTotal number of pupils with SEN support having primary type of need: Physical Disability
t_PMLD_seTotal number of pupils with statement or EHC plan having primary type of need: Profound & Multiple Learning Difficulty
t_PMLD_ssTotal number of pupils with SEN support having primary type of need: Profound & Multiple Learning Difficulty
t_pupilsTotal number of pupils
t_SEMH_seTotal number of pupils with statement or EHC plan having primary type of need: Social, Emotional and Mental Health
t_SEMH_ssTotal number of pupils with SEN support having primary type of need: Social, Emotional and Mental Health
t_SEN_supportTotal number of pupils with SEN support
t_SLCN_seTotal number of pupils with statement or EHC plan having primary type of need: Speech, Language and Communications needs
t_SLCN_ssTotal number of pupils with SEN support having primary type of need: Speech, Language and Communications needs
t_SLD_seTotal number of pupils with statement or EHC plan having primary type of need: Severe Learning Difficulty
t_SLD_ssTotal number of pupils with SEN support having primary type of need: Severe Learning Difficulty
t_SPLD_seTotal number of pupils with statement or EHC plan having primary type of need: Specific Learning Difficulty
t_SPLD_ssTotal number of pupils with SEN support having primary type of need: Specific Learning Difficulty
t_statement_or_EHC_planTotal number of pupils with statement or EHC plan
t_VI_seTotal number of pupils with statement or EHC plan having primary type of need: Visual Impairment
t_VI_ssTotal number of pupils with SEN support having primary type of need: Visual Impairment
Footnotes
  1. Special educational needs (SEN) status and primary type of SEN data is taken from both the school census and the alternative provision census. For 2016/17 primary type of SEN is not available on the alternative provision census. More detailed information on the SEN data published within this release is available in the accompanying methodology.

National - Free school meals (FSM)

Filename
fsm_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Free school meal eligibility of children in need by social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_FSM_eligiblePercentage of pupils with free school meal eligibility
social_care_groupSocial care group - Filter by social care group
t_FSM_eligibleNumber of pupils with free school meal eligibility
t_pupilsNumber of pupils
Footnotes
  1. Free school meal (FSM) eligibility is taken from both the school census and the alternative provision census. More detailed information on the FSM data published within this release is available in the accompanying methodology.

National - School type

Filename
school_type_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Type of school by social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
social_care_groupSocial care group - Filter by social care group
t_apTotal number of pupils in state-funded alternative provision (AP) school
t_primaryTotal number of pupils in state-funded primary school
t_pupilsTotal number of pupils
t_secondaryTotal number of pupils in state-funded secondary school
t_specialTotal number of pupils in special school
Footnotes
  1. State-funded alternative provision (AP) schools include pupil referral units, alternative provision academies and alternative provision free schools (in previous years this school type was labelled as 'Pupil referral unit' but the inclusion criteria is the same).
  2. The all pupils comparison figures taken from the national publication have school type allocated in a different way. As a result of this, the all pupils comparison is not provided by school type as it is not appropriate to compare. More detailed information on the school type data published within this release is available in the accompanying methodology.

National - Key Stage 1 (KS1)

Filename
ks1_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Key Stage 1 attainment by special educational need, ethnicity, placement (children looked after only) and social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
ethnicity_majorEthnicity - Filter by ethnicity
placementPlacement - Filter by placement
pt_matta_met_expected_standardPercentage of pupils meeting the expected standard in maths TA
pt_readta_met_expected_standardPercentage of pupils meeting the expected standard in reading TA
pt_scita_met_expected_standardPercentage of pupils meeting the expected standard in science TA
pt_writta_met_expected_standardPercentage of pupils meeting the expected standard in writing TA
pupil_sen_statusSpecial Educational Needs status - Filter by Special Educational Needs status
social_care_groupSocial care group - Filter by social care group
t_matta_eligible_pupilsNumber of eligible pupils in maths TA
t_matta_met_expected_standardNumber of pupils meeting the expected standard in maths TA
t_readta_eligible_pupilsNumber of eligible pupils in reading TA
t_readta_met_expected_standardNumber of pupils meeting the expected standard in reading TA
t_scita_eligible_pupilsNumber of eligible pupils in science TA
t_scita_met_expected_standardNumber of pupils meeting the expected standard in science TA
t_writta_eligible_pupilsNumber of eligible pupils in writing TA
t_writta_met_expected_standardNumber of pupils meeting the expected standard in writing TA
Footnotes
  1. Writing teacher assessment measures from 2018 onwards and reading, mathematics and science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the teacher assessment frameworks.

National - Destinations

Filename
destinations_national.csv
Geographic levels
National
Time period
2016/17 to 2020/21
Content

Destinations after completing Key Stage 4 by social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_all_notsustPercentage not recorded as a sustained destination
pt_all_unknownPercentage with activity not captured
pt_all_workPercentage in sustained employment destination
pt_appl2Percentage in intermediate apprenticeships (level 2)
pt_appl3Percentage in advanced and Higher apprenticeships (level 3 and above)
pt_apprenPercentage in sustained apprenticeships
pt_appruPercentage in alternative provision
pt_edu_comboPercentage in sustained education combination destination
pt_educationPercentage in sustained education destination
pt_fePercentage in further education
pt_hePercentage in UK higher education institution
pt_indPercentage in independent schools
pt_notsustPercentage in education or employment not sustained
pt_notsust_benPercentage in education or employment not sustained and known to be NEET
pt_only_benPercentage with no participation and known to be NEET
pt_other_eduPercentage in other education destination
pt_overallPercentage in sustained education, employment & apprenticeships
pt_sfcPercentage in sixth form college
pt_specialPercentage in special school
pt_spiPercentage in specialist post-16 institution
pt_ssfPercentage in school sixth form
pt_unknownPercentage not identified in any data
pt_unknown_idPercentage identified as DWP/HMRC customer
social_care_groupSocial care group - Filter by social care group
t_all_notsustTotal number of pupils not recorded as a sustained destination
t_all_unknownTotal number of pupils with activity not captured
t_all_workTotal number of pupils in sustained employment destination
t_appl2Total number of pupils in intermediate apprenticeships (level 2)
t_appl3Total number of pupils in advanced and Higher apprenticeships (level 3 and above)
t_apprenTotal number of pupils in sustained apprenticeships
t_appruTotal number of pupils in alternative provision
t_edu_comboTotal number of pupils in sustained education combination destination
t_educationTotal number of pupils in sustained education destination
t_feTotal number of pupils in further education
t_heTotal number of pupils in UK higher education institution
t_indTotal number of pupils in independent schools
t_notsustTotal number of pupils in education or employment not sustained
t_notsust_benTotal number of pupils in education or employment not sustained and known to be NEET
t_only_benTotal number of pupils with no participation and known to be NEET
t_other_eduTotal number of pupils in other education destination
t_overallTotal number of pupils in sustained education, employment & apprenticeships
t_pupilsTotal number of pupils at the end of key stage 4
t_sfcTotal number of pupils in sixth form college
t_specialTotal number of pupils in special school
t_spiTotal number of pupils in specialist post-16 institution
t_ssfTotal number of pupils in school sixth form
t_unknownTotal number of pupils not identified in any data
t_unknown_idTotal number of pupils identified as DWP/HMRC customer
Footnotes
  1. The destinations figures in this release are not directly comparable to the all pupils figures in the national publication as the social care destination figures include additional institutions. For example, other institutions include: independent schools, independent special schools and secure units. More detailed information on the destinations data published within this release is available in the accompanying methodology.

National - Key Stage 2 (KS2)

Filename
ks2_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Key Stage 2 attainment and progress by special educational need, ethnicity, placement (children looked after only) and social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
avg_mat_progress_scoreAverage progress score for maths
avg_mat_progress_score_lower_ciLower confidence interval for maths progress
avg_mat_progress_score_upper_ciUpper confidence interval for maths progress
avg_read_progress_scoreAverage progress score for reading
avg_read_progress_score_lower_ciLower confidence interval for reading progress
avg_read_progress_score_upper_ciUpper confidence interval for reading progress
avg_writta_progress_scoreAverage progress score for writing TA
avg_writta_progress_score_lower_ciLower confidence interval for writing TA progress
avg_writta_progress_score_upper_ciUpper confidence interval for writing TA progress
ethnicity_majorEthnicity - Filter by ethnicity
placementPlacement - Filter by placement
pt_gps_met_expected_standardPercentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_mat_met_expected_standardPercentage of pupils meeting the expected standard in maths
pt_read_met_expected_standardPercentage of pupils meeting the expected standard in reading
pt_rwm_met_expected_standardPercentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_scita_met_expected_standardPercentage of pupils meeting the expected standard in science TA
pt_writta_met_expected_standardPercentage of pupils meeting the expected standard in writing TA
pupil_sen_statusSpecial Educational Needs status - Filter by Special Educational Needs status
social_care_groupSocial care group - Filter by social care group
t_gps_eligible_pupilsNumber of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standardNumber of pupils meeting the expected standard in grammar, punctuation and spelling
t_mat_eligible_pupilsNumber of eligible pupils in maths
t_mat_met_expected_standardNumber of pupils meeting the expected standard in maths
t_mat_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_scoreTotal number of pupils progress scores for maths
t_read_eligible_pupilsNumber of eligible pupils in reading
t_read_met_expected_standardNumber of pupils meeting the expected standard in reading
t_read_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_scoreTotal number of pupils progress scores for reading
t_rwm_eligible_pupilsNumber of eligible pupils in reading, writing and maths
t_rwm_met_expected_standardNumber of pupils meeting the expected standard in reading, writing and maths
t_scita_eligible_pupilsNumber of eligible pupils in science TA
t_scita_met_expected_standardNumber of pupils meeting the expected standard in science TA
t_writta_eligible_pupilsNumber of eligible pupils in writing TA
t_writta_met_expected_standardNumber of pupils meeting the expected standard in writing TA
t_writta_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_scoreTotal number of pupils progress scores for writing TA
Footnotes
  1. 'All pupils comparison' includes all state-funded schools, alternative provision, and non-maintained special schools with pupils eligible for assessment at Key Stage 2. Participation by independent schools is voluntary, therefore the figures for all pupils includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
  2. Writing teacher assessment and reading, writing and maths (combined) measures from 2018 onwards are not directly comparable to previous years due to changes in the writing teacher assessment frameworks.

National - Absence (six half terms)

Filename
absence_six_half_terms_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Full-year absence by type of school and social care group. Data for 2019/20 is not available.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_overallOverall absence percentage
pt_pupils_pa_10_exactPersistent absentees percentage
pt_pupils_pa_50_exactSevere absentees percentage
pt_sess_authorisedAuthorised absence percentage
pt_sess_unauthorisedUnauthorised absence percentage
school_typeSchool type - Filter by school type
social_care_groupSocial care group - Filter by social care group
t_pupilsTotal number of pupils or enrolments
t_pupils_pa_10_exactNumber of persistent absentees
t_pupils_pa_50_exactNumber of severe absentees
t_sess_authorisedNumber of authorised absence sessions
t_sess_overallNumber of overall absence sessions
t_sess_possibleNumber of sessions possible
t_sess_unauthorisedNumber of unauthorised absence sessions
Footnotes
  1. The all pupils comparison figures taken from the national publication are produced using a different methodology based on enrolments and the school type is allocated in a different way. As a result of this, the all pupils comparison is not provided by school type as it is not appropriate to compare. More detailed information on the absence data published within this release is available in the accompanying methodology.
  2. With increased demand for statistics and data to measure the impact of the COVID-19 pandemic, the Department for Education changed its data gathering and release practices, focussing efforts on priority analysis and statistics.  Therefore, no absence data relating to the full 2019/20 academic year is available.

National - Key Stage 4 (KS4)

Filename
ks4_national.csv
Geographic levels
National
Time period
2016/17 to 2022/23
Content

Key Stage 4 attainment and progress by special educational need, ethnicity, placement (children looked after only), period of care length (children looked after only) and social care group.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
avg_att8Average Attainment 8 score of all pupils
avg_ebaccapsAverage EBacc APS score per pupil
avg_p8scoreAverage Progress 8 score of all pupils
ethnicity_majorEthnicity - Filter by ethnicity
p8score_CI_lowProgress 8 lower 95% confidence interval
p8score_CI_uppProgress 8 upper 95% confidence interval
placementPlacement - Filter by placement
poc_lengthLength of period of care - Filter by length of period of care
pt_ebacc_94Percentage of pupils achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)
pt_ebacc_95Percentage of pupils achieving the English Baccalaureate (grades 5 or above in English and maths, A*-C in unreformed subjects)
pt_ebacc_e_ptq_eePercentage of pupils entering the English Baccalaureate
pt_l2basics_94Percentage of pupils achieving grades 4 or above in English and mathematics GCSEs
pt_l2basics_95Percentage of pupils achieving grades 5 or above in English and mathematics GCSEs
pupil_sen_statusSpecial Educational Needs status - Filter by Special Educational Needs status
social_care_groupSocial care group - Filter by social care group
t_att8Total sum of pupils Attainment 8 scores
t_ebacc_94Total number of pupils achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)
t_ebacc_95Total number of pupils achieving the English Baccalaureate (grades 5 or above in English and maths, A*-C in unreformed subjects)
t_ebacc_e_ptq_eeTotal number of pupils entering the English Baccalaureate
t_ebaccapsTotal EBacc APS score of pupils
t_inp8calcTotal number of pupils included in Progress 8 measure
t_l2basics_94Total number of pupils achieving grades 4 or above in English and mathematics GCSEs
t_l2basics_95Total number of pupils achieving grades 5 or above in English and mathematics GCSEs
t_p8scoreTotal sum of pupils Progress 8 scores
t_pupilsTotal number of pupils at the end of key stage 4
Footnotes
  1. Special educational needs (SEN) status is taken from both the school census and the alternative provision census. The Key Stage 4 data includes pupils for whom SEN status could not be determined. More detailed information on the SEN data published within this release is available in the accompanying methodology.
  2. Due to the impact of the COVID-19 pandemic, the summer examination series was cancelled in both 2020 and 2021, and alternative processes set up to award grades. The method to award grades was different in 2021 to that in 2020. The changes to the way GCSE grades were awarded in these two years means 2019/20 and 2020/21 pupil attainment data should not be directly compared to pupil attainment data from previous or later years for the purposes of measuring year on year changes in pupil performance. More detailed information on the Key Stage 4 data published within this release is available in the accompanying methodology.
  3. In 2022/23 there was a return to pre-pandemic standards for GCSEs, with protection built into the grading process to recognise the disruption that students have faced. Throughout this release, comparisons are made with 2022 and with 2019. The more meaningful comparison is with 2019, the last year that summer exams were taken before the pandemic, as 2023 saw a return to pre-pandemic grading, with some protections. In 2022 outcomes broadly reflected a mid-point between 2019 and 2021, to take account of the impact of the pandemic and in line with Ofqual’s approach to grading in 2022. It is expected that performance in 2023 will generally be lower than in 2022. Users need to exercise extreme caution when considering comparisons over time, as they may not reflect changes in pupil performance alone. More detailed information on the Key Stage 4 data published within this release is available in the accompanying methodology.
  4. For children looked after (CLA) for at least 12 months, due to definitional differences, there can be a small number where the period of care length at 31 March is less than 12 months (where the period of care start date is 1 April).

LA - Free school meals (FSM)

Filename
fsm_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Free school meal eligibility for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after).

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_FSM_eligiblePercentage of pupils with free school meal eligibility
social_care_groupSocial care group - Filter by social care group
t_FSM_eligibleNumber of pupils with free school meal eligibility
t_pupilsNumber of pupils
Footnotes
  1. Free school meal (FSM) eligibility is taken from both the school census and the alternative provision census. More detailed information on the FSM data published within this release is available in the accompanying methodology.

LA - Absence (six half terms)

Filename
absence_six_half_terms_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Full-year absence by type of school and social care group for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after. Data for 2019/20 is not available.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_overallOverall absence percentage
pt_pupils_pa_10_exactPersistent absentees percentage
pt_pupils_pa_50_exactSevere absentees percentage
pt_sess_authorisedAuthorised absence percentage
pt_sess_unauthorisedUnauthorised absence percentage
school_typeSchool type - Filter by school type
social_care_groupSocial care group - Filter by social care group
t_pupilsTotal number of pupils or enrolments
t_pupils_pa_10_exactNumber of persistent absentees
t_pupils_pa_50_exactNumber of severe absentees
t_sess_authorisedNumber of authorised absence sessions
t_sess_overallNumber of overall absence sessions
t_sess_possibleNumber of sessions possible
t_sess_unauthorisedNumber of unauthorised absence sessions

LA - School type

Filename
school_type_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Type of school for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
social_care_groupSocial care group - Filter by social care group
t_apTotal number of pupils in state-funded alternative provision (AP) school
t_primaryTotal number of pupils in state-funded primary schools
t_pupilsTotal number of pupils
t_secondaryTotal number of pupils in state-funded secondary schools
t_specialTotal number of pupils in special schools

LA - Suspensions and permanent exclusions

Filename
permanent_exclusions_and_suspensions_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2021/22
Content

Suspensions and permanent exclusions for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_one_plus_susPercentage of pupils with one or more suspension
pt_perm_exclPercentage of pupils permanently excluded
social_care_groupSocial care group - Filter by social care group
t_one_plus_susTotal number of pupils with one or more suspension
t_perm_exclTotal number of pupils permanently excluded
t_pupilsTotal number of pupils

LA - Key Stage 4 (KS4)

Filename
ks4_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Key Stage 4 attainment and progress for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
avg_att8Average Attainment 8 score of all pupils
avg_ebaccapsAverage EBacc APS score per pupil
avg_p8scoreAverage Progress 8 score of all pupils
p8score_CI_lowProgress 8 lower 95% confidence interval
p8score_CI_uppProgress 8 upper 95% confidence interval
pt_ebacc_e_ptq_eePercentage of pupils entering the English Baccalaureate
pt_l2basics_94Percentage of pupils achieving grades 4 or above in English and mathematics GCSEs
pt_l2basics_95Percentage of pupils achieving grades 5 or above in English and mathematics GCSEs
social_care_groupSocial care group - Filter by social care group
t_att8Total sum of pupils Attainment 8 scores
t_ebacc_e_ptq_eeTotal number of pupils entering the English Baccalaureate
t_ebaccapsTotal EBacc APS score of pupils
t_inp8calcTotal number of pupils included in Progress 8 measure
t_l2basics_94Total number of pupils achieving grades 4 or above in English and mathematics GCSEs
t_l2basics_95Total number of pupils achieving grades 5 or above in English and mathematics GCSEs
t_p8scoreTotal sum of pupils Progress 8 scores
t_pupilsTotal number of pupils at the end of key stage 4
versionVersion - Filter by version

LA - Key Stage 2 (KS2)

Filename
ks2_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Key Stage 2 attainment and progress for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
avg_mat_progress_scoreAverage progress score for maths
avg_mat_progress_score_lower_CILower confidence interval for maths progress
avg_mat_progress_score_upper_CIUpper confidence interval for maths progress
avg_read_progress_scoreAverage progress score for reading
avg_read_progress_score_lower_CILower confidence interval for reading progress
avg_read_progress_score_upper_CIUpper confidence interval for reading progress
avg_writta_progress_scoreAverage progress score for writing TA
avg_writta_progress_score_lower_CILower confidence interval for writing TA progress
avg_writta_progress_score_upper_CIUpper confidence interval for writing TA progress
pt_gps_met_expected_standardPercentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_mat_met_expected_standardPercentage of pupils meeting the expected standard in maths
pt_read_met_expected_standardPercentage of pupils meeting the expected standard in reading
pt_rwm_met_expected_standardPercentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_scita_met_expected_standardPercentage of pupils meeting the expected standard in science TA
pt_writta_met_expected_standardPercentage of pupils meeting the expected standard in writing TA
social_care_groupSocial care group - Filter by social care group
t_gps_eligible_pupilsNumber of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standardNumber of pupils meeting the expected standard in grammar, punctuation and spelling
t_mat_eligible_pupilsNumber of eligible pupils in maths
t_mat_met_expected_standardNumber of pupils meeting the expected standard in maths
t_mat_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_scoreTotal number of pupils progress scores for maths
t_read_eligible_pupilsNumber of eligible pupils in reading
t_read_met_expected_standardNumber of pupils meeting the expected standard in reading
t_read_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_scoreTotal number of pupils progress scores for reading
t_rwm_eligible_pupilsNumber of eligible pupils in reading, writing and maths
t_rwm_met_expected_standardNumber of pupils meeting the expected standard in reading, writing and maths
t_scita_eligible_pupilsNumber of eligible pupils in science TA
t_scita_met_expected_standardNumber of pupils meeting the expected standard in science TA
t_writta_eligible_pupilsNumber of eligible pupils in writing TA
t_writta_met_expected_standardNumber of pupils meeting the expected standard in writing TA
t_writta_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_scoreTotal number of pupils progress scores for writing TA

LA - Special education needs (SEN)

Filename
sen_la.csv
Geographic levels
Local authority; National; Regional
Time period
2016/17 to 2022/23
Content

Special educational need and primary type of special education need for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pt_all_SENPercentage of pupils with SEN
pt_ASDPercentage of pupils with having primary type of need: Autistic Spectrum Disorder
pt_HIPercentage of pupils with having primary type of need: Hearing Impairment
pt_MLDPercentage of pupils with having primary type of need: Moderate Learning Difficulty
pt_MSIPercentage of pupils with having primary type of need: Multi- Sensory Impairment
pt_no_identified_SENPercentage of pupils with no identified SEN
pt_NSAPercentage of pupils with having primary type of need: but no specialist assessment of type of need
pt_OTHPercentage of pupils with having primary type of need: Other Difficulty/Disability
pt_PDPercentage of pupils with having primary type of need: Physical Disability
pt_PMLDPercentage of pupils with having primary type of need: Profound & Multiple Learning Difficulty
pt_SEMHPercentage of pupils with having primary type of need: Social, Emotional and Mental Health
pt_SEN_supportPercentage of pupils with SEN support
pt_SLCNPercentage of pupils with having primary type of need: Speech, Language and Communications needs
pt_SLDPercentage of pupils with having primary type of need: Severe Learning Difficulty
pt_SPLDPercentage of pupils with having primary type of need: Specific Learning Difficulty
pt_statement_or_EHC_planPercentage of pupils with statement or EHC plan
pt_VIPercentage of pupils with having primary type of need: Visual Impairment
social_care_groupSocial care group - Filter by social care group
t_all_SENTotal number of pupils with SEN
t_ASDTotal number of pupils with having primary type of need: Autistic Spectrum Disorder
t_HITotal number of pupils with having primary type of need: Hearing Impairment
t_MLDTotal number of pupils with having primary type of need: Moderate Learning Difficulty
t_MSITotal number of pupils with having primary type of need: Multi- Sensory Impairment
t_no_identified_SENTotal number of pupils with no identified SEN
t_NSATotal number of pupils with having primary type of need: but no specialist assessment of type of need
t_OTHTotal number of pupils with having primary type of need: Other Difficulty/Disability
t_PDTotal number of pupils with having primary type of need: Physical Disability
t_PMLDTotal number of pupils with having primary type of need: Profound & Multiple Learning Difficulty
t_pupilsTotal number of pupils
t_SEMHTotal number of pupils with having primary type of need: Social, Emotional and Mental Health
t_SEN_supportTotal number of pupils with SEN support
t_SLCNTotal number of pupils with having primary type of need: Speech, Language and Communications needs
t_SLDTotal number of pupils with having primary type of need: Severe Learning Difficulty
t_SPLDTotal number of pupils with having primary type of need: Specific Learning Difficulty
t_statement_or_EHC_planTotal number of pupils with statement or EHC plan
t_VITotal number of pupils with having primary type of need: Visual Impairment