Regional and LA by pupil characteristics
On this page
Data set details
- Theme
- School and college outcomes and performance
- Publication
- Multiplication tables check attainment
- API data set ID
- 019a838e-700c-72d5-96b8-d6751bf5ba54
How do I use this ID? - Release
- Academic year 2025/26
- Release type
- Number of rows
- 654,808
- Geographic levels
- Local authority, National, Regional
- Indicators
- Average attainment score
- Number of eligible pupils
- Number of eligible pupils who took the check
- Number of eligible pupils who did not take the check
- Number of pupils absent
- Number of pupils unable to participate
- Number of pupils working below the national curriculum expectation
- Number of pupils just arrived
- Number of pupils with missing reason
- Number of schools
- Percentage of eligible pupils who took the check
- Percentage of eligible pupils who did not take the check
- Percentage of pupils absent
- Percentage of pupils unable to participate
- Percentage of pupils working below the national curriculum expectation
- Percentage of pupils just arrived
- Percentage of pupils with missing reason
- Sum of scores
- Filters
- Disadvantage status
- First language status
- Free school meal status
- Minor ethnic group
- Sex
- Special education needs provision
- Time period
- 2021/22 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 | establishment_type_group | sex | disadvantage_status | ethnicity_major | ethnicity_minor | first_language | fsm_status | sen_provision | establishment_count | eligible_pupil_count | completed_check_pupil_count | not_completed_check_pupil_count | absent_pupil_count | unable_to_participate_pupil_count | working_below_pupil_count | just_arrived_pupil_count | missing_reason_pupil_count | mtc_score_total | mtc_score_average | completed_check_pupil_percent | not_completed_check_pupil_percent | absent_pupil_percent | unable_to_participate_pupil_percent | working_below_pupil_percent | just_arrived_pupil_percent | missing_reason_pupil_percent |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 202122 | Academic year | Local authority | E92000001 | England | E12000001 | North East | 840 | E06000047 | County Durham | All state funded | Boys | Total | Total | Total | Total | Total | Total | 206 | 2948 | 2818 | 130 | 11 | 11 | 101 | 1 | 6 | 53858 | 19.1 | 96 | 4 | 0 | 0 | 3 | 0 | 0 |
| 202122 | Academic year | Local authority | E92000001 | England | E12000001 | North East | 840 | E06000047 | County Durham | All state funded | Girls | Total | Total | Total | Total | Total | Total | 209 | 2747 | 2658 | 89 | 15 | 5 | 60 | 2 | 7 | 49596 | 18.7 | 97 | 3 | 1 | 0 | 2 | 0 | 0 |
| 202122 | Academic year | Local authority | E92000001 | England | E12000001 | North East | 840 | E06000047 | County Durham | All state funded | Total | Total | Total | Total | Total | Total | Total | 209 | 5695 | 5476 | 219 | 26 | 16 | 161 | 3 | 13 | 103454 | 18.9 | 96 | 4 | 0 | 0 | 3 | 0 | 0 |
| 202122 | Academic year | Local authority | E92000001 | England | E12000001 | North East | 840 | E06000047 | County Durham | All state funded | Boys | Disadvantaged | Total | Total | Total | Total | Total | 191 | 1075 | 994 | 81 | 6 | 5 | 67 | 0 | 3 | 17109 | 17.2 | 92 | 8 | 1 | 0 | 6 | 0 | 0 |
| 202122 | Academic year | Local authority | E92000001 | England | E12000001 | North East | 840 | E06000047 | County Durham | All state funded | Boys | Disadvantaged | Total | Total | Total | Total | No SEN provision | 169 | 590 | 585 | 5 | 3 | 0 | 1 | 0 | 1 | 11443 | 19.6 | 99 | 1 | 1 | 0 | 0 | 0 | 0 |
Variables in this data set
| Variable name | Variable description |
|---|---|
| absent_pupil_count | Number of pupils absent |
| absent_pupil_percent | Percentage of pupils absent |
| completed_check_pupil_count | Number of eligible pupils who took the check |
| completed_check_pupil_percent | Percentage of eligible pupils who took the check |
| disadvantage_status | Disadvantage status |
| eligible_pupil_count | Number of eligible pupils |
| establishment_count | Number of schools |
| ethnicity_minor | Minor ethnic group |
| first_language | First language status |
| fsm_status | Free school meal status |
| just_arrived_pupil_count | Number of pupils just arrived |
| just_arrived_pupil_percent | Percentage of pupils just arrived |
| missing_reason_pupil_count | Number of pupils with missing reason |
| missing_reason_pupil_percent | Percentage of pupils with missing reason |
| mtc_score_average | Average attainment score |
| mtc_score_total | Sum of scores |
| not_completed_check_pupil_count | Number of eligible pupils who did not take the check |
| not_completed_check_pupil_percent | Percentage of eligible pupils who did not take the check |
| sen_provision | Special education needs provision |
| sex | Sex |
| unable_to_participate_pupil_count | Number of pupils unable to participate |
| unable_to_participate_pupil_percent | Percentage of pupils unable to participate |
| working_below_pupil_count | Number of pupils working below the national curriculum expectation |
| working_below_pupil_percent | Percentage of pupils working below the national curriculum expectation |
Footnotes
- Average scores have been rounded to one decimal place.
- Average scores exclude pupils who did not take the check.
- Percentages have been rounded to nearest whole number, so may not sum to 100.
- Regional totals have been rounded to the nearest 10. There may be discrepancies between the national and local authority totals.
- State funded schools include community schools, voluntary aided schools, voluntary controlled schools, foundation schools, sponsored academies, converter academies, free schools, community special schools, foundation special schools, special sponsor led academies, special converter academies and special free schools.
- Pupils absent for the entire check period, unable to participate even when using access arrangements, just arrived in school, working below the national curriculum expectation for year 2 in multiplication tables and have left the school or appear on the register in error, are excluded from the number of pupils who took the check.
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
- Regional and LA by pupil characteristics
- API data set ID
- 019a838e-700c-72d5-96b8-d6751bf5ba54
- API data set version
- 1.1
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 change made as part of a release amendment (e.g. data corrections). These are usually non-breaking, but in exceptional circumstances may include breaking changes, which will be listed in the changelog.
More detailed information on versioning can be found in our Versioning - Explore education statistics API.
API data set changelog
Minor changes for version 1.1
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.
New filters
- Major ethnic group (id:
0bMT5, column:ethnicity_major)
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 Regional and LA by pupil characteristics statistics and data:
Primary Attainment Statistics
Email: Primary.ATTAINMENT@education.gov.ukContact name: Phoebe Jones