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: Career pathways: post-16 qualifications held by employees

2. Step 2

   • Data set: Employee numbers and median earnings by region, sector, subsector, level and subject

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2018-19

5. Step 5

   • Indicators:
     • Median annual earnings
     • Number of employees
     • Proportion of employees by industry sector
     • Proportion of employees by level
   • Highest qualification level:
     • Total
     • Below level 2
     • Level 2
     • Level 3
     • Level 4/5
   • Industry sector:
     • Total
     • Accommodation & food
     • Agriculture
     • Arts & entertainment
     • Construction
   • Industry sub-sector:
     • Total
   • Subject of highest qualification:
     • Total

6. Step 6 Explore data

   This is the latest data

   'Employee numbers and median earnings by region, sector, subsector, level and subject' for Accommodation & food, Agriculture, Arts & entertainment, Below level 2, Construction and 23 other filters in England for 2018-19

   	2018-19
   	Number of employees							Proportion of employees by level							Proportion of employees by industry sector							Median annual earnings
   	Total	Below level 2	Level 2	Level 3	Level 4/5	Level 6	Level 7+	Total	Below level 2	Level 2	Level 3	Level 4/5	Level 6	Level 7+	Total	Below level 2	Level 2	Level 3	Level 4/5	Level 6	Level 7+	Total	Below level 2	Level 2	Level 3	Level 4/5	Level 6	Level 7+
   Total	2,020,240	74,830	416,340	640,990	92,330	630,810	164,930	100.0%	3.7%	20.6%	31.7%	4.6%	31.2%	8.2%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	100.0%	£22,600	£16,300	£18,500	£20,600	£23,000	£26,800	£28,900
   Accommodation & food	116,480	7,940	37,190	43,920	5,140	20,460	1,830	100.0%	6.8%	31.9%	37.7%	4.4%	17.6%	1.6%	5.8%	10.6%	8.9%	6.9%	5.6%	3.2%	1.1%	£15,600	£10,200	£13,400	£16,700	£17,400	£18,800	£17,400
   Agriculture	9,120	700	2,910	3,480	420	1,420	190	100.0%	7.7%	31.9%	38.2%	4.6%	15.5%	2.1%	0.5%	0.9%	0.7%	0.5%	0.5%	0.2%	0.1%	£21,000	£19,900	£21,500	£20,700	£22,100	£20,700	£22,500
   Arts & entertainment	49,680	1,520	9,060	16,950	2,290	16,560	3,290	100.0%	3.1%	18.2%	34.1%	4.6%	33.3%	6.6%	2.5%	2.0%	2.2%	2.6%	2.5%	2.6%	2.0%	£18,700	£12,000	£15,300	£18,100	£18,600	£22,000	£22,900
   Construction	86,450	5,350	29,660	33,350	3,560	12,210	2,330	100.0%	6.2%	34.3%	38.6%	4.1%	14.1%	2.7%	4.3%	7.1%	7.1%	5.2%	3.9%	1.9%	1.4%	£27,900	£23,500	£26,000	£28,100	£32,100	£32,700	£36,700
   Education	196,130	1,840	12,940	38,500	6,530	81,550	54,780	100.0%	0.9%	6.6%	19.6%	3.3%	41.6%	27.9%	9.7%	2.5%	3.1%	6.0%	7.1%	12.9%	33.2%	£22,600	£7,800	£12,900	£16,200	£18,000	£23,800	£27,200
   Electricity & gas	11,240	160	1,960	4,790	940	2,810	600	100.0%	1.4%	17.4%	42.6%	8.3%	25.0%	5.3%	0.6%	0.2%	0.5%	0.7%	1.0%	0.4%	0.4%	£30,900	£26,900	£27,100	£30,400	£43,600	£30,900	£38,000
   Engineering	22,720	950	5,130	7,710	1,980	5,120	1,840	100.0%	4.2%	22.6%	33.9%	8.7%	22.5%	8.1%	1.1%	1.3%	1.2%	1.2%	2.1%	0.8%	1.1%	£27,500	£20,800	£23,000	£26,200	£32,200	£31,300	£34,000
   Finance & insurance	97,300	840	12,000	32,470	3,430	42,220	6,340	100.0%	0.9%	12.3%	33.4%	3.5%	43.4%	6.5%	4.8%	1.1%	2.9%	5.1%	3.7%	6.7%	3.8%	£28,000	£20,000	£22,200	£24,500	£23,500	£34,500	£45,300
   Food drink & tobacco	19,350	1,280	5,890	5,480	960	5,060	690	100.0%	6.6%	30.4%	28.3%	4.9%	26.1%	3.6%	1.0%	1.7%	1.4%	0.9%	1.0%	0.8%	0.4%	£24,200	£19,200	£20,900	£23,800	£31,300	£30,000	£31,200
   Health & social work	261,710	6,720	45,190	89,440	16,990	86,110	17,250	100.0%	2.6%	17.3%	34.2%	6.5%	32.9%	6.6%	13.0%	9.0%	10.9%	14.0%	18.4%	13.7%	10.5%	£18,800	£10,900	£13,700	£16,500	£21,500	£25,700	£26,500
   IT	62,890	590	6,470	17,700	2,950	29,540	5,640	100.0%	0.9%	10.3%	28.1%	4.7%	47.0%	9.0%	3.1%	0.8%	1.6%	2.8%	3.2%	4.7%	3.4%	£30,000	£22,700	£23,900	£26,500	£26,000	£33,300	£36,400
   Manufacturing	103,450	6,500	30,820	34,550	6,430	19,390	5,760	100.0%	6.3%	29.8%	33.4%	6.2%	18.7%	5.6%	5.1%	8.7%	7.4%	5.4%	7.0%	3.1%	3.5%	£26,200	£21,000	£23,000	£26,700	£34,400	£29,200	£35,000
   Media	36,590	290	2,170	6,070	1,070	22,640	4,360	100.0%	0.8%	5.9%	16.6%	2.9%	61.9%	11.9%	1.8%	0.4%	0.5%	0.9%	1.2%	3.6%	2.6%	£28,700	£17,100	£20,600	£24,900	£25,100	£30,200	£30,000
   Mining & quarrying	1,830	90	570	610	140	290	130	100.0%	4.9%	31.1%	33.4%	7.7%	15.9%	6.9%	0.1%	0.1%	0.1%	0.1%	0.2%	0.0%	0.1%	£32,300	£27,700	£31,300	£31,800	£42,600	£31,400	£42,000
   Other services	45,670	1,330	9,800	19,290	1,660	11,100	2,500	100.0%	2.9%	21.5%	42.2%	3.6%	24.3%	5.5%	2.3%	1.8%	2.4%	3.0%	1.8%	1.8%	1.5%	£18,400	£13,500	£15,000	£16,600	£18,400	£24,100	£25,300
   Professional services	193,110	2,230	16,190	38,190	8,930	98,380	29,200	100.0%	1.2%	8.4%	19.8%	4.6%	50.9%	15.1%	9.6%	3.0%	3.9%	6.0%	9.7%	15.6%	17.7%	£28,500	£16,900	£19,500	£23,000	£25,800	£31,500	£32,200
   Public admin & defence	81,540	640	11,880	28,290	3,700	28,880	8,150	100.0%	0.8%	14.6%	34.7%	4.5%	35.4%	10.0%	4.0%	0.9%	2.9%	4.4%	4.0%	4.6%	4.9%	£27,300	£19,100	£26,100	£27,100	£26,900	£27,500	£29,800
   Real estate	32,250	580	5,550	12,190	1,490	10,590	1,870	100.0%	1.8%	17.2%	37.8%	4.6%	32.8%	5.8%	1.6%	0.8%	1.3%	1.9%	1.6%	1.7%	1.1%	£24,800	£18,700	£21,300	£23,700	£24,000	£27,600	£32,700
   Support services	165,250	10,900	46,380	51,150	6,440	43,940	6,450	100.0%	6.6%	28.1%	31.0%	3.9%	26.6%	3.9%	8.2%	14.6%	11.1%	8.0%	7.0%	7.0%	3.9%	£20,100	£12,600	£17,000	£20,400	£20,900	£25,200	£24,600
   Transport & storage	75,020	4,730	24,060	27,350	3,370	13,610	1,890	100.0%	6.3%	32.1%	36.5%	4.5%	18.1%	2.5%	3.7%	6.3%	5.8%	4.3%	3.7%	2.2%	1.1%	£25,300	£21,900	£23,700	£25,600	£28,100	£28,200	£34,300
   Water & sewerage	12,520	1,290	4,650	3,750	420	1,930	480	100.0%	10.3%	37.2%	29.9%	3.4%	15.4%	3.8%	0.6%	1.7%	1.1%	0.6%	0.5%	0.3%	0.3%	£25,500	£21,700	£24,800	£25,700	£28,700	£28,000	£31,300
   Whole & retail trade	339,950	18,380	95,870	125,790	13,510	77,020	9,380	100.0%	5.4%	28.2%	37.0%	4.0%	22.7%	2.8%	16.8%	24.6%	23.0%	19.6%	14.6%	12.2%	5.7%	£19,200	£16,000	£17,200	£19,200	£19,400	£23,500	£27,300

   Footnotes

   1. Data are restricted to employees born between September 1988 and August 1993. These employees turned age 25-30 in the 2018-19 tax year.

   Save table

   Related information

   • Release type:
   • Publication: Career pathways: post-16 qualifications held by employees, Tax year 2018-19

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