Data set from Key stage 2 attainment

Attainment by school characteristics

Latest data
API data set version 1.0
Published
Last updated
This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by school characteristics.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
API data set ID
0e2f9901-af3b-9f77-9e7d-3a93fd7c015e
How do I use this ID?
Release
Academic year 2024/25
Release type
Number of rows
3,288
Geographic levels
National
Indicators
  • Average progress score
  • Average scaled score
  • Lower confidence interval
Filters
  • Education phase
  • School cohort size
  • School religious character
Time period
2015/16 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversionestablishment_type_groupschool_cohort_sizeeducation_phaseschool_religious_charactersexsubjectestablishment_counteligible_pupil_countexpected_standard_pupil_counthigher_standard_pupil_countnot_meeting_pupil_countworking_below_pupil_countabsent_pupil_countprogress_measure_eligible_pupil_countprogress_measure_total_scoreunable_to_access_arrived_pupil_countunable_to_access_pupil_countscaled_scores_eligible_pupil_countscaled_scores_totalworking_towards_pupil_countpre_ks_std_6_pupil_countpre_ks_std_5_pupil_countpre_ks_std_4_pupil_countpre_ks_std_3_pupil_countpre_ks_std_2_pupil_countpre_ks_std_1_pupil_countgrowing_dev_of_expected_std_pupil_countearly_dev_of_expected_std_pupil_countfoundations_of_expected_std_pupil_countengagement_model_or_below_pre_ks_std_pupil_countbelow_interim_pre_ks_std_pupil_countdisapplied_pupil_countexpected_standard_pupil_percenthigher_standard_pupil_percentnot_meeting_pupil_percentworking_below_pupil_percentabsent_pupil_percentunable_to_access_arrived_pupil_percentunable_to_access_pupil_percentaverage_scaled_scoreprogress_measure_scoreprogress_measure_lower_conf_intervalprogress_measure_upper_conf_intervalworking_towards_pupil_percentpre_ks_std_6_pupil_percentpre_ks_std_5_pupil_percentpre_ks_std_4_pupil_percentpre_ks_std_3_pupil_percentpre_ks_std_2_pupil_percentpre_ks_std_1_pupil_percentgrowing_dev_of_expected_std_pupil_percentearly_dev_of_expected_std_pupil_percentfoundations_of_expected_std_pupil_percentengagement_model_or_below_pre_ks_std_pupil_percentbelow_interim_pre_ks_std_pupil_percentdisapplied_pupil_percent
201516Academic yearNationalE92000001EnglandFinalState-funded mainstream schools1 to 15 pupilsTotalTotalTotalReading, writing and maths232323546125861212zzzzzzzzzzzzzzzzzzzzzz535zzzzzzzzzzzzzzzzzzzzzz
201516Academic yearNationalE92000001EnglandFinalState-funded mainstream schools1 to 15 pupilsTotalTotalTotalReading232323580166645302630352846zzz23228692367823zzzzzzzzzzzzz71222720z0104zzzzzzzzzzzzzzzz
201516Academic yearNationalE92000001EnglandFinalState-funded mainstream schools1 to 15 pupilsTotalTotalTotalGrammar, punctuation and spelling232323579166824414629950460zzz19229802373641zzzzzzzzzzzzz71192720z0103zzzzzzzzzzzzzzzz
201516Academic yearNationalE92000001EnglandFinalState-funded mainstream schools1 to 15 pupilsTotalTotalTotalMaths232323580161253395685349868zzz19229742355436zzzzzzzzzzzzz68142920z0103zzzzzzzzzzzzzzzz
201516Academic yearNationalE92000001EnglandFinalState-funded mainstream schools1 to 15 pupilsTotalTotalTotalWriting232323546168623683zz27zzzzzz5282zzzzzz830296127z63597216zz0zzzzzz22zzzzzz411z00

Variables in this data set

Table showing first 5 of 56 variables
Variable nameVariable description
absent_pupil_countNumber of pupils absent
absent_pupil_percentPercentage of pupils absent
average_scaled_scoreAverage scaled score
below_interim_pre_ks_std_pupil_countNumber of pupils working below the interim pre-key stage standards in writing TA
below_interim_pre_ks_std_pupil_percentPercentage of pupils working below the interim pre-key stage standards 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. Figures for 2025 are based on provisional data. Figures for other years are based on final data.
  4. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  5. 'All schools' includes all state funded, 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.
  6. 'All state funded' includes Local authority maintained, academy sponsor led, academy converter , free schools and state-funded special schools (including hospital schools).
  7. 'State-funded mainstream schools' includes local authority maintained, academies and free schools.
  8. 'Local authority maintained' includes community schools, voluntary aided schools, voluntary controlled schools and foundation schools.

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool

Using the API

  • API documentation

    This data set is available via an API, follow the link to get all the information to get started. The documentation provides full guidance and examples on how to make the most from our data sets.

  • Building API integrations

    To support building integrations on top of the explore education statistics API, software development kits (SDKs) are provided to streamline common tasks and communication with the API.

API data set details

API data set name
Attainment by school characteristics
API data set ID
0e2f9901-af3b-9f77-9e7d-3a93fd7c015e
API data set version
1.0

Download data set as CSV

Get familiar with the data. The CSV response will render its categories and column headers in a human-readable format (instead of machine-readable IDs).

Guidance: Download data set as CSV

Data set metadata

Look up human-readable labels and their corresponding machine-readable IDs to help you create data set queries.

Guidance: Get data set metadata

Query data set using GET

Quickly test the machine-readable IDs in a range of basic queries.

Guidance: Query data set (GET)

Query data set using POST

The POST endpoint is recommended for production level pipeline queries. POST requires a query to be built and supplied in JSON format using third party software such as Postman and Insomnia or programming languages such as Python, R, etc.

Guidance: Query data set (POST)

Get data set summary

Guidance: Get data set summary

API data set version history