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.
On this page
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
time_period | time_identifier | geographic_level | country_code | country_name | region_code | region_name | old_la_code | new_la_code | la_name | version | education_investment_area_flag | school_type | gender | no_schools | t_rwm_eligible_pupils | t_rwm_met_expected_standard | t_rwm_met_higher_standard | t_read_eligible_pupils | t_read_met_expected_standard | t_read_met_higher_standard | t_read_not_achieved_expected_standard | t_read_working_below_assessment | t_read_absent | t_read_unable_to_access_or_just_arrived | t_read_unable_to_access | t_read_avg_scaled_score_eligible_pupils | t_read_sum_scaled_scores | t_read_progress_eligible_pupils | t_read_progress_score | t_gps_eligible_pupils | t_gps_met_expected_standard | t_gps_met_higher_standard | t_gps_not_achieved_expected_standard | t_gps_working_below_assessment | t_gps_absent | t_gps_unable_to_access_or_just_arrived | t_gps_unable_to_access | t_gps_avg_scaled_score_eligible_pupils | t_gps_sum_scaled_scores | t_mat_eligible_pupils | t_mat_met_expected_standard | t_mat_met_higher_standard | t_mat_not_achieved_expected_standard | t_mat_working_below_assessment | t_mat_absent | t_mat_unable_to_access_or_just_arrived | t_mat_unable_to_access | t_mat_avg_scaled_score_eligible_pupils | t_mat_sum_scaled_scores | t_mat_progress_eligible_pupils | t_mat_progress_score | t_writta_eligible_pupils | t_writta_met_expected_standard | t_writta_met_higher_standard | t_writta_working_towards_expected_standard | t_writta_pre_key_stage_standard_6 | t_writta_pre_key_stage_standard_5 | t_writta_pre_key_stage_standard_4 | t_writta_pre_key_stage_standard_3 | t_writta_pre_key_stage_standard_2 | t_writta_pre_key_stage_standard_1 | t_writta_growing_development_of_expected_standard | t_writta_early_development_of_expected_standard | t_writta_foundations_of_expected_standard | t_writta_engagement_model_or_below_pre_key_stage_standards | t_writta_below_interim_pre_key_stage_standards | t_writta_absent | t_writta_disapplied | t_writta_progress_eligible_pupils | t_writta_progress_score | t_scita_eligible_pupils | t_scita_met_expected_standard | t_scita_not_met_expected_standard | t_scita_absent | t_scita_disapplied | pt_rwm_met_expected_standard | pt_rwm_met_higher_standard | pt_read_met_expected_standard | pt_read_met_higher_standard | pt_read_not_achieved_expected_standard | pt_read_working_below_assessment | pt_read_absent | pt_read_unable_to_access_or_just_arrived | pt_read_unable_to_access | avg_read_scaled_score | avg_read_progress_score | avg_read_progress_score_upper_ci | avg_read_progress_score_lower_ci | pt_gps_met_expected_standard | pt_gps_met_higher_standard | pt_gps_not_achieved_expected_standard | pt_gps_working_below_assessment | pt_gps_absent | pt_gps_unable_to_access_or_just_arrived | pt_gps_unable_to_access | avg_gps_scaled_score | pt_mat_met_expected_standard | pt_mat_met_higher_standard | pt_mat_not_achieved_expected_standard | pt_mat_working_below_assessment | pt_mat_absent | pt_mat_unable_to_access_or_just_arrived | pt_mat_unable_to_access | avg_mat_scaled_score | avg_mat_progress_score | avg_mat_progress_score_upper_ci | avg_mat_progress_score_lower_ci | pt_writta_met_expected_standard | pt_writta_met_higher_standard | pt_writta_working_towards_expected_standard | pt_writta_pre_key_stage_standard_6 | pt_writta_pre_key_stage_standard_5 | pt_writta_pre_key_stage_standard_4 | pt_writta_pre_key_stage_standard_3 | pt_writta_pre_key_stage_standard_2 | pt_writta_pre_key_stage_standard_1 | pt_writta_growing_development_of_expected_standard | pt_writta_early_development_of_expected_standard | pt_writta_foundations_of_expected_standard | pt_writta_engagement_model_or_below_pre_key_stage_standards | pt_writta_below_interim_pre_key_stage_standards | pt_writta_absent | pt_writta_disapplied | avg_writta_progress_score | avg_writta_progress_score_upper_ci | avg_writta_progress_score_lower_ci | pt_scita_met_expected_standard | pt_scita_not_met_expected_standard | pt_scita_absent | pt_scita_disapplied |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201516 | Academic year | Regional | E92000001 | England | E12000003 | Yorkshire and The Humber | Final | State-funded schools | Total | 1726 | 59570 | 29680 | 2510 | 59580 | 36650 | 9360 | 20820 | 1940 | 120 | z | 30 | 57050 | 5796850 | z | z | 59570 | 41450 | 11520 | 16110 | 1850 | 120 | z | 30 | 57550 | 5942050 | 59570 | 40150 | 8480 | 17380 | 1840 | 150 | z | 30 | 57520 | 5893580 | z | z | 59570 | 43300 | 8050 | 12010 | z | z | z | z | z | z | 2420 | 880 | 370 | z | 450 | 30 | 60 | z | z | 59570 | 46840 | 12550 | 40 | 100 | 50 | 4 | 62 | 16 | 35 | 3 | 0 | z | 0 | 102 | z | z | z | 70 | 19 | 27 | 3 | 0 | z | 0 | 103 | 67 | 14 | 29 | 3 | 0 | z | 0 | 102 | z | z | z | 73 | 14 | 20 | z | z | z | z | z | z | 4 | 1 | 1 | z | 1 | 0 | 0 | z | z | z | 79 | 21 | 0 | 0 | ||||
201516 | Academic year | Regional | E92000001 | England | E12000007 | London | Final | State-funded schools | Total | 1714 | 88430 | 52400 | 6620 | 88440 | 61410 | 18270 | 24590 | 2290 | 110 | z | 30 | 85670 | 8848460 | z | z | 88440 | 69520 | 25790 | 16590 | 2210 | 100 | z | 30 | 86090 | 9077580 | 88440 | 67690 | 19910 | 18430 | 2160 | 130 | z | 30 | 86100 | 8991860 | z | z | 88430 | 69800 | 16060 | 14130 | z | z | z | z | z | z | 2410 | 760 | 450 | z | 690 | 20 | 90 | z | z | 88430 | 74220 | 13990 | 30 | 110 | 59 | 7 | 69 | 21 | 28 | 3 | 0 | z | 0 | 103 | z | z | z | 79 | 29 | 19 | 2 | 0 | z | 0 | 105 | 77 | 23 | 21 | 2 | 0 | z | 0 | 104 | z | z | z | 79 | 18 | 16 | z | z | z | z | z | z | 3 | 1 | 1 | z | 1 | 0 | 0 | z | z | z | 84 | 16 | 0 | 0 | ||||
201516 | Academic year | Regional | E92000001 | England | E12000009 | South West | Final | State-funded schools | Total | 1765 | 54270 | 28470 | 2810 | 54280 | 37060 | 11510 | 15570 | 1480 | 140 | z | 30 | 52350 | 5400150 | z | z | 54280 | 38630 | 11560 | 14050 | 1410 | 160 | z | 30 | 52670 | 5460590 | 54280 | 36980 | 8250 | 15680 | 1410 | 170 | z | 40 | 52650 | 5404820 | z | z | 54270 | 38430 | 7170 | 11920 | z | z | z | z | z | z | 2310 | 740 | 400 | z | 350 | 30 | 60 | z | z | 54270 | 43220 | 10920 | 40 | 50 | 52 | 5 | 68 | 21 | 29 | 3 | 0 | z | 0 | 103 | z | z | z | 71 | 21 | 26 | 3 | 0 | z | 0 | 104 | 68 | 15 | 29 | 3 | 0 | z | 0 | 103 | z | z | z | 71 | 13 | 22 | z | z | z | z | z | z | 4 | 1 | 1 | z | 1 | 0 | 0 | z | z | z | 80 | 20 | 0 | 0 | ||||
201516 | Academic year | Regional | E92000001 | England | E12000004 | East Midlands | Final | State-funded schools | Total | 1497 | 49770 | 25690 | 2350 | 49780 | 31870 | 8240 | 16260 | 1480 | 110 | z | 30 | 47830 | 4882970 | z | z | 49780 | 35580 | 10320 | 12640 | 1410 | 110 | z | 30 | 48220 | 4996310 | 49780 | 34010 | 7200 | 14190 | 1390 | 130 | z | 30 | 48180 | 4944130 | z | z | 49770 | 36810 | 7410 | 9810 | z | z | z | z | z | z | 1700 | 590 | 330 | z | 370 | 40 | 80 | z | z | 49770 | 40400 | 9210 | 50 | 70 | 52 | 5 | 64 | 17 | 33 | 3 | 0 | z | 0 | 102 | z | z | z | 71 | 21 | 25 | 3 | 0 | z | 0 | 104 | 68 | 14 | 29 | 3 | 0 | z | 0 | 103 | z | z | z | 74 | 15 | 20 | z | z | z | z | z | z | 3 | 1 | 1 | z | 1 | 0 | 0 | z | z | z | 81 | 18 | 0 | 0 | ||||
201516 | Academic year | Regional | E92000001 | England | E12000005 | West Midlands | Final | State-funded schools | Total | 1655 | 65420 | 33240 | 2890 | 65430 | 41580 | 10760 | 21550 | 2080 | 100 | z | 40 | 62740 | 6400780 | z | z | 65430 | 46910 | 14140 | 16300 | 1990 | 100 | z | 40 | 63210 | 6559890 | 65430 | 44270 | 9830 | 18950 | 1960 | 120 | z | 40 | 63190 | 6482440 | z | z | 65420 | 47470 | 8370 | 13390 | z | z | z | z | z | z | 2450 | 830 | 560 | z | 580 | 40 | 60 | z | z | 65420 | 51970 | 13270 | 60 | 90 | 51 | 4 | 64 | 16 | 33 | 3 | 0 | z | 0 | 102 | z | z | z | 72 | 22 | 25 | 3 | 0 | z | 0 | 104 | 68 | 15 | 29 | 3 | 0 | z | 0 | 103 | z | z | z | 73 | 13 | 20 | z | z | z | z | z | z | 4 | 1 | 1 | z | 1 | 0 | 0 | z | z | z | 79 | 20 | 0 | 0 |
Variables in this data set
Variable name | Variable description |
---|---|
avg_gps_scaled_score | Grammar, punctuation and spelling average scaled score |
avg_mat_progress_score | Average progress score for maths |
avg_mat_progress_score_lower_ci | Lower confidence interval for maths progress |
avg_mat_progress_score_upper_ci | Upper confidence interval for maths progress |
avg_mat_scaled_score | Maths average scaled score |
Footnotes
- 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.
- All figures include LA maintained schools, academies and free schools. Excludes alternative provision and independent schools.
- Figures for 2022 are based on revised data. Figures for other years are based on final data.
- Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
- Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
- 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