Data set from Multiplication tables check attainment

Regional and LA

Not the latest data
Published
Last updated
This file contains data on the attainment of pupils in the multiplication tables check in England, broken down by region and local authority. Data is also broken down by the following pupil characteristics: sex, free school meal eligibility, special educational needs provision and ethnicity.

Data set details

Theme
School and college outcomes and performance
Publication
Multiplication tables check attainment
Release type
Number of rows
42,952
Geographic levels
Local authority, National, Regional
Indicators
  • Average attainment score of all pupils
  • Number of eligible pupils who did not take the check
  • Number of pupils absent
  • Number of pupils eligible for the check
  • Number of pupils just arrived
  • Number of pupils scored 0
  • Number of pupils scored 1
  • 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 2
  • 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 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 unable to participate
  • Number of pupils who took the check
  • Number of pupils with missing reason
  • Number of pupils working below the national curriculum expectation
  • Number of schools
  • Percentage of eligible pupils who did not take the check
  • Percentage of eligible pupils who took the check
  • Percentage of pupils absent
  • Percentage of pupils just arrived
  • Percentage of pupils scored 0
  • Percentage of pupils scored 1
  • Percentage of pupils scored 10
  • Percentage of pupils scored 11
  • Percentage of pupils scored 12
  • Percentage of pupils scored 13
  • Percentage of pupils scored 14
  • Percentage of pupils scored 15
  • Percentage of pupils scored 16
  • Percentage of pupils scored 17
  • Percentage of pupils scored 18
  • Percentage of pupils scored 19
  • Percentage of pupils scored 2
  • Percentage of pupils scored 20
  • Percentage of pupils scored 21
  • Percentage of pupils scored 22
  • Percentage of pupils scored 23
  • Percentage of pupils scored 24
  • Percentage of pupils scored 25
  • Percentage of pupils scored 3
  • Percentage of pupils scored 4
  • Percentage of pupils scored 5
  • Percentage of pupils scored 6
  • Percentage of pupils scored 7
  • Percentage of pupils scored 8
  • Percentage of pupils scored 9
  • Percentage of pupils unable to participate
  • Percentage of pupils with missing reason
  • Percentage of pupils working below the national curriculum expectation
  • Sum of scores
Filters
  • Characteristics breakdown
  • Sex
Time period
2021/22 to 2023/24

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namebreakdown_topicbreakdownestablishment_type_groupsexno_schoolst_mtc_eligible_pupilst_mtc_pupils_completed_checkt_mtc_eligible_pupils_not_completed_checkt_mtc_scored_25t_mtc_scored_24t_mtc_scored_23t_mtc_scored_22t_mtc_scored_21t_mtc_scored_20t_mtc_scored_19t_mtc_scored_18t_mtc_scored_17t_mtc_scored_16t_mtc_scored_15t_mtc_scored_14t_mtc_scored_13t_mtc_scored_12t_mtc_scored_11t_mtc_scored_10t_mtc_scored_9t_mtc_scored_8t_mtc_scored_7t_mtc_scored_6t_mtc_scored_5t_mtc_scored_4t_mtc_scored_3t_mtc_scored_2t_mtc_scored_1t_mtc_scored_0t_mtc_absentt_mtc_unable_to_participatet_mtc_working_belowt_mtc_just_arrivedt_mtc_missing_reasont_mtc_sum_scoresmtc_average_scorept_mtc_eligible_pupils_completed_checkpt_mtc_eligible_pupils_not_completed_checkpt_mtc_scored_25pt_mtc_scored_24pt_mtc_scored_23pt_mtc_scored_22pt_mtc_scored_21pt_mtc_scored_20pt_mtc_scored_19pt_mtc_scored_18pt_mtc_scored_17pt_mtc_scored_16pt_mtc_scored_15pt_mtc_scored_14pt_mtc_scored_13pt_mtc_scored_12pt_mtc_scored_11pt_mtc_scored_10pt_mtc_scored_9pt_mtc_scored_8pt_mtc_scored_7pt_mtc_scored_6pt_mtc_scored_5pt_mtc_scored_4pt_mtc_scored_3pt_mtc_scored_2pt_mtc_scored_1pt_mtc_scored_0pt_mtc_absentpt_mtc_unable_to_participatept_mtc_working_belowpt_mtc_just_arrivedpt_mtc_missing_reason
202122Academic yearLocal authorityE92000001EnglandE12000001North East840E06000047County DurhamAll pupilsTotalState-funded schoolsBoys2062948281813063230322816814713413412212910110681806474556156342523201078161111101165385819.1964211086555443433232221111000100300
202122Academic yearLocal authorityE92000001EnglandE12000001North East840E06000047County DurhamAll pupilsTotalState-funded schoolsGirls209274726588949628319515815415712012011412186978578727256483734111519717615560274959618.7973181076664444343333221101101010200
202122Academic yearLocal authorityE92000001EnglandE12000001North East840E06000047County DurhamAll pupilsTotalState-funded schoolsTotal2095695547621911285864233263012912542422432221921781651421461271171047159343529142522261616131310345418.9964201076554444333232221111100000300
202122Academic yearLocal authorityE92000001EnglandE12000001North East840E06000047County DurhamEthnicity majorAny other ethnic groupState-funded schoolsBoys13131305500011000100000000000000000000299231000383800088000800000000000000000000
202122Academic yearLocal authorityE92000001EnglandE12000001North East840E06000047County DurhamEthnicity majorAny other ethnic groupState-funded schoolsGirls1219172710102001110001100000001002000033219.589113750501100555000550000000500110000

Variables in this data set

Table showing all 72 variables
Variable nameVariable description
breakdownCharacteristics breakdown
mtc_average_scoreAverage attainment score of all pupils
no_schoolsNumber of schools
pt_mtc_absentPercentage of pupils absent
pt_mtc_eligible_pupils_completed_checkPercentage of eligible pupils who took the check
pt_mtc_eligible_pupils_not_completed_checkPercentage of eligible pupils who did not take the check
pt_mtc_just_arrivedPercentage of pupils just arrived
pt_mtc_missing_reasonPercentage of pupils with missing reason
pt_mtc_scored_0Percentage of pupils scored 0
pt_mtc_scored_1Percentage of pupils scored 1
pt_mtc_scored_10Percentage of pupils scored 10
pt_mtc_scored_11Percentage of pupils scored 11
pt_mtc_scored_12Percentage of pupils scored 12
pt_mtc_scored_13Percentage of pupils scored 13
pt_mtc_scored_14Percentage of pupils scored 14
pt_mtc_scored_15Percentage of pupils scored 15
pt_mtc_scored_16Percentage of pupils scored 16
pt_mtc_scored_17Percentage of pupils scored 17
pt_mtc_scored_18Percentage of pupils scored 18
pt_mtc_scored_19Percentage of pupils scored 19
pt_mtc_scored_2Percentage of pupils scored 2
pt_mtc_scored_20Percentage of pupils scored 20
pt_mtc_scored_21Percentage of pupils scored 21
pt_mtc_scored_22Percentage of pupils scored 22
pt_mtc_scored_23Percentage of pupils scored 23
pt_mtc_scored_24Percentage of pupils scored 24
pt_mtc_scored_25Percentage of pupils scored 25
pt_mtc_scored_3Percentage of pupils scored 3
pt_mtc_scored_4Percentage of pupils scored 4
pt_mtc_scored_5Percentage of pupils scored 5
pt_mtc_scored_6Percentage of pupils scored 6
pt_mtc_scored_7Percentage of pupils scored 7
pt_mtc_scored_8Percentage of pupils scored 8
pt_mtc_scored_9Percentage of pupils scored 9
pt_mtc_unable_to_participatePercentage of pupils unable to participate
pt_mtc_working_belowPercentage of pupils working below the national curriculum expectation
sexSex
t_mtc_absentNumber of pupils absent
t_mtc_eligible_pupilsNumber of pupils eligible for the check
t_mtc_eligible_pupils_not_completed_checkNumber of eligible pupils who did not take the check
t_mtc_just_arrivedNumber of pupils just arrived
t_mtc_missing_reasonNumber of pupils with missing reason
t_mtc_pupils_completed_checkNumber of pupils who took the check
t_mtc_scored_0Number of pupils scored 0
t_mtc_scored_1Number of pupils scored 1
t_mtc_scored_10Number of pupils scored 10
t_mtc_scored_11Number of pupils scored 11
t_mtc_scored_12Number of pupils scored 12
t_mtc_scored_13Number of pupils scored 13
t_mtc_scored_14Number of pupils scored 14
t_mtc_scored_15Number of pupils scored 15
t_mtc_scored_16Number of pupils scored 16
t_mtc_scored_17Number of pupils scored 17
t_mtc_scored_18Number of pupils scored 18
t_mtc_scored_19Number of pupils scored 19
t_mtc_scored_2Number of pupils scored 2
t_mtc_scored_20Number of pupils scored 20
t_mtc_scored_21Number of pupils scored 21
t_mtc_scored_22Number of pupils scored 22
t_mtc_scored_23Number of pupils scored 23
t_mtc_scored_24Number of pupils scored 24
t_mtc_scored_25Number of pupils scored 25
t_mtc_scored_3Number of pupils scored 3
t_mtc_scored_4Number of pupils scored 4
t_mtc_scored_5Number of pupils scored 5
t_mtc_scored_6Number of pupils scored 6
t_mtc_scored_7Number of pupils scored 7
t_mtc_scored_8Number of pupils scored 8
t_mtc_scored_9Number of pupils scored 9
t_mtc_sum_scoresSum of scores
t_mtc_unable_to_participateNumber of pupils unable to participate
t_mtc_working_belowNumber of pupils working below the national curriculum expectation

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. Regional totals have been rounded to the nearest 10. There may be discrepancies between the national and local authority totals.
  5. 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.
  6. 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.
  7. In 2023, two new local authorities were introduced (Cumberland and Westmorland & Furness) which replaced Cumbria.
  8. Unclassified ethnicity and first language categories include pupils for whom the characteristic was not obtained, refused or could not be determined.
  9. Special Educational Needs (SEN) unclassified includes pupils for whom SEN provision could not be determined.

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

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/3e7751e6-bf7d-4727-adb8-24b23771b2fd/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/3e7751e6-bf7d-4727-adb8-24b23771b2fd/csv")

Contact us

If you have a specific enquiry about Regional and LA statistics and data:

Primary Attainment Statistics

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