Data set from Multiplication tables check attainment

Regional and LA

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
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
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 first 5 of 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

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