Key stage 4 subject entries and achievements by pupils to local authority level (discounted)
On this page
Data set details
- Theme
- School and college outcomes and performance
- Publication
- Key stage 4 performance
- API data set ID
- 1ae39901-c621-a274-a84b-393929221b9f
How do I use this ID? - Release
- Academic year 2025/26
- Release type
- Number of rows
- 964,862
- Geographic levels
- Local authority, National, Regional
- 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
| time_period | time_identifier | geographic_level | country_code | country_name | region_code | region_name | old_la_code | new_la_code | la_name | version | establishment_type_group | breakdown_topic | sex | qualification_type | subject | grade | number_achieving | percentage_achieving |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202526 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 1 | 1200 | 89 | |||||
| 202526 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 4 | 863 | 64 | |||||
| 202526 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 5 | 739 | 55 | |||||
| 202526 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 7 | 384 | 29 | |||||
| 202526 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | Total pupil entries | 1345 | z |
Variables in this data set
| Variable name | Variable description |
|---|---|
| grade | Grade |
| number_achieving | Number of pupils achieving the grade |
| percentage_achieving | Percentage of pupils achieving the grade |
| sex | Sex |
| subject | Subject |
Footnotes
- Local authority, region, parliamentary constituency figures cover achievements in state-funded schools only. They do not include pupils recently arrived from overseas and so will not sum to national level totals.
- 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)).
- Any science includes Astronomy, Electronics, Environmental Science and Geology.
- Any design & technology includes Design and Technology Engineering and Product Design qualifications.
- Combined Science GCSE is a Double Award and is included in this table for the purpose of comparison with other Science subjects.
- c = a cell that has been suppressed due to low number of pupils. Suppression is applied where the data contains only one school (for example Isles of Scilly). For 2020 and 2021 results where a geographical area contains only one school the data for that area has been been wholly suppressed. This is in line with the announcement that school level data would not be published using either summer 2020 or summer 2021 exam grades awarded.
- 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.
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 local authority data
- API data set ID
- 1ae39901-c621-a274-a84b-393929221b9f
- 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
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
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:
kZTUh) - Art & Design (id:
ROKka) - Mathematics AS level (id:
kCdhs)
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 Subject filter options
Updated
- Any classical study (id:
lHKcB):- label changed to: Any Classical Study
- Any design & technology (id:
UglRF):- label changed to: Any Design and Technology
- Any mathematics (id:
rTGNj):- label changed to: Any Mathematics
- Any modern language (id:
GhFgr):- label changed to: Any Modern Language
- Business (id:
etZuS):- label changed to: Business Studies
- Childcare (id:
4G6UZ):- label changed to: Childcare Skills
- Construction (id:
QuVwb):- label changed to: Construction and the Built Environment
- D & T: Textiles Technology (id:
ThJeP):- label changed to: Design and Technology (Textiles Technology)
- Design & Technology (id:
2YIlz):- label changed to: Design and Technology
- Engineering (id:
woebx):- label changed to: Engineering Studies
- English & mathematics (id:
dDQ0Z):- label changed to: English and Mathematics
- English, mathematics & science (id:
OaWCL):- label changed to: English, Mathematics and Science
- Food Preparation & Nutrition (id:
piDSo):- label changed to: Food Preparation and Nutrition
- Hair / Personal Care (id:
604rf):- label changed to: Hair and Beauty Studies
- Health (id:
0QgT5):- label changed to: Health Studies
- Law (id:
B2D7J):- label changed to: Law / Legal Studies
- Mathematics & science (id:
uEvo4):- label changed to: Mathematics and Science
- Media / Film / TV (id:
XcqfK):- label changed to: Media / Film / TV Studies
- Speech & Drama (id:
gaCO9):- label changed to: Speech and Drama
- Sports (id:
AhOGK):- label changed to: Sports Studies
- Tourism (id:
Pt9eb):- label changed to: Travel and Tourism
New
- Personal Finance (id:
48uOU)
New Grade filter options
- 9 to 7 (id:
5knDd)
New Local authority location options
- Barnsley (id:
l82Fc, code:E08000038, old code:370) - Sheffield (id:
Uh4IR, code:E08000039, old code:373)
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 to local authority level (discounted) statistics and data:
Attainment statistics team
Email: Attainment.STATISTICS@education.gov.ukContact name: Liam Hamilton