Data set from Multiplication tables check attainment

Regional and LA by pupil characteristics

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
Academic year 2022/23
Release type
Number of rows
26,586
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
  • Gender
Time period
2021/22 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namebreakdown_topicbreakdownschool_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
202223Academic yearRegionalE92000001EnglandE12000006East of EnglandAll pupilsTotalState-funded schoolsTotal19247354070790275020740870054204060349030202840257023402260219020001840167015201310117091077051034028022015019029031039019804030141582120964281276544333332222211100000001300
202223Academic yearRegionalE92000001EnglandE12000008South EastAll pupilsTotalState-funded schoolsTotal2350103790100000380028280125807840591050704370390036703370319030202830260023902180186016801380103076047040033027023039033050029204010199517420964271286544433333222211100000000300
202223Academic yearRegionalE92000001EnglandE12000003Yorkshire and The HumberAll pupilsTotalState-funded schoolsTotal175065180627102470187407600474036203060258024202210214019801860169016901380132011909708706604703202702501901803302603001870400125270220964291276544333333222111100000100300
202223Academic yearRegionalE92000001EnglandE12000005West MidlandsAll pupilsTotalState-funded schoolsTotal17737375070990276023020896052703980334029002480236021502100196018701650157013701290109091071048032026023017019037029032020905010143976220.3964311275543333332222111100000100300
202223Academic yearRegionalE92000001EnglandE12000004East MidlandsAll pupilsTotalState-funded schoolsTotal1560563605437019901564066904150325026702470213019801810174016501530148012801140104085077059040029019014013013022021028014503020108579220964281276544433333222211110000000300

Variables in this data set

Table showing all 72 variables
Variable nameVariable description
breakdownCharacteristics breakdown
genderGender
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
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. State-funded schools includes 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.
  2. 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.
  3. Average scores have been rounded to one decimal place.
  4. Average scores exclude pupils who did not take the check.
  5. Percentages have been rounded to nearest whole number, so may not sum to 100.
  6. In 2023, two new local authorities were introduced (Cumberland and Westmorland & Furness) which replaced Cumbria.
  7. Includes pupils for whom ethnicity or first language was not obtained, refused or could not be determined.
  8. Special Educational Needs (SEN) unclassified includes pupils for whom SEN provision could not be determined.
  9. Regional totals have been rounded to the nearest 10. There may be discrepancies between the national and local authority totals.

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/fd72e177-cca3-4b29-87b7-ccc88da101e3/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/fd72e177-cca3-4b29-87b7-ccc88da101e3/csv")

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.uk
Contact name: Phoebe Jones