Data set from Key stage 4 performance

Local authority characteristics data

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

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
Release type
Number of rows
70,973
Geographic levels
Local authority, National, Regional
Indicators
  • Average Attainment 8 score
  • Average EBacc APS score
  • Average Progress 8 score
  • 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
  • Number of pupils at the end of KS4
  • Number of schools
  • Sum of Attainment 8 scores
  • 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
  • Progress 8 lower 95% confidence interval
  • Progress 8 upper 95% confidence interval
Filters
  • Sex
  • Major ethnic group
  • Minor ethnic group
  • Disadvantaged status
  • Free school meals status
  • First language
  • Special educational needs - status
  • Special educational needs - provision
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_groupbreakdownsexethnicity_majorethnicity_minorfree_school_mealssen_provisionsen_statusdisadvantagefirst_languaget_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
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Ethnicity minorBoysAsianAny other Asian backgroundTotalTotalTotalTotalTotal18936454340342.7652.7625096.8399962498277.2312448.4157224.4207232.130998.994.854462982.2510.550.510.59
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Ethnicity minorBoysAsianBangladeshiTotalTotalTotalTotalTotal10885509273374.549.6528696309356.1400772.7281551.1116721.2162229.424708.324.4951751582.7990.310.270.34
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Ethnicity minorBoysAsianChineseTotalTotalTotalTotalTotal10452064136236.0166201897.8162278.6183188.7137566.699348.1115956.213013.146.312031181.8690.980.91.06
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Ethnicity minorBoysAsianIndianTotalTotalTotalTotalTotal183010614613308.0557.81040998.1734969.2877382.7583955326930.841393956187.245.2991186721.0820.740.710.77
202324Academic yearNationalE92000001EnglandRevised00State-funded schools (LA)Ethnicity minorBoysAsianPakistaniTotalTotalTotalTotalTotal159814819661379.2644.61432296.6676845.7956464.5626842.3205513.9306520.758837.433.9713696748.9490.050.030.08

Variables in this data set

Table showing all 31 variables
Variable nameVariable description
avg_att8Average Attainment 8 score
avg_ebaccapsAverage EBacc APS score
avg_p8scoreAverage Progress 8 score
disadvantageDisadvantaged status
ethnicity_majorMajor ethnic group
ethnicity_minorMinor ethnic group
first_languageFirst language
free_school_mealsFree school meals status
p8score_ci_lowProgress 8 lower 95% confidence interval
p8score_ci_uppProgress 8 upper 95% confidence interval
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_entbasicsPercentage of pupils entering English and maths GCSEs
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
sen_provisionSpecial educational needs - provision
sen_statusSpecial educational needs - status
sexSex
t_att8Sum of Attainment 8 scores
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_entbasicsNumber of pupils entering English and maths GCSEs
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_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. Sub totals for EAL and SEN breakdowns may not sum to the grand total due to a small number of pupils with missing information.
  3. Unclassified includes pupils for whom the information was not obtained, refused or could not be determined.
  4. Progress 8 was not published in 2020 or 2021 because of the COVID-19 pandemic.
  5. 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.
  6. 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.
  7. 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.
  8. 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/85bdb5af-d60c-42a2-a19c-de7bb02447c5/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/85bdb5af-d60c-42a2-a19c-de7bb02447c5/csv")

Contact us

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

Attainment statistics team

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