Subject pupil level school type data
On this page
Data set details
- Theme
- School and college outcomes and performance
- Publication
- Key stage 4 performance
- API data set ID
- 1ae39901-7d3f-d373-a257-1b63c3bc7c7d
How do I use this ID? - Release
- Academic year 2024/25
- Release type
- Number of rows
- 13,473
- Geographic levels
- National
- Indicators
- Number of pupils achieving the grade
- Percentage of pupils achieving the grade
- Filters
- Grade
- Qualification
- School type
- Time period
- 2024/25
Data set preview
| time_period | time_identifier | geographic_level | country_code | country_name | version | establishment_type_group | breakdown_topic | sex | qualification_type | subject | grade | number_achieving | percentage_achieving |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202425 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 1 | 1112 | 90 |
| 202425 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 4 | 806 | 65 |
| 202425 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | 9 to 5 | 674 | 55 |
| 202425 | Academic year | National | E92000001 | England | Provisional | All state-funded | Total | Total | GCSE | Ancient History | Total pupil entries | 1232 | z |
| 202425 | Academic year | National | E92000001 | England | Provisional | All state-funded | Sex | Boys | GCSE | Ancient History | 9 to 1 | 559 | 90 |
Variables in this data set
| Variable name | Variable description |
|---|---|
| establishment_type_group | School type |
| grade | Grade |
| number_achieving | Number of pupils achieving the grade |
| percentage_achieving | Percentage of pupils achieving the grade |
| qualification_type | Qualification |
Footnotes
- Establishment types included in the establishment type groupings can be found in the glossary: https://explore-education-statistics.service.gov.uk/glossary
- Pupils also registered at an institution normally included within the Secondary School Performance Tables are excluded from the Alternative Provision data.
- Pupils at university technical colleges (UTCs), studio schools and further education colleges with key stage 4 provision typically attend that school for only 2 years, compared to 5 years for pupils in most secondary schools. These establishments also offer specialist curriculum. As a result, the Progress 8 data for these schools is not directly comparable with the Progress 8 data for other schools. The government’s position is that it is not appropriate to expect the same rates of EBacc entry from these types of provision and that each school should decide on a case by case basis whether its specialist curriculum is compatible with the full EBacc. This should be borne in mind when reviewing the performance data for these types of provisions.
- 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.
- For pupils at the end of KS4 in 2024/25, where pupils achieved qualifications in subjects between January 2020 and August 2021, we will not use results from these qualifications. The entries into the qualifications are still counted.
- Changes were made to the methodology for calculating performance data due to the commitment not to use qualification results awarded between January 2020 and August 2021 in future measures. GCSE exams returned in 2022 and grades were awarded at a midpoint between 2021 and pre-pandemic grading. In 2023, there was a return to pre-pandemic grading, with some protections. Comparisons to 2020, 2021, and 2022 should be made with caution.
- 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.
- 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 school type data
- API data set ID
- 1ae39901-7d3f-d373-a257-1b63c3bc7c7d
- 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)