Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

  1. Step 1 Choose a publication

    Publication
    Key stage 4 performance
  2. Step 2 Select a data set or featured table

    Data set
    KS4 local authority data
  3. Step 3 Choose locations

    Local authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford
    Regional
    • East Midlands
    • East of England
    • Inner London
    • London
    • North East
    National
    • England
  4. Step 4 Choose time period

    Time period
    2021/22
  5. Step 5 Choose your filters

    Indicators
    • Average Attainment 8 score of all pupils
    • Average EBacc APS score per pupil
    • Percentage of pupils achieving grades 4 or above in English and Mathematics GCSEs
    • Percentage of pupils achieving grades 5 or above in English and Mathematics GCSEs
    • Percentage of pupils achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)
    Gender
    • Total
  6. Step 6 (current) Explore data

    This data is not from the latest release
    View latest data: Academic year 2022/23
    WarningSome rows and columns are not shown in this table as the data does not exist in the underlying file.
    'KS4 local authority data' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 158 other locations for 2021/22
    2021/22
    Average Attainment 8 score of all pupilsAverage EBacc APS score per pupilPercentage of pupils achieving grades 4 or above in English and Mathematics GCSEsPercentage of pupils achieving grades 5 or above in English and Mathematics GCSEsPercentage of pupils achieving the English Baccalaureate (grades 4 or above in English and maths, A*-C in unreformed subjects)Percentage of pupils achieving the English Baccalaureate (grades 5 or above in English and maths, A*-C in unreformed subjects)
    England48.94.2869.0%50.0%26.9%20.3%
    North East46.94.0365.8%46.0%24.4%18.2%
    North West47.24.0966.2%46.8%23.3%17.2%
    Yorkshire and The Humber46.94.0766.6%47.7%23.4%17.7%
    East Midlands47.74.1767.8%47.5%25.2%18.7%
    West Midlands47.64.1166.6%47.2%23.5%17.3%
    East of England49.14.3169.9%50.0%27.0%20.5%
    London52.74.7774.3%57.5%37.4%28.6%
    South East50.14.4170.9%52.1%28.6%22.4%
    South West48.84.2369.3%49.4%23.0%17.6%
    Inner London52.04.7373.7%56.6%37.4%28.1%
    Outer London53.14.8074.5%58.0%37.4%28.9%
    North EastCounty Durham47.33.9765.1%45.2%22.0%16.7%
    Darlington47.54.0966.4%46.5%25.9%17.6%
    Gateshead49.74.4270.3%53.6%35.3%26.4%
    Hartlepool45.03.8165.4%42.3%18.1%13.7%
    Middlesbrough43.03.5959.7%38.9%16.0%11.7%
    Newcastle upon Tyne46.94.1063.7%46.3%27.9%22.8%
    North Tyneside48.54.1869.0%48.5%23.7%17.7%
    Northumberland46.83.9666.4%45.9%18.9%14.0%
    Redcar and Cleveland47.64.1669.8%48.9%26.2%18.1%
    South Tyneside43.13.6460.9%39.2%19.5%14.9%
    Stockton-on-Tees49.24.3371.7%52.9%31.3%24.0%
    Sunderland46.03.9862.3%42.7%27.0%19.2%
    North WestBlackburn with Darwen46.84.0667.7%46.8%17.2%11.9%
    Blackpool38.03.1351.4%31.1%8.6%5.6%
    Bolton46.34.0165.8%47.2%22.0%15.6%
    Bury46.34.0566.4%45.1%23.5%16.1%
    Cheshire East50.54.3272.8%51.8%22.5%17.1%
    Cheshire West and Chester48.44.2667.8%47.9%28.6%21.1%
    Cumbria47.54.1367.3%46.4%22.2%16.2%
    Halton46.13.8163.1%44.3%12.9%8.9%
    Knowsley36.13.0546.2%26.4%11.8%7.2%
    Lancashire47.64.1267.5%48.0%21.4%16.3%
    Liverpool45.33.8761.9%43.6%24.0%17.1%
    Manchester46.54.0963.9%46.1%24.3%17.7%
    Oldham44.63.7962.3%43.3%21.3%15.9%
    Rochdale43.73.7460.7%40.9%18.5%12.6%
    Salford43.23.7261.0%40.3%19.8%13.4%
    Sefton45.73.9764.5%44.1%22.9%16.1%
    St. Helens45.83.8163.9%44.1%21.7%15.5%
    Stockport50.14.3872.1%52.0%29.0%22.1%
    Tameside45.23.8965.2%44.2%22.0%15.7%
    Trafford58.15.2678.1%64.2%38.8%32.6%
    Warrington51.14.5173.7%54.2%29.7%23.0%
    Wigan47.64.0667.6%47.3%19.2%15.1%
    Wirral48.94.2865.6%47.4%33.8%24.8%
    Yorkshire and The HumberBarnsley45.23.9563.2%45.3%24.2%18.5%
    Bradford43.83.7559.9%41.2%19.6%13.8%
    Calderdale48.14.2169.6%50.9%19.6%15.3%
    Doncaster45.13.7865.0%44.6%14.2%10.8%
    East Riding of Yorkshire47.44.1469.3%47.2%22.7%16.8%
    Kingston upon Hull, City of44.33.8159.8%42.0%20.8%14.8%
    Kirklees48.24.1868.0%49.9%23.9%18.2%
    Leeds47.84.2268.3%51.3%27.9%21.8%
    North East Lincolnshire41.83.6358.3%36.8%19.9%13.9%
    North Lincolnshire45.73.8766.5%42.7%20.0%13.8%
    North Yorkshire50.34.4572.6%53.8%31.4%24.5%
    Rotherham46.83.8465.8%44.9%14.1%10.7%
    Sheffield46.14.0265.2%47.2%25.7%19.2%
    Wakefield47.54.1569.1%50.7%22.4%16.7%
    York53.04.6875.5%56.1%31.8%24.9%
    East MidlandsDerby44.84.0061.2%41.8%29.0%21.4%
    Derbyshire47.34.0967.8%47.5%21.4%15.9%
    Leicester46.34.0963.7%44.7%24.2%17.3%
    Leicestershire48.94.3372.1%50.8%27.1%20.5%
    Lincolnshire48.64.2567.6%47.4%29.1%21.8%
    North Northamptonshire46.24.0764.3%43.0%24.9%16.9%
    Nottingham44.53.8061.0%41.3%16.2%12.1%
    Nottinghamshire49.04.2770.2%50.9%25.0%18.8%
    Rutland55.74.9581.3%64.5%32.0%26.0%
    West Northamptonshire48.24.2070.4%48.3%26.2%19.0%
    West MidlandsBirmingham48.54.3168.0%50.9%28.8%21.7%
    Coventry46.23.9865.1%46.6%19.8%14.5%
    Dudley46.53.9265.4%45.5%17.0%12.4%
    Herefordshire, County of46.74.1167.4%46.0%24.7%17.9%
    Sandwell45.73.8261.3%41.3%18.5%12.2%
    Shropshire47.24.1167.5%44.8%21.8%15.1%
    Solihull49.94.3571.3%52.5%28.6%21.9%
    Staffordshire47.34.0067.0%45.5%20.8%14.8%
    Stoke-on-Trent43.53.5959.5%38.2%15.3%10.0%
    Telford and Wrekin47.34.1562.7%43.2%26.6%19.5%
    Walsall46.43.9363.2%44.0%20.8%15.7%
    Warwickshire50.24.4170.5%52.6%28.0%22.4%
    Wolverhampton48.03.9664.9%45.1%17.4%12.4%
    Worcestershire47.74.1768.2%47.6%25.4%18.0%
    East of EnglandBedford47.24.0667.8%45.6%20.3%14.9%
    Cambridgeshire51.74.6572.6%53.8%34.2%27.3%
    Central Bedfordshire46.43.9767.9%44.6%17.6%12.9%
    Essex47.94.1668.2%48.0%25.3%18.8%
    Hertfordshire53.34.7575.6%57.4%35.0%27.6%
    Luton46.04.0164.2%46.1%23.2%16.6%
    Norfolk47.14.1867.6%46.3%26.2%18.3%
    Peterborough46.23.8764.7%43.0%15.7%11.9%
    Southend-on-Sea56.35.0576.0%63.4%41.8%35.2%
    Suffolk46.73.9968.0%46.2%17.5%12.7%
    Thurrock45.94.0665.0%45.2%27.4%19.8%
    South EastBracknell Forest48.74.1467.7%47.5%19.1%14.4%
    Brighton and Hove51.64.7175.2%56.4%38.6%29.3%
    Buckinghamshire57.45.0879.3%64.4%36.4%31.5%
    East Sussex46.54.0666.3%46.3%24.8%18.9%
    Hampshire48.94.3170.1%50.6%26.4%20.4%
    Isle of Wight43.73.7761.1%39.6%21.2%14.7%
    Kent49.34.3368.7%49.9%30.3%24.0%
    Medway47.94.1666.2%47.7%28.4%22.2%
    Milton Keynes46.64.0466.5%46.8%20.6%15.0%
    Oxfordshire49.74.4072.0%52.9%26.5%21.5%
    Portsmouth43.43.7561.2%41.3%20.0%12.6%
    Reading52.04.6767.2%51.4%33.5%28.6%
    Slough56.05.0777.2%63.5%40.8%32.9%
    Southampton46.13.9461.9%42.1%20.7%15.9%
    Surrey52.94.6676.0%58.1%28.9%22.9%
    West Berkshire52.24.6274.2%55.0%32.2%23.6%
    West Sussex49.14.2869.6%48.8%25.8%19.4%
    Windsor and Maidenhead51.24.5876.2%55.1%31.7%23.2%
    Wokingham54.84.9479.0%62.0%38.5%29.2%
    South WestBath and North East Somerset52.24.5975.1%57.0%32.0%23.3%
    Bournemouth, Christchurch and Poole52.74.6776.4%58.9%32.9%26.8%
    Bristol, City of48.24.1666.7%48.3%21.7%16.3%
    Cornwall46.93.9865.2%43.1%17.3%12.6%
    Devon48.24.2270.0%48.9%23.5%17.4%
    Dorset47.94.1868.5%45.1%24.2%17.5%
    Gloucestershire52.64.5573.8%56.0%25.2%20.5%
    Isles of Scilly52.54.4786.7%66.7%20.0%13.3%
    North Somerset49.04.2369.4%48.3%23.5%17.7%
    Plymouth47.54.0766.5%46.0%22.1%16.6%
    Somerset45.63.8965.2%45.4%17.1%12.4%
    South Gloucestershire47.74.1068.5%48.3%22.5%16.9%
    Swindon46.64.0065.5%46.9%17.4%12.8%
    Torbay48.74.1766.3%52.3%21.2%17.9%
    Wiltshire49.34.3369.8%48.6%24.6%19.0%
    Inner LondonCamden52.44.8275.1%58.6%38.2%29.7%
    Hackney51.94.7573.6%55.8%42.7%31.7%
    Hammersmith and Fulham57.45.3580.0%66.1%50.4%40.7%
    Haringey50.54.5170.2%52.3%28.9%21.4%
    Islington49.94.4270.5%52.7%28.5%21.9%
    Kensington and Chelsea53.64.7979.7%64.6%21.8%16.5%
    Lambeth46.34.2066.1%47.3%31.9%23.0%
    Lewisham47.84.3166.6%46.7%31.1%21.8%
    Newham53.84.8776.3%59.2%38.5%28.8%
    Southwark53.64.9275.4%59.0%46.1%34.4%
    Tower Hamlets49.84.4471.2%54.5%29.0%21.8%
    Wandsworth54.05.0377.3%61.0%45.3%33.1%
    Westminster57.35.3381.8%66.0%49.4%39.1%
    Outer LondonBarking and Dagenham49.34.3568.5%50.6%29.5%20.7%
    Barnet58.15.3480.5%66.8%45.4%37.7%
    Bexley52.34.6871.9%54.6%37.2%30.3%
    Brent52.44.8772.8%56.7%40.6%31.0%
    Bromley53.94.9477.3%59.8%45.6%35.1%
    Croydon47.64.2267.9%48.9%27.3%18.9%
    Ealing53.74.9476.7%61.4%41.5%31.9%
    Enfield48.64.4667.5%50.2%32.0%23.8%
    Greenwich49.44.3169.8%51.9%29.4%23.1%
    Harrow54.24.8974.8%58.7%36.7%28.1%
    Havering50.34.5271.6%52.9%37.0%26.5%
    Hillingdon51.84.5674.9%56.0%29.9%22.6%
    Hounslow52.64.7975.2%58.5%40.1%29.6%
    Kingston upon Thames60.25.6082.5%68.9%54.0%44.2%
    Merton53.64.8176.0%57.1%38.2%27.6%
    Redbridge56.55.0879.0%65.2%37.6%29.5%
    Richmond upon Thames58.05.3683.0%67.8%49.7%39.4%
    Sutton61.05.5082.0%69.3%41.0%35.9%
    Waltham Forest48.24.2668.9%50.2%26.8%19.0%

    Footnotes

    1. In 2020 and 2021, all GCSEs in England have been reformed and use the new 9 to 1 grading system (rather than A*-G). Year on year comparisons will be limited until these qualifications are consistently included from 2020 onwards. However, results for 2020 and 2021 are not comparable with earlier years due to the cancellation of exams (due to COVID-19) and the changes to the way GCSE grades were awarded and results for 2022 are not comparable with previous years due to the changes relating to grading assessments.
    2. All state-funded schools include local authority maintained mainstream schools, academies, free schools, city technology colleges, further education colleges with provision for 14 to 16 year-olds and state-funded special schools. They exclude independent schools, independent special schools, non-maintained special schools, hospital schools, pupil referral units and alternative provision. Alternative provision includes academy and free school alternative provision.

    Save table

    Download Table

    Select file format:

    Related information

    Our statistical practice is regulated by the Office for Statistics Regulation (OSR)