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: 2023

5. Step 5

   • Indicators:
     • Annual change in the percentage receiving a suitable offer
     • Cohort number
     • Percentage no offer
     • Percentage not recorded
     • Percentage of young people who received a suitable offer

6. Step 6 Explore data

   This is the latest data

   Some rows and columns are not shown in this table as the data does not exist in the underlying file.

   'September Guarantee' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 158 other locations for 2023

   		2023
   		Cohort number	Percentage of young people who received a suitable offer	Annual change in the percentage receiving a suitable offer	Percentage offer not appropriate	Percentage no offer	Percentage not recorded
   England		1,259,403	94.6%	0.1pp	1.3%	1.0%	3.1%
   North East	North East	58,875	95.7%	0.2pp	2.2%	1.1%	1.0%
   	County Durham	11,323	96.2%	-0.3pp	2.2%	0.1%	1.5%
   	Darlington	2,388	92.6%	0.8pp	2.8%	3.6%	1.0%
   	Gateshead	4,063	98.1%	5.4pp	0.0%	0.0%	1.9%
   	Hartlepool	2,325	96.0%	-1.1pp	2.2%	1.2%	0.6%
   	Middlesbrough	3,492	95.2%	-1.5pp	1.4%	2.3%	1.2%
   	Newcastle upon Tyne	6,225	93.5%	0.1pp	4.0%	1.4%	1.1%
   	North Tyneside	4,617	94.7%	-0.8pp	2.7%	0.5%	2.1%
   	Northumberland	6,529	97.6%	0.4pp	1.1%	0.3%	1.0%
   	Redcar and Cleveland	3,376	97.0%	0.9pp	1.8%	1.2%	0.1%
   	South Tyneside	3,369	94.1%	2.9pp	2.5%	2.3%	1.1%
   	Stockton-on-Tees	4,791	95.8%	-1.1pp	1.4%	2.6%	0.3%
   	Sunderland	6,377	95.3%	-1.1pp	3.6%	1.0%	0.2%
   North West	North West	173,276	94.9%	-0.1pp	1.4%	1.0%	2.7%
   	Blackburn with Darwen	4,519	96.9%	0.3pp	1.1%	1.0%	1.0%
   	Blackpool	2,716	80.4%	-1.0pp	5.7%	7.4%	6.6%
   	Bolton	8,442	99.3%	0.2pp	0.5%	0.0%	0.1%
   	Bury	4,685	97.0%	-1.0pp	2.9%	0.0%	0.1%
   	Cheshire East	8,229	97.0%	-2.1pp	1.9%	0.4%	0.6%
   	Cheshire West and Chester	7,546	94.4%	11.0pp	0.8%	0.7%	4.1%
   	Cumberland	6,342	97.6%	z	1.8%	0.1%	0.5%
   	Halton	3,207	94.7%	-1.3pp	3.7%	1.4%	0.2%
   	Knowsley	3,125	97.2%	-0.6pp	2.1%	0.0%	0.6%
   	Lancashire	28,114	91.7%	-0.2pp	1.1%	1.5%	5.7%
   	Liverpool	10,602	94.6%	0.5pp	1.0%	1.9%	2.4%
   	Manchester	13,854	91.5%	-2.0pp	0.2%	0.1%	8.2%
   	Oldham	6,946	95.8%	-2.5pp	1.2%	2.7%	0.3%
   	Rochdale	5,918	97.6%	-0.6pp	1.2%	0.9%	0.3%
   	Salford	5,506	94.3%	-0.4pp	2.7%	0.6%	2.4%
   	Sefton	6,082	97.0%	-0.0pp	0.9%	0.6%	1.5%
   	St. Helens	4,124	95.6%	-0.2pp	2.1%	1.3%	1.0%
   	Stockport	6,500	96.9%	-0.9pp	0.8%	1.0%	1.4%
   	Tameside	5,760	95.6%	-2.5pp	2.7%	1.2%	0.5%
   	Trafford	6,449	95.5%	0.2pp	0.6%	0.3%	3.6%
   	Warrington	5,025	98.1%	0.0pp	1.4%	0.3%	0.3%
   	Westmorland and Furness	4,243	97.8%	z	1.5%	0.0%	0.6%
   	Wigan	7,546	93.2%	-0.8pp	2.2%	0.7%	3.9%
   	Wirral	7,796	96.0%	-0.1pp	2.1%	0.9%	0.9%
   Yorkshire and The Humber	Yorkshire and The Humber	126,896	94.8%	-0.1pp	1.8%	1.3%	2.1%
   	Barnsley	5,434	100.0%	0.0pp	0.0%	0.0%	0.0%
   	Bradford	14,687	92.6%	-0.7pp	1.5%	0.9%	5.1%
   	Calderdale	5,647	95.3%	-0.1pp	3.1%	1.1%	0.4%
   	Doncaster	7,119	96.4%	-1.2pp	1.3%	1.5%	0.8%
   	East Riding of Yorkshire	7,044	94.7%	-1.0pp	2.4%	1.3%	1.6%
   	Kingston upon Hull, City of	6,440	96.1%	-0.3pp	3.0%	0.6%	0.3%
   	Kirklees	10,845	95.9%	-0.7pp	2.1%	1.7%	0.3%
   	Leeds	18,425	94.2%	0.5pp	1.9%	2.7%	1.2%
   	North East Lincolnshire	3,835	94.4%	0.6pp	3.3%	1.8%	0.5%
   	North Lincolnshire	4,048	89.6%	3.4pp	1.3%	2.4%	6.7%
   	North Yorkshire	12,349	96.6%	-0.5pp	1.0%	0.8%	1.6%
   	Rotherham	6,781	94.0%	-1.5pp	3.2%	1.8%	1.0%
   	Sheffield	12,441	91.1%	1.5pp	1.4%	0.7%	6.8%
   	Wakefield	7,928	98.1%	-0.1pp	1.3%	0.6%	0.0%
   	York	3,873	96.6%	-0.7pp	0.7%	0.5%	2.2%
   East Midlands	East Midlands	109,162	94.8%	5.1pp	0.7%	1.3%	3.1%
   	Derby	6,561	95.9%	-1.2pp	0.7%	1.7%	1.7%
   	Derbyshire	16,489	97.3%	1.2pp	0.5%	1.5%	0.7%
   	Leicester	9,638	94.4%	-1.5pp	1.4%	2.6%	1.6%
   	Leicestershire	15,256	96.3%	0.7pp	0.3%	0.3%	3.0%
   	Lincolnshire	17,143	92.1%	0.0pp	1.3%	2.4%	4.1%
   	North Northamptonshire	8,174	98.2%	-0.4pp	1.1%	0.7%	0.0%
   	Nottingham	6,972	90.3%	0.1pp	0.8%	1.6%	7.4%
   	Nottinghamshire	18,373	91.7%	30.6pp	0.2%	0.7%	7.3%
   	Rutland	903	97.8%	0.5pp	0.9%	0.1%	1.2%
   	West Northamptonshire	9,653	98.6%	-0.1pp	0.7%	0.7%	0.0%
   West Midlands	West Midlands	141,377	92.6%	-3.5pp	0.7%	0.8%	5.9%
   	Birmingham	31,627	95.6%	0.3pp	0.1%	0.1%	4.2%
   	Coventry	8,257	98.6%	0.0pp	0.5%	0.8%	0.0%
   	Dudley	7,438	83.8%	-5.6pp	1.0%	6.1%	9.0%
   	Herefordshire, County of	3,708	97.5%	-1.0pp	1.6%	0.4%	0.5%
   	Sandwell	9,248	99.5%	0.1pp	0.5%	0.0%	-0.0%
   	Shropshire	5,914	85.6%	-11.4pp	0.6%	0.4%	13.4%
   	Solihull	6,241	97.1%	-0.2pp	0.9%	1.4%	0.6%
   	Staffordshire	18,806	95.8%	-1.8pp	2.2%	1.1%	0.9%
   	Stoke-on-Trent	6,089	33.0%	-58.5pp	0.0%	0.0%	67.0%
   	Telford and Wrekin	4,549	96.2%	0.3pp	1.3%	1.4%	1.2%
   	Walsall	7,594	99.3%	0.3pp	0.4%	0.3%	0.0%
   	Warwickshire	12,435	98.9%	0.8pp	0.5%	0.6%	0.0%
   	Wolverhampton	6,494	99.4%	0.2pp	0.4%	0.3%	0.0%
   	Worcestershire	12,977	89.7%	-1.2pp	0.2%	0.8%	9.3%
   East of England	East of England	141,912	95.0%	-0.6pp	2.3%	1.2%	1.4%
   	Bedford	4,401	96.6%	0.9pp	0.0%	0.8%	2.6%
   	Cambridgeshire	13,306	95.0%	-1.0pp	4.6%	0.0%	0.4%
   	Central Bedfordshire	6,246	95.2%	0.3pp	2.7%	1.5%	0.6%
   	Essex	33,963	92.8%	-1.4pp	2.6%	2.1%	2.5%
   	Hertfordshire	28,935	96.2%	0.1pp	1.8%	1.0%	1.0%
   	Luton	6,188	97.3%	-0.3pp	0.2%	0.7%	1.8%
   	Norfolk	18,358	94.1%	-1.0pp	2.7%	1.5%	1.7%
   	Peterborough	5,735	95.4%	-0.4pp	3.6%	0.5%	0.5%
   	Southend-on-Sea	4,304	95.8%	-3.0pp	1.1%	0.4%	2.7%
   	Suffolk	15,908	95.6%	0.5pp	2.2%	1.6%	0.6%
   	Thurrock	4,568	100.0%	-0.3pp	0.0%	0.0%	0.0%
   London	London	189,911	97.2%	0.5pp	0.4%	0.7%	1.7%
   	Barking and Dagenham	6,655	97.6%	-1.2pp	1.3%	0.6%	0.5%
   	Barnet	8,965	99.4%	-0.1pp	0.1%	0.4%	0.2%
   	Bexley	6,496	98.3%	0.2pp	0.4%	0.3%	1.0%
   	Brent	7,517	97.7%	0.2pp	0.1%	0.1%	2.2%
   	Bromley	7,428	97.5%	-1.0pp	0.2%	0.4%	1.8%
   	Camden	3,261	98.4%	-0.0pp	0.4%	0.3%	0.8%
   	City of London	280	99.6%	-0.4pp	0.0%	0.0%	0.4%
   	Croydon	8,790	95.3%	-0.4pp	0.5%	0.8%	3.4%
   	Ealing	7,994	96.5%	-0.9pp	0.7%	0.1%	2.8%
   	Enfield	8,580	97.3%	0.5pp	0.4%	0.0%	2.3%
   	Greenwich	6,391	97.4%	-0.8pp	0.4%	0.8%	1.4%
   	Hackney	5,276	98.1%	0.1pp	0.1%	0.1%	1.7%
   	Hammersmith and Fulham	3,104	85.6%	2.4pp	0.1%	14.3%	0.0%
   	Haringey	5,618	93.4%	-1.5pp	0.0%	0.0%	6.6%
   	Harrow	5,710	98.4%	0.2pp	0.1%	0.0%	1.5%
   	Havering	6,222	98.0%	-0.1pp	0.4%	0.3%	1.3%
   	Hillingdon	7,580	97.4%	3.6pp	0.6%	1.8%	0.2%
   	Hounslow	6,763	96.4%	13.4pp	0.2%	0.9%	2.5%
   	Islington	3,372	97.1%	0.4pp	1.3%	0.2%	1.4%
   	Kensington and Chelsea	1,762	98.1%	-0.4pp	0.2%	0.2%	1.4%
   	Kingston upon Thames	3,706	97.9%	-0.1pp	0.1%	0.2%	1.7%
   	Lambeth	5,377	97.5%	0.2pp	0.7%	0.2%	1.6%
   	Lewisham	5,728	97.4%	1.8pp	0.4%	0.5%	1.7%
   	Merton	4,203	97.3%	-0.2pp	0.2%	1.0%	1.4%
   	Newham	9,441	96.0%	-0.5pp	0.2%	0.4%	3.3%
   	Redbridge	8,165	97.5%	0.1pp	0.2%	0.5%	1.8%
   	Richmond upon Thames	3,468	98.3%	1.1pp	0.1%	0.0%	1.6%
   	Southwark	6,036	99.5%	0.2pp	0.2%	0.1%	0.2%
   	Sutton	5,972	96.5%	-1.7pp	0.1%	0.3%	3.1%
   	Tower Hamlets	6,521	97.3%	0.1pp	0.3%	1.4%	1.0%
   	Waltham Forest	6,063	99.2%	-0.4pp	0.3%	0.1%	0.3%
   	Wandsworth	4,369	97.3%	-0.3pp	1.2%	0.5%	0.9%
   	Westminster	3,098	98.1%	-0.4pp	0.1%	0.6%	1.3%
   South East	South East	199,817	92.8%	-0.0pp	1.2%	0.9%	5.1%
   	Bracknell Forest	2,748	95.1%	-0.8pp	2.3%	0.9%	1.7%
   	Brighton and Hove	5,182	95.7%	-0.4pp	3.2%	0.3%	0.8%
   	Buckinghamshire	12,842	92.7%	-1.9pp	0.9%	0.5%	5.9%
   	East Sussex	11,190	92.9%	-0.7pp	4.1%	2.0%	1.0%
   	Hampshire	29,830	96.6%	-0.5pp	1.2%	0.4%	1.8%
   	Isle of Wight	2,869	98.5%	0.3pp	1.2%	0.1%	0.2%
   	Kent	36,513	93.2%	-2.0pp	1.2%	1.0%	4.6%
   	Medway	7,224	95.3%	13.1pp	0.3%	2.7%	1.8%
   	Milton Keynes	7,016	98.1%	0.9pp	1.4%	0.2%	0.3%
   	Oxfordshire	14,117	87.9%	-7.4pp	1.1%	1.3%	9.6%
   	Portsmouth	4,285	91.5%	-2.8pp	2.8%	4.0%	1.6%
   	Reading	3,353	96.2%	0.0pp	2.7%	0.9%	0.2%
   	Slough	4,763	93.9%	2.5pp	1.6%	1.8%	2.7%
   	Southampton	4,934	91.7%	-1.6pp	0.0%	0.0%	8.3%
   	Surrey	24,329	91.6%	5.7pp	0.4%	0.3%	7.7%
   	West Berkshire	3,804	97.6%	-0.3pp	1.2%	0.8%	0.4%
   	West Sussex	17,427	83.5%	-0.6pp	0.2%	0.4%	15.8%
   	Windsor and Maidenhead	3,352	93.3%	0.6pp	0.1%	0.1%	6.5%
   	Wokingham	4,039	94.8%	0.1pp	1.6%	1.3%	2.4%
   South West	South West	118,177	94.6%	0.3pp	1.7%	0.7%	3.0%
   	Bath and North East Somerset	4,093	97.3%	2.1pp	1.1%	0.9%	0.7%
   	Bournemouth, Christchurch and Poole	8,196	93.9%	-0.0pp	2.8%	2.1%	1.3%
   	Bristol, City of	8,859	93.1%	-0.9pp	0.3%	0.4%	6.2%
   	Cornwall	12,189	94.3%	-0.6pp	1.8%	0.3%	3.6%
   	Devon	16,086	94.8%	0.4pp	2.3%	0.6%	2.4%
   	Dorset	7,630	95.5%	0.9pp	3.4%	0.6%	0.5%
   	Gloucestershire	14,017	97.3%	0.0pp	1.3%	0.5%	0.9%
   	Isles of Scilly	44	100.0%	0.0pp	0.0%	0.0%	0.0%
   	North Somerset	4,906	87.4%	-0.1pp	0.5%	0.0%	12.1%
   	Plymouth	5,959	95.1%	0.1pp	1.5%	0.7%	2.7%
   	Somerset	11,455	93.8%	4.4pp	1.4%	1.1%	3.7%
   	South Gloucestershire	5,907	96.8%	0.6pp	1.1%	1.1%	1.0%
   	Swindon	5,443	88.3%	-7.5pp	1.5%	1.1%	9.1%
   	Torbay	3,201	95.8%	0.5pp	2.0%	0.4%	1.9%
   	Wiltshire	10,192	96.6%	1.4pp	2.0%	0.1%	1.3%

   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)