Data set from Key stage 2 attainment

Key stage 2 attainment by region and local authority

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

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
Release
Academic year 2021/22
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Number of schools
  • Percentage of pupils meeting the expected standard in science TA
  • Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
Filters
  • Gender ofpupils
Time period
2015/16 to 2021/22

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameversioneducation_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 HumberFinalState-funded schoolsTotal17265957029680251059580366509360208201940120z30570505796850zz595704145011520161101850120z3057550594205059570401508480173801840150z30575205893580zz5957043300805012010zzzzzz2420880370z4503060zz5957046840125504010050462163530z0102zzz70192730z010367142930z0102zzz731420zzzzzz411z100zzz792100
201516Academic yearRegionalE92000001EnglandE12000007LondonFinalState-funded schoolsTotal171488430524006620884406141018270245902290110z30856708848460zz884406952025790165902210100z30860909077580884406769019910184302160130z30861008991860zz88430698001606014130zzzzzz2410760450z6902090zz8843074220139903011059769212830z0103zzz79291920z010577232120z0104zzz791816zzzzzz311z100zzz841600
201516Academic yearRegionalE92000001EnglandE12000009South WestFinalState-funded schoolsTotal176554270284702810542803706011510155701480140z30523505400150zz542803863011560140501410160z3052670546059054280369808250156801410170z40526505404820zz5427038430717011920zzzzzz2310740400z3503060zz542704322010920405052568212930z0103zzz71212630z010468152930z0103zzz711322zzzzzz411z100zzz802000
201516Academic yearRegionalE92000001EnglandE12000004East MidlandsFinalState-funded schoolsTotal14974977025690235049780318708240162601480110z30478304882970zz497803558010320126401410110z3048220499631049780340107200141901390130z30481804944130zz497703681074109810zzzzzz1700590330z3704080zz49770404009210507052564173330z0102zzz71212530z010468142930z0103zzz741520zzzzzz311z100zzz811800
201516Academic yearRegionalE92000001EnglandE12000005West MidlandsFinalState-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. Figures for Isles of Scilly and City of London are based on a single school in each local authority and therefore figures have been suppressed.
  2. All figures include LA maintained schools, academies and free schools. Excludes alternative provision and independent schools.
  3. Figures for 2022 are based on revised data. Figures for other years are based on final data.
  4. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
  5. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  6. Users are advised to take care when interpreting writing and science teacher assessment measures and reading, writing and maths (combined) measures for West Sussex, particularly when making comparisons over time or between local authorities. This local authority has higher rates of missing teacher assessment in 2022 than other areas - see ‘Data quality’ section for further detail.

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