National - Key Stage 2 (KS2) - API
On this page
Data set details
- Theme
- Children's social care
- Publication
- Outcomes for children in need, including children looked after by local authorities in England
- API data set ID
- 019d431f-c129-73e6-917e-6998bfe4d88d
How do I use this ID? - Release
- Reporting year 2025
- Release type
- Number of rows
- 7,062
- Geographic levels
- National
- Indicators
- Average progress score
- Lower confidence interval
- Number of eligible pupils at the end of key stage 2
- Filters
- Ethnicity
- Placement
- Social care group
- Time period
- 2018/19 to 2024/25
Data set preview
| time_period | time_identifier | geographic_level | country_code | country_name | social_care_group | sen_provision | ethnicity_major | placement | version | subject | eligible_pupil_count | expected_standard_pupil_count | expected_standard_pupil_percent | progress_measure_eligible_pupil_count | progress_measure_total_score | progress_measure_score | progress_measure_lower_conf_interval | progress_measure_upper_conf_interval |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202425 | Academic year | National | E92000001 | England | All pupils comparison | All pupils | All pupils | All pupils | Revised | Reading | 652640 | 491130 | 75 | x | x | x | x | x |
| 202425 | Academic year | National | E92000001 | England | All pupils comparison | All pupils | All pupils | All pupils | Revised | Writing | 650570 | 469790 | 72 | x | x | x | x | x |
| 202425 | Academic year | National | E92000001 | England | All pupils comparison | All pupils | All pupils | All pupils | Revised | Maths | 652620 | 484020 | 74 | x | x | x | x | x |
| 202425 | Academic year | National | E92000001 | England | All pupils comparison | All pupils | All pupils | All pupils | Revised | Reading, writing and maths | 650560 | 405190 | 62 | z | z | z | z | z |
| 202425 | Academic year | National | E92000001 | England | All pupils comparison | All pupils | All pupils | All pupils | Revised | Grammar, punctuation and spelling | 652650 | 474450 | 73 | z | z | z | z | z |
Variables in this data set
| Variable name | Variable description |
|---|---|
| eligible_pupil_count | Number of eligible pupils at the end of key stage 2 |
| ethnicity_major | Ethnicity - Filter by ethnicity |
| expected_standard_pupil_count | Number of pupils meeting the expected standard |
| expected_standard_pupil_percent | Percentage of pupils meeting the expected standard |
| placement | Placement - Filter by placement |
Footnotes
- Data is not available for 2019/20 and 2010/21 as assessments were cancelled in these years due to the COVID-19 pandemic.
- Figures for 2024/25 are based on provisional data. Figures for other years are based on final data.
- Includes all state-funded, alternative provision, and non-maintained special schools with pupils eligible for assessment at Key Stage 2. Participation by independent schools is voluntary, therefore includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
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
- National - Key Stage 2 (KS2) - API
- API data set ID
- 019d431f-c129-73e6-917e-6998bfe4d88d
- 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)
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.
Contact us
If you have a specific enquiry about National - Key Stage 2 (KS2) - API statistics and data:
Children Looked After Data Team
Email: CLA.STATS@education.gov.ukContact name: Bree Waine