Data set from Key stage 2 attainment

Combinations of attainment at the expected standard in reading, writing and maths (combined)

Latest data
API data set version 1.0
Published
Last updated
This file contains data to show the combinations of meeting the expected standard in reading, writing and maths by pupil characteristics.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
API data set ID
22339901-6f3a-7272-8576-03b26377d4ee
How do I use this ID?
Release type
Number of rows
6,739
Geographic levels
National
Indicators
  • Number all other combinations
  • Number of pupils meeting the expected standard in 1 subject
  • Number of pupils meeting the expected standard in 2 subjects
Filters
  • Disadvantage status
  • Establishment type
  • Ethnicity minor
Time period
2018/19 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversionestablishment_type_groupsexdisadvantage_statusfsm_statusethnicity_majorethnicity_minorfirst_languagemonth_of_birthsen_provisionsen_primary_needschool_countrwm_eligible_pupil_countrwm_expected_standard_pupil_countrm_nw_expected_standard_pupil_countrw_nm_expected_standard_pupil_countwm_nr_expected_standard_pupil_counttwo_subjects_expected_standard_pupil_countr_nwm_expected_standard_pupil_countw_nrm_expected_standard_pupil_countm_nrw_expected_standard_pupil_countone_subject_expected_standard_pupil_countrwm_not_expected_standard_pupil_countnon_assessed_pupil_countat_least_one_below_test_standard_pupil_countother_combinations_pupil_countrwm_expected_standard_pupil_percentagerm_nw_expected_standard_pupil_percentagerw_nm_expected_standard_pupil_percentagewm_nr_expected_standard_pupil_percentagetwo_subjects_expected_standard_pupil_percentager_nwm_expected_standard_pupil_percentagew_nrm_expected_standard_pupil_percentagem_nrw_expected_standard_pupil_percentageone_subject_expected_standard_pupil_percentagerwm_not_expected_standard_pupil_percentagenon_assessed_pupil_percentageat_least_one_below_test_standard_pupil_percentageother_combinations_pupil_percentage
201819Academic yearNationalE92000001EnglandFinalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotal158726445804181831916922353453328685410968184152235251735521523565633036262064.8772.9743.4687.03313.4751.7022.8573.4688.0268.0915.5325.1250.406
201819Academic yearNationalE92000001EnglandFinalAll state-fundedBoysTotalTotalTotalTotalTotalTotalTotalTotal158143288781979891411066752639847183611767661674229625298262425522756149960.2014.292.038.02714.3471.862.0575.0919.0089.0697.3756.9190.456
201819Academic yearNationalE92000001EnglandFinalAll state-fundedGirlsTotalTotalTotalTotalTotalTotalTotalTotal157003156972201945059156781893439671485111649560922109223261139710277112069.7491.6024.9665.99812.5661.5373.691.7777.0037.0723.613.2550.355
201819Academic yearNationalE92000001EnglandFinalAll state-fundedOtherTotalTotalTotalTotalTotalTotalTotalTotal55cccccccccccccccccccccccccc
201819Academic yearNationalE92000001EnglandFinalAll state-fundedTotalTotalTotalTotalTotalTotalOctoberTotalTotal139725467638418133517723565667273513351539360933882589235323670.2652.4423.2416.5212.2031.3442.4422.8156.6016.1974.7354.3040.432

Variables in this data set

Table showing first 5 of 37 variables
Variable nameVariable description
at_least_one_below_test_standard_pupil_countNumber of pupils working below the standard of the test in at least one subject
at_least_one_below_test_standard_pupil_percentagePercentage of pupils working below the standard of the test in at least one subject
disadvantage_statusDisadvantage status
establishment_type_groupEstablishment type
ethnicity_minorEthnicity minor

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 2025 are based on provisional data. Figures for other years are based on final data.
  3. 'All state funded' includes Local authority maintained, academy sponsor led, academy converter , free schools and state-funded special schools (including hospital 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
Combinations of attainment at the expected standard in reading, writing and maths (combined)
API data set ID
22339901-6f3a-7272-8576-03b26377d4ee
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