Data set from Key stage 2 attainment

Attainment by region and local authority

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 region and local authority.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
Release
Academic year 2022/23
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Number of schools
  • Number of eligible pupils in reading, writing and maths
  • Number of eligible pupils in reading
Filters
  • Gender
Time period
2015/16 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_flagschool_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
201516Academic yearRegionalE92000001EnglandE12000003Yorkshire and The HumberFinal00State-funded schoolsTotal17265957029680251059580366509360208201940120z30570505796850zz595704145011520161101850120z3057550594205059570401508480173801840150z30575205893580zz5957043300805012010zzzzzz2420880370z4503060zz5957046840125504010050462163530z0102zzz70192730z010367142930z0102zzz731420zzzzzz411z100zzz792100
201516Academic yearRegionalE92000001EnglandE12000007LondonFinal00State-funded schoolsTotal171488430524006620884406141018270245902290110z30856708848460zz884406952025790165902210100z30860909077580884406769019910184302160130z30861008991860zz88430698001606014130zzzzzz2410760450z6902090zz8843074220139903011059769212830z0103zzz79291920z010577232120z0104zzz791816zzzzzz311z100zzz841600
201516Academic yearRegionalE92000001EnglandE12000009South WestFinal00State-funded schoolsTotal176554270284702810542803706011510155701480140z30523505400150zz542803863011560140501410160z3052670546059054280369808250156801410170z40526505404820zz5427038430717011920zzzzzz2310740400z3503060zz542704322010920405052568212930z0103zzz71212630z010468152930z0103zzz711322zzzzzz411z100zzz802000
201516Academic yearRegionalE92000001EnglandE12000004East MidlandsFinal00State-funded schoolsTotal14974977025690235049780318708240162601480110z30478304882970zz497803558010320126401410110z3048220499631049780340107200141901390130z30481804944130zz497703681074109810zzzzzz1700590330z3704080zz49770404009210507052564173330z0102zzz71212530z010468142930z0103zzz741520zzzzzz311z100zzz811800
201516Academic yearRegionalE92000001EnglandE12000005West MidlandsFinal00State-funded schoolsTotal165565420332402890654304158010760215502080100z40627406400780zz654304691014140163001990100z4063210655989065430442709830189501960120z40631906482440zz6542047470837013390zzzzzz2450830560z5804060zz654205197013270609051464163330z0102zzz72222530z010468152930z0103zzz731320zzzzzz411z100zzz792000

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. 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.
  3. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  4. Figures for 2023 are based on revised data. Figures for other years are based on final data.
  5. All figures include LA maintained schools, academies and free schools. Excludes alternative provision and independent schools.
  6. 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

Download this data using code

Access this data using common programming languages using the URL below.

Example code