Data set from Key stage 2 attainment

Attainment by school location and pupil characteristics

Not the latest data
Published
Last updated

This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by school location. This file also contains a flag showing which local authority districts are priority areas. Fenland and East Cambridgeshire, West Somerset  and Scarborough breakdowns are available for 2022 and 2023, these are priority areas which are not local authority districts.


Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
Release type
Geographic levels
Local authority district, National, Regional
Indicators
  • Number of schools
  • Number of eligible pupils in grammar, punctuation and spelling
  • Number of eligible pupils in maths
Filters
  • Characteristics of each group
Time period
2018/19 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_namelad_codelad_nameversionpriority_areabreakdown_topicbreakdownschool_typegenderno_schoolst_rwm_eligible_pupilst_rwm_met_expected_standardt_rwm_met_higher_standardt_read_eligible_pupilst_read_met_expected_standardt_read_met_higher_standardt_read_not_achieved_expected_standardt_read_working_below_assessmentt_read_absentt_read_unable_to_access_or_just_arrivedt_read_unable_to_accesst_read_avg_scaled_score_eligible_pupilst_read_sum_scaled_scorest_read_progress_eligible_pupilst_read_progress_scoret_gps_eligible_pupilst_gps_met_expected_standardt_gps_met_higher_standardt_gps_not_achieved_expected_standardt_gps_working_below_assessmentt_gps_absentt_gps_unable_to_access_or_just_arrivedt_gps_unable_to_accesst_gps_avg_scaled_score_eligible_pupilst_gps_sum_scaled_scorest_mat_eligible_pupilst_mat_met_expected_standardt_mat_met_higher_standardt_mat_not_achieved_expected_standardt_mat_working_below_assessmentt_mat_absentt_mat_unable_to_access_or_just_arrivedt_mat_unable_to_accesst_mat_avg_scaled_score_eligible_pupilst_mat_sum_scaled_scorest_mat_progress_eligible_pupilst_mat_progress_scoret_writta_eligible_pupilst_writta_met_expected_standardt_writta_met_higher_standardt_writta_working_towards_expected_standardt_writta_pre_key_stage_standard_6t_writta_pre_key_stage_standard_5t_writta_pre_key_stage_standard_4t_writta_pre_key_stage_standard_3t_writta_pre_key_stage_standard_2t_writta_pre_key_stage_standard_1t_writta_growing_development_of_expected_standardt_writta_early_development_of_expected_standardt_writta_foundations_of_expected_standardt_writta_engagement_model_or_below_pre_key_stage_standardst_writta_below_interim_pre_key_stage_standardst_writta_absentt_writta_disappliedt_writta_progress_eligible_pupilst_writta_progress_scoret_scita_eligible_pupilst_scita_met_expected_standardt_scita_not_met_expected_standardt_scita_absentt_scita_disappliedpt_rwm_met_expected_standardpt_rwm_met_higher_standardpt_read_met_expected_standardpt_read_met_higher_standardpt_read_not_achieved_expected_standardpt_read_working_below_assessmentpt_read_absentpt_read_unable_to_access_or_just_arrivedpt_read_unable_to_accessavg_read_scaled_scoreavg_read_progress_scoreavg_read_progress_score_upper_ciavg_read_progress_score_lower_cipt_gps_met_expected_standardpt_gps_met_higher_standardpt_gps_not_achieved_expected_standardpt_gps_working_below_assessmentpt_gps_absentpt_gps_unable_to_access_or_just_arrivedpt_gps_unable_to_accessavg_gps_scaled_scorept_mat_met_expected_standardpt_mat_met_higher_standardpt_mat_not_achieved_expected_standardpt_mat_working_below_assessmentpt_mat_absentpt_mat_unable_to_access_or_just_arrivedpt_mat_unable_to_accessavg_mat_scaled_scoreavg_mat_progress_scoreavg_mat_progress_score_upper_ciavg_mat_progress_score_lower_cipt_writta_met_expected_standardpt_writta_met_higher_standardpt_writta_working_towards_expected_standardpt_writta_pre_key_stage_standard_6pt_writta_pre_key_stage_standard_5pt_writta_pre_key_stage_standard_4pt_writta_pre_key_stage_standard_3pt_writta_pre_key_stage_standard_2pt_writta_pre_key_stage_standard_1pt_writta_growing_development_of_expected_standardpt_writta_early_development_of_expected_standardpt_writta_foundations_of_expected_standardpt_writta_engagement_model_or_below_pre_key_stage_standardspt_writta_below_interim_pre_key_stage_standardspt_writta_absentpt_writta_disappliedavg_writta_progress_scoreavg_writta_progress_score_upper_ciavg_writta_progress_score_lower_cipt_scita_met_expected_standardpt_scita_not_met_expected_standardpt_scita_absentpt_scita_disapplied
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinal1Disadvantage statusDisadvantagedState-funded schoolsTotal3155729922557357881732511z52953887542-303.9380195573781241522511z53054915557394761362511z53054499542-232.738715557392671231667630zzz3z10546-89.41034255739616010544641631400z102-0.560771253-0.041022123-1.080520382682227400z104711424400z103-0.4294072230.024360587-0.883175034701222311110zzz1z00-0.1637552050.31386792-0.64137833712900
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinal1Free school meal statusFSM eligibleState-funded schoolsTotal3137017810370219511361311z35435682358-390.838177370238661171311z35536452370249401061311z35536264358-240.51056237024735961243410zzz2z10360-182.3143937025311610483591437400z101-1.091726751-0.452210035-1.731243467641832400z103671129400z102-0.671817212-0.113486118-1.23014830667926311100zzz1z00-0.5064288610.081778448-1.09463617683100
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinal1Disadvantage statusNot known to be disadvantagedState-funded schoolsTotal316165007361653719173510z60964775607525.95320861655227058510z6106604161656218148510z61065105607465.93098661656016447321100zzz2z00608621.94658861656649108112873112100z1060.866479751.3576126960.37534680390449100z10891298100z1070.7675963531.1963807580.33881194791278000000zzz0z001.0229384671.4755544410.57032249392800
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinal1Free school meal statusNot known to be FSM eligibleState-funded schoolsTotal31803621858036752281101710z78482980791612.853366803692328931710z78584504803707217781710z78583340791473.70283380370519674745320zzz3z00794714.85063680370993107711842814200z1060.7747830161.2050174560.344548577864112200z108882710200z1060.5988657810.9744826490.22324891488249101000zzz0z000.9003156621.2963851770.504246148881200
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinal1School typeTotalState-funded schoolsTotal3111737999511738942792463021z11381186621149222.01518911739303942103021z114012095611739562571843021z11401196041149233.19227111739522311701988730zzz5z101154532.536246117396220920688762421300z1040.1932247080.550196089-0.163746674793418300z106822216300z1050.2029523680.514606805-0.108702068812014211100zzz0z000.4614698840.7900027050.132937063821800

Variables in this data set

Table showing first 5 of 118 variables
Variable nameVariable description
avg_gps_scaled_scoreGrammar, punctuation and spelling average scaled score
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_mat_scaled_scoreMaths average scaled score

Footnotes

  1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
  2. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  3. Figures for 2023 are based on revised data. Figures for other years are based on final data.

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