Scottish Social Services Workforce Data
Mental Health Officers time series data
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 - 2021
- Cover MHOs: 2014 - 2021
- Age and gender of the MHO workforce: 2007 - 2021
- Ethnicity of the MHO workforce: 2008 - 2021
- MHO trainees: 2008/09 - 2021/2022
- MHO leavers: 2009 - 2021
- MHO vacancies & shortfalls: 2006 - 2021
- Proportion of Social Workers who are MHOs: 2014 - 2021
- MHOs by type of Specialist Team: 2005 - 2021
- MHOs in Mental Health Teams: 2005 - 2021
- MHOs in Non-Mental Health Teams: 2005 - 2021
- Exclusive MHO positions: 2006 - 2021
- Filled MHO posts, hours on MHO work and hours on MHO work per 100,000 population by local authority: 2016 to 2021
- 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.
Table | Description | File type | File size (KB) | |
---|---|---|---|---|
All tables 2021 (Excel 365) | .xlsx | 97.0 | Download | |
All tables (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 |
Annex 3 | Filled posts, hours on MHO work and hours on MHO work per 100,000 population by local authority (2016-2021) | .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 |