Detailed data

Since March 2012 we have published more detailed workforce data at a local authority level. This data can be downloaded below. Each file comes with its own guidance document explaining what data is available inside it.

Mental Health Officers (MHO) data 2016 - additional tables

07 Nov 2017

These spreadsheets present additional MHO data for 2016 that does not appear in the 2016 MHO report or in the full MHO time series data. Data is provided for 2016 on filled MHO posts and estimated average weekly hours on MHO work by health board, MHOs in Health and Social Care Partnerships (HSCPs), MHOs by contract type and MHOs by employee status. It is hoped the additional data will prove useful to users at local and national level and we welcome feedback on it, directed to This email address is being protected from spambots. You need JavaScript enabled to view it..

Read more

Interactive Social Worker Data Tool 2016

01 Nov 2017

This file allows you to interactively investigate data on practising social workers employed by local authorities. It uses data from our LA Post Types publication and adds in some contextual population data from National Records of Scotland. Guidance and background notes are included within the file.

Read more

Local authority post types 2016

06 Oct 2017

These spreadsheets present headcount and WTE (whole time equivalent) data of all filled posts in local authority social work services where those employed do not work in a registered care service. This therefore covers staff working primarily in field social work services. The data published includes a breakdown of the numbers of different people and posts across the whole of Scotland as well as by individual local authorities.

Read more

Mental Health Officer time series data

29 Aug 2017

This page provides MHO workforce data for the full period for which data is available, as follows:

  • Filled MHO posts, headcount and contracted Whole Time Equivalent (WTE): 2005 - 2016
  • Cover MHOs: 2014 - 2016
  • MHO WTE rates per 100,000 population, 2005 - 2016
  • Age and gender of the MHO workforce: 2007 - 2016
  • Ethnicity of the MHO workforce: 2008 - 2016
  • MHO trainees: 2008/09 - 2016/17
  • MHO leavers: 2009 - 2016
  • MHO vacancies & shortfalls: 2006 - 2016
  • Proportion of Social Workers who are MHOs: 2014 - 2016
  • MHOs by type of Specialist Team: 2005 - 2016
  • MHOs in Mental Health Teams: 2005 - 2016
  • MHOs in Non-Mental Health Teams: 2005 - 2016
  • Exclusive MHO positions: 2006 - 2016
  • MHO work: 2005 - 2015 (MHO work was dropped from the 2016 report)
  • Filled MHO posts, contracted WTE and weekly hours on MHO work by MHO type and team type: 2016
  • Filled MHO posts, full contracted Whole Time Equivalent (WTE) and WTE per 100k population by local authority: 2006 - 2016
  • Filled MHO posts, hours on MHO work and hours on MHO work per 100,000 population by local authority: 2016
  • Filled MHO posts, contracted hours, hours on MHO work and percentage MHO work hours of contracted hours by local authority: 2016

This constitutes all the data on the MHO workforce collected by the Scottish Government from 2005 to March 2012, and subsequently by the SSSC from December 2012 to date.

Read more

Interactive Social Worker Data Tool

22 Dec 2016

This file allows you to interactively investigate data on practising social workers employed by local authorities. It uses data from our LA Post Types publication and adds in some contextual population data from National Records of Scotland. Guidance and background notes are included within the file.

Read more

Local authority post types 2015

02 Sep 2016

These spreadsheets present headcount and WTE (whole time equivalent) data of all filled posts in local authority social work services where those employed do not work in a registered care service. This therefore covers staff working primarily in field social work services. The data published includes a breakdown of the numbers of different people and posts across the whole of Scotland as well as by individual local authorities.

Read more