Data set from Key stage 2 attainment

Attainment by region, local authority and pupil characteristics

Latest data
Published
Last updated

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


Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Average progress score for maths
  • Average progress score for reading
  • Average progress score for writing TA
Filters
  • Characteristics of each group
  • Gender
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_nameold_la_codenew_la_codela_nameversionpriority_area_flageducation_investment_area_flagbreakdown_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 authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00SEN statusAll SENState-funded schoolsBoys642596122591151810031130z2142109923327.130446259102201144210z2162140525912433924210z2162160724429.76188925991396251714474zzz0z10244-553.57009725911314510241447391250z990.1164396820.909151721-0.676272356398441600z994813361600z1000.1219749550.79827344-0.554323531351371075232zzz0z00-2.268729906-1.554255372-2.98320444445600
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00SEN statusAll SENState-funded schoolsGirls581513711516513671081z1321301013967.0910431516611671521z13313173151618711531z13212928144-218.5802021516755113131032zzz0z10147-123.37896315158921025143944751z990.4826693741.508996988-0.54365824447441011z99405471021z98-1.517918069-0.637574732-2.39826140744334991021zzz0z10-0.8393126730.081185645-1.759810992386110
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00SEN statusAll SENState-funded schoolsTotal674109834101803116741211z3463410937294.221489410168311815731z34934578410185411635741z34834535388-188.81831341015881473830154106zzz0z20391-676.9490641017123720241448411050z990.2532835730.880650967-0.374083822418441410z994510401410z99-0.4866451370.049666803-1.02295707639236974121zzz0z00-1.731327519-1.166919354-2.295735685425800
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00Ethnicity majorAny other ethnic groupState-funded schoolsBoys14157115727100z1413909-23.00344715985100z141481151054100z14147093.12777115824210000zzz0z009-8.553887157800477471347700z99-2.5559385561.477469481-6.589346592605333700z106673327700z1050.3475301113.868903462-3.173843245313271370000zzz0z00-0.9504318892.769717776-4.670581554475300
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00Ethnicity majorAny other ethnic groupState-funded schoolsGirls1218152181790100z1718641291.579301181790100z171883181651100z1718211245.298117181621000001zzz0z001242.9229661816200831194500600z1107.63160841711.124642244.13857459394500600z11189286600z1073.7748430836.8244418620.72524430589116000006zzz0z003.5769138336.7986579490.355169718891100

Variables in this data set

Table showing first 5 of 119 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. Local authority codes made be shown where they have changed since 2016.

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