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
  • Proportion of Social Workers who are MHOs: 2014 - 2022
  • MHOs by type of Specialist Team: 2005 - 2022
  • MHOs in Mental Health Teams: 2005 - 2022
  • MHOs in Non-Mental Health Teams: 2005 - 2022
  • Exclusive MHO positions: 2006 - 2022
  • Filled MHO posts, hours on MHO work and hours on MHO work per 100,000 population by local authority: 2016 to 2022
  • 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) 
  • MHO WTE rates per 100,000 population, 2005 - 2016 (dropped from the 2017 report) 
  • 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)

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 is shown in the tables below.

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. 

If you have any enquiries about these tables, please contact:

Zara Gall
Tel: 01382 723657
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

 

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