Data set from Key stage 2 attainment

Key stage 2 attainment by pupil residency and pupil characteristics

Not the latest data
Published
Last updated

This file contains data on the attainment and progress of pupils in key stage 2 assessments in England, broken down by pupil residency and pupil characteristics. 


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
  • Average progress score for maths
  • Average progress score for reading
  • Average progress score for writing TA
Filters
  • Characteristics of each group
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_namelad_codelad_nameversioncharacteristic_groupcharacteristicschool_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 EastE06000001HartlepoolFinalDisadvantage statusDisadvantagedState-funded schoolsTotal4056030325560362921732311z53454441543-309.2567855603821281542211z53655579560399801372211z53655147543-222.1373560396701241667620zzz2z10547-102.93611156040115810544651631400z102-0.569533674-0.050263355-1.088803993682328400z104711424400z103-0.4090926340.044257151-0.862442418711322311100zzz0z00-0.1881830180.289003323-0.665369359722800
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinalFree school meal statusFSM eligibleState-funded schoolsTotal3837518213375224541361311z35936221361-393.234237375242691191211z36137098375254431071211z36136904361-221.83987537525138971243410zzz2z10363-178.56282137525811610493601436300z101-1.089291515-0.452437615-1.726145416651832300z103681129300z102-0.614514889-0.058508571-1.170521208671026311100zzz1z00-0.4919085980.09386306-1.077680255693100
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinalDisadvantage statusNot known to be disadvantagedState-funded schoolsTotal366175007261753719074510z61064862609531.07651661755327058510z6116615161756318248510z61165209609485.87557561756116447321100zzz2z00610644.14420461756749108112873112100z1060.8720468241.3623726490.38172099990449100z10891298100z1070.7978252461.2259049940.36974549991278000000zzz0z001.0559741051.5078474760.60410073392800
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinalFree school meal statusNot known to be FSM eligibleState-funded schoolsTotal38802621848026752281111510z78583082791615.053968802693329931510z78684632802708219781510z78683452791485.5781580270619674745310zzz2z00794719.77091480271091107710842814200z1060.7775650671.2077995070.347330627864112200z108882710200z1060.6138788240.9894956920.23826195788249101000zzz0z000.9065124861.3025820.510442972891100
201819Academic yearLocal authority districtE92000001EnglandE12000001North EastE06000001HartlepoolFinalSchool typeTotalState-funded schoolsTotal4511778039711778992822472821z11441193031152221.81973111779353982122721z114712173011779622621852721z11471203561152263.73827511779572341711988720zzz4z101157541.208093117796820720688762421200z1040.192551850.549058122-0.163954422793418200z106822216200z1050.2289394750.540187847-0.082308897812015211100zzz0z000.4677684470.7958750630.139661831821800

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. Disadvantaged pupils are defined as: those who were registered as eligible for free school meals at any point in the last six years, children looked after by a local authority or have left local authority care in England and Wales through adoption, a special guardianship order, a residence order or a child arrangements order. These 2022 statistics are revised and now include pupils in the care of a local authority. These pupils were not included in the provisional statistics unless they were also eligible for free school meals during the last 6 years or ceased to be looked-after in the last year.
  2. Figures for 2022 are based on revised data. Figures for other years are based on final data.
  3. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
  4. Writing teacher assessment and reading, writing and maths (combined) measures from 2018 onwards are not directly comparable to previous years due to changes in the writing teacher assessment frameworks.
  5. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.

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