Mental Health Officer time series data

29 Aug 2017

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 - 2016
  • Cover MHOs: 2014 - 2016
  • MHO WTE rates per 100,000 population, 2005 - 2016
  • Age and gender of the MHO workforce: 2007 - 2016
  • Ethnicity of the MHO workforce: 2008 - 2016
  • MHO trainees: 2008/09 - 2016/17
  • MHO leavers: 2009 - 2016
  • MHO vacancies & shortfalls: 2006 - 2016
  • Proportion of Social Workers who are MHOs: 2014 - 2016
  • MHOs by type of Specialist Team: 2005 - 2016
  • MHOs in Mental Health Teams: 2005 - 2016
  • MHOs in Non-Mental Health Teams: 2005 - 2016
  • Exclusive MHO positions: 2006 - 2016
  • 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
  • Filled MHO posts, full contracted Whole Time Equivalent (WTE) and WTE per 100k population by local authority: 2006 - 2016
  • Filled MHO posts, hours on MHO work and hours on MHO work per 100,000 population by local authority: 2016
  • Filled MHO posts, contracted hours, hours on MHO work and percentage MHO work hours of contracted hours by local authority: 2016

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 97.0 Download
All tables and charts (Open Document) .ods 80.4 Download
All tables (compressed CSV files) .zip 16.6 Download
Filled posts & WTEs .csv 0.7 Download
Cover MHOs .csv 0.2 Download
WTE per population .csv 0.4 Download
Age & Gender .csv 2.4 Download
Ethnicity .csv 0.4 Download
Trainees .csv 0.5 Download
Leavers .csv 1.1 Download
Vacancies & Shortfalls .csv 1.6 Download
MHOs in SW posts .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 .csv 3.0 Download
Filled posts, WTE and weekly hours on MHO work by MHO type and team type .csv 1.3 Download
Filled posts, WTE & WTE per population by local authority .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
Filled posts, contracted hours, hours on MHO work and % MHO work hours of contracted hours by local authority .csv 1.5 Download
Definitions of terms .csv 1.1 Download