Mental Health Officer time series data

27 Aug 2020

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
  • Proportion of Social Workers who are MHOs: 2014 - 2019 (2020 to be updated after publication of the 2020 Workforce Data Report)
  • MHOs by type of Specialist Team: 2005 - 2020
  • MHOs in Mental Health Teams: 2005 - 2020
  • MHOs in Non-Mental Health Teams: 2005 - 2020
  • Exclusive MHO positions: 2006 - 2020
  • 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 2020
  • 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.

Individual tables are available for download below in Microsoft Excel (.xlsx) and OpenDocument Spreadsheet (.ods) format. In addition, the data tables are available in non-proprietary Comma Separated Values (CSV) format, individually and together in a compressed ZIP file. The provision of the data in these formats is intended to facilitate its analysis and re-use. 

Table  Description File type File size (KB)  
  All tables 2020 (Excel 365)  - Table 9 to be updated after publication of the 2020 Workforce Data Report (WDR) .xlsx 97.0 Download
  All tables (Open Document)  - Table 9 to be updated after publication of the 2020 WDR .ods 80.4 Download
  All tables (compressed CSV files)- To be updated after publication of the 2020 WDR .zip 16.6 Download
1 Filled posts & WTEs. .csv 0.7 Download
2 Cover MHOs .csv 0.2 Download
3 WTE per population 2005 to 2016 .csv 0.4 Download
4 Age & Gender .csv 2.4 Download
5 Ethnicity .csv 0.4 Download
6 Trainees .csv 0.5 Download
7 Leavers .csv 1.1 Download
8 Vacancies & Shortfalls .csv 1.6 Download
9 MHOs in SW posts -to 2019. To be updated with 2020 data after publication of the 2020 WDR. .csv 2.1 Download
10 Type of Specialist Team (MH or Non-MH) .csv 1.4 Download
11 Mental Health Teams .csv 2.7 Download
12 Non-Mental Health Teams .csv 3.7 Download
13 Exclusive MHO positions .csv 3.4 Download
14 MHO work (2005 to 2015) .csv 3.0 Download
Annex 1 Filled posts, WTE and weekly hours on MHO work by MHO type and team type (2016) .csv 1.3 Download
Annex 2  Filled posts, WTE & WTE per population by local authority (2006 to 2016)  .csv 5.8 Download
Annex 3  Filled posts, hours on MHO work and hours on MHO work per 100,000 population by local authority (2016-2020) .csv 1.3 Download
  Definitions of terms .csv 1.1 Download