Data set from Key stage 4 performance

Local authority district and region of pupil residence data

Not the latest data
Published
Last updated
Local authority district level headline entry and attainment measures for the latest year - based on pupil postcode rather than location of the school. State-funded school pupils only.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
Release type
Number of rows
308
Geographic levels
Local authority district, National, Regional
Indicators
  • Average Attainment 8 score of all pupils
  • Average EBacc APS score per pupil
  • Average Progress 8 score of all pupils
  • Percentage of pupils achieving grades 4 or above in English and Mathematics GCSEs
  • Percentage of pupils achieving grades 5 or above in English and Mathematics GCSEs
  • Percentage of pupils entering the English Baccalaureate
  • Percentage of pupils achieving the English Baccalaureate grades 4 or above (A*-C in unreformed subjects)
  • Percentage of pupils achieving the English Baccalaureate grades 5 or above (A*-C in unreformed subjects)
  • Percentage of pupils entering English and Mathematics GCSEs
  • Total number of pupils at the end of key stage 4
  • Total number of pupils included in Progress 8 measure
  • Total number of schools
  • Total sum of pupils Attainment 8 scores
  • Total sum of pupils Progress 8 scores
  • Total number of pupils entering English and Mathematics GCSEs
  • Total number of pupils achieving grades 4 or above in English and Mathematics GCSEs
  • Total number of pupils achieving grades 5 or above in English and Mathematics GCSEs
  • Total number of pupils entering the English Baccalaureate
  • Total number of pupils achieving the English Baccalaureate grades 4 or above (A*-C in unreformed subjects)
  • Total number of pupils achieving the English Baccalaureate grades 5 or above (A*-C in unreformed subjects)
  • Total EBacc APS score of pupils
  • Progress 8 lower 95% confidence interval
  • Progress 8 upper 85% confidence interval
Time period
2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_namelad_codelad_nameversionlevel_methodologyestablishment_typet_schoolst_pupilst_att8avg_att8t_entbasicspt_entbasicst_l2basics_95pt_l2basics_95t_l2basics_94pt_l2basics_94t_ebacc_e_ptq_eept_ebacc_e_ptq_eet_ebacc_95pt_ebacc_95t_ebacc_94pt_ebacc_94t_ebaccapsavg_ebaccapst_inp8calct_p8scoreavg_p8scorep8score_ci_lowp8score_ci_upp
202223Academic yearNationalE92000001EnglandRevisedPupil residencyState-funded schools (LA)404660261427981661.9546.458011996.327424045.539403565.423749639.410293017.114656124.32450945.264.07567877-14693.009-0.03-0.03-0.02
202223Academic yearRegionalE92000001EnglandE12000001North EastRevisedPupil residencyState-funded schools (LA)206277481236052.544.52652795.61164041.91733462.51025236.9413614.9622822.4106469.763.8426853-7221.924-0.27-0.29-0.25
202223Academic yearRegionalE92000001EnglandE12000002North WestRevisedPupil residencyState-funded schools (LA)617828993694882.6244.679618963458541.75166562.33006836.31166114.11726420.8319682.473.8678470-15672.851-0.2-0.21-0.19
202223Academic yearRegionalE92000001EnglandE12000003Yorkshire and The HumberRevisedPupil residencyState-funded schools (LA)451609082729527.3844.85857796.22610042.938354632276637.4930415.31364022.4236495.883.8858370-3237.142-0.06-0.07-0.04
202223Academic yearRegionalE92000001EnglandE12000004East MidlandsRevisedPupil residencyState-funded schools (LA)551530012392127.7745.15113396.52264942.73370563.61921736.3816415.41180422.3209070.843.9450361-2307.99-0.05-0.06-0.03

Variables in this data set

Table showing all 23 variables
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 85% confidence interval
pt_ebacc_94Percentage of pupils achieving the English Baccalaureate grades 4 or above (A*-C in unreformed subjects)
pt_ebacc_95Percentage of pupils achieving the English Baccalaureate grades 5 or above (A*-C in unreformed subjects)
pt_ebacc_e_ptq_eePercentage of pupils entering the English Baccalaureate
pt_entbasicsPercentage of pupils entering English and Mathematics GCSEs
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
t_att8Total sum of pupils Attainment 8 scores
t_ebacc_94Total number of pupils achieving the English Baccalaureate grades 4 or above (A*-C in unreformed subjects)
t_ebacc_95Total number of pupils achieving the English Baccalaureate grades 5 or above (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_entbasicsTotal number of pupils entering English and Mathematics GCSEs
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
t_schoolsTotal number of schools

Footnotes

  1. All state-funded schools include local authority maintained mainstream schools, academies, free schools, city technology colleges, further education colleges with provision for 14 to 16 year-olds and state-funded special schools. They exclude independent schools, independent special schools, non-maintained special schools, hospital schools, pupil referral units and alternative provision. Alternative provision includes academy and free school alternative provision. 
  2. Some zero percentages may represent small numbers due to rounding.
  3. z = When an observation is not applicable
  4. Reformed GCSEs were introduced in phases for first examination between 2017 and 2020. The last phase of reformed GCSEs was first examined in 2022. This was due to the cancellation of exams and assessments in summer 2020 and 2021 due to the impact of the pandemic. All GCSEs now use the 9-1 grading system. Results for 2020 and 2021 are not comparable with earlier years due to the cancellation of exams (due to Covid-19) and changes to way GCSE grades were awarded in those years. GCSE exams returned in 2022 and grades were awarded at a midpoint between 2021 and pre-pandemic grading. Changes were made to the methodology for calculating performance data due to the commitment not to use qualification results awarded between January 2020 and August 2021 in future measures. In 2023 there was a return to pre-pandemic grading, with some protections. 
  5. Local authority, region and the total (state-funded sector) figures cover achievements in state-funded schools only. They do not include pupils recently arrived from overseas and so will not match with state-funded figures in the national tables. 
  6. Northumberland district boundary was changed in 2014. The local authority district code was changed from E06000048 to E06000057 to reflect this.
  7. East Hertfordshire district boundary was changed in 2014. The local authority district code was changed from E07000097 to E07000242 to reflect this.
  8. St Albans district boundary was changed in 2013. The local authority district code was changed from E07000100 to E07000240 to reflect this.
  9. Stevenage district boundary was changed in 2014. The local authority district code was changed from E07000101 to E07000243 to reflect this.
  10. Welwyn Hatfield district boundary was changed in 2013. The local authority district code was changed from E07000104 to E07000241 to reflect this.
  11. Northamptonshire district boundary was changed in 2021. The local authority district code was changed from E10000021 to E06000061 (North Northamptonshire) and E06000062 (West Northamptonshire).
  12. Pupils not resident in England in 2022/23 and pupils with missing or invalid postcode information are excluded from the figures presented (999 pupils).

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

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/1ba3021d-6b90-42f0-a5fa-528350d69957/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/1ba3021d-6b90-42f0-a5fa-528350d69957/csv")

Contact us

If you have a specific enquiry about Local authority district and region of pupil residence data statistics and data:

Attainment statistics team

Email: Attainment.STATISTICS@education.gov.uk
Contact name: Liam Hamilton