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

Top qualifications by region and industry sector ordered by employee numbers

Latest data
Published
Last updated

Data showing the top qualifications held by employees in each region, sector and subsector group. The qualifications are ordered by the number of employees who hold them and are based on the highest qualification held by employees. 

The data are restricted to qualification in the top 40 by number of employees for each region, sector, subsector and level. If a qualification is not in the top 40, it is still included if at least 100 employees hold it. 

The table only includes qualifications at level 2 or higher that were achieved in post-16 education. Qualifications achieved at school, such as GCSEs, are 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_qual is the proportion of employees in the region, sector and subsector who hold the qualification. 

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


Data set details

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

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_nameregion_codesectorsubsectorlevel_groupsubjectqual_titlequal_rankemployeesmedian_earningspct_qual
201819Tax yearNationalE92000001EnglandAccommodation & foodAccommodationLevel 2Retail and Commercial EnterpriseHospitality and Catering Apprenticeship1420185001.9
201819Tax yearNationalE92000001EnglandAccommodation & foodAccommodationLevel 2Business, Administration, Finance and LawCustomer Service Apprenticeship2200161000.9
201819Tax yearNationalE92000001EnglandAccommodation & foodAccommodationLevel 2Retail and Commercial EnterpriseHospitality Apprenticeship3160154000.7
201819Tax yearNationalE92000001EnglandAccommodation & foodAccommodationLevel 2Retail and Commercial EnterpriseCatering and Professional Chefs Apprenticeship4120190000.5
201819Tax yearNationalE92000001EnglandAccommodation & foodAccommodationLevel 2Retail and Commercial EnterpriseHairdressing Apprenticeship5100108000.4

Variables in this data set

Table showing first 5 of 9 variables
Variable nameVariable description
employeesNumber of employees
level_groupHighest qualification level - Filter by highest qualification level
median_earningsMedian annual earnings
pct_qualProportion of employees by qualification
qual_rankRanking of qualifications in total by employee numbers - Filter by overall qualification ranking within each sector and region group

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