Data set from Multiplication tables check attainment

Multiplication tables check attainment by region and local authority

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: gender, 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
8,806
Geographic levels
Local authority, National, Regional
Indicators
  • Mean average score
  • Number of schools
  • Number of pupils eligible for the check
  • Number of 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 pupils scored 25
  • Number of pupils scored 24
  • Number of pupils scored 23
  • Number of pupils scored 22
  • Number of pupils scored 21
  • Number of pupils scored 20
  • Number of pupils scored 19
  • Number of pupils scored 18
  • Number of pupils scored 17
  • Number of pupils scored 16
  • Number of pupils scored 15
  • Number of pupils scored 14
  • Number of pupils scored 13
  • Number of pupils scored 12
  • Number of pupils scored 11
  • Number of pupils scored 10
  • Number of pupils scored 9
  • Number of pupils scored 8
  • Number of pupils scored 7
  • Number of pupils scored 6
  • Number of pupils scored 5
  • Number of pupils scored 4
  • Number of pupils scored 3
  • Number of pupils scored 2
  • Number of pupils scored 1
  • Number of pupils scored 0
  • 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
  • Percentage of pupils scored 25
  • Percentage of pupils scored 24
  • Percentage of pupils scored 23
  • Percentage of pupils scored 22
  • Percentage of pupils scored 21
  • Percentage of pupils scored 20
  • Percentage of pupils scored 19
  • Percentage of pupils scored 18
  • Percentage of pupils scored 17
  • Percentage of pupils scored 16
  • Percentage of pupils scored 15
  • Percentage of pupils scored 14
  • Percentage of pupils scored 13
  • Percentage of pupils scored 12
  • Percentage of pupils scored 11
  • Percentage of pupils scored 10
  • Percentage of pupils scored 9
  • Percentage of pupils scored 8
  • Percentage of pupils scored 7
  • Percentage of pupils scored 6
  • Percentage of pupils scored 5
  • Percentage of pupils scored 4
  • Percentage of pupils scored 3
  • Percentage of pupils scored 2
  • Percentage of pupils scored 1
  • Percentage of pupils scored 0
  • Sum of scores
Filters
  • Characteristics of each group
  • Gender
Time period
2021/22

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namecharacteristic_groupcharacteristicschool_typegenderno_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 yearRegionalE92000001EnglandE12000007LondonAll pupilsTotalState-funded schoolsTotal18219692093160376031570133907910562043703730337028802650242022102040183015801480131010709006905103602802201602103904605202390110290194499520.9964331486543332222221111100000001200
202122Academic yearRegionalE92000001EnglandE12000008South EastAll pupilsTotalState-funded schoolsTotal23391043401000104330251701181076905920510045504220394037303530328032502960267024802160175015301140770550480340280300420560430276090490194998819.5964241176544443333322211110000010300
202122Academic yearRegionalE92000001EnglandE12000002North WestAll pupilsTotalState-funded schoolsTotal24828989086260363024680104006590502042503740337031502970288026702610234020701890169013901140870610460350270220250420530360222070440171547419.9964271276544333333222211110000010200
202122Academic yearRegionalE92000001EnglandE12000005West MidlandsAll pupilsTotalState-funded schoolsTotal176874210711803030204408830544041003280307028502550250022202140205018901750152013201180950740570350340260210230390450300184050390141426219.9964281276444333333222211100000110201
202122Academic yearRegionalE92000001EnglandE12000006East of EnglandAll pupilsTotalState-funded schoolsTotal1917735507060029501828084205300414035503160279027602530237024502230204018701730143012601070820600400330290180240360440320176050380137768819.5964251176544433333322211110000010201

Variables in this data set

Table showing all 72 variables
Variable nameVariable description
characteristicCharacteristics of each group
genderGender
mtc_average_scoreMean average score
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
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. Percentages have been rounded to nearest whole number, so may not sum to 100.
  2. Average scores have been rounded to one decimal place.
  3. Includes all pupils who participated in the multiplication tables check, those absent for the entire period of which the check could be administered, those unable to participate even when using access arrangements and those working below the national curriculum expectation for year 2 in multiplication tables. Pupils with missing, or invalid results are not included in the calculations.
  4. Includes pupils for whom ethnicity or first language was not obtained, refused or could not be determined.
  5. Includes pupils from all state-funded schools.
  6. Regional totals have been rounded to the nearest 10. There may be discrepancies between the sum of constituent items and totals.
  7. Average scores exclude pupils who did not take 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

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/7e11133e-0634-4d5c-8ca1-8512c9ee5e6a/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/7e11133e-0634-4d5c-8ca1-8512c9ee5e6a/csv")

Contact us

If you have a specific enquiry about Multiplication tables check attainment by region and local authority statistics and data:

Primary Attainment Statistics

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