Data set from Key stage 2 attainment

Key stage 2 institution level - Schools (performance)

Latest data
API data set version 1.0.1
Published
Last updated
This file contains data on the attainment of primary schools at institution level.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
API data set ID
019afee4-e5d0-72f9-9a8f-d7a1a56eac1d
How do I use this ID?
Release
Academic year 2024/25 Revised
Release type
Number of rows
1,197,784
Geographic levels
School
Indicators
  • Average scaled score
  • Percentage of pupils absent from or not able to access the test
  • Percentage of pupils absent or disapplied
Filters
  • Characteristics of each group
  • Subjects
Time period
2022/23 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversionschool_urnschool_laestabschool_namebreakdown_topicbreakdownsubjectexpected_standard_pupil_percenthigher_standard_pupil_percentaverage_scaled_scoreprogress_measure_scoreprogress_measure_lower_conf_intervalprogress_measure_upper_conf_intervalabsent_or_not_able_to_access_percentworking_towards_expected_standard_pupil_percentabsent_or_disapplied_percentprogress_measure_unadjustedprogress_measure_description
202425Academic yearSchoolE92000001EnglandFinal1000002013614The Aldgate SchoolAll pupilsTotalReading, writing and maths7710zzzzzzzzz
202425Academic yearSchoolE92000001EnglandFinal1000002013614The Aldgate SchoolAll pupilsTotalReading9347108zzz0zzzz
202425Academic yearSchoolE92000001EnglandFinal1000002013614The Aldgate SchoolAll pupilsTotalWriting8013zzzzz200zz
202425Academic yearSchoolE92000001EnglandFinal1000002013614The Aldgate SchoolAll pupilsTotalMaths9337108zzz0zzzz
202425Academic yearSchoolE92000001EnglandFinal1000002013614The Aldgate SchoolAll pupilsTotalGrammar, punctuation and spelling8750108zzz0zzzz

Variables in this data set

Table showing first 5 of 13 variables
Variable nameVariable description
absent_or_disapplied_percentPercentage of pupils absent or disapplied
absent_or_not_able_to_access_percentPercentage of pupils absent from or not able to access the test
average_scaled_scoreAverage scaled score
breakdownCharacteristics of each group
expected_standard_pupil_percentPercentage of pupils meeting the expected standard

Footnotes

  1. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  2. Figures for all years based on Final data as of April 2026 update.

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
Key stage 2 institutional level - Schools (performance)
API data set ID
019afee4-e5d0-72f9-9a8f-d7a1a56eac1d
API data set version
1.0.1

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

API data set updates come in 3 forms: Major, Minor and Patch.

  • Major update (e.g. 1.x.x to 2.0.0): a breaking change meaning the removal of columns or rows from the data set.
  • Minor update (e.g. 1.1.x to 1.2.0): non-breaking changes made as part of a new release (likely with new / additional data).
  • Patch update (e.g. 1.1.0 to 1.1.1): a non-breaking change made as part of a release amendment (e.g. data corrections).

More detailed information on versioning can be found in our Versioning - Explore education statistics API.

API data set changelog

Patch changes for version 1.0.1

This version introduces patch changes that are unlikely to affect consumers of the previous version. You may wish to check the list of changes below before upgrading.

New filters

  • Topic of Characteristics (id: 7u9Xo, column: breakdown_topic)

Updated indicators

  • Average scaled score (id: ODwCL, column: average_scaled_score):
    • Progress measure 'description' [not populated in 2024] (id: HAYzL, column: progress_measure_description):
      • progress measure - lower confidence limit [not populated in 2024] (id: 6lKrf, column: progress_measure_lower_conf_interval):
        • progress measure - upper confidence limit [not populated in 2024] (id: 0H5T5, column: progress_measure_upper_conf_interval):
          • Progress measures (id: CQCId, column: progress_measure_score):
            • Unadjusted progress measure [not populated in 2024] (id: YAzHK, column: progress_measure_unadjusted):

              Contact us

              If you have a specific enquiry about Key stage 2 institution level - Schools (performance) statistics and data:

              Primary Attainment Statistics

              Email: Primary.Attainment@education.gov.uk
              Contact name: Lilian Williams