Academic year 2022/23

Key stage 2 attainment

Data guidance

Published 14 December 2023

Description

These data files contain statistics covering attainment in the following key stage 2 assessments:

• reading, writing and maths
• reading test
• maths test 
• grammar, punctuation and spelling (GPS) test 
• writing teacher assessment
• science teacher assessment

The publication methodology should be referenced alongside this data. It provides information on the data sources, their coverage and quality, as well as explaining methodology used in producing the data. 

Coverage

This publication provides information on assessment outcomes in state-funded primary schools.  Data is for England only.

File formats and conventions

This dataset has been rounded to 0 decimal places. 

Data files

All data files associated with this releases are listed below with guidance on their content. To download any of these files, please visit our data catalogue.

Disadvantaged gap index

• Filename: ks2_national_disadvantage_gap_index_2011_to_2023_revised.csv
• Geographic levels: National
• Time period: 2010/11 to 2022/23
• Content:

  This file contains data on the key stage 2 disadvantage gap index in England.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
all_other_pupils	Total number of all other eligible pupils at the end of key stage 2
disadvantaged_pupils	Total number of eligible disadvantaged pupils at the end of key stage 2
gap_index	Disadvantage gap index

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
2. Only includes pupils for whom a valid test or teacher assessment could be determined in maths and English in 2011, reading, writing and maths from 2012 to 2015 or a reading and maths valid scaled score from 2016-2019. This number may therefore differ from the total included in national test results which include pupils recorded as A - absent, U - unable to access test.
3. Figures for 2023 are based on revised data. Figures for other years are based on final data.

Distribution of scaled scores

• Filename: ks2_national_scaledscores_2019_to_2023_revised.csv
• Geographic levels: National
• Time period: 2018/19 to 2022/23
• Content:

  This file contains data on scaled score distributions for key stage 2 tests in England.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
gender	Gender
pt_cumulative	Cumulative percentage
scaled_scores	Scaled scores distribution
subject	Subject
t_eligible_pupils	Total number of eligible pupils at the end of key stage 2

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
2. 'All schools' includes all state-funded schools, alternative provision, and non-maintained special schools with pupils eligible for assessment at key stage 2. Participation by independent schools is voluntary, therefore the ‘All schools’ figures includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
3. Figures for 2023 are based on revised data. Figures for other years are based on final data.

Attainment by school characteristics

• Filename: ks2_national_school_characteristics_2016_to_2023_revised.csv
• Geographic levels: National
• Time period: 2015/16 to 2022/23
• Content:

  This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by school characteristics.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
breakdown	Characteristics of each group
gender	Gender
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils meeting the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils meeting the higher standard in maths
pt_mat_not_achieved_expected_standard	Percentage of pupils not meeting the expected standard in maths
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils meeting the higher standard in reading
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils meeting the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils meeting the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils meeting the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils meeting the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils meeting the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

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. 'All schools' includes all state-funded schools, alternative provision, and non-maintained special schools with pupils eligible for assessment at key stage 2. Participation by independent schools is voluntary, therefore the ‘All schools’ figures includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
5. Figures for 2023 are based on revised data. Figures for other years are based on final data.
6. 'State-funded schools' includes LA maintained schools, sponsored academies, converter academies, free schools and state-funded special schools (including hospital schools).

Attainment by pupil characteristics

• Filename: ks2_national_pupil_characteristics_2016_to_2023_revised.csv
• Geographic levels: National
• Time period: 2015/16 to 2022/23
• Content:

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

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
breakdown	Characteristics of each group
gender	Gender
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils meeting the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils meeting the higher standard in maths
pt_mat_not_achieved_expected_standard	Percentage of pupils not meeting the expected standard in maths
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils meeting the higher standard in reading
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils meeting the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils meeting the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils meeting the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils meeting the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils meeting the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

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. 'State-funded schools' includes LA maintained schools, sponsored academies, converter academies, free schools and state-funded special schools (including hospital schools).

Attainment by region and local authority

• Filename: ks2_regional_and_local_authority_2016_to_2023_revised.csv
• Geographic levels: Local authority; National; Regional
• Time period: 2015/16 to 2022/23
• Content:

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

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
gender	Gender
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils meeting the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils meeting the higher standard in maths
pt_mat_not_achieved_expected_standard	Percentage of pupils not meeting the expected standard in maths
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils meeting the higher standard in reading
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils meeting the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils meeting the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils meeting the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils meeting the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils meeting the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

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.

Attainment by parliamentary constituency

• Filename: ks2_parliamentary_constituency_2019_to_2023_revised.csv
• Geographic levels: National; Parliamentary constituency
• Time period: 2018/19 to 2022/23
• Content:

  This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by parliamentary constituency.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils reaching the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling test
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils reaching the higher standard in maths test
pt_mat_not_achieved_expected_standard	Percentage of pupils not reaching the expected standard in maths test
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils reaching the higher standard in reading test
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading test
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils reaching the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils reaching the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling test
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils reaching the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths test
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils reaching the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading test
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils reaching the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
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. Figures for 2023 are based on revised data. Figures for other years are based on final data.

Attainment by pupil residency and pupil characteristics

• Filename: ks2_pupil_residency_and_pupil_characteristics_2019_to_2023_revised.csv
• Geographic levels: Local authority district; National; Regional
• Time period: 2018/19 to 2022/23
• Content:

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

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
breakdown	Characteristics of each group
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils reaching the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling test
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils reaching the higher standard in maths test
pt_mat_not_achieved_expected_standard	Percentage of pupils not reaching the expected standard in maths test
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils reaching the higher standard in reading test
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading test
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils reaching the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils reaching the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling test
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils reaching the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths test
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils reaching the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading test
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils reaching the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
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. Figures for 2023 are based on revised data. Figures for other years are based on final data.

Attainment by school location and pupil characteristics

• Filename: ks2_school_location_and_pupil_characteristics_2019_to_2023_revised.csv
• Geographic levels: Local authority district; National; Regional
• Time period: 2018/19 to 2022/23
• Content:

  This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by school location. This file also contains a flag showing which local authority districts are priority areas. Fenland and East Cambridgeshire, West Somerset and Scarborough breakdowns are available for 2022 and 2023, these are priority areas which are not local authority districts.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
breakdown	Characteristics of each group
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils reaching the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling test
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils reaching the higher standard in maths test
pt_mat_not_achieved_expected_standard	Percentage of pupils not reaching the expected standard in maths test
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils reaching the higher standard in reading test
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading test
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils reaching the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils reaching the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling test
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils reaching the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths test
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils reaching the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading test
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils reaching the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
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. Figures for 2023 are based on revised data. Figures for other years are based on final data.

Attainment by phonics prior attainment

• Filename: ks2_by_phonics_prior_attainment_2017_to_2023_revised.csv
• Geographic levels: National
• Time period: 2016/17 to 2022/23
• Content:

  This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by phonics prior attainment. This file gives breakdowns for all pupils and by disadvantage status.

  Within the underlying data file all rows where "disadvantaged status" is "All pupils" reflect the figures for all schools in England. Rows where "disadvantaged status" is "Disadvantaged" or "Not known to be disadvantaged" reflect the figures for all state-funded schools in England. As a result numbers of "Disadvantaged" and "Not known to be disadvantaged" will not sum to "All pupils".

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
avg_read_scaled_score	Reading average scaled score
disadvantage_status	Disadvantage status
final_phonics_outcome	Final phonics outcome
gender	Gender
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils reaching the higher standard in reading test
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading test
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
school_type	School type
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils reaching the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading test
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

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. 'All schools' includes all state-funded schools, alternative provision, and non-maintained special schools with pupils eligible for assessment at key stage 2. Participation by independent schools is voluntary, therefore the ‘All schools’ figures includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
4. Figures for 2023 are based on revised data. Figures for other years are based on final data.

National schools distribution

• Filename: ks2_national_schools_distribution_2019_to_2023_revised.csv
• Geographic levels: National
• Time period: 2018/19 to 2022/23
• Content:

  The national distribution table of schools in the key stage 2 assessments in England.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
number_of_schools	Number of schools
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)

Attainment by region, local authority and pupil characteristics

• Filename: ks2_regional_local_authority_and_pupil_characteristics_2019_to_2023_revised.csv
• Geographic levels: Local authority; National; Regional
• Time period: 2018/19 to 2022/23
• Content:

  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.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

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
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_read_scaled_score	Reading average scaled score
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
breakdown	Characteristics of each group
gender	Gender
no_schools	Number of schools
pt_gps_absent	Percentage of pupils absent in grammar, punctuation and spelling
pt_gps_met_expected_standard	Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_gps_met_higher_standard	Percentage of pupils meeting the higher standard in grammar, punctuation and spelling
pt_gps_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in grammar, punctuation and spelling
pt_gps_unable_to_access	Percentage of pupils unable to access in grammar, punctuation and spelling
pt_gps_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in grammar, punctuation and spelling
pt_gps_working_below_assessment	Percentage of pupils working below the standard of the grammar, punctuation and spelling
pt_mat_absent	Percentage of pupils absent in maths
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_mat_met_higher_standard	Percentage of pupils meeting the higher standard in maths
pt_mat_not_achieved_expected_standard	Percentage of pupils not meeting the expected standard in maths
pt_mat_unable_to_access	Percentage of pupils unable to access in maths
pt_mat_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in maths
pt_mat_working_below_assessment	Percentage of pupils not achieved expected standard in maths
pt_read_absent	Percentage of pupils who were absent in reading
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_read_met_higher_standard	Percentage of pupils meeting the higher standard in reading
pt_read_not_achieved_expected_standard	Percentage of pupils not achieved expected standard in reading
pt_read_unable_to_access	Percentage of pupils who were unable to access in reading
pt_read_unable_to_access_or_just_arrived	Percentage of pupils just arrived or unable to access in reading
pt_read_working_below_assessment	Percentage of pupils working below the standard of the reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_rwm_met_higher_standard	Percentage of pupils meeting the higher standard in reading, writing and maths (combined)
pt_scita_absent	Percentage of pupils absent in science TA
pt_scita_disapplied	Percentage of pupils disapplied in science TA
pt_scita_met_expected_standard	Percentage of pupils meeting the expected standard in science TA
pt_scita_not_met_expected_standard	Percentage of pupils who have not met the expected standard in science TA
pt_writta_absent	Percentage of pupils who were absent in writing TA
pt_writta_below_interim_pre_key_stage_standards	Percentage of pupils working below the interim pre-key stage standards in writing TA
pt_writta_disapplied	Percentage of pupils disapplied in writing TA
pt_writta_early_development_of_expected_standard	Percentage of pupils with early development of the expected standard in writing TA
pt_writta_engagement_model_or_below_pre_key_stage_standards	Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
pt_writta_foundations_of_expected_standard	Percentage of pupils with foundations of the expected standard in writing TA
pt_writta_growing_development_of_expected_standard	Percentage of pupils with growing development of the expected standard in writing TA
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
pt_writta_met_higher_standard	Percentage of pupils working at greater depth in writing TA
pt_writta_pre_key_stage_standard_1	Percentage of pupils working at pre-key stage standard 1 in writing TA
pt_writta_pre_key_stage_standard_2	Percentage of pupils working at pre-key stage standard 2 in writing TA
pt_writta_pre_key_stage_standard_3	Percentage of pupils working at pre-key stage standard 3 in writing TA
pt_writta_pre_key_stage_standard_4	Percentage of pupils working at pre-key stage standard 4 in writing TA
pt_writta_pre_key_stage_standard_5	Percentage of pupils working at pre-key stage standard 5 in writing TA
pt_writta_pre_key_stage_standard_6	Percentage of pupils working at pre-key stage standard 6 in writing TA
pt_writta_working_towards_expected_standard	Percentage of pupils working towards the expected standard in writing TA
t_gps_absent	Number of pupils absent in grammar, punctuation and spelling
t_gps_avg_scaled_score_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling average scaled score calculation
t_gps_eligible_pupils	Number of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standard	Number of pupils meeting the expected standard in grammar, punctuation and spelling
t_gps_met_higher_standard	Number of pupils meeting the higher standard in grammar, punctuation and spelling
t_gps_not_achieved_expected_standard	Number of pupils not achieved expected standard in grammar, punctuation and spelling
t_gps_sum_scaled_scores	Sum of grammar, punctuation and spelling scaled scores
t_gps_unable_to_access	Number of pupils unable to access in grammar, punctuation and spelling
t_gps_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in grammar, punctuation and spelling
t_gps_working_below_assessment	Number of pupils working below the standard of the grammar, punctuation and spelling
t_mat_absent	Number of pupils absent in maths
t_mat_avg_scaled_score_eligible_pupils	Number of eligible pupils in maths average scaled score calculation
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_met_expected_standard	Number of pupils meeting the expected standard in maths
t_mat_met_higher_standard	Number of pupils meeting the higher standard in maths
t_mat_not_achieved_expected_standard	Number of pupils not achieved expected standard in maths
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_mat_sum_scaled_scores	Sum of maths scaled scores
t_mat_unable_to_access	Number of pupils unable to access in maths
t_mat_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in maths
t_mat_working_below_assessment	Number of pupils working below the standard of the maths
t_read_absent	Number of pupils absent in reading
t_read_avg_scaled_score_eligible_pupils	Number of eligible pupils in reading average scaled score calculation
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_met_expected_standard	Number of pupils meeting the expected standard in reading
t_read_met_higher_standard	Number of pupils meeting the higher standard in reading
t_read_not_achieved_expected_standard	Number of pupils not achieved expected standard in reading
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_read_sum_scaled_scores	Sum of reading scaled scores
t_read_unable_to_access	Number of pupils unable to access in reading
t_read_unable_to_access_or_just_arrived	Number of pupils just arrived or unable to access in reading
t_read_working_below_assessment	Number of pupils working below the standard of the reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths
t_rwm_met_higher_standard	Number of pupils meeting the higher standard in reading, writing and maths
t_scita_absent	Number of pupils absent in science TA
t_scita_disapplied	Number of pupils disapplied in science TA
t_scita_eligible_pupils	Number of eligible pupils in science TA
t_scita_met_expected_standard	Number of pupils meeting the expected standard in science TA
t_scita_not_met_expected_standard	Number of pupils who have not met the expected standard in science TA
t_writta_absent	Number of pupils absent in writing TA
t_writta_below_interim_pre_key_stage_standards	Number of pupils working below the interim pre-key stage standards in writing TA
t_writta_disapplied	Number of pupils disapplied in writing TA
t_writta_early_development_of_expected_standard	Number of pupils with early development of the expected standard in writing TA
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_engagement_model_or_below_pre_key_stage_standards	Number of pupils working at the engagement model or below pre-key stage standards in writing TA
t_writta_foundations_of_expected_standard	Number of pupils with foundations of the expected standard in writing TA
t_writta_growing_development_of_expected_standard	Number of pupils with growing development of the expected standard in writing TA
t_writta_met_expected_standard	Number of pupils meeting the expected standard in writing TA
t_writta_met_higher_standard	Number of pupils working at greater depth in writing TA
t_writta_pre_key_stage_standard_1	Number of pupils working at pre-key stage standard 1 in writing TA
t_writta_pre_key_stage_standard_2	Number of pupils working at pre-key stage standard 2 in writing TA
t_writta_pre_key_stage_standard_3	Number of pupils working at pre-key stage standard 3 in writing TA
t_writta_pre_key_stage_standard_4	Number of pupils working at pre-key stage standard 4 in writing TA
t_writta_pre_key_stage_standard_5	Number of pupils working at pre-key stage standard 5 in writing TA
t_writta_pre_key_stage_standard_6	Number of pupils working at pre-key stage standard 6 in writing TA
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_score	Total number of pupils progress scores for writing TA
t_writta_working_towards_expected_standard	Number of pupils working towards the expected standard in writing TA

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.

Attainment by school type and pupil characteristics

• Filename: ks2_school_type_and_pupil_characteristics_2023_revised.csv
• Geographic levels: National
• Time period: 2022/23
• Content:

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

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
breakdown	Characteristics of each group
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
school_type	Type of school
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_rwm_met_expected_standard	Number of pupils meeting the expected standard in reading, writing and maths

Multi-academy trusts by pupil characteristics

• Filename: ks2_multi_academy_trusts_pupil_characteristics_202223.csv
• Geographic levels: National
• Time period: 2021/22 to 2022/23
• Content:

  Headline attainment measures in multi-academy trusts broken down by performance tables eligibility, academy type, and the following pupil characteristics: sex, major and minor ethnicity, special educational need description, disadvantaged status, first language, and prior attainment status.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
avg_mat_progress_score	Average progress score for maths
avg_mat_progress_score_lower_ci	Lower confidence intervals for maths progress
avg_mat_progress_score_upper_ci	Upper confidence intervals for maths progress
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence intervals for reading progress
avg_read_progress_score_upper_ci	Upper confidence intervals for reading progress
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence intervals for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence intervals for writing TA progress
breakdown	The characteristic of the pupil
no_pupils	Number of pupils at the end of key stage 2
no_schools	Number of schools
performance_tables_eligibility	The performance tables eligibility of the pupils' academy
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
school_type	Academy type
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_progress_eligible_pupils	Total number of pupils progress score for maths
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_progress_eligible_pupils	Total number of pupils progress score for reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_progress_eligible_pupils	Total number of pupils progress score for writing TA

Footnotes

1. Figures for 2023 are based on revised data. Figures for other years are based on final data.
2. Includes state-funded mainstream academies within multi-academy trusts only. Special schools, pupil referral units, alternative provision academies and alternative provision free schools are not included.
3. Academies have been associated with the multi-academy trust that they were part of on 14 September at the start of the academic year. Institutions that joined a multi-academy trust during the academic year are not included.
4. All multi-academy trust schools include converter academies, sponsored academies, free schools and studio schools.
5. Eligible academies include academies in a multi-academy trust that met the inclusion criteria, i.e., a multi-academy trust that contained at least three academies with results at that phase of education/cohort and where those academies have been in the multi-academy trust for at least three academic years. Ineligible academies were either in a multi-academy trust that did not meet the inclusion criteria or were in a multi-academy trust that met the inclusion criteria, but the academy had not been in the multi-academy trust for at least three academic years. 

Multi-academy trusts by characteristics

• Filename: ks2_multi_academy_trusts_mat_properties_202223.csv
• Geographic levels: National
• Time period: 2021/22 to 2022/23
• Content:

  Headline attainment measures in multi-academy trusts broken down by performance tables eligibility, academy type, and the following trust characteristics: the number of years the academies have been in their trust and the number of KS4 academies in their trust.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
avg_mat_progress_score	Average progress score for maths
avg_mat_progress_score_lower_ci	Lower confidence intervals for maths progress
avg_mat_progress_score_upper_ci	Upper confidence intervals for maths progress
avg_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence intervals for reading progress
avg_read_progress_score_upper_ci	Upper confidence intervals for reading progress
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence intervals for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence intervals for writing TA progress
breakdown	The characteristic of the pupil
no_pupils	Number of pupils at the end of key stage 2
no_schools	Number of schools
performance_tables_eligibility	The performance tables eligibility of the pupils' academy
pt_mat_met_expected_standard	Percentage of pupils meeting the expected standard in maths
pt_read_met_expected_standard	Percentage of pupils meeting the expected standard in reading
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_writta_met_expected_standard	Percentage of pupils meeting the expected standard in writing TA
school_type	Academy type
t_mat_eligible_pupils	Number of eligible pupils in maths
t_mat_progress_eligible_pupils	Total number of pupils progress score for maths
t_read_eligible_pupils	Number of eligible pupils in reading
t_read_progress_eligible_pupils	Total number of pupils progress score for reading
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
t_writta_eligible_pupils	Number of eligible pupils in writing TA
t_writta_progress_eligible_pupils	Total number of pupils progress score for writing TA

Footnotes

1. Figures for 2023 are based on revised data. Figures for other years are based on final data.
2. Includes state-funded mainstream academies within multi-academy trusts only. Special schools, pupil referral units, alternative provision academies and alternative provision free schools are not included.
3. Academies have been associated with the multi-academy trust that they were part of on 14 September at the start of the academic year. Institutions that joined a multi-academy trust during the academic year are not included.
4. All multi-academy trust schools include converter academies, sponsored academies, free schools and studio schools.
5. Eligible academies include academies in a multi-academy trust that met the inclusion criteria, i.e., a multi-academy trust that contained at least three academies with results at that phase of education/cohort and where those academies have been in the multi-academy trust for at least three academic years. Ineligible academies were either in a multi-academy trust that did not meet the inclusion criteria or were in a multi-academy trust that met the inclusion criteria, but the academy had not been in the multi-academy trust for at least three academic years. 

Attainment by academies open years

• Filename: ks2_academies_by_length_of_time_open_attainment_timeseries_2023_revised.csv
• Geographic levels: National
• Time period: 2016/17 to 2022/23
• Content:

  This file contains data on the attainment of academies, broken down by the length of time they have been open.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
pt_rwm_met_expected_standard	Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
school_count	School count
school_type	School type
t_rwm_eligible_pupils	Number of eligible pupils in reading, writing and maths
years_open	Years open

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
2. Figures for 2023 are based on revised data. Figures for other years are based on final data.
3. Annual variations in school numbers can occur due to schools opening and closing, and fluctuations in enrolments affecting whether a school is included in this measure year on year. 
4. Figures include mainstream sponsored academies and mainstream converter academies which opened before 12 September and schools which were LA maintained mainstream schools on 12 September .

Progress by academies open years

• Filename: ks2_academies_by_length_of_time_open_progress_2023_revised.csv
• Geographic levels: National
• Time period: 2022/23
• Content:

  This file contains data on the progress of academies, broken down by the length of time they have been open.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable name	Variable description
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_read_progress_score	Average progress score for reading
avg_read_progress_score_lower_ci	Lower confidence interval for reading progress
avg_read_progress_score_upper_ci	Upper confidence interval for reading progress
avg_writta_progress_score	Average progress score for writing TA
avg_writta_progress_score_lower_ci	Lower confidence interval for writing TA progress
avg_writta_progress_score_upper_ci	Upper confidence interval for writing TA progress
school_type	School type
t_mat_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_score	Total number of pupils progress scores for maths
t_read_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_score	Total number of pupils progress scores for reading
t_writta_progress_eligible_pupils	Total number of pupils at the end of key stage 2 included in the writing progress scores
t_writta_progress_score	Total number of pupils progress scores for writing
years_open	Years open

Footnotes

1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
2. Figures for 2023 are based on revised data. Figures for other years are based on final data.
3. Annual variations in school numbers can occur due to schools opening and closing, and fluctuations in enrolments affecting whether a school is included in this measure year on year. 
4. Figures include mainstream sponsored academies and mainstream converter academies which opened before 12 September and schools which were LA maintained mainstream schools on 12 September .