Data set from Key stage 4 performance

Key stage 4 subject entries and achievements by pupils at national level by characteristics (discounted)

Latest data
API data set version 2.0
Published
Last updated
National level pupil entries and achievements across GCSE and vocational subjects in state-funded schools by pupil characteristics such as ethnicity and disadvantage status since 2018/19. Discounting is applied.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
API data set ID
19e39901-93ff-4d76-950f-4689d6c361fe
How do I use this ID?
Release type
Number of rows
355,700
Geographic levels
National
Indicators
  • Percentage of pupils achieving the grade
  • Number of pupils achieving the grade
Filters
  • Subject
  • Grade
  • Sex
Time period
2018/19 to 2025/26

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversionestablishment_type_groupbreakdown_topicsexethnicity_majorethnicity_minorfsm_statussen_statusdisadvantage_statusfirst_languageks2_scaled_score_groupschool_admission_typeschool_religious_characterqualification_typesubjectgradenumber_achievingpercentage_achieving
202526Academic yearNationalE92000001EnglandProvisionalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalGCSEAncient History9 to 1120089
202526Academic yearNationalE92000001EnglandProvisionalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalGCSEAncient History9 to 486364
202526Academic yearNationalE92000001EnglandProvisionalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalGCSEAncient History9 to 573955
202526Academic yearNationalE92000001EnglandProvisionalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalGCSEAncient History9 to 738429
202526Academic yearNationalE92000001EnglandProvisionalAll state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalGCSEAncient HistoryTotal pupil entries1345z

Variables in this data set

Table showing first 5 of 13 variables
Variable nameVariable description
disadvantage_statusDisadvantaged status
ethnicity_minorEthnicity
first_languageFirst language
fsm_statusFree school meals status
gradeGrade

Footnotes

  1. Selective areas include local authorities where more than 25% of state-funded secondary places are in selective schools. These local authorities are Bexley, Buckinghamshire, Kent, Lincolnshire, Medway, Slough, Southend-on-Sea, Sutton, Torbay, Trafford and Wirral.
  2. Sub totals for EAL and SEN breakdowns may not sum to the grand total due to a small number of pupils with missing information.
  3. Unknown includes pupils for whom the information was not obtained, refused or could not be determined.
  4. Discounting has been applied. For further information please see the discounting guidance (https://www.gov.uk/government/publications/key-stage-4-qualifications-discount-codes-and-point-scores (opens in new tab)).
  5. Any science includes Astronomy, Electronics, Environmental Science and Geology.
  6. Any design & technology includes Design and Technology Engineering and Product Design qualifications.
  7. Combined Science GCSE is a Double Award and is included in this table for the purpose of comparison with other Science subjects.
  8. In 2017, new reformed GCSEs (which use the 9-1 grade scale) were introduced into secondary school performance tables in a phased approach. Unreformed subjects continued to be graded using the A* to G system. From 2020 onwards all GCSEs are now reformed and use the 9-1 grading scale.
  9. Where subjects have been combined into a group (e.g. Other Modern Languages) and a pupil has two or more entries, each result in each subject is counted.

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
Subject pupil level characteristic data
API data set ID
19e39901-93ff-4d76-950f-4689d6c361fe
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 Subject filter options

  • Any other subject (id: f5OSY)
  • Art & Design (id: AUAGK)
  • Mathematics AS level (id: 723Xo)

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.

Updated filters

  • Ethnicity major (id: mcX9K, column: ethnicity_major):
    • label changed to: Major ethnicity grouping

Updated Ethnicity filter options

  • All mixed / multiple ethnic groups (id: 5iYdi):
    • label changed to: All Mixed / Multiple ethnic groups
  • Any other Black background (id: eQVuS):
    • label changed to: Any other Black / African / Caribbean background
  • Any other mixed / multiple ethnic background (id: TNSPJ):
    • label changed to: Any other Mixed / Multiple ethnic background

Changes to Subject filter options

Updated
  • Any classical study (id: toiEm):
    • label changed to: Any Classical Study
  • Any design & technology (id: flgYF):
    • label changed to: Any Design and Technology
  • Any mathematics (id: ew5uS):
    • label changed to: Any Mathematics
  • Any modern language (id: TDVPJ):
    • label changed to: Any Modern Language
  • Business (id: 1VNi3):
    • label changed to: Business Studies
  • Childcare (id: utRo4):
    • label changed to: Childcare Skills
  • Construction (id: Gkzgr):
    • label changed to: Construction and the Built Environment
  • D & T: Textiles Technology (id: ThpyP):
    • label changed to: Design and Technology (Textiles Technology)
  • Design & Technology (id: SiUVx):
    • label changed to: Design and Technology
  • Engineering (id: boHtT):
    • label changed to: Engineering Studies
  • English & mathematics (id: 5r2di):
    • label changed to: English and Mathematics
  • English, mathematics & science (id: 4AiUZ):
    • label changed to: English, Mathematics and Science
  • Food Preparation & Nutrition (id: 0DZT5):
    • label changed to: Food Preparation and Nutrition
  • Hair / Personal Care (id: 9jQ4v):
    • label changed to: Hair and Beauty Studies
  • Health (id: 2fClz):
    • label changed to: Health Studies
  • Law (id: dND0Z):
    • label changed to: Law / Legal Studies
  • Mathematics & science (id: p1NSo):
    • label changed to: Mathematics and Science
  • Media / Film / TV (id: IL3Bz):
    • label changed to: Media / Film / TV Studies
  • Speech & Drama (id: zZqFQ):
    • label changed to: Speech and Drama
  • Sports (id: kO5hs):
    • label changed to: Sports Studies
  • Tourism (id: XlEfK):
    • label changed to: Travel and Tourism
New
  • Personal Finance (id: 0ySET)

Updated Major ethnicity grouping filter options

  • Mixed / multiple ethnic groups (id: LK4mW):
    • label changed to: Mixed / Multiple ethnic groups

Updated School religious character filter options

  • Roman catholic (id: YcNHK):
    • label changed to: Roman Catholic

New Grade filter options

  • 9 to 7 (id: mcPg9)

New time periods

  • 2025/26 (code: AY)

Contact us

If you have a specific enquiry about Key stage 4 subject entries and achievements by pupils at national level by characteristics (discounted) statistics and data:

Attainment statistics team

Email: Attainment.STATISTICS@education.gov.uk
Contact name: Liam Hamilton