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.

Interactive Social Worker Data Tool 2018

20 Dec 2019

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 2018

19 Dec 2019

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

2018 detailed workforce information

17 Dec 2019

This spreadsheet contains information about the Social Services Workforce collected from services regulated by the Care Inspectorate (via its Annual Returns in December) and from the annual December Local Authority Social Work Services Staffing Return in 2018.

Read more

Mental Health Officer time series data

21 Aug 2019

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

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 2017

26 Oct 2018

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 2017

26 Oct 2018

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