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 - 2019
  • Cover MHOs: 2014 - 2019
  • MHO WTE rates per 100,000 population, 2005 - 2016 (dropped from the 2017 report) 
  • Age and gender of the MHO workforce: 2007 - 2019
  • Ethnicity of the MHO workforce: 2008 - 2019
  • MHO trainees: 2008/09 - 2018/19
  • MHO leavers: 2009 - 2019
  • MHO vacancies & shortfalls: 2006 - 2019
  • Proportion of Social Workers who are MHOs: 2014 - 2019
  • MHOs by type of Specialist Team: 2005 - 2019
  • MHOs in Mental Health Teams: 2005 - 2019
  • MHOs in Non-Mental Health Teams: 2005 - 2019
  • Exclusive MHO positions: 2006 - 2019
  • 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 2019
  • 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.

Description File type File size (KB)  
All tables 2019 (Excel 365) -  table 8 to be updated after 27/08 .xlsx 97.0 Download
All tables (Open Document) - table 8 to be updated after  27/08 .ods 80.4 Download
All tables (compressed CSV files) -  table 8 to be updated after 27/08 .zip 16.6 Download
Filled posts & WTEs. .csv 0.7 Download
Cover MHOs .csv 0.2 Download
WTE per population 2005 to 2016 .csv 0.4 Download
Age & Gender .csv 2.4 Download
Ethnicity .csv 0.4 Download
Trainees .csv 0.5 Download
Leavers to be updated w/c 17/08/2020 .csv 1.1 Download
Vacancies & Shortfalls .csv 1.6 Download
MHOs in SW posts -  to be updated after publication of 2019 Workforce Data report .csv 2.1 Download
Type of Specialist Team .csv 1.4 Download
Mental Health Teams .csv 2.7 Download
Non-Mental Health Teams .csv 3.7 Download
Exclusive MHO positions .csv 3.4 Download
MHO work (2005 to 2015) .csv 3.0 Download
Filled posts, WTE and weekly hours on MHO work by MHO type and team type (2006 to 2016) .csv 1.3 Download
Filled posts, WTE & WTE per population by local authority (2006 to 2016) .csv 5.8 Download
Filled posts, hours on MHO work and hours on MHO work per 100,000 population by local authority .csv 1.3 Download
Definitions of terms .csv 1.1 Download