Mental Health Officer time series data

31 Jan 2017

This page provides MHO workforce data for the full period for which data is available, as follows:

  • MHO numbers, full contracted Whole Time Equivalent (WTE) and WTE per 100k population: 2005 - 2015
  • Age and gender of the MHO workforce: 2007 - 2015
  • Ethnicity of the MHO workforce: 2008 - 2015
  • MHO trainees: 2008/09 - 2015/16
  • MHO leavers: 2009 - 2015
  • MHO vacancies and shortfalls: 2006 - 2015
  • MHOs by type of Specialist Team: 2005 - 2015
  • MHOs in Mental Health Teams: 2005 - 2015
  • MHOs in Non-Mental Health Teams: 2005 - 2015
  • Exclusive MHO positions: 2006 - 2015
  • MHO work: 2005 - 2015
  • MHO numbers, full contracted Whole Time Equivalent (WTE) and WTE per 100k population by local authority: 2006 - 2015

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 and charts 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.

DescriptionFile typeFile size (KB) 
All tables and charts (Excel 2010) .xlsx 208.5 Download
All tables and charts (Open Document) .ods 191.1 Download
All tables (compressed CSV files) .zip 11.0 Download
MHOs: Nos & WTEs .csv 0.4 Download
MHOs per population .csv 0.6 Download
MHOs: Age & Gender .csv 2.1 Download
MHOs: Ethnicity .csv 0.4 Download
MHO Trainees .csv 0.4 Download
MHO Leavers .csv 1.0 Download
MHO Vacancies & Shortfalls .csv 1.5 Download
MHOs: Type of Team .csv 0.9 Download
MHOs: Mental Health Teams .csv 1.1 Download
MHOs: Non-Mental Health Teams .csv 2.6 Download
MHOs: Exclusive positions .csv 2.6 Download
MHO work .csv 2.9 Download
MHOs by Local Authority (headcount/WTE/WTE per pop) .csv 5.8 Download