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

   • Publication: September Guarantee: offers of education and training for young people age 16 and 17

2. Step 2

   • Data set: September Guarantee

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford
   • Regional:
     • East Midlands
     • East of England
     • London
     • North East
     • North West
   • National:
     • England

4. Step 4

   • Time period: 2019 to 2023

5. Step 5

   • Indicators:
     • Percentage of young people who received a suitable offer

6. Step 6 Explore data

   This is the latest data

   Percentage of young people who received a suitable offer for 'September Guarantee' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 160 other locations between 2019 and 2023

   		2019	2020	2021	2022	2023
   England		95.0%	94.3%	95.5%	94.6%	94.6%
   North East	North East	95.5%	94.8%	95.7%	95.5%	95.7%
   	County Durham	97.0%	96.5%	96.6%	96.6%	96.2%
   	Darlington	95.2%	94.9%	96.7%	91.8%	92.6%
   	Gateshead	92.2%	83.1%	92.1%	92.8%	98.1%
   	Hartlepool	98.2%	97.3%	97.0%	97.1%	96.0%
   	Middlesbrough	97.4%	95.3%	96.2%	96.7%	95.2%
   	Newcastle upon Tyne	96.7%	93.6%	95.0%	93.4%	93.5%
   	North Tyneside	97.1%	97.2%	96.5%	95.5%	94.7%
   	Northumberland	97.9%	96.6%	96.8%	97.2%	97.6%
   	Redcar and Cleveland	93.9%	97.7%	96.7%	96.1%	97.0%
   	South Tyneside	92.3%	91.7%	92.5%	91.2%	94.1%
   	Stockton-on-Tees	97.3%	95.4%	96.4%	96.8%	95.8%
   	Sunderland	89.8%	95.7%	95.2%	96.4%	95.3%
   North West	North West	96.3%	96.0%	95.7%	95.0%	94.9%
   	Blackburn with Darwen	98.2%	97.8%	98.0%	96.5%	96.9%
   	Blackpool	89.6%	91.0%	85.3%	81.4%	80.4%
   	Bolton	99.0%	99.0%	98.9%	99.2%	99.3%
   	Bury	97.5%	98.7%	97.8%	98.0%	97.0%
   	Cheshire East	99.4%	98.6%	99.0%	99.2%	97.0%
   	Cheshire West and Chester	98.6%	97.7%	92.0%	83.4%	94.4%
   	Cumberland	no data	no data	no data	no data	97.6%
   	Cumbria	97.1%	96.5%	97.6%	97.9%	no data
   	Halton	97.4%	96.8%	96.6%	96.0%	94.7%
   	Knowsley	97.6%	98.0%	98.6%	97.8%	97.2%
   	Lancashire	93.7%	93.6%	93.7%	91.9%	91.7%
   	Liverpool	94.3%	93.0%	95.2%	94.2%	94.6%
   	Manchester	94.9%	94.5%	93.5%	93.5%	91.5%
   	Oldham	98.0%	97.2%	96.4%	98.3%	95.8%
   	Rochdale	98.5%	97.6%	96.8%	98.2%	97.6%
   	Salford	94.1%	94.6%	94.6%	94.7%	94.3%
   	Sefton	97.0%	96.9%	96.9%	97.0%	97.0%
   	St. Helens	95.5%	95.5%	95.6%	95.7%	95.6%
   	Stockport	97.6%	97.6%	97.5%	97.8%	96.9%
   	Tameside	98.5%	97.9%	95.7%	98.1%	95.6%
   	Trafford	96.1%	96.1%	95.9%	95.3%	95.5%
   	Warrington	96.3%	97.6%	97.4%	98.1%	98.1%
   	Westmorland and Furness	no data	no data	no data	no data	97.8%
   	Wigan	95.2%	95.6%	95.4%	94.0%	93.2%
   	Wirral	97.4%	97.1%	97.0%	96.1%	96.0%
   Yorkshire and The Humber	Yorkshire and The Humber	95.5%	95.3%	95.3%	94.9%	94.8%
   	Barnsley	99.9%	99.8%	99.9%	100.0%	100.0%
   	Bradford	94.6%	94.8%	93.0%	93.3%	92.6%
   	Calderdale	96.0%	96.4%	96.1%	95.4%	95.3%
   	Doncaster	99.4%	98.9%	98.4%	97.7%	96.4%
   	East Riding of Yorkshire	96.2%	94.5%	95.7%	95.7%	94.7%
   	Kingston upon Hull, City of	97.4%	97.4%	97.4%	96.4%	96.1%
   	Kirklees	96.6%	96.7%	96.9%	96.6%	95.9%
   	Leeds	91.7%	93.3%	93.2%	93.7%	94.2%
   	North East Lincolnshire	95.2%	95.0%	95.4%	93.8%	94.4%
   	North Lincolnshire	96.0%	87.5%	92.5%	86.2%	89.6%
   	North Yorkshire	95.5%	94.3%	96.5%	97.1%	96.6%
   	Rotherham	97.7%	98.1%	97.0%	95.5%	94.0%
   	Sheffield	91.9%	92.2%	91.2%	89.6%	91.1%
   	Wakefield	98.1%	98.2%	98.1%	98.3%	98.1%
   	York	96.2%	96.8%	96.7%	97.3%	96.6%
   East Midlands	East Midlands	94.6%	95.1%	96.6%	89.7%	94.8%
   	Derby	94.0%	92.1%	94.3%	97.0%	95.9%
   	Derbyshire	91.1%	93.7%	98.0%	96.1%	97.3%
   	Leicester	96.9%	95.9%	95.4%	95.9%	94.4%
   	Leicestershire	94.6%	96.2%	96.2%	95.7%	96.3%
   	Lincolnshire	94.1%	91.9%	94.9%	92.1%	92.1%
   	North Northamptonshire	no data	no data	98.4%	98.6%	98.2%
   	Northamptonshire	97.9%	98.4%	no data	no data	no data
   	Nottingham	94.7%	96.2%	95.6%	90.2%	90.3%
   	Nottinghamshire	94.2%	95.4%	97.0%	61.1%	91.7%
   	Rutland	98.4%	96.0%	97.9%	97.3%	97.8%
   	West Northamptonshire	no data	no data	98.8%	98.7%	98.6%
   West Midlands	West Midlands	96.0%	94.9%	96.3%	96.1%	92.6%
   	Birmingham	92.6%	90.9%	94.2%	95.3%	95.6%
   	Coventry	96.7%	97.4%	98.6%	98.6%	98.6%
   	Dudley	96.2%	95.6%	88.7%	89.5%	83.8%
   	Herefordshire, County of	95.9%	97.3%	97.0%	98.5%	97.5%
   	Sandwell	99.2%	99.3%	99.5%	99.5%	99.5%
   	Shropshire	96.3%	83.9%	99.3%	97.0%	85.6%
   	Solihull	97.1%	97.4%	97.9%	97.3%	97.1%
   	Staffordshire	98.5%	98.2%	98.5%	97.6%	95.8%
   	Stoke-on-Trent	97.6%	97.0%	93.2%	91.5%	33.0%
   	Telford and Wrekin	93.6%	93.3%	95.8%	95.9%	96.2%
   	Walsall	99.0%	99.3%	99.0%	98.9%	99.3%
   	Warwickshire	97.9%	98.3%	98.7%	98.1%	98.9%
   	Wolverhampton	98.4%	98.7%	99.0%	99.2%	99.4%
   	Worcestershire	92.7%	90.4%	93.3%	90.9%	89.7%
   East of England	East of England	95.2%	95.2%	95.8%	95.6%	95.0%
   	Bedford	95.8%	96.9%	96.3%	95.8%	96.6%
   	Cambridgeshire	95.4%	96.3%	96.6%	96.0%	95.0%
   	Central Bedfordshire	95.4%	95.1%	95.8%	94.9%	95.2%
   	Essex	94.6%	94.7%	95.3%	94.1%	92.8%
   	Hertfordshire	96.5%	96.5%	96.9%	96.1%	96.2%
   	Luton	97.2%	97.0%	97.1%	97.6%	97.3%
   	Norfolk	94.5%	92.4%	92.9%	95.1%	94.1%
   	Peterborough	91.8%	92.9%	94.8%	95.8%	95.4%
   	Southend-on-Sea	96.0%	94.4%	96.1%	98.8%	95.8%
   	Suffolk	93.2%	95.1%	95.8%	95.1%	95.6%
   	Thurrock	99.9%	99.7%	100.0%	100.2%	100.0%
   London	London	95.5%	95.9%	96.6%	96.7%	97.2%
   	Barking and Dagenham	97.9%	97.0%	97.5%	98.7%	97.6%
   	Barnet	96.0%	99.2%	99.2%	99.4%	99.4%
   	Bexley	98.9%	98.1%	98.1%	98.1%	98.3%
   	Brent	97.9%	97.2%	97.5%	97.5%	97.7%
   	Bromley	98.4%	98.3%	98.6%	98.5%	97.5%
   	Camden	98.6%	98.7%	98.4%	98.5%	98.4%
   	City of London	99.6%	100.0%	100.0%	100.0%	99.6%
   	Croydon	94.0%	94.2%	95.6%	95.6%	95.3%
   	Ealing	89.0%	90.6%	95.8%	97.4%	96.5%
   	Enfield	87.8%	94.8%	94.9%	96.8%	97.3%
   	Greenwich	97.3%	96.6%	97.6%	98.2%	97.4%
   	Hackney	97.8%	97.3%	97.7%	98.0%	98.1%
   	Hammersmith and Fulham	99.2%	98.3%	67.2%	83.2%	85.6%
   	Haringey	83.8%	84.6%	92.2%	95.0%	93.4%
   	Harrow	98.7%	98.1%	98.1%	98.2%	98.4%
   	Havering	98.7%	98.1%	98.1%	98.1%	98.0%
   	Hillingdon	92.5%	91.7%	96.8%	93.8%	97.4%
   	Hounslow	95.2%	95.8%	96.6%	83.0%	96.4%
   	Islington	96.6%	97.1%	97.3%	96.7%	97.1%
   	Kensington and Chelsea	96.1%	98.2%	98.7%	98.5%	98.1%
   	Kingston upon Thames	96.3%	96.9%	98.1%	98.0%	97.9%
   	Lambeth	93.2%	95.1%	95.3%	97.3%	97.5%
   	Lewisham	98.3%	98.5%	98.3%	95.6%	97.4%
   	Merton	96.8%	96.7%	97.4%	97.5%	97.3%
   	Newham	94.3%	94.7%	95.7%	96.6%	96.0%
   	Redbridge	97.2%	93.3%	94.5%	97.5%	97.5%
   	Richmond upon Thames	95.5%	96.2%	97.0%	97.2%	98.3%
   	Southwark	98.5%	99.3%	99.1%	99.3%	99.5%
   	Sutton	97.4%	97.8%	98.3%	98.2%	96.5%
   	Tower Hamlets	95.2%	93.2%	96.7%	97.3%	97.3%
   	Waltham Forest	97.4%	98.3%	99.4%	99.6%	99.2%
   	Wandsworth	94.5%	94.2%	97.8%	97.7%	97.3%
   	Westminster	98.5%	98.3%	98.3%	98.5%	98.1%
   South East	South East	93.8%	90.9%	93.2%	92.8%	92.8%
   	Bracknell Forest	96.9%	93.0%	97.5%	95.9%	95.1%
   	Brighton and Hove	93.9%	96.0%	96.5%	96.1%	95.7%
   	Buckinghamshire	93.6%	92.5%	92.3%	94.6%	92.7%
   	East Sussex	93.7%	94.4%	94.7%	93.6%	92.9%
   	Hampshire	97.5%	97.5%	97.0%	97.1%	96.6%
   	Isle of Wight	98.3%	98.2%	98.2%	98.3%	98.5%
   	Kent	93.2%	93.2%	94.6%	95.1%	93.2%
   	Medway	85.0%	86.8%	70.2%	82.2%	95.3%
   	Milton Keynes	97.0%	96.3%	96.6%	97.2%	98.1%
   	Oxfordshire	96.0%	95.5%	95.8%	95.3%	87.9%
   	Portsmouth	95.3%	94.1%	94.2%	94.3%	91.5%
   	Reading	57.4%	92.6%	95.1%	96.2%	96.2%
   	Slough	95.5%	94.4%	93.3%	91.4%	93.9%
   	Southampton	95.4%	94.7%	95.7%	93.3%	91.7%
   	Surrey	94.2%	67.2%	87.5%	85.9%	91.6%
   	West Berkshire	98.0%	97.9%	98.3%	97.9%	97.6%
   	West Sussex	89.3%	90.2%	92.7%	84.1%	83.5%
   	Windsor and Maidenhead	94.8%	94.3%	81.8%	92.8%	93.3%
   	Wokingham	96.3%	96.2%	96.3%	94.7%	94.8%
   South West	South West	92.5%	91.3%	94.7%	94.3%	94.6%
   	Bath and North East Somerset	78.8%	82.6%	95.7%	95.1%	97.3%
   	Bournemouth, Christchurch and Poole	92.6%	90.3%	94.6%	93.9%	93.9%
   	Bristol, City of	92.8%	87.0%	92.3%	94.1%	93.1%
   	Cornwall	95.7%	95.5%	96.1%	94.9%	94.3%
   	Devon	95.6%	95.7%	95.8%	94.4%	94.8%
   	Dorset	94.6%	94.6%	92.8%	94.6%	95.5%
   	Gloucestershire	97.0%	97.4%	97.6%	97.3%	97.3%
   	Isles of Scilly	100.0%	97.1%	100.0%	100.0%	100.0%
   	North Somerset	91.5%	91.0%	89.2%	87.5%	87.4%
   	Plymouth	95.0%	95.1%	96.1%	95.0%	95.1%
   	Somerset	91.8%	93.1%	94.1%	89.4%	93.8%
   	South Gloucestershire	94.6%	85.5%	95.7%	96.2%	96.8%
   	Swindon	60.8%	50.8%	89.5%	95.8%	88.3%
   	Torbay	96.5%	96.9%	96.7%	95.2%	95.8%
   	Wiltshire	93.4%	94.3%	94.8%	95.1%	96.6%

   Footnotes

   1. In 2019, local authority figures for Reading should be used with caution due to administrative issues.
   2. In 2020, local authority figures for Bristol, Swindon, Shropshire and Worcestershire should be used with caution due to system issues or administrative errors.

   Save table

   Related information

   • Release type:
   • Publication: September Guarantee: offers of education and training for young people age 16 and 17, Academic year 2023/24

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