Data set from 16 to 19 performance

KS4 prior attainment - average KS4 prior attainment by student characteristics and region

Latest data
API data set version 2.0
Published
Last updated
Average KS4 prior attainment by student characteristics and region or LA. Student characteristics include sex, ethnicity, disadvantage status, free school meal provision, first language, special educational needs provision, and KS4 prior attainment.

Data set details

Theme
School and college outcomes and performance
Publication
16 to 19 performance
API data set ID
019d9137-8890-76b5-8a80-54824375eeb8
How do I use this ID?
Release type
Number of rows
169,648
Geographic levels
Local authority, National, Regional
Indicators
  • Number of students
  • Number of students with KS4 prior attainment
  • Average KS4 prior attainment
Filters
  • Exam cohort
  • Characteristic
Time period
2021/22 to 2025/26

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversionregion_coderegion_nameold_la_codenew_la_codela_namebreakdown_topicbreakdownestablishment_type_groupestablishment_typeexam_cohortstudent_countstudents_with_prior_countprior_average
202526Academic yearLocal authorityE92000001EnglandProvisionalE12000007London203E09000011GreenwichSEN ProvisionEducation, health and care plan - TotalState-funded institutionsAll state-funded schools and collegesA level16166.31515
202526Academic yearLocal authorityE92000001EnglandProvisionalE12000007London203E09000011GreenwichSEN ProvisionEducation, health and care plan - TotalState-funded institutionsAll state-funded schools and collegesAcademic16166.31515
202526Academic yearLocal authorityE92000001EnglandProvisionalE12000007London203E09000011GreenwichSEN ProvisionEducation, health and care plan - TotalState-funded institutionsAll state-funded schools and collegesT level00z
202526Academic yearLocal authorityE92000001EnglandProvisionalE12000007London203E09000011GreenwichSEN ProvisionEducation, health and care plan - TotalState-funded institutionsAll state-funded schools and collegesApplied general664.24405
202526Academic yearLocal authorityE92000001EnglandProvisionalE12000007London203E09000011GreenwichSEN ProvisionEducation, health and care plan - TotalState-funded institutionsAll state-funded schools and collegesTech level223.89285

Variables in this data set

Table showing all 5 variables
Variable nameVariable description
breakdownCharacteristic
exam_cohortExam cohort
prior_averageAverage KS4 prior attainment
student_countNumber of students
students_with_prior_countNumber of students with KS4 prior attainment

Footnotes

  1. Figures for the total APS per entry student count may not match the sum of females and males, as not all institutions recorded the sex for every student.
  2. Disadvantage status is as reported at the end of key stage 4. Analysis involving disadvantage status includes students at state-funded schools and colleges only.
  3. EHC plans and statements of SEN are legal documents which detail the needs of the individual student, and the assistance they are to receive.
  4. For 2024/25, final data is reported instead of the revised data normally presented for historical comparison. This is due to data quality issues affecting late results and Q grades in the 2024/25 revised data.
  5. T level data is not available prior to 2025/26.

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
KS4 prior attainment - average KS4 prior attainment by student characteristics and region
API data set ID
019d9137-8890-76b5-8a80-54824375eeb8
API data set version
2.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

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

Major changes for version 2.0

WarningThis version introduces major breaking changes that may be incompatible with consumers of the previous version.

It is recommended to check the list of changes below and make any required changes to your API data set queries before upgrading to this version.

The following are examples of breaking changes:

  • options were deleted
  • ids were changed
  • codes were changed

Deleted time periods

  • 2020/21 (code: AY)

Minor changes for version 2.0

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

Changes to Exam cohort filter options

Updated
  • End of 16-18 study (id: tXW6E):
    • label changed to: End of 16-19 study
New
  • T level (id: CpjjI)

New time periods

  • 2025/26 (code: AY)

Contact us

If you have a specific enquiry about KS4 prior attainment - average KS4 prior attainment by student characteristics and region statistics and data:

Attainment statistics team

Email: Attainment.STATISTICS@education.gov.uk
Contact name: John Shale