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.

November 2021

Adults' services time series 2011 to 2021

12 Dec 2022

Adults’ services account for over 68% of the Scottish social service workforce

These tables look at a time series from 2011 to 2021 of the adults' services workforce and show the change over time of the composition of adults’ services.

These tables also  include an overview of the headcount, numbers of services, median number of staff and employer type for all adults’ services’ sub-sectors.


Read more

November 2022

The Adults' services workforce tables - 2021

07 Nov 2022

These tables look in detail at the adults' services workforce in Scotland. They supplement data already published in the Scottish Social Service Sector: Report on 2021 Workforce Data.

Read more

October 2022

Local Authority Post Types 2021

06 Oct 2022

This file allows you to interactively investigate the Local Authority Post Types data. The file presents 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.

Download (XLSX, 66 kb)

Read more

Interactive Social Worker Data Tool 2021

04 Oct 2022

This file allows you to interactively investigate data on practising social workers employed by local authorities. Guidance and background notes are included within the file.

Read more

August 2022

Mental Health Officers time series data

27 Aug 2022

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): 2006 - 2022
  • Cover MHOs: 2014 - 2022
  • Age and gender of the MHO workforce: 2007 - 2022
  • Ethnicity of the MHO workforce: 2008 - 2022
  • MHO trainees: 2008/09 - 2022/2023
  • MHO leavers: 2009 - 2022
  • MHO vacancies & shortfalls: 2006 - 2022

Read more

July 2022

2020 Children's Services Workforce Tables

01 Jul 2022

This file contains The Children’s Services Workforce 2020 Tables. These tables look at the workforce in children’s services in Scotland broken by sub-sector, and focuses in detail on the three sub-sectors which can be split further (day care of children, residential child care, and school care accommodation). It supplements data already published in the Scottish Social Service Sector: Report on 2020 Workforce Data.

Read more