Data set from Career pathways: post-16 qualifications held by employees

Qualification pathways for high earning employees

Latest data
Published
Last updated

This is the underlying data used to create this interactive pathways visualisation in the career pathways dashboard. The pathways visualisation provides a summary of common qualification pathways followed by top earning employees of each industry sector and in each region. 

Top earning employees are those who are in the top third of earners in their region and sector. 

Qualification pathways are constructed from regulated qualifications achieved by employees in post-16 education at level 2 and above. Basic skills qualifications, unregulated provision and qualifications achieved at school, such as GCSEs, are excluded.  AS Levels and smaller qualifications that are taken alongside A Levels or larger level 2 and 3 qualifications as also excluded. 

This file is designed to provide access to the underlying data for this publication rather than for use with the table creator tool.

pct_employees is the proportion of employees for a given qualification who went on to achieve the subsequent qualification.

qual_rank is the ranking of the starting qualification by number of employees, within the region, sector and starting level,

dest_rank is the ranking of the subsequent qualification by number of employees, within the region, sector and starting level.


Data set details

Theme
Further education
Publication
Career pathways: post-16 qualifications held by employees
Release type
Geographic levels
National, Regional
Indicators
  • Level of subsequent qualification
  • Number of employees
  • Proportion of employees by subsequent qualification
Filters
  • destination ranking by number of employees
  • Highest qualification level
  • Industry sector
Time period
2018-19

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_nameregion_codesectorlevel_groupsubjectqual_titlenext_qual_titlenext_level_groupnext_subjectqual_rankdest_rankemployeespct_employees
201819Tax yearRegionalE92000001EnglandEast MidlandsE12000004Accommodation & foodLevel 2Retail and Commercial EnterpriseHospitality and Catering ApprenticeshipDid not progress to a higher level qualificationDid not progress to a higher level qualificationDid not progress to a higher level qualification1126057
201819Tax yearRegionalE92000001EnglandEast MidlandsE12000004Accommodation & foodLevel 2Retail and Commercial EnterpriseHospitality and Catering ApprenticeshipHospitality and Catering ApprenticeshipLevel 3Retail and Commercial Enterprise125010.9
201819Tax yearRegionalE92000001EnglandEast MidlandsE12000004Accommodation & foodLevel 2Retail and Commercial EnterpriseHospitality and Catering ApprenticeshipHospitality ApprenticeshipLevel 3Retail and Commercial Enterprise13407.9
201819Tax yearRegionalE92000001EnglandEast MidlandsE12000004Accommodation & foodLevel 2Retail and Commercial EnterpriseHospitality and Catering ApprenticeshipAward in Supervising Food Safety in CateringLevel 3Retail and Commercial Enterprise14305.7
201819Tax yearRegionalE92000001EnglandEast MidlandsE12000004Accommodation & foodLevel 2Retail and Commercial EnterpriseHospitality and Catering ApprenticeshipDiploma in Shift ManagementLevel 3Retail and Commercial Enterprise15305.7

Variables in this data set

Table showing first 5 of 11 variables
Variable nameVariable description
dest_rankdestination ranking by number of employees - Filter by destination rank
employeesNumber of employees
level_groupHighest qualification level - Filter by highest qualification level
next_level_groupLevel of subsequent qualification
next_qual_titleSubsequent qualification title

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.
  2. Excludes qualifications at below level 2 and qualifications achieved prior to post-16 education (e.g. GCSEs).

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