Data set from Multiplication tables check attainment

National score distribution by pupil characteristics

Latest data
API data set version 1.0
Published
Last updated
This file contains data on the attainment scores of pupils in the multiplication tables check assessment in England, broken down by pupil characteristics.

Data set details

Theme
School and college outcomes and performance
Publication
Multiplication tables check attainment
API data set ID
019a838e-4b72-7769-a0db-c3fae7a23deb
How do I use this ID?
Release type
Number of rows
4,494
Geographic levels
National
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 scored 0
  • Number of pupils scored 1
  • Number of pupils scored 2
  • Number of pupils scored 3
  • Number of pupils scored 4
  • Number of pupils scored 5
  • Number of pupils scored 6
  • Number of pupils scored 7
  • Number of pupils scored 8
  • Number of pupils scored 9
  • Number of pupils scored 10
  • Number of pupils scored 11
  • Number of pupils scored 12
  • Number of pupils scored 13
  • Number of pupils scored 14
  • Number of pupils scored 15
  • Number of pupils scored 16
  • Number of pupils scored 17
  • Number of pupils scored 18
  • Number of pupils scored 19
  • Number of pupils scored 20
  • Number of pupils scored 21
  • Number of pupils scored 22
  • Number of pupils scored 23
  • Number of pupils scored 24
  • Number of pupils scored 25
  • Number of schools
  • Percentage of eligible pupils who took the check
  • Percentage of eligible pupils who did not take the check
  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • Sum of scores
Filters
  • Disadvantage status
  • First language status
  • Free school meal status
  • Minor ethnic group
  • Month of birth
  • Sex
  • Special education needs provision
  • Special education primary need
Time period
2021/22 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameestablishment_type_groupsexdisadvantage_statusethnicity_majorethnicity_minorfirst_languagefsm_statusmonth_of_birthsen_provisionsen_primary_needestablishment_counteligible_pupil_countcompleted_check_pupil_countnot_completed_check_pupil_countmtc_score_25_pupil_countmtc_score_24_pupil_countmtc_score_23_pupil_countmtc_score_22_pupil_countmtc_score_21_pupil_countmtc_score_20_pupil_countmtc_score_19_pupil_countmtc_score_18_pupil_countmtc_score_17_pupil_countmtc_score_16_pupil_countmtc_score_15_pupil_countmtc_score_14_pupil_countmtc_score_13_pupil_countmtc_score_12_pupil_countmtc_score_11_pupil_countmtc_score_10_pupil_countmtc_score_9_pupil_countmtc_score_8_pupil_countmtc_score_7_pupil_countmtc_score_6_pupil_countmtc_score_5_pupil_countmtc_score_4_pupil_countmtc_score_3_pupil_countmtc_score_2_pupil_countmtc_score_1_pupil_countmtc_score_0_pupil_countmtc_score_totalmtc_score_averagecompleted_check_pupil_percentnot_completed_check_pupil_percentmtc_score_25_pupil_percentmtc_score_24_pupil_percentmtc_score_23_pupil_percentmtc_score_22_pupil_percentmtc_score_21_pupil_percentmtc_score_20_pupil_percentmtc_score_19_pupil_percentmtc_score_18_pupil_percentmtc_score_17_pupil_percentmtc_score_16_pupil_percentmtc_score_15_pupil_percentmtc_score_14_pupil_percentmtc_score_13_pupil_percentmtc_score_12_pupil_percentmtc_score_11_pupil_percentmtc_score_10_pupil_percentmtc_score_9_pupil_percentmtc_score_8_pupil_percentmtc_score_7_pupil_percentmtc_score_6_pupil_percentmtc_score_5_pupil_percentmtc_score_4_pupil_percentmtc_score_3_pupil_percentmtc_score_2_pupil_percentmtc_score_1_pupil_percentmtc_score_0_pupil_percent
202122Academic yearNationalE92000001EnglandAll state fundedTotalTotalTotalTotalTotalTotalTotalTotalTotal1637065225962568826571172999766144835036822308422745524915232612187220442194491850417079155141391612172102658862670848053355272022171650189230081238595319.89642712765444333332222111100000
202122Academic yearNationalE92000001EnglandAll state fundedGirlsTotalTotalTotalTotalTotalTotalTotalTotal16194318633308755987879502368042354018318153281382012615119731138110714102399887923983487426653755034686347724291625126710287769151378603766419.69732512765444433333222111100000
202122Academic yearNationalE92000001EnglandAll state fundedBoysTotalTotalTotalTotalTotalTotalTotalTotal16323333626316933166939349739810248101850415514136351230011288104919728921086177840716664905635476241763231237617301453118987497716306348289209552812765443333322221111100000
202122Academic yearNationalE92000001EnglandAll state fundedTotalTotalTotalTotalTotalTotalJuneTotalTotal14220524285001024181239159493683299223972354192919691818173216081678146413991213112494583963851831125421215416427596569719.39552411765444333333222211100001
202122Academic yearNationalE92000001EnglandAll state fundedTotalTotalTotalTotalTotalTotalDecemberTotalTotal14352547115271819931548466054094310126062294209019361730162115601478135412341128931783724502371244200151122156219105818620.19642812765444333322221111000000

Variables in this data set

Table showing all 68 variables
Variable nameVariable description
completed_check_pupil_countNumber of eligible pupils who took the check
completed_check_pupil_percentPercentage of eligible pupils who took the check
disadvantage_statusDisadvantage status
eligible_pupil_countNumber of eligible pupils
establishment_countNumber of schools
ethnicity_minorMinor ethnic group
first_languageFirst language status
fsm_statusFree school meal status
month_of_birthMonth of birth
mtc_score_0_pupil_countNumber of pupils scored 0
mtc_score_0_pupil_percent0
mtc_score_1_pupil_countNumber of pupils scored 1
mtc_score_1_pupil_percent1
mtc_score_10_pupil_countNumber of pupils scored 10
mtc_score_10_pupil_percent10
mtc_score_11_pupil_countNumber of pupils scored 11
mtc_score_11_pupil_percent11
mtc_score_12_pupil_countNumber of pupils scored 12
mtc_score_12_pupil_percent12
mtc_score_13_pupil_countNumber of pupils scored 13
mtc_score_13_pupil_percent13
mtc_score_14_pupil_countNumber of pupils scored 14
mtc_score_14_pupil_percent14
mtc_score_15_pupil_countNumber of pupils scored 15
mtc_score_15_pupil_percent15
mtc_score_16_pupil_countNumber of pupils scored 16
mtc_score_16_pupil_percent16
mtc_score_17_pupil_countNumber of pupils scored 17
mtc_score_17_pupil_percent17
mtc_score_18_pupil_countNumber of pupils scored 18
mtc_score_18_pupil_percent18
mtc_score_19_pupil_countNumber of pupils scored 19
mtc_score_19_pupil_percent19
mtc_score_2_pupil_countNumber of pupils scored 2
mtc_score_2_pupil_percent2
mtc_score_20_pupil_countNumber of pupils scored 20
mtc_score_20_pupil_percent20
mtc_score_21_pupil_countNumber of pupils scored 21
mtc_score_21_pupil_percent21
mtc_score_22_pupil_countNumber of pupils scored 22
mtc_score_22_pupil_percent22
mtc_score_23_pupil_countNumber of pupils scored 23
mtc_score_23_pupil_percent23
mtc_score_24_pupil_countNumber of pupils scored 24
mtc_score_24_pupil_percent24
mtc_score_25_pupil_countNumber of pupils scored 25
mtc_score_25_pupil_percent25
mtc_score_3_pupil_countNumber of pupils scored 3
mtc_score_3_pupil_percent3
mtc_score_4_pupil_countNumber of pupils scored 4
mtc_score_4_pupil_percent4
mtc_score_5_pupil_countNumber of pupils scored 5
mtc_score_5_pupil_percent5
mtc_score_6_pupil_countNumber of pupils scored 6
mtc_score_6_pupil_percent6
mtc_score_7_pupil_countNumber of pupils scored 7
mtc_score_7_pupil_percent7
mtc_score_8_pupil_countNumber of pupils scored 8
mtc_score_8_pupil_percent8
mtc_score_9_pupil_countNumber of pupils scored 9
mtc_score_9_pupil_percent9
mtc_score_averageAverage attainment score
mtc_score_totalSum of scores
not_completed_check_pupil_countNumber of eligible pupils who did not take the check
not_completed_check_pupil_percentPercentage of eligible pupils who did not take the check
sen_primary_needSpecial education primary need
sen_provisionSpecial education needs provision
sexSex

Footnotes

  1. Average scores have been rounded to one decimal place.
  2. Average scores exclude pupils who did not take the check.
  3. Percentages have been rounded to nearest whole number, so may not sum to 100.
  4. 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.
  5. 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.
  6. Unknown ethnicity and first language categories include pupils for whom the characteristic was not obtained, refused or could not be determined.
  7. Unknown Special Educational Needs (SEN) provision includes pupils for whom SEN provision could not be determined.
  8. Disadvantaged pupils are defined as those who are registered as eligible for free school meals at any point in the last six years, children looked after by a local authority and children who left care in England and Wales through adoption or via a Special Guardianship or Child Arrangements Order.

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 score distribution by pupil characteristics
API data set ID
019a838e-4b72-7769-a0db-c3fae7a23deb
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

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.


Contact us

If you have a specific enquiry about National score distribution by pupil characteristics statistics and data:

Primary Attainment Statistics

Email: Primary.ATTAINMENT@education.gov.uk
Contact name: Phoebe Jones