Data set from Employer Skills Survey

Mayoral Strategic Authorities - core indicators

Latest data
Published
Last updated
Covers vacancies, hard-to-fill vacancies, skill-shortage vacancies, skills gaps and training measures for Mayoral Strategic Authorities.

Data set details

Theme
UK education and training statistics
Publication
Employer Skills Survey
Release type
Number of rows
23
Geographic levels
English devolved area
Indicators
  • Number of sites with at least one vacancy
  • Number of vacancies
  • Percentage of sites with at least one vacancy
  • Vacancy density (vacancies as a proportion of employment)
  • Hard-to-fill vacancy density (HtF vacancies as a share of vacancies)
  • Number of hard-to-fill vacancies
  • Number of sites with at least one hard-to-fill vacancy
  • Percentage of sites with at least one hard-to-fill vacancy
  • Number of sites with at least one skill-shortage vacancy
  • Number of skill-shortage vacancies
  • Percentage of sites with at least one skill-shortage vacancy
  • Skill-shortage vacancy density (SSVs as a share of vacancies)
  • Number of sites with at least one skill gap (i.e. 1+ employee not fully proficient)
  • Number of skill gaps (employees not fully proficient)
  • Percentage of sites with at least one skill gap (i.e. 1+ employee not fully proficient)
  • Skill gap density (the proportion of employees judged not fully proficient)
  • Average number of days training per employee
  • Average number of days training per trainee
  • Number of employees trained in the past 12 months
  • Number of sites arranging or funding online training or e-learning in the past 12 months
  • Number of sites providing basic induction training
  • Number of sites providing extensive induction training
  • Number of sites providing health and safety or first aid training
  • Number of sites providing job specific training
  • Number of sites providing management training
  • Number of sites providing new technology training
  • Number of sites providing supervisory training
  • Number of sites that have funded or arranged any off-the-job training for staff over the past 12 months
  • Number of sites that have funded or arranged any on-the-job training for staff over the past 12 months
  • Number of sites that have funded or arranged any training for staff over the past 12 months
  • Number of sites that have funded or arranged only on-the-job training for staff over the past 12 months
  • Percentage of employees that received any training in the past 12 months
  • Percentage of sites arranging or funding online training or e-learning in the past 12 months
  • Percentage of sites providing basic induction training
  • Percentage of sites providing extensive induction training
  • Percentage of sites providing health and safety or first aid training
  • Percentage of sites providing job specific training
  • Percentage of sites providing management training
  • Percentage of sites providing new technology training
  • Percentage of sites providing supervisory training
  • Percentage of sites that have funded or arranged any off-the-job training for staff over the past 12 months
  • Percentage of sites that have funded or arranged any on-the-job training for staff over the past 12 months
  • Percentage of sites that have funded or arranged any training for staff over the past 12 months
  • Percentage of sites that have funded or arranged only on-the-job training for staff over the past 12 months
  • Total number of training days for employees
  • Unweighted base of sites
  • Unweighted base of sites with vacancies
  • Number of employees
  • Number of sites in population
  • Number of sites in population who have funded or arranged any training for staff over the past 12 months
Time period
2022 to 2024

Data set preview

Table showing first 5 rows, from underlying data
country_namecountry_coderegion_nameregion_codeenglish_devolved_area_nameenglish_devolved_area_codegeographic_levelweight_basehas_trained_basesample_sizesample_size_w_vactime_periodtime_identifierhas_vachas_htfvhas_ssvhas_skillgapvac_sumhtfv_sumssv_sumskillgapsemployeestraineestraining_dayshas_offthejob_traininghas_onthejob_traininghas_onthejob_training_onlyhas_training_in_generalhas_e_learninghas_basic_induction_traininghas_extensive_induction_traininghas_health_safety_traininghas_job_specific_traininghas_supervisory_traininghas_management_traininghas_new_technology_trainingvac_inchtfv_incssv_incskillgap_incoffthejob_training_inconthejob_training_inconthejob_training_only_inctraining_in_general_ince_learning_incbasic_induction_training_incextensive_induction_training_inchealth_safety_training_incjob_specific_training_incsupervisory_training_incmanagement_training_incnew_technology_training_incvac_denhtfv_denssv_denskillgap_dentraining_dentrain_days_employeetrain_days_trainee
EnglandE92000001East of EnglandE12000006Cambridgeshire and PeterboroughE47000008English devolved area27208.999997409316860.21294076139523472022Calendar year6843.630913623084243.940216133772724.229042742614424.051187031622290014900710023600446200276600167500011665.481674259513608.06826803215194.7312665017916860.212940761311152.467848314510205.37379765526308.6047173941312108.673445973414458.04977193865511.641897133184961.61083742097464.9426688239125.152085391872915.597560426836210.012235080311716.259514085239642.873614154765650.013114297944819.091959524408861.965573679174566.146660706474660.529329217323937.417111750364971.818033903352685.752474317716532.690227083717529.427925108974844.27549459222235.1228765641000765.062798608448530.95049256507475.2916075990212161.98581924352543.753224575999176.0549729305888
EnglandE92000001North EastE12000001North EastE47000010English devolved area25926.999998748515731.874040754619485212022Calendar year4948.994840769773093.952638217991966.072192773864437.7493959951118200950058002560041930022960016240009935.436900991812956.12190408975796.437139762815731.874040754610171.37120536529430.648792310765299.8864353259611066.474349844112391.38686148884612.180822190735086.144047766016759.8328039958219.088189304619311.93332293889517.5831071580543917.116324280515738.320811900610949.971542811413422.356759902968360.677571803579264.654542612122759.946124459679533.688843564321770.344285246472178.766120484997329.317427855337132.330185422219742.96902445623434.3380733281724852.244904167072931.96146947391826.116389515327154.75946309818733.873908746101857.07440965802692
EnglandE92000001North EastE12000001North of TyneE47000011English devolved area21946.999997492713375.082294281616464842022Calendar year4643.32084996583056.696921072352016.403535591463388.02896869353168001100073002090036950026800014070008771.4139616666210922.21772745114603.6683326149613375.08229428168860.081624890587976.918884926164731.411148663828988.1361223049710673.38124064513873.297039751984200.437993249865848.2563326556321.156972937058613.927629841999.1876043915880215.437321588739239.966346027560449.766335848630320.976298961775660.942644989336166.243193349760959.640148070988935.374818969799567.200604262059679.800490238541628.959052023238631.404950645019443.72501195866294.5503196548181465.313393238885143.13466879689515.6516666313711572.53360483011943.80756803038895.24938480488677
EnglandE92000001North EastE12000001Tees ValleyE47000006English devolved area15280.99999887559189.1129031468311993802022Calendar year3558.071773975782214.936366312881316.088929125712209.1782291520211800520032001340026050014160011020005881.931172274057640.350900648693307.181730872789189.112903146836283.772810642445895.655870192883319.369426918616487.866065723437615.763823489362889.102764129043182.003084040333955.9041145587823.284286200102214.49470824210388.6125837917843314.457026564456538.491794860983649.999024286440321.642443106577960.134237967561468.382801222200164.159140630146136.122849527530470.603834495293382.87811787448331.440496972669234.627968092008643.04990216415854.519701395820644.563148176996627.18848623289565.1415149169789354.36961971261094.230441117698567.78089149797258
EnglandE92000001North WestE12000002Greater ManchesterE47000001English devolved area77213.999999895148584.380094749920406432022Calendar year17729.34397791539406.783449966867220.9477283395412819.6736104446668004160034700695001314800779000445500033886.140739537339881.802868503614698.239355212648584.380094749933312.555591287732838.580353621818342.411835360935635.311792680942800.881202972519185.344332090718390.917627716822851.818696270922.961307506332212.18274334962539.3518632998541116.602783964646443.886006086439451.650999648454719.035718076038762.921724162478268.566390116167267.59081887960637.753722080202173.347260422350788.09597059693239.4887087057137.85356032504847.03532010021535.0768618910655562.332548234004951.91847031864225.2825971966315559.24960542476383.38807512462765.71830833359698

Variables in this data set

Table showing all 50 variables
Variable nameVariable description
basic_induction_training_incPercentage of sites providing basic induction training
e_learning_incPercentage of sites arranging or funding online training or e-learning in the past 12 months
employeesNumber of employees
extensive_induction_training_incPercentage of sites providing extensive induction training
has_basic_induction_trainingNumber of sites providing basic induction training
has_e_learningNumber of sites arranging or funding online training or e-learning in the past 12 months
has_extensive_induction_trainingNumber of sites providing extensive induction training
has_health_safety_trainingNumber of sites providing health and safety or first aid training
has_htfvNumber of sites with at least one hard-to-fill vacancy
has_job_specific_trainingNumber of sites providing job specific training
has_management_trainingNumber of sites providing management training
has_new_technology_trainingNumber of sites providing new technology training
has_offthejob_trainingNumber of sites that have funded or arranged any off-the-job training for staff over the past 12 months
has_onthejob_trainingNumber of sites that have funded or arranged any on-the-job training for staff over the past 12 months
has_onthejob_training_onlyNumber of sites that have funded or arranged only on-the-job training for staff over the past 12 months
has_skillgapNumber of sites with at least one skill gap (i.e. 1+ employee not fully proficient)
has_ssvNumber of sites with at least one skill-shortage vacancy
has_supervisory_trainingNumber of sites providing supervisory training
has_trained_baseNumber of sites in population who have funded or arranged any training for staff over the past 12 months
has_training_in_generalNumber of sites that have funded or arranged any training for staff over the past 12 months
has_vacNumber of sites with at least one vacancy
health_safety_training_incPercentage of sites providing health and safety or first aid training
htfv_denHard-to-fill vacancy density (HtF vacancies as a share of vacancies)
htfv_incPercentage of sites with at least one hard-to-fill vacancy
htfv_sumNumber of hard-to-fill vacancies
job_specific_training_incPercentage of sites providing job specific training
management_training_incPercentage of sites providing management training
new_technology_training_incPercentage of sites providing new technology training
offthejob_training_incPercentage of sites that have funded or arranged any off-the-job training for staff over the past 12 months
onthejob_training_incPercentage of sites that have funded or arranged any on-the-job training for staff over the past 12 months
onthejob_training_only_incPercentage of sites that have funded or arranged only on-the-job training for staff over the past 12 months
sample_sizeUnweighted base of sites
sample_size_w_vacUnweighted base of sites with vacancies
skillgap_denSkill gap density (the proportion of employees judged not fully proficient)
skillgap_incPercentage of sites with at least one skill gap (i.e. 1+ employee not fully proficient)
skillgapsNumber of skill gaps (employees not fully proficient)
ssv_denSkill-shortage vacancy density (SSVs as a share of vacancies)
ssv_incPercentage of sites with at least one skill-shortage vacancy
ssv_sumNumber of skill-shortage vacancies
supervisory_training_incPercentage of sites providing supervisory training
train_days_employeeAverage number of days training per employee
train_days_traineeAverage number of days training per trainee
traineesNumber of employees trained in the past 12 months
training_daysTotal number of training days for employees
training_denPercentage of employees that received any training in the past 12 months
training_in_general_incPercentage of sites that have funded or arranged any training for staff over the past 12 months
vac_denVacancy density (vacancies as a proportion of employment)
vac_incPercentage of sites with at least one vacancy
vac_sumNumber of vacancies
weight_baseNumber of sites in population

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

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/eb49cfb2-576c-4663-aea4-342a9bad361e/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/eb49cfb2-576c-4663-aea4-342a9bad361e/csv")

Contact us

If you have a specific enquiry about Mayoral Strategic Authorities - core indicators statistics and data:

Skills England Research and Analysis

Email: se.employerskillssurvey@DWP.GOV.UK
Contact name: Victoria Leech