Data set from Key stage 4 performance

KS4 local authority data

Not the latest data
Published
Last updated
Local authority and regional level headline entry and attainment measures for the latest year broken down gender. State-funded schools only.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
Release type
Number of rows
1,950
Geographic levels
Local authority, National, Regional
Indicators
  • Average Attainment 8 score of all pupils
  • Average Attainment 8 score per pupil in Ebacc subjects
  • Average Attainment 8 score per pupil in English
  • Average Attainment 8 score per pupil in Mathematics
  • Average EBacc APS score per pupil
  • Average highest point score in Humanities EBacc subject area
  • Average highest point score in Languages EBacc subject area
  • Average number of Ebacc slots filled
  • Average number of Open slots filled
  • Average point score in English EBacc subject area including English literature
  • Average point score in Mathematics EBacc subject area
  • Average point score in Science EBacc subject area
  • Average score per pupil from GCSEs in open Attainment 8 slots
  • Average score per pupil from non-GCSEs in open Attainment 8 slots
  • Average score per pupil from open Attainment 8 slots
  • Percentage of pupils achieving any passes at GCSE or equivalent
  • Percentage of pupils achieving grade 4 or above in Ebacc English component
  • Percentage of pupils achieving grade 4 or above in Ebacc Humanities component
  • Percentage of pupils achieving grade 4 or above in Ebacc Languages component
  • Percentage of pupils achieving grade 4 or above in Ebacc Mathematics component
  • Percentage of pupils achieving grade 4 or above in Ebacc Science component
  • Percentage of pupils achieving grade 5 or above in Ebacc English component
  • Percentage of pupils achieving grade 5 or above in Ebacc Humanities component
  • Percentage of pupils achieving grade 5 or above in Ebacc Languages component
  • Percentage of pupils achieving grade 5 or above in Ebacc Mathematics component
  • Percentage of pupils achieving grade 5 or above in Ebacc Science component
  • 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 achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)
  • Percentage of pupils achieving the English Baccalaureate (grades 5 or above in English and maths, A*-C in unreformed subjects)
  • Percentage of pupils entered for Ebacc English
  • Percentage of pupils entered for Ebacc Humanities (Geography or History)
  • Percentage of pupils entered for Ebacc Languages
  • Percentage of pupils entered for Ebacc Mathematics
  • Percentage of pupils entered for Ebacc Science
  • Percentage of pupils entering English and Mathematics GCSEs
  • Percentage of pupils entering GCSEs or equivalents
  • Percentage of pupils entering the English Baccalaureate
  • Total Attainment 8 score in Ebacc subjects
  • Total Attainment 8 score in English
  • Total Attainment 8 score in Mathematics
  • Total EBacc APS score of pupils
  • Total highest point score in Humanities EBacc subject area
  • Total highest point score in Languages EBacc subject area
  • Total number of Ebacc slots filled
  • Total number of Open slots filled
  • Total number of pupils achieving any passes at GCSE or equivalent
  • Total number of pupils achieving grade 4 or above in Ebacc English component
  • Total number of pupils achieving grade 4 or above in Ebacc Humanities component
  • Total number of pupils achieving grade 4 or above in Ebacc Languages component
  • Total number of pupils achieving grade 4 or above in Ebacc Mathematics component
  • Total number of pupils achieving grade 4 or above in Ebacc Science component
  • Total number of pupils achieving grade 5 or above in Ebacc English component
  • Total number of pupils achieving grade 5 or above in Ebacc Humanities component
  • Total number of pupils achieving grade 5 or above in Ebacc Languages component
  • Total number of pupils achieving grade 5 or above in Ebacc Mathematics component
  • Total number of pupils achieving grade 5 or above in Ebacc Science component
  • 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 achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)
  • Total number of pupils achieving the English Baccalaureate (grades 5 or above in English and maths, A*-C in unreformed subjects)
  • Total number of pupils at the end of key stage 4
  • Total number of pupils entered for Ebacc English
  • Total number of pupils entered for Ebacc Humanities (Geography or History)
  • Total number of pupils entered for Ebacc Languages
  • Total number of pupils entered for Ebacc Mathematics
  • Total number of pupils entered for Ebacc Science
  • Total number of pupils entering English and Mathematics GCSEs
  • Total number of pupils entering GCSEs or equivalents
  • Total number of pupils entering the English Baccalaureate
  • Total number of schools
  • Total point score in English EBacc subject area including English literature
  • Total point score in Mathematics EBacc subject area
  • Total point score in Science EBacc subject area
  • Total score from GCSEs in open Attainment 8 slots
  • Total score from non-GCSEs in open Attainment 8 slots
  • Total score from open Attainment 8 slots
  • Total sum of pupils Attainment 8 scores
Filters
  • Gender
Time period
2018/19 to 2021/22

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_flagschool_characteristicbreakdowncharacteristic_gendercharacteristic_admission_typecharacteristic_religious_denominationt_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
202122Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)TotalGirlsTotalTotal375928615414727591.2151.527821397.215110752.820523271.712556843.96948924.39085131.71289052.944.527123941921.4460.150.150.1679503.990.290.290.3-24391.085-0.09-0.1-0.0816008.9350.060.050.0779416.4620.290.290.328071598.127988197.82747259627867497.427451995.923625382.614663451.220823272.815834155.314441652.614324960.610191869.524187784.521043673.519383070.617149672.611700979.816006365.591359567.014.751377894.54.8212240534.28794289.52.78321246011.22719134.029.5421885014.74577147.19163769484.9413.2807662.252.88033672.88062452.8
202122Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)TotalBoysTotalTotal380329904713879463.646.428595495.614128347.219868766.4101561344959116.66636222.21217487.694.07282288-58705.029-0.21-0.21-0.2-104462.545-0.37-0.38-0.369995.540.040.030.04-36092.566-0.13-0.13-0.12-104123.212-0.37-0.37-0.3628938196.828803096.328065793.92870969628152994.124132480.711586138.717555758.716281454.414138150.2130225547008860.522071573.821628972.31915736816199667.1834047214331934.791410468.014.721375011.254.611390163.81572229.511.9128793009.62820936.029.44104999.8813.74074227.713.63269709.4510.9804518.252.78176412.78168282.7
202122Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)TotalTotalTotalTotal401558520128607054.8148.956416796.4292390504039196922712938.811908020.315721326.92506540.634.28553527-16783.583-0.03-0.03-0.03-24958.555-0.05-0.05-0.04-14395.545-0.03-0.03-0.02-20083.631-0.04-0.04-0.03-24706.75-0.04-0.05-0.0457009697.45679119755538294.956577096.75560489547757781.626249544.938378965.632115554.928579751.427347457.317200665.54625927942672572.938540369.333349269.820041376.330338295.182770035.024.732752905.754.723630694.041366519.012.34609176010.45540070.049.58323849.8814.28651374.8914.87039194.39121612180.52.816210082.816230732.8
202122Academic yearRegionalE92000001EnglandE12000001North EastRevised00State-funded schools (LA)TotalTotalTotalTotal194277711303123.2546.92643395.212787461827965.8945134506518.2676624.4111925.784.0326968-7304.602-0.27-0.29-0.25-7372.655-0.27-0.29-0.25-9633.875-0.36-0.38-0.34-10365.408-0.38-0.4-0.36-3793.043-0.14-0.16-0.122678796.52664495.92595393.52651995.52596393.52257181.31072738.61755963.21401750.51241947.81230554.5693864.72135676.91935569.71725066.41532067.9821776.613892951238204.46123345.54.441083113.9538041.9427926810.12476408.9369815.513.3406399.7514.6286585.510.3119814.254.3755132.7758212.7
202122Academic yearRegionalE92000001EnglandE12000001North EastRevised00State-funded schools (LA)TotalGirlsTotalTotal1901363167235149.31314496.4657748.3926568533039.1303922.3399629.357719.774.2313275-1285.763-0.1-0.12-0.07533.630.040.010.07-5647.01-0.43-0.45-0.4-3970.409-0.3-0.33-0.272546.9640.190.160.221327197.413218971295995.11316396.61296295.11132583.1609844.7951169.8689550.6627248.4649457.3425869.81122382.3950869.8868567794270.1492480.7733885.38608274.4661913.54.54564004.14318782.3414737510.81216548.9187784.513.8215537.515.815419311.361344.54.5377882.8379822.8

Variables in this data set

Table showing all 79 variables
Variable nameVariable description
avg_att8Average Attainment 8 score of all pupils
avg_att8_ebacAverage Attainment 8 score per pupil in Ebacc subjects
avg_att8_engAverage Attainment 8 score per pupil in English
avg_att8_matAverage Attainment 8 score per pupil in Mathematics
avg_att8_openAverage score per pupil from open Attainment 8 slots
avg_att8_open_gAverage score per pupil from GCSEs in open Attainment 8 slots
avg_att8_open_ngAverage score per pupil from non-GCSEs in open Attainment 8 slots
avg_ebac_fillAverage number of Ebacc slots filled
avg_ebaccapsAverage EBacc APS score per pupil
avg_ebptseng_llAverage point score in English EBacc subject area including English literature
avg_ebptshumAverage highest point score in Humanities EBacc subject area
avg_ebptslanAverage highest point score in Languages EBacc subject area
avg_ebptsmatAverage point score in Mathematics EBacc subject area
avg_ebptssciAverage point score in Science EBacc subject area
avg_open_fillAverage number of Open slots filled
characteristic_genderGender
pt_anypassPercentage of pupils achieving any passes at GCSE or equivalent
pt_ebac2sci_94Percentage of pupils achieving grade 4 or above in Ebacc Science component
pt_ebac2sci_95Percentage of pupils achieving grade 5 or above in Ebacc Science component
pt_ebac2sci_ePercentage of pupils entered for Ebacc Science
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_ebaceng_94Percentage of pupils achieving grade 4 or above in Ebacc English component
pt_ebaceng_95Percentage of pupils achieving grade 5 or above in Ebacc English component
pt_ebaceng_ePercentage of pupils entered for Ebacc English
pt_ebachum_94Percentage of pupils achieving grade 4 or above in Ebacc Humanities component
pt_ebachum_95Percentage of pupils achieving grade 5 or above in Ebacc Humanities component
pt_ebachum_ePercentage of pupils entered for Ebacc Humanities (Geography or History)
pt_ebaclan_94Percentage of pupils achieving grade 4 or above in Ebacc Languages component
pt_ebaclan_95Percentage of pupils achieving grade 5 or above in Ebacc Languages component
pt_ebaclan_ePercentage of pupils entered for Ebacc Languages
pt_ebacmat_94Percentage of pupils achieving grade 4 or above in Ebacc Mathematics component
pt_ebacmat_95Percentage of pupils achieving grade 5 or above in Ebacc Mathematics component
pt_ebacmat_ePercentage of pupils entered for Ebacc Mathematics
pt_entbasicsPercentage of pupils entering English and Mathematics GCSEs
pt_entry_1Percentage of pupils entering GCSEs or equivalents
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_anypassTotal number of pupils achieving any passes at GCSE or equivalent
t_att8Total sum of pupils Attainment 8 scores
t_att8_ebacTotal Attainment 8 score in Ebacc subjects
t_att8_engTotal Attainment 8 score in English
t_att8_matTotal Attainment 8 score in Mathematics
t_att8_openTotal score from open Attainment 8 slots
t_att8_open_gTotal score from GCSEs in open Attainment 8 slots
t_att8_open_ngTotal score from non-GCSEs in open Attainment 8 slots
t_ebac_fillTotal number of Ebacc slots filled
t_ebac2sci_94Total number of pupils achieving grade 4 or above in Ebacc Science component
t_ebac2sci_95Total number of pupils achieving grade 5 or above in Ebacc Science component
t_ebac2sci_eTotal number of pupils entered for Ebacc Science
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_ebaceng_94Total number of pupils achieving grade 4 or above in Ebacc English component
t_ebaceng_95Total number of pupils achieving grade 5 or above in Ebacc English component
t_ebaceng_eTotal number of pupils entered for Ebacc English
t_ebachum_94Total number of pupils achieving grade 4 or above in Ebacc Humanities component
t_ebachum_95Total number of pupils achieving grade 5 or above in Ebacc Humanities component
t_ebachum_eTotal number of pupils entered for Ebacc Humanities (Geography or History)
t_ebaclan_94Total number of pupils achieving grade 4 or above in Ebacc Languages component
t_ebaclan_95Total number of pupils achieving grade 5 or above in Ebacc Languages component
t_ebaclan_eTotal number of pupils entered for Ebacc Languages
t_ebacmat_94Total number of pupils achieving grade 4 or above in Ebacc Mathematics component
t_ebacmat_95Total number of pupils achieving grade 5 or above in Ebacc Mathematics component
t_ebacmat_eTotal number of pupils entered for Ebacc Mathematics
t_ebptseng_llTotal point score in English EBacc subject area including English literature
t_ebptshumTotal highest point score in Humanities EBacc subject area
t_ebptslanTotal highest point score in Languages EBacc subject area
t_ebptsmatTotal point score in Mathematics EBacc subject area
t_ebptssciTotal point score in Science EBacc subject area
t_entbasicsTotal number of pupils entering English and Mathematics GCSEs
t_entry_1Total number of pupils entering GCSEs or equivalents
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_open_fillTotal number of Open slots filled
t_pupilsTotal number of pupils at the end of key stage 4
t_schoolsTotal number of schools

Footnotes

  1. 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. 'England' includes all pupils from state-funded schools, 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. In 2020 and 2021, all GCSEs in England have been reformed and use the new 9 to 1 grading system (rather than A*-G). Year on year comparisons will be limited until these qualifications are consistently included from 2020 onwards. However, results for 2020 and 2021 are not comparable with earlier years due to the cancellation of exams (due to COVID-19) and the changes to the way GCSE grades were awarded and results for 2022 are not comparable with previous years due to the changes relating to grading assessments.
  3. 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 is not being supressed in 2022 at local authority or national level.
  4. In 2021, two new local authorities were introduced (North Northamptonshire and West Northamptonshire) which replaced Northamptonshire.
  5. City of London does not have any state funded secondary schools, therefore there are no entries present in the data for this local authority.
  6. : = When data is unavailable for other reasons
  7. EBacc sciences includes the double award GCSE in combined science, and single GCSEs in biology, chemistry, physics and computer science.
  8. Average number of slots filled that contains U grades or other qualifications scoring 0 points are counted as a non-filled slot.
  9. z = When an observation is not applicable
  10. In 2019, two new local authorities were created from a merger of others. Bournemouth, Christchurch and Poole was created on 1 April 2019 from areas that were previously administered by the unitary authorities of Bournemouth and Poole, and the district of Christchurch. Dorset was created on 1 April 2019 from the districts of Weymouth and Portland, West Dorset, North Dorset, Purbeck and East Dorset. 2019 data is not comparable to previous years.
  11. 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.
  12. The open element contains the three highest point scores in any three other subjects, 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.

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/2ad5c9f3-e2f9-4508-9eae-6c5d086c99ec/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/2ad5c9f3-e2f9-4508-9eae-6c5d086c99ec/csv")

Contact us

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

Attainment statistics team

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