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.

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

January 2022

Interactive Social Worker Data Tool 2020

20 Jan 2022

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

October 2021

2020 detailed workforce information

28 Oct 2021

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 2020.

Read more

September 2021

The Adults' services workforce tables - 2020

21 Sep 2021

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 2020 Workforce Data.

Read more

Local authority post types 2020

09 Sep 2021

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

August 2021

Mental Health Officers time series data

27 Aug 2021

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 - 2020
  • Cover MHOs: 2014 - 2020
  • MHO WTE rates per 100,000 population, 2005 - 2016 (dropped from the 2017 report) 
  • Age and gender of the MHO workforce: 2007 - 2020
  • Ethnicity of the MHO workforce: 2008 - 2020
  • MHO trainees: 2008/09 - 2019/20
  • MHO leavers: 2009 - 2020
  • MHO vacancies & shortfalls: 2006 - 2020

    Read more