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
  • sex
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_nameversionpriority_area_flageducation_investment_area_flagbreakdown_topicbreakdownestablishment_type_groupsexno_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_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_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_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_engagement_model_or_below_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_arrivedavg_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_arrivedavg_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_arrivedavg_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_engagement_model_or_below_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 schoolsBoys6425961225911518100311302142109923327.13044625910220114421021621405259124339242102162160724429.76188925991396251714474010244-553.57009725911314510241447391250990.1164396820.909151721-0.6762723563984416009948133616001000.1219749550.79827344-0.554323531351371075232000-2.268729906-1.554255372-2.98320444445600
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00SEN statusAll SENState-funded schoolsGirls5815137115165136710811321301013967.09104315166116715211331317315161871153113212928144-218.5802021516755113131032010147-123.37896315158921025143944751990.4826693741.508996988-0.543658244474410119940547102198-1.517918069-0.637574732-2.39826140744334991021010-0.8393126730.081185645-1.759810992386110
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00SEN statusAll SENState-funded schoolsTotal6741098341018031167412113463410937294.2214894101683118157313493457841018541163574134834535388-188.81831341015881473830154106020391-676.9490641017123720241448411050990.2532835730.880650967-0.37408382241844141099451040141099-0.4866451370.049666803-1.02295707639236974121000-1.731327519-1.166919354-2.295735685425800
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00Ethnicity majorAny other ethnic groupState-funded schoolsBoys141571157271001413909-23.0034471598510014148115105410014147093.127771158242100000009-8.55388715780047747134770099-2.5559385561.477469481-6.5893465926053337001066733277001050.3475301113.868903462-3.173843245313271370000000-0.9504318892.769717776-4.670581554475300
201819Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadFinal00Ethnicity majorAny other ethnic groupState-funded schoolsGirls12181521817901001718641291.5793011817901001718831816511001718211245.2981171816210000010001242.92296618162008311945006001107.63160841711.124642244.13857459394500600111892866001073.7748430836.8244418620.725244305891160000060003.5769138336.7986579490.355169718891100

Variables in this data set

Table showing first 5 of 103 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. Figures for 2024 are based on revised data. Figures for other years are based on final data.
  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. Local authority codes may be shown where they have changed since 2016.
  4. 'State-funded schools' includes LA maintained schools, sponsored academies, converter academies, free schools and state-funded special schools (excluding hospital schools).
  5. Regional figures are rounded in the historical data before 2022.

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