Data set from Key stage 4 performance

Local authority data

Not the latest data
Published
Last updated
Local authority and regional level performance measures in state-funded schools since 2018/19.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
Release type
Number of rows
2,934
Geographic levels
Local authority, National, Regional
Indicators
  • Average Attainment 8 score
  • Average EBacc APS score
  • Average Progress 8 score
  • Average Attainment 8 score for EBacc element
  • Average Attainment 8 score for English element
  • Average Attainment 8 score for maths element
  • Average Progress 8 score for EBacc element
  • Average Progress 8 score for English element
  • Average Progress 8 score for maths element
  • Average Progress 8 score for open element
  • Average EBacc APS score for humanities pillar
  • Average EBacc APS score for language pillar
  • Average number of EBacc slots filled for Attainment 8
  • Average number of open slots filled for Attainment 8
  • Average EBacc APS score for English pillar
  • Average EBacc APS score for maths pillar
  • Average EBacc APS score for science pillar
  • Average Attainment 8 score for open element - GCSE only
  • Average Attainment 8 score for open element - non-GCSE only
  • Average Attainment 8 score for open element
  • Percentage of pupils achieving grades 4 or above in English and maths GCSEs
  • Percentage of pupils achieving grades 5 or above in English and maths GCSEs
  • Percentage of pupils entering English and maths GCSEs
  • Percentage of pupils achieving grades 4 or above in the EBacc
  • Percentage of pupils achieving grades 5 or above in the EBacc
  • Percentage of pupils entering the EBacc
  • Percentage of pupils achieving any passes at GCSE or equivalent
  • Percentage of pupils achieving grades 4 or above in the Ebacc English pillar
  • Percentage of pupils achieving grades 4 or above in the Ebacc humanities pillar
  • Percentage of pupils achieving grades 4 or above in the Ebacc language pillar
  • Percentage of pupils achieving grades 4 or above in the Ebacc maths pillar
  • Percentage of pupils achieving grades 4 or above in the Ebacc science pillar
  • Percentage of pupils achieving grades 5 or above in the Ebacc English pillar
  • Percentage of pupils achieving grades 5 or above in the Ebacc humanities pillar
  • Percentage of pupils achieving grades 5 or above in the Ebacc language pillar
  • Percentage of pupils achieving grades 5 or above in the Ebacc maths pillar
  • Percentage of pupils achieving grades 5 or above in the Ebacc science pillar
  • Percentage of pupils entering the EBacc English pillar
  • Percentage of pupils entering the EBacc humanities pillar
  • Percentage of pupils entering the EBacc language pillar
  • Percentage of pupils entering the EBacc maths pillar
  • Percentage of pupils entering the EBacc science pillar
  • Percentage of pupils entering at least 1 GCSE or equivalent
  • Number of pupils at the end of KS4
  • Number of schools
  • Sum of Attainment 8 scores for EBacc element
  • Sum of EBacc APS scores
  • Sum of Progress 8 scores
  • Number of pupils included in Progress 8 measure
  • Number of pupils achieving grades 4 or above in English and maths GCSEs
  • Number of pupils achieving grades 5 or above in English and maths GCSEs
  • Number of pupils entering English and maths GCSEs
  • Number of pupils achieving grades 4 or above in the EBacc
  • Number of pupils achieving grades 5 or above in the EBacc
  • Number of pupils entering the EBacc
  • Sum of Attainment 8 scores for English element
  • Sum of Attainment 8 scores for maths element
  • Sum of EBacc APS scores for humanities pillar
  • Sum of EBacc APS scores for language pillar
  • Total number of EBacc slots filled for Attainment 8
  • Total number of open slots filled for Attainment 8
  • Number of pupils achieving any passes at GCSE or equivalent
  • Number of pupils achieving grades 4 or above in the EBacc English pillar
  • Number of pupils achieving grades 4 or above in the EBacc humanities pillar
  • Number of pupils achieving grades 4 or above in the EBacc language pillar
  • Number of pupils achieving grades 4 or above in the EBacc maths pillar
  • Number of pupils achieving grades 4 or above in the EBacc science pillar
  • Number of pupils achieving grades 5 or above in the EBacc English pillar
  • Number of pupils achieving grades 5 or above in the EBacc humanities pillar
  • Number of pupils achieving grades 5 or above in the EBacc language pillar
  • Number of pupils achieving grades 5 or above in the EBacc maths pillar
  • Number of pupils achieving grades 5 or above in the EBacc science pillar
  • Number of pupils entering the EBacc English pillar
  • Number of pupils entering the EBacc humanities pillar
  • Number of pupils entering the EBacc languge pillar
  • Number of pupils entering the EBacc maths pillar
  • Number of pupils entering the EBacc science pillar
  • Number of pupils entering at least 1 GCSE or equivalent
  • Sum of EBacc APS scores for English pillar
  • Sum of EBacc APS scores for maths pillar
  • Sum of EBacc APS scores for science pillar
  • Sum of Attainment 8 scores for open element - GCSE only
  • Sum of Attainment 8 scores for open element - non-GCSE only
  • Sum of Attainment 8 scores for open element
  • Sum of Attainment 8 scores
  • Sum of Progress 8 scores for EBacc element
  • Sum of Progress 8 scores for English element
  • Sum of Progress 8 scores for maths element
  • Sum of Progress 8 scores for open element
  • Progress 8 lower 95% confidence interval
  • Progress 8 lower 95% confidence interval for EBacc element
  • Progress 8 lower 95% confidence interval for English element
  • Progress 8 lower 95% confidence interval for maths element
  • Progress 8 lower 95% confidence interval for open element
  • Progress 8 upper 95% confidence interval
  • Progress 8 upper 95% confidence interval for EBacc element
  • Progress 8 upper 95% confidence interval for English element
  • Progress 8 upper 95% confidence interval for maths element
  • Progress 8 upper 95% confidence interval for open element
Filters
  • Sex
Time period
2018/19 to 2023/24

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameversioneducation_investment_area_flagpriority_area_flagestablishment_type_groupsext_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_uppt_p8engavg_p8engp8eng_ci_lowp8eng_ci_uppt_p8matavg_p8matp8mat_ci_lowp8mat_ci_uppt_p8ebacavg_p8ebacp8ebac_ci_lowp8ebac_ci_uppt_p8openavg_p8openp8open_ci_lowp8open_ci_uppt_entry_1pt_entry_1t_anypasspt_anypasst_ebaceng_ept_ebaceng_et_ebacmat_ept_ebacmat_et_ebac2sci_ept_ebac2sci_et_ebachum_ept_ebachum_et_ebaclan_ept_ebaclan_et_ebaceng_95pt_ebaceng_95t_ebacmat_95pt_ebacmat_95t_ebac2sci_95pt_ebac2sci_95t_ebachum_95pt_ebachum_95t_ebaclan_95pt_ebaclan_95t_ebaceng_94pt_ebaceng_94t_ebacmat_94pt_ebacmat_94t_ebac2sci_94pt_ebac2sci_94t_ebachum_94pt_ebachum_94t_ebaclan_94pt_ebaclan_94t_ebptseng_llavg_ebptseng_llt_ebptsmatavg_ebptsmatt_ebptssciavg_ebptsscit_ebptshumavg_ebptshumt_ebptslanavg_ebptslant_att8_engavg_att8_engt_att8_matavg_att8_matt_att8_ebacavg_att8_ebact_att8_openavg_att8_opent_att8_open_gavg_att8_open_gt_att8_open_ngavg_att8_open_ngt_ebac_fillavg_ebac_fillt_open_fillavg_open_fill
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Boys387031897414014862.8143.930417395.41402834420068462.911703936.74761314.96839121.41248822.693.92299169-43842.263-0.15-0.15-0.14-94145.985-0.31-0.32-0.3132662.9650.110.10.11-18020.931-0.06-0.07-0.05-93881.483-0.31-0.32-0.3130763296.430600495.929725293.230550795.829898793.725914181.213000740.81723745416695252.313943546.6124502486784452.222177769.522382370.219587265.515758560.88655366.61450238.884.551467566.644.61406530.644.4111406663.58621390.271.952915930.769.12935133.289.24174991.0313.13988807.7412.53380475.2410.6608332.51.98633682.78625512.7
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Girls383030530114770077.3748.42962259714823748.620743267.913623344.66540121.49029329.61303844.214.2728725626765.5960.090.090.168463.630.240.230.24-47598.375-0.17-0.17-0.16-2105.118-0.01-0.01069775.3350.240.240.2529867897.829767497.529100195.329681397.229137995.425254582.715494350.820637567.615782151.714088948.413582653.8961426224588080.521497570.419386666.516605665.811734175.71615998.765.291389289.654.551392956.824.5612129023.97818968.642.683246995.5210.62778579.39.14245635.7713.94498866.7814.73841512.5312.6657354.252.28486802.88537502.8
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Total408562427528784940.1846.160039896.228852046.240811665.425327240.611301418.115868425.42552666.94.09586425-17076.667-0.03-0.03-0.03-25682.355-0.04-0.05-0.04-14935.41-0.03-0.03-0.02-20126.049-0.03-0.04-0.03-24106.148-0.04-0.05-0.0460631097.160367896.758825394.260232096.559036694.65116868228495045.637874960.73247735228032447.526032850.916398657.546765774.943879870.33897386632364163.220389471.63066237.644.912856856.294.582799487.464.4823535683.771440358.912.316162926.289.95713712.589.28420626.813.58487674.5213.67221987.7711.61265686.75217120482.717163012.7
202324Academic yearRegionalE92000001EnglandE12000001North EastRevised00State-funded schools (LA)Boys19114647609236.541.61381194.3589440.2877659.9498234189212.9288019.753788.23.6714087-5099.628-0.36-0.39-0.34-6756.17-0.48-0.51-0.45-2125.1-0.15-0.18-0.13-4905.383-0.35-0.38-0.32-6544.432-0.46-0.49-0.441397795.41389294.81345091.81386894.713476921184980.9534336.5746551709548.4589443.7527944.6249146.6980967987467.4857163.6688258.1342564.1640064.37633474.32608634.16498403.4238091.631288178.81266948.6177942.512.117578312130022.58.945760.53.1387752.6386982.6
202324Academic yearRegionalE92000001EnglandE12000001North EastRevised00State-funded schools (LA)Girls19014231653664.7545.91367796.1625944922064.8576640.5264718.6382826.956833.373.9913750-1890.58-0.14-0.16-0.11452.4350.030.010.06-5833.33-0.42-0.45-0.4-4443.811-0.32-0.35-0.31317.5790.10.070.121382597.11376596.71342694.31371296.41340994.21183083.1633444.5913864.2670947.1591544.1583549.3364257.51110378955667.1857964730661.8468974723575.0860903.754.2861227.54.3539733.79313082.214547710.2121807.58.6183361.512.9203018.7514.3154123.510.848895.253.4388482.7389192.7

Variables in this data set

Table showing all 100 variables
Variable nameVariable description
avg_att8Average Attainment 8 score
avg_att8_ebacAverage Attainment 8 score for EBacc element
avg_att8_engAverage Attainment 8 score for English element
avg_att8_matAverage Attainment 8 score for maths element
avg_att8_openAverage Attainment 8 score for open element
avg_att8_open_gAverage Attainment 8 score for open element - GCSE only
avg_att8_open_ngAverage Attainment 8 score for open element - non-GCSE only
avg_ebac_fillAverage number of EBacc slots filled for Attainment 8
avg_ebaccapsAverage EBacc APS score
avg_ebptseng_llAverage EBacc APS score for English pillar
avg_ebptshumAverage EBacc APS score for humanities pillar
avg_ebptslanAverage EBacc APS score for language pillar
avg_ebptsmatAverage EBacc APS score for maths pillar
avg_ebptssciAverage EBacc APS score for science pillar
avg_open_fillAverage number of open slots filled for Attainment 8
avg_p8ebacAverage Progress 8 score for EBacc element
avg_p8engAverage Progress 8 score for English element
avg_p8matAverage Progress 8 score for maths element
avg_p8openAverage Progress 8 score for open element
avg_p8scoreAverage Progress 8 score
p8ebac_ci_lowProgress 8 lower 95% confidence interval for EBacc element
p8ebac_ci_uppProgress 8 upper 95% confidence interval for EBacc element
p8eng_ci_lowProgress 8 lower 95% confidence interval for English element
p8eng_ci_uppProgress 8 upper 95% confidence interval for English element
p8mat_ci_lowProgress 8 lower 95% confidence interval for maths element
p8mat_ci_uppProgress 8 upper 95% confidence interval for maths element
p8open_ci_lowProgress 8 lower 95% confidence interval for open element
p8open_ci_uppProgress 8 upper 95% confidence interval for open element
p8score_ci_lowProgress 8 lower 95% confidence interval
p8score_ci_uppProgress 8 upper 95% confidence interval
pt_anypassPercentage of pupils achieving any passes at GCSE or equivalent
pt_ebac2sci_94Percentage of pupils achieving grades 4 or above in the Ebacc science pillar
pt_ebac2sci_95Percentage of pupils achieving grades 5 or above in the Ebacc science pillar
pt_ebac2sci_ePercentage of pupils entering the EBacc science pillar
pt_ebacc_94Percentage of pupils achieving grades 4 or above in the EBacc
pt_ebacc_95Percentage of pupils achieving grades 5 or above in the EBacc
pt_ebacc_e_ptq_eePercentage of pupils entering the EBacc
pt_ebaceng_94Percentage of pupils achieving grades 4 or above in the Ebacc English pillar
pt_ebaceng_95Percentage of pupils achieving grades 5 or above in the Ebacc English pillar
pt_ebaceng_ePercentage of pupils entering the EBacc English pillar
pt_ebachum_94Percentage of pupils achieving grades 4 or above in the Ebacc humanities pillar
pt_ebachum_95Percentage of pupils achieving grades 5 or above in the Ebacc humanities pillar
pt_ebachum_ePercentage of pupils entering the EBacc humanities pillar
pt_ebaclan_94Percentage of pupils achieving grades 4 or above in the Ebacc language pillar
pt_ebaclan_95Percentage of pupils achieving grades 5 or above in the Ebacc language pillar
pt_ebaclan_ePercentage of pupils entering the EBacc language pillar
pt_ebacmat_94Percentage of pupils achieving grades 4 or above in the Ebacc maths pillar
pt_ebacmat_95Percentage of pupils achieving grades 5 or above in the Ebacc maths pillar
pt_ebacmat_ePercentage of pupils entering the EBacc maths pillar
pt_entbasicsPercentage of pupils entering English and maths GCSEs
pt_entry_1Percentage of pupils entering at least 1 GCSE or equivalent
pt_l2basics_94Percentage of pupils achieving grades 4 or above in English and maths GCSEs
pt_l2basics_95Percentage of pupils achieving grades 5 or above in English and maths GCSEs
sexSex
t_anypassNumber of pupils achieving any passes at GCSE or equivalent
t_att8Sum of Attainment 8 scores
t_att8_ebacSum of Attainment 8 scores for EBacc element
t_att8_engSum of Attainment 8 scores for English element
t_att8_matSum of Attainment 8 scores for maths element
t_att8_openSum of Attainment 8 scores for open element
t_att8_open_gSum of Attainment 8 scores for open element - GCSE only
t_att8_open_ngSum of Attainment 8 scores for open element - non-GCSE only
t_ebac_fillTotal number of EBacc slots filled for Attainment 8
t_ebac2sci_94Number of pupils achieving grades 4 or above in the EBacc science pillar
t_ebac2sci_95Number of pupils achieving grades 5 or above in the EBacc science pillar
t_ebac2sci_eNumber of pupils entering the EBacc science pillar
t_ebacc_94Number of pupils achieving grades 4 or above in the EBacc
t_ebacc_95Number of pupils achieving grades 5 or above in the EBacc
t_ebacc_e_ptq_eeNumber of pupils entering the EBacc
t_ebaccapsSum of EBacc APS scores
t_ebaceng_94Number of pupils achieving grades 4 or above in the EBacc English pillar
t_ebaceng_95Number of pupils achieving grades 5 or above in the EBacc English pillar
t_ebaceng_eNumber of pupils entering the EBacc English pillar
t_ebachum_94Number of pupils achieving grades 4 or above in the EBacc humanities pillar
t_ebachum_95Number of pupils achieving grades 5 or above in the EBacc humanities pillar
t_ebachum_eNumber of pupils entering the EBacc humanities pillar
t_ebaclan_94Number of pupils achieving grades 4 or above in the EBacc language pillar
t_ebaclan_95Number of pupils achieving grades 5 or above in the EBacc language pillar
t_ebaclan_eNumber of pupils entering the EBacc languge pillar
t_ebacmat_94Number of pupils achieving grades 4 or above in the EBacc maths pillar
t_ebacmat_95Number of pupils achieving grades 5 or above in the EBacc maths pillar
t_ebacmat_eNumber of pupils entering the EBacc maths pillar
t_ebptseng_llSum of EBacc APS scores for English pillar
t_ebptshumSum of EBacc APS scores for humanities pillar
t_ebptslanSum of EBacc APS scores for language pillar
t_ebptsmatSum of EBacc APS scores for maths pillar
t_ebptssciSum of EBacc APS scores for science pillar
t_entbasicsNumber of pupils entering English and maths GCSEs
t_entry_1Number of pupils entering at least 1 GCSE or equivalent
t_inp8calcNumber of pupils included in Progress 8 measure
t_l2basics_94Number of pupils achieving grades 4 or above in English and maths GCSEs
t_l2basics_95Number of pupils achieving grades 5 or above in English and maths GCSEs
t_open_fillTotal number of open slots filled for Attainment 8
t_p8ebacSum of Progress 8 scores for EBacc element
t_p8engSum of Progress 8 scores for English element
t_p8matSum of Progress 8 scores for maths element
t_p8openSum of Progress 8 scores for open element
t_p8scoreSum of Progress 8 scores
t_pupilsNumber of pupils at the end of KS4
t_schoolsNumber of schools

Footnotes

  1. Local authority, region, parliamentary constituency 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.
  2. Progress 8 was not published in 2020 or 2021 because of the COVID-19 pandemic.
  3. A Progress 8 score of 1.0 means pupils make on average a grade more progress than the national average of pupils with similar KS2 prior attainment in mainstream schools. Progress 8 should be interpreted alongside the associated confidence intervals. If the confidence intervals cross 0, then progress is not significantly different compared to pupils with similar KS2 prior attainment in mainstream schools.
  4. EBacc science includes double award GCSE for pupils on the combined science pathway or the average of a pupil's best two science grades for pupils on the single science pathway (i.e., where pupils enter three of biology, chemistry, computer science, and physics).
  5. The open element of Attainment 8 contains the three highest point scores in any three other subjects eligible for performance tables, including English language or literature (if not counted in the English slot), further GCSE qualifications (including English Baccalaureate subjects) or any other non-GCSE qualifications on the DfE approved list.
  6. For the number of slots filled, entries that were awarded U grades or other qualifications scoring 0 points are counted as a non-filled slot.
  7. 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. GCSE exams returned in 2022 and grades were awarded at a midpoint between 2021 and pre-pandemic grading. In 2023, there was a return to pre-pandemic grading, with some protections. Comparisons to 2020, 2021, and 2022 should be made with caution.
  8. c = a cell that has been suppressed due to low number of pupils. Suppression was applied where deemed necessary for all data up to 2018/19. For 2019/20, DfE suppression policy changed. For 2020 and 2021 results where a geographical area contains only one school (for example Isles of Scilly) the data for that area has been suppressed. This is in line with the announcement that school level data would not be published using either summer 2020 or summer 2021 exam grades awarded. Data has not being supressed at local authority or national level from 2022 onwards.
  9. In 2017, new reformed GCSEs (which use the 9-1 grade scale) were introduced into secondary school performance tables in a phased approach. Unreformed subjects continued to be graded using the A* to G system. From 2020 onwards all GCSEs are now reformed and use the 9-1 grading scale.

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/2ffd4d86-94f0-4a1d-8909-9f27e8522a95/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/2ffd4d86-94f0-4a1d-8909-9f27e8522a95/csv")

Contact us

If you have a specific enquiry about Local authority data statistics and data:

Attainment statistics team

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