Scottish Health and Social Care Open Data data dictionary - onetomapanalytics/Meta_Data GitHub Wiki

Scottish Health and Social Care Open Data - Data dictionary

1. Health and Care

Care Home Census

Data from the annual Care Home Census for Adults in Scotland. Data are presented at Scotland and at Local Authority level, and cover the period from 2009/10 to 2021/22, excluding the year 2019/20 when the Care Home Census was cancelled due to the COVID-19 pandemic.

Average Weekly Charges

The average weekly charges for self funders, publicly funded and all funded people, with and without nursing care, of 65 years and above at council area level and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Average Gross Weekly Charge
CA text Council area code (2011 configuration) Council area labels - https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/967937c4-8d67-4f39-974f-fd58c4acfda5
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Only includes 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Pound Sterling (£)
Value numeric The Average Gross Weekly Charge in Pound Sterling
ValueQF text Qualifier for Value indicating missing data
Qualifier information

Number of Long Stay Residents By Length of Stay

The number of long stay residents by length of their stay on council area and Scotland level across all sector types. 'Complete length of stay' is calculated for long stay residents who were discharged from a care home during the census year and whose stay in the home has therefore ended. 'Incomplete length of stay' is calculated for residents who are still living in a care home at the end of the census year (31 March).

Column Type Label Description
DateOrFinancialYear text Format is YYYY/YY or YYYYMMDD. For complete length of stay, format is YYYY/YY as data relate to the whole of the financial year. For ongoing length of stay, format is YYYYMMDD as data relate to a snapshot date 31 March ie the last day of the census financial year.
KeyStatistic text Number of Long Stay Residents by Length of Stay.
CA text Council area code (2011 configuration). Council area labels
CAQF text Qualifier for CA. Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Number.
Value numeric Number of Long Stay Residents by Length of Stay.
ValueQF text Qualifier for Value.
Qualifier information

Percentage of Long Stay Residents by Length of Stay

Column Type Label Description
DateOrFinancialYear text Format is YYYY/YY or YYYYMMDD. For complete length of stay, format is YYYY/YY as data relate to the whole of the financial year. For ongoing length of stay, format is YYYYMMDD as data relate to a snapshot date 31 March ie the last day of the census financial year.
KeyStatistic text Percentage of Long Stay Residents by Length of Stay.
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Percentage
Value numeric Percentage of Long Stay Residents by Length of Stay
ValueQF text Qualifier for Value indicating suppressed data
Qualifier information

Average Age of Residents

The mean and median age of residents, as well as at the time of admission and discharge, across all sectors at council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Mean and Median Age of Long Stay Residents
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Years
Value numeric Mean and Median Age of Long Stay Residents in years
ValueQF text Qualifier for Value Qualifier information

Average Length of Stay

The mean and median length of stay across all sectors at council area and Scotland level in years. 'Complete length of stay' is calculated for long stay residents who were discharged from a care home during the census year and whose stay in the home has therefore ended. 'Incomplete length of stay' is calculated for residents who are still living in a care home at the end of the census year (31 March).

Column Type Label Description
DateOrFinancialYear text Format is YYYY/YY or YYYYMMDD. For complete length of stay, format is YYYY/YY as data relate to the whole of the financial year. For ongoing length of stay, format is YYYYMMDD as data relate to a snapshot date 31 March ie the last day of the census financial year.
KeyStatistic text Mean and median length of Stay by Long Stay Residents
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Years
Value numeric Average length of stay in years.
ValueQF text Qualifier for Value Qualifier information

Admissions, Discharges and Deaths

The number of admissions, discharges and deaths for different clientele groups across all sectors on council are and Scotland level.

Column Type Label Description
Date text Format YYYY/YY. This is the financial year during which the admissions, discharges and deaths occurred.
KeyStatistic text Number of Admissions, Discharges and Deaths by Long Stay Residents.
CA text Council area code (2011 configuration) Council area labels
CAQF text Qualfier for CA Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Adults with Learning Disabilities', 'Adults with Mental Health Problems', 'Adults with Physical Disabilities', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority sector, and Voluntary sector combined together).
Unit text Number
Value numeric Number of Admissions, Discharges and Deaths by Long Stay Residents.
ValueQF text Qualifier for Value indicating suppressed values Qualifier information

Occupancy

The occupancy for various clientele groups across the local authority and NHS sector, the private sector and the voluntary sector on council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Percentage Occupancy
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Adults with Learning Disabilities', 'Adults with Mental Health Problems', 'Adults with Physical Disabilities', 'Older People Aged 65 and Older' and 'Other'.
Sector text The sector in which the care homes are run. Includes Private sector, Local Authority sector, Voluntary sector, and All sectors.
Unit text Percentage
Value numeric Percentage Occupancy
ValueQF text Qualifier for Value Qualifier information

Number of Long Stay Residents By Source of Funding

The number of residents aged 65 and above that are self-funded, funded by the NHS and funded by their local authority on council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Long Stay Residents by Source of Funding.
CA text Council area code (2011 configuration) Council area labels
CAQF text Qualifier for CA Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Only includes 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Number.
Value numeric Number of Long Stay Residents by Source of Funding
ValueQF text Qualifier for Value Qualifier information

Sources of Funding

The percentage of residents aged 65 and above that are self-funded, funded by the NHS and funded by their local authority on council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Percentage of Long Stay Residents by Source of Funding
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Only includes 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority sector, and Voluntary sector combined together).
Unit text Percentage
Value numeric Percentage of Long Stay Residents by Source of Funding
ValueQF text Qualifier for Value Qualifier information

Percentage of Residents by Health Characteristics

The percentage of residents by various health characteristics and those requiring nursing care across all sectors at council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Percentage of Long Stay Residents by Health Characteristic.
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Percentage
Value numeric Percentage of Long Stay Residents by Health Characteristic.
ValueQF text Qualifier for Value indicating suppressed values Qualifier information

Percentage of Residents by Demographic characteristics

The percentage of residents by age and sex across all sectors at council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Percentage of Long Stay Residents by Age Group and Sex.
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Percentage
Value numeric Percentage of Long Stay Residents by Age Group and Sex.
ValueQF text Qualifier for Value indicating suppressed data Qualifier information

Number of Residents by Health Characteristics

The number of residents by various health characteristics and those requiring nursing care across all sectors at Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Residents by Health Characteristics
CA text Council area code (2011 configuration). Council area labels
CAQF text Council area code qualifiers. Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Number
Value numeric Number of Residents by Health Characteristics
ValueQF text Value qualifiers. Qualifier information

Number of Residents by Demographic Characteristics

The number of residents by age and sex across all sectors at Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Long Stay Residents by Age Group and Sex.
CA text Council area code (2011 configuration) Council area labels
CAQF text Council area code qualifiers. Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Learning Disabilities', 'Mental Health Problems', 'Physical and Sensory Impairment', and 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority/Health Board sectors, and Voluntary or Not for Profit sector combined together).
Unit text Number
Value numeric Number of Long Stay Residents by Age Group and Sex.
ValueQF text Qualifier for Value. Qualifier information

Residents by Type of Stay

The number of residents by their type of stay (long/short/respite stay) across local authority and NHS, private and voluntary sector for various clientele groups.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Long Stay, Short Stay and Respite Residents.
CA text Council area code (2011 configuration) Council area labels
CAQF text Qualfier for CA Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Adults with Learning Disabilities', 'Adults with Mental Health Problems', 'Adults with Physical Disabilities', 'Older People Aged 65 and Older' and 'Other Groups'.
MainClientGroupQF text
Sector text The sector in which the care homes are run. Includes Private sector, Local Authority sector, Voluntary sector, and All sectors.
SectorQF text Qualifier for Sector, indicating totals for all sectors Qualifier information
Unit text Number
Value numeric Number of Long Stay and Short Stay and Respite Residents.
ValueQF text Qualifier for Value indicating suppressed values Qualifier information

Number of Care Homes

The number of care homes across various sectors and clientele groups at council area and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Care Homes
CA text Council area code (2011 configuration) Council area labels
CAQF text Qualifier for CA Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Adults with Learning Disabilities', 'Adults with Mental Health Problems', 'Adults with Physical Disabilities', 'Older People Aged 65 and Older' and 'Other Groups'.
MainClientGroupQF text
Sector text The sector in which the care homes are run. Includes Private sector, Local Authority sector, Voluntary sector, and All sectors.
SectorQF text Qualifier for Sector indicating 'All sectors' totals Qualifier information
Unit text Number
Value numeric Number of Care Homes
ValueQF text Qualifier for Value Qualifier information

Registered Care Home Places

The number of registered places in care homes for different clientele groups and across the different sectors on local authority and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Registered Places.
CA text Council area code (2011 configuration) Council area labels
CAQF text Qualfier for CA Qualifier information
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Includes 'All Adults', 'Adults with Learning Disabilities', 'Adults with Mental Health Problems', 'Adults with Physical Disabilities', 'Older People Aged 65 and Older' and 'Other Groups'.
MainClientGroupQF text Qualifier for MainClientGroup Qualifier information
Sector text The sector in which the care homes are run. Includes Private sector, Local Authority sector, Voluntary sector, and All sectors.
SectorQF text Qualifier for Sector indicating 'All sectors' totals Qualifier information
Unit text Number
Value numeric Number of Registered Places
ValueQF text Qualifier for Value Qualifier information

Rate of Care Home Places

The rate of registered places in care homes per 1000 people population for different clientele groups and across the different sectors on local authority and Scotland level.

Column Type Label Description
Date numeric Format YYYYMMDD. This is the last day in the census year (31st March).
KeyStatistic text Number of Registered Places for Older People per 1000 population.
CA text Council area code (2011 configuration) Council area labels
MainClientGroup text This is the group of adults in the care home(s) who make up the majority of all residents. Only includes 'Older People Aged 65 and Older'.
Sector text The sector in which the care homes are run. Only includes 'All Sectors' (i.e. Private sector, Local Authority sector, and Voluntary sector combined together).
Unit text Rate
Value numeric Number of Registered Places for Older People per 1000 population.
ValueQF text

COVID-19

COVID-19 Education Surveillance

This dataset presents information on COVID-19 in children and young people of educational age, education staff and educational settings. This includes: (1) testing and cases among children and young people of educational age, (@) hospital admissions related to COVID-19 among children and young people of educational age, (3) information from contact tracing on cases present in an educational setting in the 7-days before symptom onset, and on cases who work in education or childcare, and (4) information about COVID-19 cases in registered school pupils.

Cases among Children

Information on COVID-19 cases among children and young people in Scotland, broken down by age group.

Column Type Label
WeekEnding numeric Last day of the week during which the individual was tested.
AgeGroup text Age group of the individual.
PatientsPositive numeric Number of individuals tested positive.
Rate numeric Rate per 100,000 population.

Tests among Children

Column Type Label
WeekEnding numeric Last day of the week during which the individual was tested.
AgeGroup text Age group of individual.
TotalTests numeric Total number of tests carried out.
PositiveTests numeric Number of positive tests.
NegativeTests numeric Number of negative tests.
PercentPositive numeric Percentage of all tests that were positive.

Hospital Admissions

Information on the number of children admitted to hospital with a positive COVID-19 test, broken down by age.

Column Type Label Description
WeekEnding numeric Last day of the week during which the individual was admitted.
AgeGroup text Age group of the individual.
AvgNumberAdmissions numeric Mean weekly admissions across a three week period, the last week of which is specified in WeekEnding.
AvgNumberAdmissionsQF text Qualifier for AvgNumberAdmissionsQF. Qualifier information

Contact Tracing in Educational Settings

Information on educational settings that index cases have attended over the previous 7 days. This is based on interviews conducted with cases identified in the Case Management System (CMS) and involves cases recalling where they have been in the 7 days prior to symptom onset (or date of test if asymptomatic).

Please note: Public Health Scotland cannot infer from the figures whether a specific setting indicates where the COVID-19 transmission took place. This is because cases may have attended multiple settings or events within a short space of time. In addition, it is possible that even though a case visited a few settings and events, transmission may have taken place elsewhere.

Therefore, users of the data must exercise caution and cannot make inferences about the rank of settings cases visited. The data presented were analysed using data from the CMS which was designed for contact tracing purposes and not for identifying where transmission took place.

Column Type Label Description
WeekEnding numeric Last day of the reference week.
TotalCases numeric Number of cases recorded in the case management system.
NumberCasesInEducationalSetting numeric Number of cases reporting to have visited an educational setting in the 7 days prior to symptom onset or prior to test date for asymptomatic cases.
PercentCasesInEducationalSetting numeric Percentage of cases who reported having visited an educational setting as a proportion of all cases.

Contact Tracing in Education and Childcare

Information on cases reporting an occupation in the education and childcare sector. The ‘education and childcare’ sector covers a broad range of occupations, and those reporting they are employed will include some students undertaking part-time work alongside their studies.

Column Type Label Description
WeekEnding numeric Last day of the reference week.
TotalCases numeric Number of positive cases aged 18 and above.
NumberCasesInEducation numeric Number of positive cases aged 18 and above stating occupation sector as Education and Childcare. This may include students over 18, as well as staff.
PercentCasesInEducation numeric Percentage of positive cases aged 18 and above stating occupation sector as Education and Childcare.
NumberCasesEmployedInEducation numeric Number of positive cases aged 18 and above, stating they are employed, with occupation sector Education and Childcare. The education and childcare sector covers a broad range of occupations, and may include some students undertaking part-time work alongside their studies.
PercentCasesEmployedInEducation numeric Percentage of positive cases aged 18 and above employed in Education and Childcare.

Contact Tracing - Completeness

Information on the proportion of index cases that have information recorded on their occupation within the contact tracing system.

Column Type Label Description
WeekEnding numeric Last day of the reference week.
TotalCases numeric Number of new cases in the Case Management System (CMS).
IncompleteCases numeric Number of cases with incomplete information on their occupational sector.
PercentCompletedCases numeric Percentage of cases with information on occupational sector completed.

Rates by Age Group

Information on rates of COVID-19 among the population is Scotland, broken down by age group.

Column Type Label Description
WeekEnding numeric Last day of the week during which the individual was tested.
AgeGroup text Age group of the individual.
Rate numeric Rate per 100,000 population.

Cases in registered school pupils

Information about COVID-19 cases in registered school pupils.

Column Type Label Description
TestWeekEnding numeric
Positive text
Number numeric
SchoolType text
Total numeric
Percent numeric

COVID-19 Wider Impacts - Contacts with NHS 24

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection. The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on contacts with NHS 24. Information is shown for patients in different age groups; for males and females; and for people living in areas with different levels of material deprivation. Information is also available at different levels of geographical breakdown such as Health Boards, Health and Social Care partnerships, and Scotland totals.

NHS24 Contacts By Health Board, Age and Sex

Information on the weekly number of completed contacts with NHS 24 in Scotland, as well as the corresponding weekly average number of completed contacts made in 2018-2019. Data is broken down by health board, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which NHS24 was contacted.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex. Qualifier information
CompletedContacts numeric Weekly number of completed contacts with NHS24.
Average20182019 numeric Average weekly number of completed contacts with NHS24 in 2018-2019.
PercentVariation numeric Percentage change in completed contacts with NHS24 compared with the corresponding time in 2018-2019

NHS24 Contacts By Health Board and Deprivation

Information on the weekly number of completed contacts with NHS 24 in Scotland, as well as the corresponding weekly average number of completed contacts made in 2018-2019. Data is broken down by health board and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which NHS24 was contacted.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
CompletedContacts numeric Weekly number of completed contacts with NHS24.
Average20182019 numeric Average weekly number of completed contacts with NHS24 in 2018-2019.
PercentVariation numeric Percentage change in completed contacts with NHS24 compared with the corresponding time in 2018-2019

NHS24 Contacts By HSCP, Age and Sex

Information on the weekly number of completed contacts with NHS 24 in Scotland, as well as the corresponding weekly average number of completed contacts made in 2018-2019. Data is broken down by Health and Social Care partnership, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which NHS24 was contacted.
HSCP text Health and Social Care Partnership (2016) HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex Qualifier information
CompletedContacts numeric Weekly number of completed contacts with NHS24.
Average20182019 numeric Average weekly number of completed contacts with NHS24 in 2018-2019.
PercentVariation numeric Percentage change in completed contacts with NHS24 compared with the corresponding time in 2018-2019

NHS24 Contacts By HSCP and Deprivation

Information on the weekly number of completed contacts with NHS 24 in Scotland, as well as the corresponding weekly average number of completed contacts made in 2018-2019. Data is broken down by Health and Social Care partnership and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which NHS24 was contacted.
HSCP text Health and Social Care Partnership (2016) HSCP labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
CompletedContacts numeric Weekly number of completed contacts with NHS24.
Average20182019 numeric Average weekly number of completed contacts with NHS24 in 2018-2019.
PercentVariation numeric Percentage change in completed contacts with NHS24 compared with the corresponding time in 2018-2019

COVID-19 Wider Impacts - Emergency Department Activity

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection. The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures; and (4) this dataset provides a weekly summary of people attending A&E departments (Emergency Departments and Nurse/GP led minor injury units) in the recent past, along with historical activity for comparison purposes. The recent trend data is shown by age group, sex and broad deprivation category (SIMD). Information is also available at different levels of geographical breakdown such as Health Boards, Health and Social Care partnerships, and Scotland totals.

A&E Activity by Health Board, Age and Sex

Information on the weekly number of A&E attendances in Scotland, as well as the corresponding weekly average number of attendances in 2018-2019. Data is broken down by health board, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A & E.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex. Qualifier information
NumberAttendances numeric Weekly number of A & E attendances.
Average20182019 numeric Average weekly number of A & E attendances in 2018-2019.
PercentVariation numeric Percentage change in A&E attendances compared with the corresponding time in 2018-2019

A&E Activity by Health Board and Deprivation

Information on the weekly number of A&E attendances in Scotland, as well as the corresponding weekly average number of attendances in 2018-2019. Data is broken down by health board and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A & E.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
NumberAttendances numeric Weekly number of A & E attendances.
Average20182019 numeric Average weekly number of A & E attendances in 2018-2019.
PercentVariation numeric Percentage change in A&E attendances compared with the corresponding time in 2018-2019

A&E Activity by HSCP, Age and Sex

Information on the weekly number of A&E attendances in Scotland, as well as the corresponding weekly average number of attendances in 2018-2019. Data is broken down by Health and Social Care partnership, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A & E.
HSCP text Health and Social Care Partnership (2016) of residence HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex Qualifier information
NumberAttendances numeric Weekly number of A & E attendances.
Average20182019 numeric Average weekly number of A & E attendances in 2018-2019.
PercentVariation numeric Percentage change in A&E attendances compared with the corresponding time in 2018-2019

A&E Activity by HSCP and Deprivation

Information on the weekly number of A&E attendances in Scotland, as well as the corresponding weekly average number of attendances in 2018-2019. Data is broken down by Health and Social Care partnership and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A & E.
HSCP text Health and Social Care Partnership (2016) of residence HSCP labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
NumberAttendances numeric Weekly number of A & E attendances.
Average20182019 numeric Average weekly number of A & E attendances in 2018-2019.
PercentVariation numeric Percentage change in A&E attendances compared with the corresponding time in 2018-2019

COVID-19 Wider Impacts - Excess Deaths

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection.

The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) Individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) The health service delaying preventative and non-urgent care such as some screening services and planned surgery; (3) Other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on the number of deaths in Scotland, derived from the National Records of Scotland (NRS) weekly deaths registration data. Data show recent trends in deaths (2020), whether COVID or non-COVID related, and historic trends for comparison (five-year average, 2015-2019). The recent trend data are shown by age group and sex, and the national data are also shown by broad area deprivation category (Scottish Index of Multiple Deprivation, SIMD).

Deaths By Health Board, Age and Sex

Information on the weekly number of deaths from all causes in Scotland as well as the corresponding five-year average (2015-2019). Data are broken down by health board, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the death was registered.
HB text Health Board 2019 Health board labels
HBQF text Qualifier for Health board, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup, indicating aggregated data. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex, indicating aggregated data. Qualifier information
Deaths numeric Weekly number of deaths from all causes.
Average20152019 numeric Average weekly number of deaths in 2015-2019.
PercentVariation numeric Variation in the number of deaths from the 2015-2019 average.
PercentVariationQF text Qualifier for PercentVariation Qualifier information

Deaths By HSCP, Age and Sex

Information on the weekly number of deaths from all causes in Scotland, as well as the corresponding five-year average (2015-2019). Data are broken down by Health and Social Care partnership, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the death was registered.
HSCP text Health and Social Care Partnership (2016) HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup, indicating aggregated data. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex, indicating aggregated data. Qualifier information
Deaths numeric Weekly number of deaths from all causes.
Average20152019 numeric Average weekly number of deaths in 2015-2019.
PercentVariation numeric Variation in the number of deaths from the 2015-2019 average.
PercentVariationQF text Qualifier for PercentVariation Qualifier information

Deaths By Deprivation

Information on the weekly number of deaths from all causes in Scotland, broken down by deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which the death was registered.
Country text Country code for Scotland Country labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2020 (1 = most deprived, 5 = least deprived) SIMD open data
Deaths numeric Weekly number of deaths from all causes.
Average20152019 numeric Average weekly number of deaths in 2015-2019.
PercentVariation numeric Variation in the number of deaths from the 2015-2019 average.

COVID-19 Wider Impacts - Hospital Admissions

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection.

The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; and (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on hospital admissions. Data are shown by age group, sex, broad deprivation category and specialty groups. Information is also available at different levels of geographical breakdown such as Health Boards, Health and Social Care partnerships, and Scotland totals.

Admissions By Health Board, Age and Sex

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by health board, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HB text 9-digit code for health board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup, indicating aggregated data. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex, indicating aggregated data. Qualifier information
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

Admissions By Health Board and Deprivation

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by health board and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HB text 9-digit code for health board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

Admissions By Health Board and Specialty

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by health board and specialty.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HB text 9-digit code for health board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
Specialty text The name of the specialty
SpecialtyQF text Qualifier for Specialty, indicating aggregated data Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

Admissions By HSCP, Age and Sex

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by Health and Social Care partnership, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HSCP text 9-digit code for Health and Social Care Partnerships (2016) of residence HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup, indicating aggregated data. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex, indicating aggregated data. Qualifier information
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

Admissions By HSCP and Deprivation

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by Health and Social Care partnership and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HSCP text 9-digit code for Health and Social Care Partnerships (2016) of residence HSCP labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

Admissions By HSCP and Specialty

Information on the weekly number of hospital admissions in Scotland, as well as the weekly average number of admissions in 2018-2019. Data is broken down by Health and Social Care partnerships and specialty.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient was admitted to hospital.
HSCP text 9-digit code for Health and Social Care Partnerships (2016) of residence HSCP labels
AdmissionType text Type of hospital admission (Emergency, Planned, All).
AdmissionTypeQF text Qualifier for AdmissionType, indicating aggregated data. Qualifier information
Specialty text The name of the specialty
SpecialtyQF text Qualifier for Specialty, indicating aggregated data Qualifier information
NumberAdmissions numeric Weekly number of admissions to hospital.
Average20182019 numeric Average weekly number of admissions to hospital in 2018-2019.
PercentVariation numeric Variation in the number of hospital admissions from the 2018-2019 average.

COVID-19 Wider Impacts - Out of Hours Cases

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection.

The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on Primary Care Out of Hours cases. The Primary Care Out of Hours service provides urgent access to a nurse or doctor, when needed at times outside normal general practice hours, such as evenings, overnight or during the weekend. An appointment to the service is normally arranged following contact with NHS 24. The recent trend data is shown by age group, sex and broad deprivation category (SIMD). Information is also available at different levels of geographical breakdown such as Health Boards, Health and Social Care partnerships, and Scotland totals.

OOH Cases By Health Board, Age and Sex

Information on the weekly number of out of hours cases in Scotland, as well as the corresponding weekly average number of cases in 2018-2019. Data is broken down by health board, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which Out of Hours consultations took place.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex. Qualifier information
Consultations numeric Weekly number of out of hours cases.
Average20182019 numeric Average number of weekly out of hours cases in 2018-2019.
PercentVariation numeric Percentage change in cases compared with the corresponding time in 2018-2019

OOH Cases By Health Board and Deprivation

Information on the weekly number of out of hours cases in Scotland, as well as the corresponding weekly average number of cases in 2018-2019. Data is broken down by health board and deprivation.

Column Type Label Description
WeekEnding numeric Last day of the week during which Out of Hours consultations took place.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
Consultations numeric Weekly number of out of hours cases.
Average20182019 numeric Average number of weekly out of hours cases in 2018-2019.
PercentVariation numeric Percentage change in cases compared with the corresponding time in 2018-2019

OOH Cases By HSCP, Age and Sex

Information on the weekly number of out of hours cases in Scotland, as well as the corresponding weekly average number of cases in 2018-2019. Data are broken down by Health and Social Care partnership, age group and sex.

Column Type Label Description
WeekEnding numeric Last day of the week during which Out of Hours consultations took place.
HSCP text Health and Social Care Partnership (2016) HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex Qualifier information
Consultations numeric Weekly number of out of hours cases.
Average20182019 numeric Average number of weekly out of hours cases in 2018-2019.
PercentVariation numeric Percentage change in cases compared with the corresponding time in 2018-2019

OOH Cases By HSCP and Deprivation

Information on the weekly number of out of hours cases in Scotland, as well as the corresponding weekly average number of cases in 2018-2019. Data are broken down by Health and Social Care partnership and deprivation quintile.

Column Type Label Description
WeekEnding numeric Last day of the week during which Out of Hours consultations took place.
HSCP text Health and Social Care Partnership (2016) HSCP labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
Consultations numeric Weekly number of out of hours cases.
Average20182019 numeric Average number of weekly out of hours cases in 2018-2019.
PercentVariation numeric Percentage change in cases compared with the corresponding time in 2018-2019

COVID-19 Wider Impacts - Scottish Ambulance Services

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection.

The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; and (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on Scottish Ambulance Services. Data are shown by age group, sex and broad deprivation category (SIMD), as well as by different levels of geographical breakdown such as Health Boards, Health and Social Care partnerships, and Scotland totals.

Please note that the source of this data is the Unscheduled Care Datamart and represents a sub-set of the total Scottish Ambulance service activity. Figures include emergencies, where a vehicle arrived at the scene of the incident, and excludes both data from resources which were cleared as ‘dealt with by another vehicle’ and air ambulance data. The figures presented in this dataset relate to incidents concerning both COVID-19 and non-COVID issues.

SAS Incidents By Health Board, Age and Sex

Information on the weekly number of incidents attended by Scottish Ambulance Services, as well as the corresponding average number of incidents in 2018-2019. Data are broken down by health board, age group and sex.

Please note that the source of this data is the Unscheduled Care Datamart and represents a sub-set of the total Scottish Ambulance service activity. Figures include emergencies, where a vehicle arrived at the scene of the incident, and excludes both data from resources which were cleared as ‘dealt with by another vehicle’ and air ambulance data.

Column Type Label Description
WeekEnding numeric Last day of the week for which number of SAS incidents is reported.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex. Qualifier information
SASIncidents numeric Weekly number of incidents where Scottish Ambulance Services were called.
Average20182019 numeric Average number of weekly incidents where Scottish Ambulance Services were called in 2018-2019.
PercentVariation numeric Percentage change in SAS incidents compared with the corresponding time in 2018-2019

SAS Incidents By Health Board and Deprivation

Information on the weekly number of incidents attended by Scottish Ambulance Services, as well as the corresponding average number of incidents in 2018-2019. Data are broken down by health board and deprivation quintile.

Please note that the source of this data is the Unscheduled Care Datamart and represents a sub-set of the total Scottish Ambulance service activity. Figures include emergencies, where a vehicle arrived at the scene of the incident, and excludes both data from resources which were cleared as ‘dealt with by another vehicle’ and air ambulance data.

Column Type Label Description
WeekEnding numeric Last day of the week for which number of SAS incidents is reported.
HB text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
SASIncidents numeric Weekly number of incidents where Scottish Ambulance Services were called.
Average20182019 numeric Average number of weekly incidents where Scottish Ambulance Services were called in 2018-2019.
PercentVariation numeric Percentage change in SAS incidents compared with the corresponding time in 2018-2019

SAS Incidents By HSCP, Age and Sex

Information on the weekly number of incidents attended by Scottish Ambulance Services, as well as the corresponding average number of incidents in 2018-2019. Data are broken down by Health and Social Care partnership, age and sex.

Please note that the source of this data is the Unscheduled Care Datamart and represents a sub-set of the total Scottish Ambulance service activity. Figures include emergencies, where a vehicle arrived at the scene of the incident, and excludes both data from resources which were cleared as ‘dealt with by another vehicle’ and air ambulance data.

Column Type Label Description
WeekEnding numeric Last day of the week for which number of SAS incidents is reported.
HSCP text Health and Social Care Partnership (2016) HSCP labels
AgeGroup text Age group of patient.
AgeGroupQF text Qualifier for AgeGroup Qualifier information
Sex text Sex of patient.
SexQF text Qualifier for Sex Qualifier information
SASIncidents numeric Weekly number of incidents where Scottish Ambulance Services were called.
Average20182019 numeric Average number of weekly incidents where Scottish Ambulance Services were called in 2018-2019.
PercentVariation numeric Percentage change in SAS incidents compared with the corresponding time in 2018-2019

SAS Incidents By HSCP and Deprivation

Information on the weekly number of incidents attended by Scottish Ambulance Services, as well as the corresponding average number of incidents in 2018-2019. Data are broken down by Health and Social Care partnership and deprivation quintile.

Please note that the source of this data is the Unscheduled Care Datamart and represents a sub-set of the total Scottish Ambulance service activity. Figures include emergencies, where a vehicle arrived at the scene of the incident, and excludes both data from resources which were cleared as ‘dealt with by another vehicle’ and air ambulance data.

Column Type Label Description
WeekEnding numeric Last day of the week for which number of SAS incidents is reported.
HSCP text Health and Social Care Partnership (2016) HSCP labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile 2016 (1 = most deprived, 5 = least deprived) SIMD open data
SASIncidents numeric Weekly number of incidents where Scottish Ambulance Services were called.
Average20182019 numeric Average number of weekly incidents where Scottish Ambulance Services were called in 2018-2019.
PercentVariation numeric Percentage change in SAS incidents compared with the corresponding time in 2018-2019

COVID-19 Wider Impacts - Antenatal Bookings

As an essential service, maternity care including ‘booking’ has been provided throughout the COVID-19 pandemic, and women have been encouraged to attend all their scheduled antenatal appointments. However, how some elements of maternity care are delivered has changed in order to minimise the number of visits women need to make. The ‘booking’ appointment is the first main appointment a woman has with her local maternity service once she knows she is pregnant. At the booking appointment, women are assessed by a midwife who can then tailor the subsequent care they receive during their pregnancy to their particular preferences and needs. Women are encouraged to book before they are 13 weeks pregnant, and ideally before they are 10 weeks pregnant.

In general, prior to COVID-19, women were offered an initial in-person booking appointment (including various face to face tests such as blood tests and blood pressure monitoring) then a follow up appointment for their early pregnancy ultrasound scan. Since March 2020, in many areas women have been offered an initial remote consultation, then an in-person ‘one stop’ follow up appointment for all their face to face tests and their scan.

This dataset shows the number of women booking for antenatal care in each week from the week beginning 1 April 2019 onwards. In addition to the weekly data, monthly data (based on exact month of booking rather than summation of sequential weeks) is presented for each NHS Board of residence, including the Island Boards. Due to small numbers, weekly data is not shown for individual Island Boards of residence (NHS Orkney, NHS Shetland, and NHS Western Isles), however the Island Boards are included in the Scotland total.

Antenatal bookings by Health Board

Information on women booking for antenatal care, broken down by health board.

Column Type Label Description
HB text 9-digit code for health board of residence, based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB Qualifier information
WeekBeginning numeric First day of the reference week.
NumberWomenBooking numeric Number of women booking for antenatal care.
NumberGestation10to12Wks numeric Number of women booking for antenatal care at 10 to 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationOver12Wks numeric Number of women booking for antenatal care at over 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationUnder10Wks numeric Number of women booking for antenatal care at under 10 weeks gestation, based on completed weeks of pregnancy.

Antenatal bookings by Age

Information on antenatal bookings broken down by age.

Column Type Label Description
Country text 9-digit country code for Scotland.
WeekBeginning numeric First day of the reference week.
AgeGroup text Age group of the individual.
NumberWomenBooking numeric Number of women booking for antenatal care.
NumberGestation10to12Wks numeric Number of women booking for antenatal care at 10 to 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationOver12Wks numeric Number of women booking for antenatal care at over 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationUnder10Wks numeric Number of women booking for antenatal care at under 10 weeks gestation, based on completed weeks of pregnancy.

Antenatal bookings by Deprivation

Information on antenatal bookings broken down by deprivation category.

Column Type Label Description
Country text 9-digit country code for Scotland.
WeekBeginning numeric First day of the reference week.
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile (1 = least deprived, 5 = most deprived) SIMD open data
NumberWomenBooking numeric Number of women booking for antenatal care.
NumberGestation10to12Wks numeric Number of women booking for antenatal care at 10 to 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationOver12Wks numeric Number of women booking for antenatal care at over 12 weeks gestation, based on completed weeks of pregnancy.
NumberGestationUnder10Wks numeric Number of women booking for antenatal care at under 10 weeks gestation, based on completed weeks of pregnancy.

COVID-19 Wider Impacts - Cardiovascular Activity

Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection. The COVID-19 pandemic has wider impacts on individuals’ health, and their use of healthcare services, than those that occur as the direct result of infection. Reasons for this may include: (1) individuals being reluctant to use health services because they do not want to burden the NHS or are anxious about the risk of infection; (2) the health service delaying preventative and non-urgent care such as some screening services and planned surgery; and (3) other indirect effects of interventions to control COVID-19, such as mental or physical consequences of distancing measures.

This dataset provides information on trend data regarding the wider impact of the pandemic on cardiovascular attendances in A&E departments. Data is available from the beginning of 2020 along with historical activity (average from 2018 and 2019) for comparison purposes. The recent trend data for Accident & Emergency Department attendances are shown by age group, and by broad area deprivation category (Scottish Index of Multiple Deprivation, SIMD).

A&E Cardiovascular Activity By Age

Information on cardiovascular attendances in Accident and Emergency Departments in Scotland, broken down by age group.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A&E.
Country text 9-digit country code for Scotland Country labels
AgeGroup text Age group of patient.
CardioAdmissions numeric The weekly number of A&E attendances with cardiovascular problems.
Average20182019 numeric Average weekly number of cardiovascular attendances in 2018-2019.
PercentVariation numeric Variation in the number of cardiovascular attendances from the 2018-2019 average.

A&E Cardiovascular Activity By Deprivation

Information on cardiovascular attendances in Accident and Emergency Departments in Scotland, broken down by deprivation category.

Column Type Label Description
WeekEnding numeric Last day of the week during which the patient attended A&E.
Country text 9-digit country code for Scotland Country labels
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile (1 = most deprived, 5 = least deprived) SIMD open data
CardioAdmissions numeric The weekly number of A&E attendances with cardiovascular problems.
Average20182019 numeric Average weekly number of cardiovascular attendances in 2018-2019.
PercentVariation numeric Variation in the number of cardiovascular attendances from the 2018-2019 average.

COVID-19 Wider Impacts - Gestation at Delivery

Care for women and babies around the time they are giving birth/being born is an essential, time critical service that cannot be deferred. As such, it has been provided throughout the COVID-19 pandemic, and maternity and neonatal staff have not been redeployed to support other services. The way that some elements of this care are provided has changed in response to COVID-19 however, to minimise the risk of infection and to allow services to continue to provide safe care during times when a high number of staff may be off work, for example due to needing to isolate. Relevant guidance has been issued by the Scottish Government, the Royal College of Obstetricians and Gynaecologists, and the British Association for Perinatal Medicine.

‘Gestation at delivery’ refers to the number of completed weeks pregnant a woman is when she delivers her baby. Babies are ‘due’ at 40 completed weeks gestation. Those born between 37 and 41 weeks inclusive are considered to be born ‘at term’. Babies born at under 37 weeks (more than three weeks before their due date) are considered preterm or premature, with those born at under 32 weeks considered very preterm and those born at 32 to 36 weeks inclusive considered moderately preterm. Babies born at or over 42 weeks (more than two weeks after their due date) are considered post-term or over-due. Babies born preterm are at increased risk of both short and long term health and developmental problems, with the risk increasing the earlier a baby is born. Babies are also at increased risk when pregnancies extend post-term, in particular the risk of stillbirth increases from 42 weeks gestation onwards.

This dataset presents information on gestation at delivery. Data is shown at Scotland and NHS Board level, as well as broken down by age group and deprivation.

Gestation Data by Health Board

Information on gestation at delivery for births in Scotland, broken down by health board.

Column Type Label Description
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB Qualifier information
Month numeric Month based on the date the woman was discharged from hospital after delivery.
AllBirths numeric Number of all singleton live births.
Gestation32to36Wks numeric Number of singleton live births delivered at 32 to 36 weeks gestation.
Gestation37to41Wks numeric Number of singleton live births delivered at 37 to 41 weeks gestation.
Gestation42WksOrOver numeric Number of singleton live births delivered at or over 42 weeks gestation.
GestationUnder32Wks numeric Number of singleton live births delivered at under 32 weeks gestation.
GestationUnder37Wks numeric Number of singleton live births delivered at under 37 weeks gestation.
Gestation18to44Wks numeric Number of singleton live births delivered at 18 to 44 weeks gestation.
GestationUnknown numeric Number of singleton live births where gestation at delivery is unknown.
Percent32to36Wks numeric Percentage of singleton live births delivered at 32 to 36 weeks gestation.
Percent37to41Wks numeric Percentage of singleton live births delivered at 37 to 41 weeks gestation.
Percent42WksOrOver numeric Percentage of singleton live births delivered at or over 42 weeks gestation.
PercentUnder32Wks numeric Percentage of singleton live births delivered at under 32 weeks gestation.
PercentUnder37Wks numeric Percentage of singleton live births delivered at under 37 weeks gestation.

Gestation Data by Age

Information on gestation at delivery for births in Scotland, broken down by age.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month based on the date the woman was discharged from hospital after delivery.
AgeGroup text Age group of woman.
AllBirths numeric Number of all singleton live births.
Gestation32to36Wks numeric Number of singleton live births delivered at 32 to 36 weeks gestation.
Gestation37to41Wks numeric Number of singleton live births delivered at 37 to 41 weeks gestation.
Gestation42WksOrOver numeric Number of singleton live births delivered at or over 42 weeks gestation.
GestationUnder32Wks numeric Number of singleton live births delivered at under 32 weeks gestation.
GestationUnder37Wks numeric Number of singleton live births delivered at under 37 weeks gestation.
Gestation18to44Wks numeric Number of singleton live births delivered at 18 to 44 weeks gestation.
GestationUnknown numeric Number of singleton live births where gestation at delivery is unknown.
Percent32to36Wks numeric Percentage of singleton live births delivered at 32 to 36 weeks gestation.
Percent37to41Wks numeric Percentage of singleton live births delivered at 37 to 41 weeks gestation.
Percent42WksOrOver numeric Percentage of singleton live births delivered at or over 42 weeks gestation.
PercentUnder32Wks numeric Percentage of singleton live births delivered at under 32 weeks gestation.
PercentUnder37Wks numeric Percentage of singleton live births delivered at under 37 weeks gestation.

Gestation Data by Deprivation

Information on gestation at delivery for births in Scotland, broken down by deprivation category.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month based on the date the woman was discharged from hospital after delivery.
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile (1 = most deprived, 5 = least deprived) SIMD open data
AllBirths numeric Number of all singleton live births.
Gestation32to36Wks numeric Number of singleton live births delivered at 32 to 36 weeks gestation.
Gestation37to41Wks numeric Number of singleton live births delivered at 37 to 41 weeks gestation.
Gestation42WksOrOver numeric Number of singleton live births delivered at or over 42 weeks gestation.
GestationUnder32Wks numeric Number of singleton live births delivered at under 32 weeks gestation.
GestationUnder37Wks numeric Number of singleton live births delivered at under 37 weeks gestation.
Gestation18to44Wks numeric Number of singleton live births delivered at 18 to 44 weeks gestation.
GestationUnknown numeric Number of singleton live births where gestation at delivery is unknown.
Percent32to36Wks numeric Percentage of singleton live births delivered at 32 to 36 weeks gestation.
Percent37to41Wks numeric Percentage of singleton live births delivered at 37 to 41 weeks gestation.
Percent42WksOrOver numeric Percentage of singleton live births delivered at or over 42 weeks gestation.
PercentUnder32Wks numeric Percentage of singleton live births delivered at under 32 weeks gestation.
PercentUnder37Wks numeric Percentage of singleton live births delivered at under 37 weeks gestation.

COVID-19 Wider Impacts - Induction of Labour

Care for women around the time they are giving birth is an essential, time critical service that cannot be deferred. As such, it has been provided throughout the COVID-19 pandemic, and maternity staff have not been redeployed to support other services. The way that some elements of this care are provided has changed in response to COVID-19 however, to minimise the risk of infection and to allow services to continue to provide safe care during times when a high number of staff may be off work, for example due to needing to isolate.

Guidance issued by the Scottish Government and Royal College of Obstetricians and Gynaecologists to maternity services at the height of the first wave of the pandemic noted that: (1) it may be necessary for services to temporarily suspend the option for women to deliver at home or in midwife led units, and to concentrate delivery care within obstetric units; (2) additional restrictions on the use of water births were recommended; (3) care pathways for women requiring induction of labour should be amended to ensure the early stages of the induction process were delivered on an outpatient basis wherever possible; (4) services should consider deferring a planned induction of labour or elective caesarean section if a woman was isolating due to having COVID-19, or having been in contact with a case, if it was safe to do so; (5) services should support low risk women in the early latent phase of labour to remain at home wherever possible; and (6) in general, strict restrictions on visitors for patients in hospital were advised, however women giving birth could still be accompanied by their chosen birth partner

'Induction of labour' is when a woman is given a medical intervention to start her labour rather than waiting for labour to start spontaneously. It is offered because there are medical reasons meaning it is considered safer (for the mother or baby) for the baby to be born, or because a woman is past her ‘due date’. There are different approaches to inducing labour, for example using medicines, a medical ‘balloon’ device that sits at the neck of the womb, and/or breaking the woman’s waters.

This dataset shows information on induction of labour, presented at Scotland and NHS Board level. Scotland level data is also available by age group and deprivation category. The information on induction of labour presented in this dataset is taken from hospital discharge records, specifically records relating to the care of women delivering a singleton live birth (i.e. one baby, not twins or more) at 37-42 weeks gestation (i.e. up to 3 weeks before or after their due date).

Inductions by Health Board

Information on induction of labour by health board.

Column Type Label Description
HB text 9-digit code for health board of residence, based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB Qualifier information
Month numeric Month based on the date the woman was discharged from hospital after delivery.
SingletonLiveBirths37to42Wks numeric Number of singleton live births at 37 to 42 weeks gestation inclusive.
NumberInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
NumberNotInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
NumberInductionUnknown numeric Number of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.
PercentInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
PercentNotInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
PercentUnknown numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.

Inductions by Age and Sex

Information on induction of labour by age.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month based on the date the woman was discharged from hospital after delivery.
AgeGroup text Age group of the woman.
SingletonLiveBirths37to42Wks numeric Number of singleton live births at 37 to 42 weeks gestation inclusive.
NumberInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
NumberNotInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
NumberInductionUnknown numeric Number of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.
PercentInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
PercentNotInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
PercentUnknown numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.

Inductions by Deprivation

Information on induction of labour by deprivation category.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month based on the date the woman was discharged from hospital after delivery.
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile (1 = most deprived, 5 = least deprived) SIMD open data
SingletonLiveBirths37to42Wks numeric Number of singleton live births at 37 to 42 weeks gestation inclusive.
NumberInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
NumberNotInduced numeric Number of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
NumberInductionUnknown numeric Number of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.
PercentInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that followed induction.
PercentNotInduced numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive that were not induced.
PercentUnknown numeric Percentage of singleton live births at 37 to 42 weeks gestation inclusive where induction is unknown.

COVID-19 Wider Impacts - Termination of Pregnancy

As an essential service, care relating to termination of pregnancy has been provided throughout the COVID-19 pandemic. Termination of pregnancy can be carried out as a medical procedure or, less commonly, a surgical procedure. Medical terminations involve the woman taking two different medicines 24-48 hours apart to end her pregnancy. Prior to October 2017, women having a medical termination were required to attend a clinic or hospital on two occasions to take the first and then, separately, the second medicine. From October 2017, women requiring an early medical termination (at up to 9 weeks and 6 days gestation) were able to take the second medicine away with them at the end of their first appointment, and subsequently take that at home. From 31 March 2020, in response to the COVID-19 pandemic, women requiring an early medical termination (at up to 11 weeks and 6 days gestation) have been able to have an initial remote consultation, by telephone or video call, then take both medicines at home.

Termination of pregnancy (also referred to as a therapeutic or induced abortion) is provided under the terms of the Abortion Act 1967 and subsequent regulations. When a healthcare practitioner provides a termination of pregnancy, there is a legal requirement for them to notify the Chief Medical Officer of the termination within seven days of it taking place. Public Health Scotland is responsible for the collation of data derived from notifications of terminations of pregnancy on behalf of the Chief Medical Officer. Detailed information on terminations is published each year by Public Health Scotland. The most recent report covers the year to December 2019.

This dataset presents information on the number of terminations of pregnancy carried out in Scotland, and the average gestation (stage of pregnancy) at which they occurred. Data is shown at Scotland and NHS Board level, as well as broken down by age group and deprivation.

Terminations by Health Board

Information on terminations of pregnancy in Scotland, broken down by health board.

Column Type Label Description
HB text 9-digit code for health board of residence, based on boundaries as at 1st April 2019 Health board labels
HBQF text Qualifier for HB Qualifier information
Month numeric Month during which termination occurred.
AverageGestation numeric Average gestation at termination based on completed weeks of pregnancy.
NumberTerminations numeric Number of terminations of pregnancy.
NumberGestation10to12Wks numeric Number of terminations of pregnancy at 10 to 12 weeks gestation.
NumberGestation10to12WksQF text Qualifier for NumberGestation10to12Wks
NumberGestationOver12Wks numeric Number of terminations of pregnancy at over 12 weeks gestation.
NumberGestationOver12WksQF text Qualifier for NumberGestationOver12Wks
NumberGestationUnder10Wks numeric Number of terminations of pregnancy at under 10 weeks gestation.
NumberGestationUnder10WksQF text Qualifier for NumberGestationUnder10Wks

Terminations by Age

Information on terminations of pregnancy in Scotland, broken down by age.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month during which termination occurred.
AgeGroup text Age group of the individual.
AverageGestation numeric Average gestation at termination based on completed weeks of pregnancy.
NumberTerminations numeric Number of terminations of pregnancy.

Terminations by Deprivation

Information on terminations of pregnancy in Scotland, broken down by deprivation category.

Column Type Label Description
Country text 9-digit country code for Scotland.
Month numeric Month during which termination occurred.
SIMDQuintile numeric Scottish Index of Multiple Deprivation Quintile (1 = most deprived, 5 = least deprived). SIMD open data
AverageGestation numeric Average gestation at termination based on completed weeks of pregnancy.
NumberTerminations numeric Number of terminations of pregnancy.

Emergency care

NHS Scotland Accident & Emergency Sites

This reference dataset provides a listing of all NHS Emergency Departments, Minor Injury Units and other GP or nurse led departments that carry out Emergency Department related activity across Scotland.

Accident & Emergency Sites

A listing of all NHS Emergency Departments, Minor Injury Units and other GP or nurse led departments that carry out Emergency Department related activity across Scotland.

Column Type Label Description
HB text Health Board 2019 Code Health board labels
TreatmentLocationName text Name of Emergency Department site
TreatmentLocationCode text A unique referencing code identifying a NHS Hospital Current NHS hospitals in Scotland
CurrentDepartmentType text Reference identifying hospitals as either an Emergency Department or a Minor Injuries Unit/Other.
FileType text Sites submit data as either an "Episode file" (a detailed record for each attendance) or an "Aggregate file" (monthly summary attendance figures only)
Comments text Details of location, if it has closed/re-opened or had a change of file type or department type.
Status text If the emergency is open or closed down.

Unintentional Injuries

Summary of admissions to hospital and deaths in Scotland from unintentional injuries and assaults.

Admissions

Information on emergency hospital admissions as a result of unintentional injuries and assaults.

Column Type Label Description
FinancialYear text The financial year (1st April to 31st March) the data refers to, as YYYY/YY.
HBR text 9-digit code for health board of residence 2019, 9-digit country code for Scotland. Health board labels Country labels
HBRQF text Qualifier for HBR.
CA text 9-digit code for council area 2019, 9-digit country code for Scotland. Council area labels Country labels
CAQF text Qualifier for CA.
AgeGroup text Refers to the patient's age. Ages have been arranged in seven different groups.
AgeGroupQF text Qualifier for AgeGroup.
Sex text The patient's sex.
SexQF text Qualifier for Sex.
InjuryLocation text The place the injury occurred: Home; Other; Unknown; Not applicable. Where place of injury occurred is not recorded and the admission is not due to a road traffic accident the place of occurrence is classified as 'Not applicable'.
InjuryLocationQF text Qualifier for InjuryLocation.
InjuryType text The injury type of the patient: All (aggregates all injury types); Land transport accidents; Poisoning; Falls; Struck by, against; Crushing; Scalds; Accidental exposure; Other.
InjuryTypeQF text Qualifier for InjuryType.
NumberOfAdmissions numeric The total number of admissions.

Deaths

Information on deaths as a result of an unintentional injury.

Column Type Label Description
Year numeric The calendar year (1st January to 31st December) the data refers to, as YYYY.
HBR text 9-digit code for health board of residence 2019, 9-digit country code for Scotland. Health board labels Country labels
HBRQF text Qualifier for HBR.
CA text 9-digit code for council area 2019, 9-digit country code for Scotland. Council area labels Country labels
CAQF text Qualifier for CA.
AgeGroup text Refers to the patient's age. Ages have been arranged in seven different groups.
AgeGroupQF text Qualifier for AgeGroup.
Sex text The patient's sex.
SexQF text Qualifier for Sex.
InjuryLocation text The place the injury occurred: Home; Other; Unknown; Not applicable. Where place of injury occurred is not recorded and the death does not result from a land transport accident the place of occurrence is classified as 'Not applicable'. The code for 'Home' is used for any non-institutional place of residence, whether or not the deceased lived there (i.e. it is not necessarily the person's own home).
InjuryLocationQF text Qualifier for InjuryLocation.
InjuryType text The injury type of the patient: All (aggregates all injury types); Land transport accidents; Poisoning; Falls; Struck by, against; Crushing; Scalds; Accidental exposure; Other.
InjuryTypeQF text Qualifier for InjuryType.
NumberofDeaths numeric

Hospital activity

Alcohol Related Hospital Statistics Scotland

Alcohol-related hospital statistics (ARHS) provide an annual update to figures on the alcohol-related inpatient and day case activity taking place within general acute hospitals and psychiatric hospitals in Scotland.

ARHS by Age & Gender

Data on alcohol related hospital statistics by Gender (Male/Female/All) and Age (Age-group (5-yr)/All). Publication Date 17 November 2020.

Column Type Label Description
Condition text Alcohol-related diagnoses. Alcohol misuse is recorded using the International Classification of Diseases. A list of alcohol codes used in this publication is uploaded as a separate file ("ICD Codes")
ICD10 text ICD-10 code of the condition. Custom groupings do not have an ICD-10 code. ICD-10 codes and information
ICD10QF text Qualifier for ICD-10 codes Qualifier information
SMRType text These statistics are derived from data collected on alcohol-related inpatient and day case activity taking place within general acute hospitals and psychiatric hospitals in Scotland, submitted to ISD as part of the Scottish Morbidity Record 01 (SMR01) and Scottish Morbidity Record 04 (SMR04) data sets.
FinancialYear text Data is recorded for financial years (1st April to 31st March)
Gender text The gender of the patient
GenderQF text Qualifier for Gender, indicating totals Qualifier information
AgeGroup text The age group of the patient in 5 year age brackets
AgeGroupQF text Qualifier for AgeGroup, indicating totals Qualifier information
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays
EASRPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfPatients
EASRNewPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfNewPatients
EASRNewPatientsQF text Qualifier for EASRNewPatients
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available. Therefore a ‘stay’ and a ‘discharge’ are equivalent in this report.
NumberOfStaysQF text Qualifier for NumberOfStays Qualifier information
NumberOfPatients numeric The number of unique individuals treated within the financial year. Patients are counted only once in the financial year in which they have an alcohol-related stay, even though the same patient may be admitted to hospital several times in a year.
NumberOfPatientsQF text Qualifier for NumberOfPatients Qualifier information
NumberOfNewPatients numeric The number of new patients. These are defined as patients who have not been previously admitted to hospital with an alcohol diagnosis within the last 10 years. If a patient has several alcohol-related stays over a number of years, this patient will be counted only in the year of the first alcohol-related hospital stay within a 10 year period.
NumberOfNewPatientsQF text Qualifier for NumberOfNewPatients Qualifier information
AverageNumberOfStaysPerPatient numeric The average number of stays per patient

ARHS by Deprivation

Data on alcohol related hospital statistics by Deprivation (SIMD deciles).

Column Type Label Description
Condition text Alcohol-related diagnoses. Alcohol misuse is recorded using the International Classification of Diseases. A list of alcohol codes used in this publication is uploaded as a separate file ("ICD Codes")
ICD10 text ICD-10 code of the condition. Custom groupings do not have an ICD-10 code ICD-10 codes and information
ICD10QF text Qualifier for ICD-10 codes Qualifier information
SMRType text These statistics are derived from data collected on alcohol-related inpatient and day case activity taking place within general acute hospitals and psychiatric hospitals in Scotland, submitted to ISD as part of the Scottish Morbidity Record 01 (SMR01) and Scottish Morbidity Record 04 (SMR04) data sets.
FinancialYear text Data is recorded for financial years (1st April to 31st March)
SIMDVersion text The Version Scottish Index of Multiple Deprivation Version (population weighted) used SIMD open data
SIMDDecile numeric The SIMD decile: 1=most deprived; 10=least deprived
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays
EASRPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfPatients
EASRNewPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfNewPatients
EASRNewPatientsQF text Qualifier for EASRNewPatients Qualifier information
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available. Therefore a ‘stay’ and a ‘discharge’ are equivalent in this report.
NumberOfPatients numeric The number of unique individuals treated within the financial year. Patients are counted only once in the financial year in which they have an alcohol-related stay, even though the same patient may be admitted to hospital several times in a year.
NumberOfNewPatients numeric The number of new patients. These are defined as patients who have not been previously admitted to hospital with an alcohol diagnosis within the last 10 years. If a patient has several alcohol-related stays over a number of years, this patient will be counted only in the year of the first alcohol-related hospital stay within a 10 year period.
NumberOfNewPatientsQF text Qualifier for NumberOfNewPatients Qualifier information
AverageNumberOfStaysPerPatient numeric The average number of stays per patient

ARHS by Council Area

Data on alcohol related hospital statistics by Council Areas. The Scotland total is also included in the file.

Column Type Label Description
Condition text Alcohol-related diagnoses. Alcohol misuse is recorded using the International Classification of Diseases. A list of alcohol codes used in this publication is uploaded as a separate file ("ICD Codes")
ICD10 text ICD-10 code of the condition. Custom groupings do not have an ICD-10 code ICD-10 codes and information
ICD10QF text Qualifier for ICD-10 codes Qualifier information
SMRType text These statistics are derived from data collected on alcohol-related inpatient and day case activity taking place within general acute hospitals and psychiatric hospitals in Scotland, submitted to ISD as part of the Scottish Morbidity Record 01 (SMR01) and Scottish Morbidity Record 04 (SMR04) data sets.
FinancialYear text Data is recorded for financial years (1st April to 31st March)
CA text 9-digit code referring to Council Area, based on boundaries as at 1st April 2011. The Scotland total is also included. Council Area labels
CAQF text Qualifier for CA Qualifier information
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays
EASRPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfPatients
EASRNewPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfNewPatients
EASRNewPatientsQF text Qualifier for EASRNewPatients Qualifier information
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available. Therefore a ‘stay’ and a ‘discharge’ are equivalent in this report.
NumberOfStaysQF text Qualifier for NumberOfStays Qualifier information
NumberOfPatients numeric The number of unique individuals treated within the financial year. Patients are counted only once in the financial year in which they have an alcohol-related stay, even though the same patient may be admitted to hospital several times in a year.
NumberOfPatientsQF text Qualifier for NumberOfPatients Qualifier information
NumberOfNewPatients numeric The number of new patients. These are defined as patients who have not been previously admitted to hospital with an alcohol diagnosis within the last 10 years. If a patient has several alcohol-related stays over a number of years, this patient will be counted only in the year of the first alcohol-related hospital stay within a 10 year period.
NumberOfNewPatientsQF text Qualifier for NumberOfNewPatients Qualifier information
AverageNumberOfStaysPerPatient numeric The average number of stays per patient

ARHS by Health Boards

Data on alcohol related hospital statistics by Health Board of Residence. The Scotland total is also included in the file.

Column Type Label Description
Condition text Alcohol-related diagnoses. Alcohol misuse is recorded using the International Classification of Diseases. A list of alcohol codes used in this publication is uploaded as a separate file ("ICD Codes")
ICD10 text ICD-10 code of the condition. Custom groupings do not have an ICD-10 code ICD-10 codes and information
ICD10QF text Qualifier for ICD-10 codes Qualifier information
SMRType text These statistics are derived from data collected on alcohol-related inpatient and day case activity taking place within general acute hospitals and psychiatric hospitals in Scotland, submitted to ISD as part of the Scottish Morbidity Record 01 (SMR01) and Scottish Morbidity Record 04 (SMR04) data sets.
FinancialYear text Data is recorded for financial years (1st April to 31st March)
HBR text 9-digit code referring to Health Board of residence, based on boundaries as at 1st April 2014. The Scotland total is also included. Health board labels Country labels
HBRQF text Qualifier for HBR Qualifier information
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays
EASRPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfPatients
EASRNewPatients numeric European Age-sex Standardised Rates (EASR) based on NumberOfNewPatients
EASRNewPatientsQF text Qualifier for EASRNewPatients Qualifier information
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available. Therefore a ‘stay’ and a ‘discharge’ are equivalent in this report.
NumberOfStaysQF text Qualifier for NumberOfStays Qualifier information
NumberOfPatients numeric The number of unique individuals treated within the financial year. Patients are counted only once in the financial year in which they have an alcohol-related stay, even though the same patient may be admitted to hospital several times in a year.
NumberOfPatientsQF text Qualifier for NumberOfPatients Qualifier information
NumberOfNewPatients numeric The number of new patients. These are defined as patients who have not been previously admitted to hospital with an alcohol diagnosis within the last 10 years. If a patient has several alcohol-related stays over a number of years, this patient will be counted only in the year of the first alcohol-related hospital stay within a 10 year period.
NumberOfNewPatientsQF text Qualifier for NumberOfNewPatients Qualifier information
AverageNumberOfStaysPerPatient numeric The average number of stays per patient

ICD-10 Codes

This file contains the ICD-10 codes (International Statistical Classification of Diseases and Related Health Problems) that were used to create the output-files in this dataset.

Column Type Label Description
ICD10SubCondition text Code for ICD-10 subcondition
SubConditionDescription text Description of ICD-10 subcondition
ICD10Condition text Code for ICD-10 Condition
ICD10ConditionQF text Qualifier for ICD10Condition Qualifier information
ConditionDescription text Description of ICD-10 condition

Annual Hospital Beds Information

In order to provide an effective, safe and efficient service to patients, hospitals must balance the provision of staffed beds against anticipated demand. Historically, the total number of beds has been reducing in line with evolving models of healthcare provision which aim to reduce the frequency and duration of hospital admissions and improve the integration of health and social care services. This strategy aims to improve outcomes for patients and reduce the likelihood of future hospital admissions.

Beds by Health Board of Treatment and Specialty

Information on hospital beds by health board of treatment and specialty.

Column Type Label Description
FinancialYear text The reference period as financial year (YYYY/YY)
FinancialYearQF text Qualifier for FinancialYear Qualifier information
HB text 9-digit code for NHS board of treatment based on boundaries as at 1st April 2019, special health board and country code for Scotland
Health board labels, Special health boards, Country label
HBQF text Qualifier for HB Qualifier information
Specialty text Specialty Specialties
SpecialtyQF text Qualifier for Specialty Qualifier information
SpecialtyName text The name of the Specialty Specialties
SpecialtyNameQF text Qualifier for SpecialtyName Qualifier information
SpecialtyGrouping text Specialty Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined. Specialty Groupings
SpecialtyGroupingQF text Qualifier for SpecialtyGrouping Qualifier information
AverageAvailableStaffedBeds numeric Daily average number of available staffed beds
AverageAvailableStaffedBedsQF text Qualifier for AverageAvailableStaffBeds Qualifier information
PercentageOccupancy numeric Percentage (%) of daily occupancy of beds
PercentageOccupancyQF text Qualifier for PercentageOccupancy Qualifier information
AllStaffedBeds numeric Annually Available Staffed Beds
AllStaffedBedsQF text Qualifier for AllStaffedBeds Qualifier information
AverageOccupiedBeds numeric Daily average number of occupied beds
AverageOccupiedBedsQF text Qualifier for AverageOccupiedBeds Qualifier information
TotalOccupiedBeds numeric Annually Occupied Beds
TotalOccupiedBedsQF text Qualifier for TotalOccupiedBeds Qualifier information

Beds by Location of Treatment and Specialty

Information on hospital beds by health board of treatment and specialty.

Column Type Label Description
FinancialYear text The reference period as financial year (YYYY/YY)
FinancialYearQF text Qualifier for FinancialYear Qualifier information
HB text 9-digit code for NHS board of treatment based on boundaries as at 1st April 2019, special health board and country code for Scotland Health board labels Country labels Special Health Board
HBQF text Qualifier for HB Qualifier information
Location text 5-digit code for location of treatment, and country code for Scotland Location Lookup, Country label
LocationQF text Qualifier for Location Qualifier information
Specialty text Specialty Specialties
SpecialtyQF text Qualifier for Specialty Qualifier information
SpecialtyName text The name of the Specialty Specialties
SpecialtyNameQF text Qualifier for SpecialtyName Qualifier information
SpecialtyGrouping text Specialty Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined. Specialty Groupings
SpecialtyGroupingQF text Qualifier for SpecialtyGrouping Qualifier information
AverageAvailableStaffedBeds numeric Daily average number of available staffed beds
AverageAvailableStaffedBedsQF text Qualifier for AverageAvailableStaffBeds Qualifier information
PercentageOccupancy numeric Percentage (%) of daily occupancy of beds
PercentageOccupancyQF text Qualifier for PercentageOccupancy Qualifier information
AllStaffedBeds numeric Annually Available Staffed Beds
AllStaffedBedsQF text Qualifier for AllStaffedBeds Qualifier information
AverageOccupiedBeds numeric Daily average number of occupied beds
AverageOccupiedBedsQF text Qualifier for AverageOccupiedBeds Qualifier information
TotalOccupiedBeds numeric Annually Occupied Beds
TotalOccupiedBedsQF text Qualifier for TotalOccupiedBeds Qualifier information

Hospital Locations Lookup File

This lookup covers locations included in the Secondary Care Team’s Annual Acute hospital activity and NHS beds publication that was released on 28th September 2021. This includes locations that have been closed over the past ten financial years which are not present in the current NHS Hospitals in Scotland lookup. It is maintained by the Secondary Care Team and is accurate as of 28th September 2021.

Column Type Label Description
Location text A unique referencing code identifying a NHS Hospital
LocationName text Name of the hospital
Address1 text Address Line 1
Address2 text Address Line 2
Address3 text Address Line 3
Address4 text Address Line 4
Postcode text Postcode of the hospital
StartDate numeric Starting date.
EndDate numeric Ending date.
HB text Healthboard Code (2019) Health board labels
HBQF text Qualifier for HB Qualifier information
CA text Council Area Code (2019) Council area labels
CAQF text Qualifier for CA Qualifier information
HSCP text Health and Social Care Partnership Code (2019) Health and Social Care Partnership labels
HSCPQF text Qualifier for HSCP Qualifier information
DataZone text Datazone Code (2011) Data Zone labels
DataZoneQF text Qualifier for DataZone Qualifier information
IntZone text Intermediate Zone (2011) IntZone labels
IntZoneQF text Qualifier for IntZone Qualifier information

Inpatient and Day Case Activity

A patient is termed an inpatient when they occupy a staffed bed in a hospital and either remain overnight (whether intended or not) or are expected to remain overnight but are discharged earlier. An inpatient’s admission can be an emergency, an elective or a transfer. A day case is when a patient makes a planned attendance for one day to a specialty for clinical care and requires the use of a bed (or trolley in lieu of a bed). Although a day case is usually completed on the same day, the patient may need to be admitted as an inpatient if they are not fit to be discharged.

Activity by Board of Residence

Inpatient and daycase activity (episode and stays) by health board of residence of the patients

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence, country code for Scotland and 6-digit codes for other residential categories
Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories
Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Day cases; All Inpatients; All Inpatients and Day cases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Residence, Age and Sex

Age and sex breakdown for inpatient and daycase activity (episode and stays) by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Day cases; All Inpatients; All Inpatients and Day cases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Sex text The sex of the patient (Female/Male)
Age text Age of the patient as 10-year age bands
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays Qualifier information
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Residence and Deprivation

Deprivation breakdown for inpatient and daycase activity (episode and stays) by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
SIMD numeric Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year SIMD open data
SIMDQF text Qualifier for SIMD indicating where the quintile is not applicable/unknown Qualifier information
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Residence and Specialty

Specialty breakdown for inpatient and daycase activity (episode and stays) by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Specialty text Specialty code Specialties
SpecialtyName text The name of the Specialty
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Spells numeric Number of spells. A specialty spell is a period of time that a patient spends as an inpatient in a specialty at a given location. However, a patient may change consultant, significant facility, and/or hospital during a specialty spell.
LengthOfSpell numeric Total length of spells
AverageLengthOfSpell numeric Average length of a spell
AverageLengthOfSpellQF text Qualifier for AverageLengthOfSpell indicating where this data item is not applicable Qualifier information

Activity by Health Board of Treatment

Inpatient and daycase activity (episode and stays) by health board of treatment of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Treatment, Age and Sex

Age and sex breakdown for inpatient and daycase activity (episode and stays) by health board of treatment of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Sex text The sex of the patient (Female/Male)
Age text Age of the patient 10 year age bands
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes Qualifier information
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Treatment and Deprivation

Deprivation breakdown for inpatient and daycase activity (episode and stays) by health board of treatment of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
SIMD numeric Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year SIMD open data
SIMDQF text Qualifier for SIMD indicating where the quintile is not applicable/unknown Qualifier information
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information

Activity by Board of Treatment and Specialty

Specialty breakdown for inpatient and daycase activity (episode and stays) by health board of treatment of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AdmissionType text The admission type of the patient as: Elective Inpatients; Emergency Inpatients; Transfers; All Daycases; All Inpatients; All Inpatients and Daycases
AdmissionTypeQF text Qualifier for AdmissionType indicating aggregated data Qualifier information
Specialty text Specialty code Specialties
SpecialtyName text The name of the Specialty
Episodes numeric Number of episodes
LengthOfEpisode numeric Total length of episodes
AverageLengthOfEpisode numeric Average length of an episode
AverageLengthOfEpisodeQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable Qualifier information
Spells numeric Number of spells. A specialty spell is a period of time that a patient spends as an inpatient in a specialty at a given location. However, a patient may change consultant, significant facility, and/or hospital during a specialty spell.
LengthOfSpell numeric Total length of spells
AverageLengthOfSpell numeric Average length of a spell
AverageLengthOfSpellQF text Qualifier for AverageLengthOfSpell indicating where this data item is not applicable Qualifier information

Cross Boundary Flow

The cross-boundary flow refers to the relationship between the health board patients live in and those they are treated in.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HBT text 9-digit code for health board of treatment based on boundaries as at 1st April 2019 and 6-digit codes for special board Health board labels Special Health Board
HBR text 9-digit code for health board of residence based on boundaries as at 1st April 2019 and 6-digit codes for other residential categories Health board labels Residential Categories
Episodes numeric Number of episodes
Stays numeric Number of stays
CrossBoundaryFlag numeric Indicates whether the NHS Board of treatment is the same as the NHS Board of residence (0 - no, 1 - yes)

Publication Notes

Publication notes in relation to data accuracy and general observations concerning data quality.

Column Type Label Description
loc_name text
dqNotesIP text
dqNotesOP text
dqNotesBeds text

Outpatient Activity

"Patients who require the medical opinion of a specialist clinician may be referred to an outpatient clinic for treatment or investigation. An outpatient is a patient who attends a consultant or other medical clinic or has an arranged meeting with a consultant or a senior member of their team outside of a clinic session. Outpatients are not admitted to a hospital and do not use a hospital bed.

Outpatient attendances can be categorised as new or follow-up (return) attendances. Information on return appointments is only available for datasets that report on NHS board of treatment. Files reporting on the residency of patients only contain data for new outpatients as the ISD(S)1 data source for return outpatients does not contain residence information. ISD(S)1 also does not record information on the deprivation, age or sex of patients."

Activity by Board of Residence

New outpatient appointments and 'Did Not Attends' by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Residence, Age and Sex

Age and sex breakdown for new outpatient appointments and 'Did Not Attends' by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
Sex text The sex of the patient (Female/Male)
Age text Age of the patient 10 year age bands
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Residence and Deprivation

Deprivation breakdown for new outpatient appointments and 'Did Not Attends' by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
SIMD numeric Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year SIMD open data
SIMDQF text Qualifier for SIMD indicating where the quintile is not applicable/unknown Qualifier information
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Residence and Specialty

Specialty breakdown for new outpatient appointments and 'Did Not Attends' by health board of residence of the patients.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories Health board labels Country labels Residential Categories
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories Health board labels Council area labels Country labels Residential Categories
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
Specialty text Specialty code Specialties
SpecialtyName text The name of the Specialty
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Treatment

New outpatient appointments, return appointments and 'Did Not Attends' by health board of treatment.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
AppointmentType text The outpatient appointment type as 'New', Return', 'All Appointments' (total of 'New' + 'Return') or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for Appointments indicating aggregated data Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Treatment, Age and Sex

Age and sex breakdown for new outpatient appointments, and 'Did Not Attends' by health board of treatment.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
Sex text The sex of the patient (Female/Male)
Age text Age of the patient 10 year age bands
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Treatment and Deprivation

Deprivation breakdown for new outpatient appointments and 'Did Not Attends' by health board of treatment.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
SIMD numeric Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year SIMD open data
SIMDQF text Qualifier for SIMD indicating where the quintile is not applicable/unknown Qualifier information
AppointmentType text The outpatient appointment type as 'New' or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for AppointmentType Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Activity by Board of Treatment and Specialty

Specialty breakdown for new outpatient appointments, return appointments and 'Did Not Attends' by health board of treatment.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
Specialty text
SpecialtyName text
AppointmentType text The outpatient appointment type as 'New', Return', 'All Appointments' (total of 'New' + 'Return') or 'DNA' (Did Not Attend)
AppointmentTypeQF text Qualifier for Appointments indicating aggregated data Qualifier information
Appointments numeric The number of appointments
AppointmentsQF text Qualifier for Appointments indicating incomplete data Qualifier information
Rate numeric Only available for DNAs; calculated from new appointments and presented as a percentage of the total number of outpatient appointments
RateQF text Qualifier for Rate indicating that Rate is not applicable to new appointment data Qualifier information

Cross Boundary Flow

The cross-boundary flow refers to the relationship between the health board patients live in and those they are treated in.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HBT text 9-digit code for health board of treatment based on boundaries as at 1st April 2019 and 6-digit codes for special board Health board labels Special Health Board
HBR text 9-digit code for health board of residence based on boundaries as at 1st April 2019 and 6-digit codes for other residential categories Health board labels Residential Categories
Attendances numeric Number of attendances
CrossBoundaryFlag numeric Indicates whether the NHS Board of treatment is the same as the NHS Board of residence (0 - no, 1 - yes)

Publication Notes

Publication notes in relation to data accuracy and general observations concerning data quality.

Column Type Label Description
loc_name text
dqNotesIP text
dqNotesOP text
dqNotesBeds text

Beds Information in Scotland

To provide an effective, safe and efficient service to patients, hospitals must balance the provision of staffed beds against anticipated demand. Historically, the total number of beds has been reducing in line with evolving models of healthcare provision which aim to reduce the frequency and duration of hospital admissions and improve the integration of health and social care services. This strategy aims to improve outcomes for patients and reduce the likelihood of future hospital admissions.

Beds by Board of Treatment and Specialty

Quarterly information on hospital beds.

Column Type Label Description
Quarter text The reference period as quarter (YYYYQN)
QuarterQF text Qualifier for Quarter indicating provisional data Qualifier information
HB text 9-digit codes for health board of treatment based on boundaries as at 1st April, country code for Scotland and 6-digit codes for special board Health board labels Country labels Special Health Board
HBQF text Qualifier for HB indicating aggregated data Qualifier information
Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards Health board labels Country labels Special Health Board Hospitals
LocationQF text Qualifier for Location indicating aggregated data Qualifier information
Specialty text Specialty code Specialties
SpecialtyQF text Qualifier for Specialty indicating aggregated data Qualifier information
SpecialtyName text The name of the Specialty
SpecialtyNameQF text Qualifier for SpecialtyName Qualifier information
AllStaffedBeddays numeric
AllStaffedBeddaysQF text
TotalOccupiedBeddays numeric
TotalOccupiedBeddaysQF text
AverageAvailableStaffedBeds numeric Daily average number of available staffed beds
AverageAvailableStaffedBedsQF text Qualifier for AverageAvailableStaffBeds Qualifier information
AverageOccupiedBeds numeric Daily average number of occupied beds
AverageOccupiedBedsQF text Qualifier for AverageOccupiedBeds Qualifier information
PercentageOccupancy numeric Percentage (%) of daily occupancy of beds
PercentageOccupancyQF text Qualifier for PercentageOccupancy Qualifier information

Publication Notes

Publication notes in relation to data accuracy and general observations concerning data quality.

Column Type Label Description
loc_name text
dqNotesIP text
dqNotesOP text
dqNotesBeds text

Drug-Related Hospital Statistics Scotland

Drug-related hospital statistics (DRHS) provide an annual update to figures on the drug-related inpatient and day case activity taking place within general acute hospitals in Scotland.

DRHS By Health Board

Information on drug related hospital stays at health board level.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
HBR text 9- digit code for health board of residence, based on the boundaries as at the time of event Health Board labels
HBRQF text Qualifier for HBR Qualifier information
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available.
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays. It uses the European Standard Population 2013.

DRHS By Council Area

Information on drug related hospital stays at council area level.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
CA text 9- digit code for Council area of residence, based on the boundaries as at the time of event Council Area labels Country labels
CAQF text Qualifier for CA Qualifier information
NumberOfStays numeric For this dataset, a hospital stay (also described as a continuous inpatient stay or CIS), is defined as an unbroken period of time that a patient spends as an inpatient or day-case. During a stay a patient may have numerous episodes as they change consultant, significant facility, speciality and/or hospital. Stays are counted at the point of discharge, when all diagnostic information regarding the full stay is available.
EASRStays numeric European Age-sex Standardised Rates (EASR) based on NumberOfStays. It uses the European Standard Population 2013.

Learning Disability Inpatient Activity

These files present information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland. The period covered is financial years 1997/98 - 2021/22, for all NHS Boards of treatment.

Activity by Age and Sex

Information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland, by age and sex.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric inpatient records.
TimeRange text Denotes the financial years covered by this dataset. Financial years start on 1 April and end on 31 March. This file shows data for the six-year period from 1 April 2016 to 31 March 2022.
Country text 9-digit code for NHS Scotland as a whole. Country label
AgeGroup text Refers to the patient's age on discharge. Ages have been arranged in seven different groups.
Sex text The patient's sex, as recorded on discharge.
DischargesCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCountQF text A qualifier to give extra information about the discharge count. Qualifier information
PatientsCount numeric The total number of patients. Patients are counted only once in each 6-year period under consideration here, regardless of whether they have had multiple discharges.
PatientsCountQF text A qualifier to give extra information about the patient count. Qualifier information

Activity by Deprivation

Information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland, by deprivation (SIMD quintiles)

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric inpatient records.
TimeRange text Denotes the financial years covered by this dataset. Financial years start on 1 April and end on 31 March. This file shows data for the six-year period from 1 April 2016 to 31 March 2022.
Country text 9-digit code for NHS Scotland as a whole. Country label
SIMDQuintile text The Scottish Index of Multiple Deprivation (SIMD) uses a wide range of information for small areas (data zones) to identify concentrations of multiple deprivation across Scotland. The data zones are then arranged in five groups (quintiles), ranging from the most deprived (1 - contains the 20% most deprived data zones) to the least deprived (5 - contains the 20% least deprived datazones). The SIMD version used depends on the years in question. More information can be found in the PHS Deprivation Guidance (Version 3.4, Section 3.2, pg 12): https://www.isdscotland.org/Products%2Dand%2DServices/GPD%2DSupport/Deprivation/. Postcode matching is used to determine the deprivation quintile for a particular patient; specifically, the postcode used to attribute a deprivation quintile is the last postcode that the patient is recorded under during each 6-year period. As this is not possible for a few incorrect or invalid postcodes, the numbers here will be slightly lower than the Scotland total in other tables. Scottish Index of Multiple Deprivation
PatientsCount numeric The total number of patients. Patients are counted only once in each 6-year period under consideration here, regardless of whether they have had multiple discharges. Please note that the data includes Scotland residents only.
PatientsEASR numeric The number of patients relative to the size of the population, expressed per 100,000 population. The European Age-Sex Standardised Rate (EASR) takes into account differences between populations with regard to age and sex composition and uses the European Standard Population 2013.

Activity by Health Board

Information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland, by health board of treatment.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric inpatient records.
TimeRange text Denotes the financial years covered by this dataset. Financial years start on 1 April and end on 31 March. This file shows data for the six-year period from 1 April 2016 to 31 March 2022.
HBT text 9-digit code for health board of treatment based on boundaries as at 1st April 2019. Dumfries & Galloway record a large proportion of the discharges at Acorn House which is a facility that offers short-stay respite breaks for children & young people with learning disabilities. While this service is offered across Scotland, Dumfries & Galloway are the only NHS Board that record this activity on SMR04. All Orkney and Shetland psychiatric patients are treated by a mainland board as they have no psychiatric hospitals within their board area. Western Isles are also absent from this analysis, as the Western Isles Hospital, based in Stornoway, does not have specialist Learning Disability inpatient facilities. [Health board codes] (https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/652ff726-e676-4a20-abda-435b98dd7bdc)
DischargesCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCountQF text A qualifier to give extra information about the discharge count. Qualifier information
CISCount numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. As a result, information used to assign a stay to the Learning Disability specialty has to be taken from a single episode within the stay. In this report, the specialty and the health board of treatment are taken from the last episode in the stay, and then the total length of stay is calculated by summing the lengths of all the episodes composing the stay, irrespective of whether the previous episodes in the stay also occurred in the Learning Disability specialty. Finally, in this report, stays are assigned to financial years based on the date of discharge of the last episode in the stay.
CISCountQF text A qualifier to give extra information about the count of continuous inpatient stays. Qualifier information
MeanLengthOfStay numeric The average (mean) length of a continuous inpatient stay in hospital. For further details on the methodology, please see entry for CISCount.
MeanLengthOfStayQF text A qualifier to give extra information about the mean length of continuous inpatient stays. Qualifier information
PatientsCount numeric The total number of patients. Regardless of how many times they have been discharged during each 6-year period under consideration here, patients are counted only once at the Scotland level. However, if they have been treated in multiple Health Boards, then they will be counted more than once. As such, the individual Health Board numbers do not sum up to the Scotland total.
PatientsCountQF text A qualifier to give extra information about the patient count. Qualifier information
DischargesPercent numeric The percentage of discharges over the period for the associated health board against the Scotland total.
DischargesPercentQF text A qualifier to give extra information about the discharge percentage. Qualifier information

Activity Health Board Trend

Information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland by health board of treatment covering financial years from 1997/98 to 2020/21.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric records.
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBT text 9-digit code for health board of treatment based on boundaries as at 1st April 2019. Dumfries & Galloway record a large proportion of the discharges at Acorn House which is a facility that offers short-stay respite breaks for children & young people with learning disabilities. While this service is offered across Scotland, Dumfries & Galloway are the only NHS Board that record this activity on SMR04. All Orkney and Shetland psychiatric patients are treated by a mainland board as they have no psychiatric hospitals within their board area. Western Isles are also absent from this analysis, as the Western Isles Hospital, based in Stornoway, does not have specialist Learning Disability inpatient facilities. [Health board codes] (https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/652ff726-e676-4a20-abda-435b98dd7bdc)
DischargesCount text The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCountQF text A qualifier to give extra information about the discharge count. Qualifier information
CISCount text The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. As a result, information used to assign a stay to the Learning Disability specialty has to be taken from a single episode within the stay. In this report, the specialty and the health board of treatment are taken from the last episode in the stay. Moreover, stays are assigned to financial years based on the date of discharge of the last episode in the stay.
CISCountQF text A qualifier to give extra information about the count of continuous inpatient stays. Qualifier information
PatientsCount text The total number of patients. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year. However, if they have been treated in multiple health boards, they will be counted more than once.
PatientsCountQF text A qualifier to give extra information about the patient count. Qualifier information

Activity Scotland Trend

Information on patients with learning disabilities who have been cared for as inpatients or day cases in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland covering financial years from 1997/98 to 2020/21.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric records.
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
Country text 9-digit code for NHS Scotland as a whole. Country label
DischargesCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCrudeRate numeric The annual number of discharges relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and sex composition. Rates are calculated using National Records of Scotland mid-year population estimates. Populations used for the years 2002 onwards are rebased following the 2011 Census.
DischargesEASR numeric The annual number of discharges relative to the size of the population, expressed per 100,000 population. The European Age-Sex Standardised Rate (EASR) takes into account differences between populations with regard to age and sex composition and uses the European Standard Population 2013.
CISCount numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. As a result, information used to assign a stay to the Learning Disability specialty has to be taken from a single episode within the stay. In this report, the specialty is taken from the last episode in the stay. Moreover, stays are assigned to financial years based on the date of discharge of the last episode in the stay.
CISCrudeRate numeric The annual number of continuous inpatient stays relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and sex composition. Rates are calculated using National Records of Scotland mid-year population estimates. Populations used for the years 2002 onwards are rebased following the 2011 Census.
CISEASR numeric The annual number of continuous inpatient stays relative to the size of the population, expressed per 100,000 population. The European Age-Sex Standardised Rate (EASR) takes into account differences between populations with regard to age and sex composition and uses the European Standard Population 2013.
PatientsCount numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level.
PatientsCrudeRate numeric The annual number of patients relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and sex composition. Rates are calculated using National Records of Scotland mid-year population estimates. Populations used for the years 2002 onwards are rebased following the 2011 Census.
PatientsEASR numeric The annual number of patients relative to the size of the population, expressed per 100,000 population. The European Age-Sex Standardised Rate (EASR) takes into account differences between populations with regard to age and sex composition and uses the European Standard Population 2013.

Inpatient Length of Stay

Information on patients with learning disabilities who have been cared for as inpatients in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland, by length of stay

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric inpatient records.
FinancialYear text Denotes the financial years covered by this dataset. Financial years start on 1 April and end on 31 March. This file shows data for the six-year period from 1 April 2016 to 31 March 2022.
LengthOfStay text The length of a patient's time as an inpatient.
Country text 9-digit code for NHS Scotland as a whole. Country label
PatientsCount numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. As a result, information used to assign a stay to the Learning Disability specialty has to be taken from a single episode within the stay. In this report, the specialty and the health board of treatment are taken from the last episode in the stay. Moreover, stays are assigned to financial years based on the date of discharge of the last episode in the stay.

Discharge Type - Scotland

Information on patients with learning disabilities who have been cared for in psychiatric hospitals and certain care homes contracted by NHS Boards within Scotland, by discharge type.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric records.
TimeRange text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
Country text 9-digit code for NHS Scotland as a whole. Country label
DischargeType text Indicates whether a discharge from an inpatient or day case episode is regular, irregular (e.g. self-discharge) or as a result of the patients death.
DischargesCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCountQF text A qualifier to give extra information about the discharge count. Qualifier information

Discharge Type - Health Board

Information on patients with learning disabilities who have been cared for in psychiatric hospitals and certain care homes contracted by NHS Boards, by health board and discharge type.

Column Type Label Description
Dataset text The data source that is reported from. SMR04 covers psychiatric records.
TimeRange text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBT text 9-digit code for health board of treatment based on boundaries as at 1st April 2019. Dumfries & Galloway record a large proportion of the discharges at Acorn House which is a facility that offers short-stay respite breaks for children & young people with learning disabilities. While this service is offered across Scotland, Dumfries & Galloway are the only NHS Board that record this activity on SMR04. All Orkney and Shetland psychiatric patients are treated by a mainland board as they have no psychiatric hospitals within their board area. Western Isles are also absent from this analysis, as the Western Isles Hospital, based in Stornoway, does not have specialist Learning Disability inpatient facilities. [Health board codes] (https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/652ff726-e676-4a20-abda-435b98dd7bdc)
DischargeType text Indicates whether a discharge from an inpatient or day case episode is regular, irregular (e.g. self-discharge) or as a result of the patients death.
DischargesCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties, significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargesCountQF text A qualifier to give extra information about the discharge count. Qualifier information

Mental Health Inpatient Activity

These files present information on patients with mental health problems who have been cared for as inpatients or day cases in Scottish general and psychiatric hospitals. The period covered is financial years 1997/98 - 2020/21, for all NHS Boards of residence and treatment.

Age and Sex

Patients and discharge counts and rates given for age groups and sex which is split by health board in which the patient resides.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBR text 9-digit code for health board of residence.The Scotland total is also included. There are also 6-digit codes for other residential categories. NHS Board information Country labelsOther residential information
HBRQF text Qualifier for HBR, indicating Scotland totals. Qualifier information
AgeGroup text Refers to the patient's age on admission. Ages have been arranged in five different groups.
Sex text The patient's sex, as recorded on admission.
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
DischargeCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargeCountQF text A qualifier to give extra information about the discharge count. Qualifier information
DischargeRates text The annual number of discharges relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
DischargeRatesQF text A qualifier to give extra information about the discharge rates. Qualifier information
PatientsCount numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level. However, if their age band and/or sex changes during the year, they will be counted more than once. At the health board of residence level, patients will be counted more than once in each year if they have moved from one health board of residence, age band and/or sex to another.
PatientCountQF text A qualifier to give extra information about the patient count. Qualifier information
PatientsRates text The annual number of patients relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
PatientRatesQF text A qualifier to give extra information about the patient rates. Qualifier information

Deprivation

Data for number of patients, discharges and hospital residents by counts and rates for Scottish Index of Multiple Deprivation (SIMD) categories. This is split by health board of residence.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBR text 9-digit code for health board of residence. The Scotland total is also included. NHS Board information Country labels
HBRQF text Qualifier for HBR, indicating Scotland totals. Qualifier information
SIMD numeric The SIMD uses a wide range of information for small areas (data zones) to identify concentrations of multiple deprivation across Scotland. The data zones are then arranged in five groups (quintiles), ranging from the most deprived (1 - contains the 20% most deprived datazones) to the least deprived (5 - contains the 20% least deprived datazones). The SIMD version used depends on the years in question, more information can be found in the PHS Deprivation Guidance (Version 3.4, Section 3.2, pg 12): https://www.isdscotland.org/Products%2Dand%2DServices/GPD%2DSupport/Deprivation/. SIMD open data
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
DischargeCount numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargeCountQF text A qualifier to give extra information about the discharge count. Qualifier information
DischargeRates numeric The annual number of discharges relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
DischargeRatesQF text A qualifier to give extra information about the discharge rates. Qualifier information
PatientsCount numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level. However, if their SIMD quintile changes during the year as a result of moving to a different data zone, they will be counted more than once. At the health board of residence level, patients will be counted more than once in each year if they have moved from one health board of residence and/or SIMD quintile to another.
PatientCountQF text A qualifier to give extra information about the patient count. Qualifier information
PatientsRates numeric The annual number of patients relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
PatientRatesQF text A qualifier to give extra information about the patient rates. Qualifier information
HospitalResidentsCount numeric The total number of hospital residents. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board).
HospitalResidentsCountQF text A qualifier to give extra information about the hospital resident count. Qualifier information
HospitalResidentsRates numeric The annual number of hospital residents relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
HospitalResidentsRatesQF text A qualifier to give extra information about the hospital resident rates. Qualifier information

Length of Stay

Length of stay which is split by health board in which the patient was treated.

Column Type Label Description
FinancialYear text The financial year in which the continuous inpatient stay (CIS) ended. Financial years start on 1 April and end on 31 March.
HBT text 9-digit code for health board of treatment and 6-digit codes for special health boards. The Scotland total is also included. Stays are assigned to health boards of treatment based on information taken from the last episode in the stay. NHS Board information NHS Special Board information Country labels
HBTQF text Qualifier for HBT, indicating Scotland totals. Qualifier information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
LengthOfStay text The total length of a continuous inpatient stay in hospital. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay.
NumberOfStays numeric The total number of continuous inpatient stays for the associated length of stay category.

Diagnosis

Data for number of patients, discharges and hospital residents by counts and rates for diagnosis. Diagnosis is given by ICD10 codes and is split by health board of treatment.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBT text 9-digit code for health board of treatment and 6-digit codes for special health boards. The Scotland total is also included. NHS Board information NHS Special Board information Country labels
HBTQF text Qualifier for HBT, indicating Scotland totals. Qualifier information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
ICD10Codes text The diagnosis grouping in which the patient belongs, derived from the International Classification of Diseases and Related Health Problems, Tenth Revision (World Health Organization). Up to six diagnoses (one principal diagnosis and five secondary diagnoses) may be recorded per hospital episode. Only principal diagnosis was used to create the groupings. The only exception is 'Organic, including symptomatic, mental disorders' (F00-F09), which also includes cases where a principal diagnosis G was accompanied by a secondary diagnosis of F00. ICD10 Codes Open Data ICD10 Codes
DischargeCount text The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
DischargeCountQF text A qualifier to give extra information about the discharge count. Qualifier information
DischargeRates text The annual number of discharges relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
DischargeRatesQF text A qualifier to give extra information about the discharge rates. Qualifier information
PatientsCount text The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level. However, if they belong in multiple diagnosis groupings, they will be counted more than once. At the health board of treatment level, patients will be counted more than once if they have received treatment in more than one health board and/or belong in multiple diagnosis groupings.
PatientCountQF text A qualifier to give extra information about the patient count. Qualifier information
PatientsRates text The annual number of patients relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
PatientRatesQF text A qualifier to give extra information about the patient rates. Qualifier information
HospitalResidentsCount text The total number of hospital residents. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board).
HospitalResidentsCountQF text A qualifier to give extra information about the hospital resident rates. Qualifier information
HospitalResidentsRates text The annual number of hospital residents relative to the size of the population, expressed per 100,000 population. The crude rate takes no account of differences between populations with regard to age and gender composition.
HospitalResidentsRatesQF text A qualifier to give extra information about the hospital resident rates. Qualifier information

Hospital Trend

Data for the number of admissions, discharges and stays; also count of patients and hospital residents by hospital.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
LocationCode text 5-digit code for hospital location. Hospital codes information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
NumberOfAdmissions numeric The total number of admissions. An admission marks the start of an inpatient episode or day case episode.
NumberOfDischarges numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
NumberOfStays numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. Stays are assigned to hospitals based on information taken from the last episode in the stay.
NumberOfPatients numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Patients are counted only once in each financial year. However, if they have been treated in multiple hospitals, they will be counted more than once.
NumberOfHospitalResidents text The total number of hospital residents. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board).
NumberOfHospitalResidentsQF text A qualifier to give extra information about the number of hospital residents. Qualifier information

Health Board Trend

Data for the number of admissions, discharges and stays; also count of patients and hospital residents by health board of treatment.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBT text 9-digit code for health board of treatment and 6-digit codes for special health boards. NHS Board information NHS Special Board information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
NumberOfAdmissions numeric The total number of admissions. An admission marks the start of an inpatient episode or day case episode.
NumberOfDischarges numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
NumberOfStays numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay. Stays are assigned to health boards of treatment based on information taken from the last episode in the stay.
NumberOfPatients numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Patients are counted only once in each financial year. However, if they have been treated in multiple health boards, they will be counted more than once.
NumberOfHospitalResidents text The total number of hospital residents. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board).
NumberOfHospitalResidentsQF text A qualifier to give extra information about the number of hospital residents. Qualifier information

Scotland Trend

Data for the number of admissions, discharges and stays; also count of patients and hospital residents for Scotland.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
Country text 9-digit code for NHS Scotland as a whole. Country labels
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
NumberOfAdmissions numeric The total number of admissions. An admission marks the start of an inpatient episode or day case episode.
NumberOfDischarges numeric The total number of discharges. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence.
NumberOfStays numeric The total number of continuous inpatient stays. A continuous inpatient stay is an unbroken period of time that a patient spends as an inpatient. However, a patient may change consultant, significant facility, specialty, and/or hospital during a continuous inpatient stay.
NumberOfPatients numeric The total number of patients. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level.
NumberOfHospitalResidents text The total number of hospital residents. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board).
NumberOfHospitalResidentsQF text A qualifier to give extra information about the number of hospital residents. Qualifier information

Cross Boundary Flow

Flow between health boards showing number of patients treated in a health board which differs to where they live.

Column Type Label Description
FinancialYear text The financial year in which the patient was discharged. Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBR text 9-digit code for health board of residence. NHS Board information
HBT text 9-digit code for health board of treatment and 6-digit codes for special health boards. NHS Board information NHS Special Board information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
DischargeCount text This field tells you how many discharges took place for each combination of board of residence and treatment. A discharge represents the end of a hospital episode. Discharges include: deaths; transfers to other specialties, consultants, significant facilities and hospitals; and routine discharges home. Discharges are assigned to financial year according to the date of discharge.
DischargeCountQF text A qualifier to give extra information about the discharge count. Qualifier information
PatientsCount text This field tells you how many patients from each NHS board of residence were treated within their own board, and how many were treated outside their board. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year.
PatientCountQF text A qualifier to give extra information about the patient count Qualifier information

Council Area Discharge and Patient Rates

Discharge and patient rates for Council Areas across Scotland.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
CA text 9-digit code for council areas. Council Area information
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
DischargesRate numeric The annual number of discharges relative to the size of the population, expressed per 100,000 population. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence. The crude rate takes no account of differences between populations with regard to age and gender composition.
PatientsRate numeric The annual number of patients relative to the size of the population, expressed per 100,000 population. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year. However, if their council area changes during the year, they will be counted more than once. The crude rate takes no account of differences between populations with regard to age and gender composition.

Readmissions

This section shows what percentage of the total number of continuous inpatient stays in each year were readmissions (within 28 and 133 days following discharge).

Column Type Label Description
FinancialYear text The financial year in which the patient was discharged. Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
HBT text 9-digit code for health board of treatment. The Scotland total is also included. NHS Board information NHS Special Board information
HBTQF text Qualifier for HBT, indicating Scotland totals. Qualifier information
Dataset text Refers to the dataset the information is taken from.
PercentageOfReadmissionsWithin28Days numeric Refers to a case where a patient who has been discharged from hospital is admitted again within 28 days. The percentage of readmissions is calculated by dividing the total number of readmissions by the total number of continuous inpatient stays. Only readmissions in the following psychiatric specialties have been considered here: G1 - General Psychiatry and G4 – Psychiatry of Old Age.
PercentageOfReadmissionsWithin133Days numeric Refers to a case where a patient who has been discharged from hospital is admitted again within 133 days. The percentage of readmissions is calculated by dividing the total number of readmissions by the total number of continuous inpatient stays. Only readmissions in the following psychiatric specialties have been considered here: G1 - General Psychiatry and G4 – Psychiatry of Old Age.

Relative Index of Inequality

Data describing inequality across the population of Scotland for patients, discharges, and hospital residents. A higher number indicates greater inequality in the most deprived quintile compared to the least deprived quintile relative to the mean, i.e., it shows how much more likely people from the most deprived quintile are to experience inpatient mental health care compared to people from the least deprived quintile in that year.

Column Type Label Description
FinancialYear text Financial years start on 1 April and end on 31 March. For example, financial year 2017/2018 covers the period 1 April 2017 – 31 March 2018.
Country text 9-digit code for NHS Scotland as a whole. Country labels
Dataset text The data source that is reported from. SMR01 covers non-psychiatric records and SMR04 covers psychiatric records. Total covers both groups.
DatasetQF text Qualifier for Dataset Qualifier information
Discharges numeric The relative index of inequality (RII) is used to quantify the relative inequality gap by taking into consideration the number of discharges for all of the deprivation quintiles and the population size of each quintile. A hospital discharge marks the end of an episode of care. Discharges include deaths, transfers to other specialties/significant facilities and hospitals, and discharges home or to other regular place of residence. RII information
DischargesQF text Qualifier for Discharges Qualifier information
Patients numeric The relative index of inequality (RII) is used to quantify the relative inequality gap by taking into consideration the number of patients for all of the deprivation quintiles and the population size of each quintile. A patient is defined as an individual discharged from hospital (including as a transfer out) at least once during the financial year. Regardless of how many times they have been discharged during the financial year, patients are counted only once in each financial year at the Scotland level. However, if their SIMD quintile changes during the year as a result of moving to a different data zone, they will be counted more than once. RII information
PatientsQF text Qualifier for Patients Qualifier information
Residents text The relative index of inequality (RII) is used to quantify the relative inequality gap by taking into consideration the number of hospital residents for all of the deprivation quintiles and the population size of each quintile. A hospital resident is an individual who is an inpatient at midnight on 31 March, before the beginning of the next financial year (1 April). Although the term 'hospital resident' is used for simplicity, some people will be looked after in care homes (under contract to the local NHS Board). RII information
ResidentsQF text Qualifier for Residents Qualifier information

ICD10-Codes

ICD-10 Codes which are used in Mental Health diagnosis

Column Type Label Description
ICD10 Diagnosis Grouping - Codes text The ICD10 codes composing each diagnosis grouping. World Health Organisation classifications
ICD10 Diagnosis Grouping - Name text The name given to each diagnosis grouping, summarising the conditions contained within it. Adapted from ICD10.
ICD10 Diagnosis - Code text The ICD10 code behind each individual condition.
ICD10 Diagnosis - Name text The name given to each individual condition. Reprinted from ICD10.

Monthly A&E Activity and Waiting Times

Key statistics on new and unplanned return attendances at Accident and Emergency (A&E) services across Scotland. The information presented includes trends in the number of attendances and admissions, and performance against the four hour waiting time standard.

Monthly A&E Activity and Waiting Times

This data resource contains monthly key statistics on new and unplanned return attendances at Accident and Emergency (A&E) services across Scotland.

Column Type Label Description
Month numeric Calendar month and year data pertains to
Country text Country code Country labels
HBT text Health Board of treatment 2019 code Health board labels
TreatmentLocation text A unique referencing code identifying a NHS Hospital Current NHS hospitals in Scotland
DepartmentType text Reference identifying hospitals as either an Emergency Department or a Minor Injuries Unit/Other.
NumberOfAttendancesAggregate numeric The total number of attendances at aggregate level. An attendance represents the presence of a patient in an A&E service seeking medical attention.
NumberOfAttendancesEpisode numeric The total number of attendances at episode level. An attendance represents the presence of a patient in an A&E service seeking medical attention.
NumberOfAttendancesEpisodeQF text Qualifier for NumberOfAttendancesEpisode, not applicable indicates that this data item is not reported by the respective site. Qualifier information
NumberMeetingTargetAggregate numeric The number of attendances that are admitted, transferred or discharged within four hours of arrival at aggregate level.
NumberMeetingTargetEpisode numeric The number of attendances that are admitted, transferred or discharged within four hours of arrival at episode level.
NumberMeetingTargetEpisodeQF text Qualifier for NumberMeetingTargetEpisode, not applicable indicates that this data item is not reported by the respective site. Qualifier information
DischargeDestinationAdmissionToSame numeric The number of attendances that were admitted to the same NHS heathcare provider/hospital. ( Episode level data only)
DischargeDestinationAdmissionToSameQF text Qualifier for DischargeDestinationAdmissionToSame, not applicable indicates that this data item is not reported by the respective site. Qualifier information
DischargeDestinationOtherSpecialty numeric The number of attendances that were discharged to a Private healthcare provider and the number of attendances that died. (Episode level data only)
DischargeDestinationOtherSpecialtyQF text Qualifier for DischargeDestinationOtherSpecialty, not applicable indicates that this data item is not reported by the respective site. Qualifier information
DischargeDestinationResidence numeric The number of attendances that were discharged to a Private residence, residential institution or temporary residence. (Episode level data only)
DischargeDestinationResidenceQF text Qualifier for DischargeDestinationResidence, not applicable indicates that this data item is not reported by the respective site. Qualifier information
DischargeDestinationTransfer numeric The number of attendances that were transferred to another NHS healthcare provider/hospital. (Episode level data only)
DischargeDestinationTransferQF text Qualifier for DischargeDestinationTransfer, not applicable indicates that this data item is not reported by the respective site. Qualifier information
DischargeDestinationUnknown numeric The number of attendances where the discharge destination was Other or Not Known. (Episode level data only)
DischargeDestinationUnknownQF text Qualifier for DischargeDestinationUnknown, not applicable indicates that this data item is not reported by the respective site. Qualifier information
AttendanceGreater8hrs numeric The number of attendances that have been in the A&E department longer than 8 hours. (Episode level data only)
AttendanceGreater8hrsQF text Qualifier for AttendanceGreater8hrs, not applicable indicates that this data item is not reported by the respective site. Qualifier information
AttendanceGreater12hrs numeric The number of attendances that have been in the A&E department longer than 12 hours. (Episode level data only)
AttendanceGreater12hrsQF text Qualifier for AttendanceGreater12hrs, not applicable indicates that this data item is not reported by the respective site. Qualifier information

Scottish Heart Disease Statistics

Summary of discharges from hospital and deaths in Scotland resulting from a heart condition (including coronary heart disease, heart attack, heart failure and angina).

Heart Disease Activity By Health Board

Information on discharges from hospitals in Scotland resulting from a heart condition at health board level

Column Type Label Description
FinancialYear text The financial year (1st April to 31st March) the data refers to, as YYYY/YY.
HBR text 9-digit code for health board of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland.
Health board labels, Country codes
HBRQF text Qualifier for HBR. Qualifier information
AdmissionType text The admission type (Elective, Emergency, Transfer, All).
AdmissionTypeQF text Qualifier for AdmissionType. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDischarges numeric The total number of discharges.
NumberOfDischargesQF text
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Heart Disease Activity By Council Area

Information on discharges from hospitals in Scotland resulting from a heart condition at council area level.

Column Type Label Description
FinancialYear text The financial year (1st April to 31st March) the data refers to, as YYYY/YY.
CA text 9-digit code for council area of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Council area labels , Country codes
CAQF text Qualifier for CA. Qualifier information
AdmissionType text The admission type (Elective, Emergency, Transfer, All).
AdmissionTypeQF text Qualifier for AdmissionType. Qualifier information
AgeGroup text
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDischarges numeric The total number of discharges.
NumberOfDischargesQF text Qualifier for NumberOfDischarges. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Heart Disease Mortality By Health Board

Information on deaths in Scotland resulting from a heart condition at health board level.

Column Type Label Description
Year numeric The calendar year (1st January to 31st Decmeber) the data refers to, as YYYY.
HBR text 9-digit code for health board of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Health board labels, Country codes
HBRQF text Qualifier for HBR. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDeaths numeric The total number of deaths.
NumberOfDeathsQF text Qualifier for NumberOfDeaths. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Heart Disease Mortality By Council Area

Information on deaths in Scotland resulting from a heart condition at council area level.

Column Type Label Description
Year numeric The calendar year (1st January to 31st Decmeber) the data refers to, as YYYY.
CA text 9-digit code for council area of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland.
Council area labels , Country codes
CAQF text Qualifier for CA Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDeaths numeric The total number of deaths.
NumberOfDeathsQF text Qualifier for NumberOfDeaths. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Scottish Stroke Statistics

Summary of discharges from hospital and deaths in Scotland resulting from a cerebrovascular disease (including stroke and subarachnoid haemorrhage).

Stroke Activity By Health Board

Information on hospital activity related to cerebrovascular disease (including stroke and subarachnoid haemorrhage).

Column Type Label Description
FinancialYear text The financial year (1st April to 31st March) the data refers to, as YYYY/YY.
HBR text 9-digit code for health board of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Health board labels Country labels
HBRQF text Qualifier for HBR. Qualifier information
AdmissionType text The admission type (Elective, Emergency, Transfer, All).
AdmissionTypeQF text Qualifier for AdmissionType. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDischarges numeric The total number of discharges.
NumberOfDischargesQF text Qualifier for NumberOfDischarges. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Stroke Activity By Council Area

Information on hospital activity related to cerebrovascular disease (including stroke and subarachnoid haemorrhage) presented by council area.

Column Type Label Description
FinancialYear text The financial year (1st April to 31st March) the data refers to, as YYYY/YY.
CA text 9-digit code for council area of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Council area labels, Country labels
CAQF text Qualifier for CA. Qualifier information
AdmissionType text The admission type (Elective, Emergency, Transfer, All).
AdmissionTypeQF text Qualifier for AdmissionType. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDischarges numeric The total number of discharges.
NumberOfDischargesQF text
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Stroke Mortality By Health Board

Information on deaths resulting from a cerebrovascular disease (including stroke and subarachnoid haemorrhage) presented by health board of residence.

Column Type Label Description
Year numeric The calendar year (1st January to 31st December) the data refers to, as YYYY.
HBR text 9-digit code for health board of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Health board labels Country labels
HBRQF text Qualifier for HBR. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDeaths numeric The total number of deaths.
NumberOfDeathsQF text Qualifier for NumberOfDeaths. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Stroke Mortality By Council Area

Information on deaths resulting from a cerebrovascular disease (including stroke and subarachnoid haemorrhage) presented by council area.

Column Type Label Description
Year numeric The calendar year (1st January to 31st December) the data refers to, as YYYY.
CA text 9-digit code for council area of residence based on boundaries as at 2nd February 2018, 9-digit country code for Scotland. Council area labels, Country labels
CAQF text Qualifier for CA. Qualifier information
AgeGroup text Refers to the patient's age. Ages have been arranged in five different groups.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The patient's sex.
SexQF text Qualifier for Sex. Qualifier information
Diagnosis text The patient's diagnosis.
NumberOfDeaths numeric The total number of deaths.
NumberOfDeathsQF text Qualifier for NumberOfDeaths. Qualifier information
CrudeRate numeric The crude rate per 100,00 population.
CrudeRateQF text Qualifier for CrudeRate. Qualifier information
EASR numeric The European Age-Sex Standardised Rate per 100,000 population.

Population estimates

Population estimates for all geography types in Scotland.

Data Zone (2011) Population Estimates

Population estimates for all 6976 data zone (2011) in Scotland from 2001 to 2021.

Column Type Label Description
Year numeric Year
DataZone text Data Zone 2011 9 digit code Data Zone labels
DataZoneQF text Qualifier for data zone 2011, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Intermediate Zone (2011) Population Estimates

Population estimates for all 1279 intermediate zone (2011) in Scotland from 2001 to 2021.

Column Type Label Description
Year numeric Year
IntZone text Intermediate Zone 2011 9 digit code Intermediate Zone labels
IntZoneQF text Qualifier for intermediate zone 2011, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Council Area (2019) Population Estimates

Population estimates for all 32 council areas (2019) in Scotland from 1981 to 2021.

Column Type Label Description
Year numeric Year
CA text Council Area 2019 9 digit code Council Area labels
CAQF text Qualifier for council area 2019, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Health and Social Care Partnership (2019) Population Estimates

Population estimates for all 31 health and social care partnerships (2019) in Scotland from 1981 to 2021.

Column Type Label Description
Year numeric Year
HSCP text Health and Social Care Partnership 2019 9 digit code Health and Social Care Partnership labels
HSCPQF text Qualifier for health and social care partnership 2019, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Health Board (2019) Population Estimates

Population estimates for all 14 health board (2019) in Scotland from 1981 to 2021.

Column Type Label Description
Year numeric Year
HB text Health Board 2019 9 digit code and country code for Scotland Health board labels Country labels
HBQF text Qualifier for health board 2019, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Data Zone (2001) Population Estimates

Population estimates for all 6505 data zone (2001) in Scotland from 2001 to 2014. From 2011 Data Zones were redrawn and population estimates were rebased from 2011 to 2014.

Column Type Label Description
Year numeric Year
DataZone text Data Zone 2001 9 digit code Data Zone labels
DataZoneQF text Qualifier for 2001 Data Zones, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Intermediate Zone (2001) Population Estimates

Population estimates for all 1235 intermediate zone (2001) in Scotland from 2001 to 2014. From 2011 intermediate zones were redrawn and population estimates were rebased from 2011 to 2014.

Column Type Label Description
Year numeric Year
IntZone text Intermediate Zone 2001 9 digit code Intermediate Zone labels
IntZoneQF text Qualifier for 2001 Intermediate Zones, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Health Board (1995) Population Estimates 1974 - 1980

Population estimates for all 15 health boards (1995) in Scotland from 1974 to 1980.

Column Type Label Description
Year numeric Year
HB text Health Board 1995 code, also included is the Scotland 9 digit code Health board labels
HBQF text Qualifier for health board 1995, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for Sex, indicating totals. Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85plus numeric Number of the population at 85 years of age and over

Health Board (1995) Population Estimates 1981 - 2006

Population estimates for all 15 health boards (1995) in Scotland from 1981 to 2006.

Column Type Label Description
Year numeric Year
HB text Health Board 1995 code, also included is the Scotland 9 digit code Health board labels
HBQF text Qualifier for health board 1995, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for Sex, indicating totals. Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and older

Health Board (2006) Population Estimates

Population estimates for all 14 health boards (2006) in Scotland from 1981 to 2013.

Column Type Label Description
Year numeric Year
HB text Health Board 2006 9 digit code Health board labels
HBQF text Qualifier for health board 2006, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Population Projections

Population projections for Scotland on a country, NHS health board, health and social care partnership and council area level by sex and single year of age.

Council Area Projections

Population projections for Scotland for all 32 council areas for 25 years from the release date.

Column Type Label Description
Year numeric Year
CA text Council Area 2019 9 digit code Council Area labels
CAQF text Qualifier for council area 2019, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Health and Social Care Partnership Projections

Population projections for Scotland for all 31 Health and Social Care Partnerships for 25 years from the release date.

Column Type Label Description
Year numeric Year
HSCP text Health and Social Care Partnership 2019 9 digit code Health and Social Care Partnership labels
HSCPQF text Qualifier for health and social care partnership 2019, denotes Scotland totals and revised GSS codes Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Health Board Projections

Population projections for Scotland for all 14 NHS health boards for 25 years from the release date.

Column Type Label Description
Year numeric Year
HB text Health Board 2006 9 digit code Health board labels
HBQF text Qualifier for health board 2006, denotes Scotland totals Qualifier information
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Scotland Projections

Population projections for Scotland on a country level for 25 years from the release date.

Column Type Label Description
Year numeric Year
Country text 9 digit country code for Scotland Country labels
Sex text Sex
SexQF text Qualifier for sex Qualifier information
AllAges numeric Total population for all ages at the geography level
Age0 numeric Number of the population at less than 12 months of age
Age1 numeric Number of the population at one year of age
Age2 numeric Number of the population at two years of age
Age3 numeric Number of the population at three years of age
Age4 numeric Number of the population at four years of age
Age5 numeric Number of the population at five years of age
Age6 numeric Number of the population at six years of age
Age7 numeric Number of the population at seven years of age
Age8 numeric Number of the population at eight years of age
Age9 numeric Number of the population at nine years of age
Age10 numeric Number of the population at ten years of age
Age11 numeric Number of the population at 11 years of age
Age12 numeric Number of the population at 12 years of age
Age13 numeric Number of the population at 13 years of age
Age14 numeric Number of the population at 14 years of age
Age15 numeric Number of the population at 15 years of age
Age16 numeric Number of the population at 16 years of age
Age17 numeric Number of the population at 17 years of age
Age18 numeric Number of the population at 18 years of age
Age19 numeric Number of the population at 19 years of age
Age20 numeric Number of the population at 20 years of age
Age21 numeric Number of the population at 21 years of age
Age22 numeric Number of the population at 22 years of age
Age23 numeric Number of the population at 23 years of age
Age24 numeric Number of the population at 24 years of age
Age25 numeric Number of the population at 25 years of age
Age26 numeric Number of the population at 26 years of age
Age27 numeric Number of the population at 27 years of age
Age28 numeric Number of the population at 28 years of age
Age29 numeric Number of the population at 29 years of age
Age30 numeric Number of the population at 30 years of age
Age31 numeric Number of the population at 31 years of age
Age32 numeric Number of the population at 32 years of age
Age33 numeric Number of the population at 33 years of age
Age34 numeric Number of the population at 34 years of age
Age35 numeric Number of the population at 35 years of age
Age36 numeric Number of the population at 36 years of age
Age37 numeric Number of the population at 37 years of age
Age38 numeric Number of the population at 38 years of age
Age39 numeric Number of the population at 39 years of age
Age40 numeric Number of the population at 40 years of age
Age41 numeric Number of the population at 41 years of age
Age42 numeric Number of the population at 42 years of age
Age43 numeric Number of the population at 43 years of age
Age44 numeric Number of the population at 44 years of age
Age45 numeric Number of the population at 45 years of age
Age46 numeric Number of the population at 46 years of age
Age47 numeric Number of the population at 47 years of age
Age48 numeric Number of the population at 48 years of age
Age49 numeric Number of the population at 49 years of age
Age50 numeric Number of the population at 50 years of age
Age51 numeric Number of the population at 51 years of age
Age52 numeric Number of the population at 52 years of age
Age53 numeric Number of the population at 53 years of age
Age54 numeric Number of the population at 54 years of age
Age55 numeric Number of the population at 55 years of age
Age56 numeric Number of the population at 56 years of age
Age57 numeric Number of the population at 57 years of age
Age58 numeric Number of the population at 58 years of age
Age59 numeric Number of the population at 59 years of age
Age60 numeric Number of the population at 60 years of age
Age61 numeric Number of the population at 61 years of age
Age62 numeric Number of the population at 62 years of age
Age63 numeric Number of the population at 63 years of age
Age64 numeric Number of the population at 64 years of age
Age65 numeric Number of the population at 65 years of age
Age66 numeric Number of the population at 66 years of age
Age67 numeric Number of the population at 67 years of age
Age68 numeric Number of the population at 68 years of age
Age69 numeric Number of the population at 69 years of age
Age70 numeric Number of the population at 70 years of age
Age71 numeric Number of the population at 71 years of age
Age72 numeric Number of the population at 72 years of age
Age73 numeric Number of the population at 73 years of age
Age74 numeric Number of the population at 74 years of age
Age75 numeric Number of the population at 75 years of age
Age76 numeric Number of the population at 76 years of age
Age77 numeric Number of the population at 77 years of age
Age78 numeric Number of the population at 78 years of age
Age79 numeric Number of the population at 79 years of age
Age80 numeric Number of the population at 80 years of age
Age81 numeric Number of the population at 81 years of age
Age82 numeric Number of the population at 82 years of age
Age83 numeric Number of the population at 83 years of age
Age84 numeric Number of the population at 84 years of age
Age85 numeric Number of the population at 85 years of age
Age86 numeric Number of the population at 86 years of age
Age87 numeric Number of the population at 87 years of age
Age88 numeric Number of the population at 88 years of age
Age89 numeric Number of the population at 89 years of age
Age90plus numeric Number of the population at 90 years of age and over

Standard Populations

There are two methods of standardising: direct and indirect. Both methods rely upon reference to a single standard population, which has a known population structure (in the case of direct standardisation) or known age-specific rates (in the case of indirect standardisation). The choice of standard population is important, as it influences the standardised rates or ratios obtained.

European Standard Population

Different countries across Europe have different population structures - some have higher percentages of young people, whilst others have a greater proportion of old people. Therefore in order to compare more accurately information on the rates of illness and death it is helpful to adjust the figures for each country to show what would be happening if each country had the same population structure. The European Standard Population (ESP) is a theoretical population adding up to a total of 100,000 which is widely used to produce European age-standardised rates. This data has been created which is based on an average of states' population projections for 2011 - 2030.

Column Type Label Description
AgeGroup text Five year age groups in years
EuropeanStandardPopulation numeric Number of the standard population to be used for standardisation purposes

European Standard Population by Sex

Different countries across Europe have different population structures - some have higher percentages of young people, whilst others have a greater proportion of old people. Therefore in order to compare more accurately information on the rates of illness and death it is helpful to adjust the figures for each country to show what would be happening if each country had the same population structure. The European Standard Population (ESP) is a theoretical population adding up to a total of 100,000 which is widely used to produce European age-standardised rates. This data has been created which is based on an average of states' population projections for 2011 - 2030.

Column Type Label Description
AgeGroup text Five year age groups in years
Sex text Sex of the standard population
EuropeanStandardPopulation numeric Number of the standard population to be used for standardisation purposes

World Standard Population

The World standard population is based on the populations of 46 countries and was developed in 1960. It is used to produce world standardised rates. It is a much ‘younger’ population compared to the population of Scotland (and other Western European countries). However, as the World standard population is a very ‘young’ population, it is generally less appropriate for Scottish data than the European standard population and is only be used for particular purposes.

Column Type Label Description
AgeGroup text Five year age groups in years
WorldStandardPopulation numeric Number of the standard population to be used for standardisation purposes

World Standard Population by Sex

The World standard population is based on the populations of 46 countries and was developed in 1960. It is used to produce world standardised rates. It is a much ‘younger’ population compared to the population of Scotland (and other Western European countries). Also, like the European standard population, the World standard population has equal numbers of males and females within an age band.However, as the World standard population is a very ‘young’ population, it is generally less appropriate for Scottish data than the European standard population and is only be used for particular purposes.

Column Type Label Description
AgeGroup text Five year age groups in years
Sex text Sex of the standard population
WorldStandardPopulation numeric Number of the standard population to be used for standardisation purposes

Substance use

Scottish Drug Misuse Database

The Scottish Drug Misuse Database (SDMD) report provide an annual update to figures on the number of individuals presenting for assessment at specialist drug treatment services.

DMD By Health Board and Demographics

Information on the number of individuals presenting for assessment at specialist drug treatment services in Scotland presented at health board level, broken down by age and sex.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
HBR text 9- digit code for Health Board of residence, based on boundaries as at 1st April 2014 from 2010/11 onwards, and boundaries as at time of event prior to 2010/2011 Health Board labels, Country codes
HBRQF text Qualifier for HB Qualifier information
AgeGroup text The age group of the patient in 5 year age brackets. Also includes people of unknown age.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The sex of the patient.
SexQF text Qualifier for Sex. Qualifier information
NumberAssessed numeric The number of individuals being assessed for treatment.
NumberQF text
PercentAssessed numeric The percentage of people in age and sex categories. The denominator is the number of individuals assessed for treatment within location.
PercentQF text

SDMD By Council Area and Demographics

Information on the number of individuals presenting for assessment at specialist drug treatment services in Scotland presented at council area level, broken down by age and sex.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
CA text 9- digit code for Council area of residence, based on the boundaries as at the time of event Council Area labels, Country codes
CAQF text Qualifier for CA Qualifier information
AgeGroup text The age group of the patient in 5 year age brackets. Also includes people of unknown age.
AgeGroupQF text Qualifier for AgeGroup. Qualifier information
Sex text The sex of the patient.
SexQF text Qualifier for Sex. Qualifier information
NumberAssessed numeric The number of individuals being assessed for treatment.
NumberQF text
PercentAssessed numeric The percentage of people in age and sex categories. The denominator is the number of individuals assessed for treatment within location.
PercentQF text

SDMD By Health Board and Treatment Group

Information on the number of individuals presenting for assessment at specialist drug treatment services in Scotland at health board level, broken down by treatment group.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
HBR text 9- digit code for Health Board of residence, based on boundaries as at 1st April 2014 from 2010/11 onwards, and boundaries as at time of event prior to 2010/2011 Health Board labels, Country codes
HBRQF text Qualifier for HBR Qualifier information
TreatmentGroup text Individuals assessed for drug treatment presenting different conditions. Individuals may belong to more than one treatment group.
TreatmentGroupQF text Qualifier for TreatmentGroup Qualifier information
NumberAssessed numeric The number of individuals being assessed for treatment.
NumberQF text
PercentAssessed numeric The percentage of people in treatment group. The denominator is the number of individuals assessed for treatment within location.
PercentQF text

SDMD By Council Area and Treatment Group

Information on the number of individuals presenting for assessment at specialist drug treatment services in Scotland presented at council area level, broken down by treatment group.

Column Type Label Description
FinancialYear text Data is for financial years (1st April to 31st March)
CA text 9- digit code for Council area of residence, based on the boundaries as at the time of event Council Area labels, Country codes
CAQF text Qualifier for CA Qualifier information
TreatmentGroup text Individuals assessed for drug treatment presenting different conditions. Individuals may belong to more than one treatment group.
TreatmentGroupQF text Qualifier for TreatmentGroup Qualifier information
NumberAssessed numeric The number of individuals being assessed for treatment.
NumberQF text
PercentAssessed numeric The percentage of people in treatment group. The denominator is the number of individuals assessed for treatment within location.
PercentQF text

ARCHIVED - Drug and Alcohol Treatment Waiting Times

As of 27/09/2022, this dataset has been superseded by a new version.

This data provides a quarterly update on waiting times for people accessing specialist drug and alcohol treatment services. In 2011, the Scottish Government set a standard that 90% of people referred for help with problematic drug or alcohol use will wait no longer than three weeks for specialist treatment that supports their recovery. This data was extracted from the new Drug and Alcohol Information System (DAISy) and its predecessor the Drug and Alcohol Treatment Waiting Times (DATWT) database. DAISy was implemented in four NHS Boards (Ayrshire & Arran, Dumfries & Galloway, Grampian and Western Isles) from December 2020, and was available in all NHS Boards from April 2021.

Completed Waits by NHS Board

Information on waiting times for completed treatment referrals to specialist drug and alcohol services at NHS board level.

Column Type Label Description
Quarter text Quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels , Country labels
HBTQF text Qualifier for HBT, indicating the data which was derived at a health board level. For some prison health boards there is no prisons data. This is due to there not being a drug or alcohol treatment service available within prisons in that health board. Services change frequently so this may change over time. Qualifier information
SubstanceType text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol).
SubstanceTypeQF text Qualifier for SubstanceType, not applicable indicates that this data item is not reported by the respective location. Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

Completed Waits by Alcohol and Drug Partnership

Information on waiting times for completed treatment referrals to specialist drug and alcohol services at Alcohol and Drug Partnership (ADP) level.

Column Type Label Description
Quarter text Quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
ADP text Alcohol and Drug Partnership
ADPQF text Qualifier for ADP Qualifier information
SubstanceType text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol).
SubstanceTypeQF text Qualifier for SubstanceType, indicating the data which was derived at an substance used level. Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

Ongoing Waits by NHS Board

Information on waiting times for ongoing treatment referrals to specialist drug and alcohol services at NHS board level.

Column Type Label Description
Quarter text Calendar year and quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels , Country labels
HBTQF text Qualifier for HBT, indicating the data which was derived at a health board level. For some prison health boards there is no prisons data. This is due to there not being a drug or alcohol treatment service available within prisons in that health board. Services change frequently so this may change over time. Qualifier information
SubstanceType text Qualifier for SubstanceType, not applicable indicates that this data item is not reported by the respective location.
SubstanceTypeQF text Qualifier for SubstanceType, not applicable indicates that this data item is not reported by the respective location. Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

Ongoing Waits by Alcohol and Drug Partnership

Information on waiting times for ongoing treatment referrals to specialist drug alcohol services at Alcohol and Drug Partnership (ADP) level.

Column Type Label Description
Quarter text Quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels
ADP text Alcohol and Drug Partnership
ADPQF text Qualifier for ADP Qualifier information
SubstanceType text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol).
SubstanceTypeQF text Qualifier for SubstanceType, not applicable indicates that this data item is not reported by the respective location. Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

Completed Waits in Prisons

Information on waiting times for completed treatment referrals to specialist drug and alcohol treatments services at prisons in Scotland.

Column Type Label Description
Quarter text Calendar year and quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels , Country labels
ADP text Alcohol and Drug Partnership
ADPQF text Qualifier for ADP, not applicable indicates that this data item is not reported by the respective location. Qualifier information
SubstanceType text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol).
SubstanceTypeQF text Qualifier for SubstanceType, not applicable indicates that this data item is not reported by the respective location. Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

Ongoing Waits in Prisons

Information on waiting times for ongoing treatment referrals to specialist drug and alcohol services at prisons in Scotland.

Column Type Label Description
Quarter text Calendar year and quarter the data pertains to
HBT text Health Board of treatment based on boundaries as at 1st April 2019 Health board labels , Country labels
ADP text Alcohol and Drug Partnership
ADPQF text Qualifier for ADP, not applicable indicates that this data item is not reported by the respective location.
SubstanceType text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol).
SubstanceTypeQF text Substance type people were receiving treatment for: Drugs, Alcohol or Co-dependency (both drugs and alcohol). Qualifier information
TotalNumberOfReferrals numeric Total number of referrals for a first drug or alcohol treatment.
PercentWaitUpTo1Week numeric Percentage of TotalNumberOfReferrals that involved a wait of one week or less.
PercentWaitOver1WeekAndUpTo2Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over one week and up to two weeks.
PercentWaitOver2WeeksAndUpTo3Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over two weeks and up to three weeks.
PercentWaitOver3WeeksAndUpTo4Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over three weeks and up to four weeks.
PercentWaitOver4WeeksAndUpTo5Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over four weeks and up to five weeks.
PercentWaitOver5WeeksAndUpTo6Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over five weeks and up to six weeks.
PercentWaitOver6WeeksAndUpTo8Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over six weeks and up to eight weeks.
PercentWaitOver8WeeksAndUpTo12Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over eight weeks and up to 12 weeks.
PercentWaitOver12WeeksAndUpTo16Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 12 weeks and up to 16 weeks.
PercentWaitOver16WeeksAndUpTo20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 16 weeks and up to 20 weeks.
PercentWaitOver20Weeks numeric Percentage of TotalNumberOfReferrals that involved a wait of over 20 weeks.

NHS Smoking Cessation Service Statistics (Scotland)

This release presents data on quit attempts made with the help of NHS Stop Smoking Services during the financial years, 2010/11 – 2021/22, and the outcomes of those quit attempts. Information is presented at national, NHS Board and Local Authority level along with breakdowns including age, gender, and deprivation.

Statistics are based on total ‘quit attempts’ made during the year, rather than total number of clients with a quit attempt, so could include repeat quit attempts for the same client.

Smoking Cessation by Gender and Age

Information on smoking cessation broken down by gender and age.

Column Type Label Description
FinancialYear text Financial Year (Apr-Mar)
Gender text Gender
GenderQF text Qualifier for Gender Qualifier information
AgeGroup text Age group
AgeGroupQF text Qualifier for AgeGroup Qualifier information
NumberQuitAttempts numeric Number of quit attempts (the number of quit attempts may include repeat quit attempts for the same client)
NumberFourWeekQuits numeric Number of successful quits at 4-week follow-up where the client self-reported as ‘not smoked, even a puff, in the last two weeks’
NumberTwelveWeekQuits numeric Number of successful quits at 12-week follow-up where the client self-reported as ‘not smoked' or 'smoked up to five cigarettes since four-week follow-up’
FourWeekQuitRate numeric Percentage of successful quits at 4-week follow-up
TwelveWeekQuitRate numeric Percentage of successful quits at 12-week follow-up

Smoking Cessation by Health Board

Information on smoking cessation broken down by health board of treatment.

Column Type Label Description
FinancialYear text Financial Year (Apr-Mar)
HBT text NHS Board of Treatment (2019) Health board labels
HBTQF text Qualifier for HBT Qualifier information
NumberQuitAttempts numeric Number of quit attempts (the number of quit attempts may include repeat quit attempts for the same client)
NumberFourWeekQuits numeric Number of successful quits at 4-week follow-up where the client self-reported as ‘not smoked, even a puff, in the last two weeks’
NumberTwelveWeekQuits numeric Number of successful quits at 12-week follow-up where the client self-reported as ‘not smoked' or 'smoked up to five cigarettes since four-week follow-up’Number of successful quits at 12-week follow-up where the client self-reported as ‘not smoked' or 'smoked up to five cigarettes since four-week follow-up’
FourWeekQuitRate numeric Percentage of successful quits at 4-week follow-up
TwelveWeekQuitRate numeric Percentage of successful quits at 12-week follow-up

Smoking Cessation by Council Area

Information on smoking cessation broken down by council area of residence.

Column Type Label Description
FinancialYear text Financial Year (Apr-Mar)
CA text Council Area of Residence Council area labels
CAQF text Qualifier for CA Qualifier information
NumberQuitAttempts numeric Number of quit attempts (the number of quit attempts may include repeat quit attempts for the same client)
NumberFourWeekQuits numeric Number of successful quits at 4-week follow-up where the client self-reported as ‘not smoked, even a puff, in the last two weeks’
NumberTwelveWeekQuits numeric Number of successful quits at 12-week follow-up where the client self-reported as ‘not smoked' or 'smoked up to five cigarettes since four-week follow-up’
FourWeekQuitRate numeric Percentage of successful quits at 4-week follow-up
TwelveWeekQuitRate numeric Percentage of successful quits at 12-week follow-up

Smoking Cessation by Deprivation

Information on smoking cessation broken down by Scotland level deprivation quintiles

Column Type Label Description
FinancialYear text Financial Year (Apr-Mar)
SIMDQuintile numeric Scottish Index of Multiple Deprivation - Scotland level quintile (1 = most deprived, 5 = least deprived) SIMD open data
NumberQuitAttempts numeric Number of quit attempts (the number of quit attempts may include repeat quit attempts for the same client)
NumberFourWeekQuits numeric Number of successful quits at 4-week follow-up where the client self-reported as ‘not smoked, even a puff, in the last two weeks’
NumberTwelveWeekQuits numeric Number of successful quits at 12-week follow-up where the client self-reported as ‘not smoked' or 'smoked up to five cigarettes since four-week follow-up’
FourWeekQuitRate numeric Percentage of successful quits at 4-week follow-up
TwelveWeekQuitRate numeric Percentage of successful quits at 12-week follow-up

Workforce

Allied Health Professional Vacancies

Information on open allied health professional vacancies taken at a census point, for each NHS board, broken down by profession and pay bands. A vacancy is a post which has been cleared for advert after being through the redeployment process (internal or external advert) and remains a vacancy until an individual starts in the post. All data is presented as whole time equivalents.

Vacancies December 2019

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 31st of December 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies September 2019

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 30th of September 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies June 2019

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 30th of June 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies March 2019

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 31st of March 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies December 2018

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 31st of December 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies September 2018

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 30th of September 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
VacantLessThan3Months numeric Vacancies open for up to 3 months
VacantLessThan3MonthsQF text Qualifier for VacantLessThan3Months Qualifier information
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies June 2018

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 30th of June 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
VacantLessThan3Months numeric Vacancies open for up to 3 months
VacantLessThan3MonthsQF text Qualifier for VacantLessThan3Months Qualifier information
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Vacancies March 2018

Number of vacancies and posts under review for Allied Health Professionals within NHS Scotland as of the 31st of March 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
BandGroup text Agenda for change pay bands
BandGroupQF text Qualifier for BandGroup Qualifier information
JobSubFamily text The sub area of allied health profession of the vacancy
JobSubFamilyQF text Qualifier for JobSubFamily Qualifier information
Establishment numeric The total number of posts allocated to the specific sub area of allied health profession, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific sub area of allied health profession, in a specific band for each board
PostsUnderReview numeric Number of posts under review
TotalVacancies numeric Total number of Vacancies
VacantLessThan3Months numeric Vacancies open for up to 3 months
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
VacantUnknown numeric Vacancies that are open for an unknown amount of time

Consultant Vacancies

Information on open consultant vacancies taken at a census point, for each NHS board, broken down by speciality.

A vacancy is a post which has been cleared for advert after being through the redeployment process (internal or external advert) and remains a vacancy until an individual starts in the post. All data is presented as whole time equivalents.

Vacancies December 2019

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 31st of December 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric code for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies September 2019

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 30th of September 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric code for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies June 2019

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 30th of June 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric code for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies March 2019

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 31st of March 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric code for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies December 2018

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 31st of December 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric code for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies September 2018

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 30th of September 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Vacancies June 2018

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 30th of June 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric for health specialties Specialty labels
SpecialtyQF text Qualifier for Specialty Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
VacanciesGreater6Months numeric Vacancies open for 6 months or more
VacanciesGreater6MonthsQF text Qualifier for VacanciesGreater6Months Qualifier information

Vacancies March 2018

Number of vacancies and posts under review for Consultants within NHS Scotland as of the 31st of March 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
Specialty text Alphanumeric for health specialities Specialty labels
SpecialtyQF text Qualifier for Speciality Qualifier information
Establishment numeric The total number of posts allocated to specific specialities, in a specific grade for each board
StaffInPost numeric Staff currently in post in the specific specialities, in a specific grade for each board
TotalVacancies numeric Total number of vacancies
VacanciesGreater6Months numeric Vacancies open for 6 months or more

Nursing and Midwifery Vacancies

Information on open nursing and midwifery vacancies taken at a census point, for each NHS board, broken down by profession and pay bands. A vacancy is a post which has been cleared for advert after being through the redeployment process (internal or external advert) and remains a vacancy until an individual starts in the post. All data is presented as whole time equivalents.

Vacancies December 2019

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 31st of December 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

Vacancies September 2019

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 30th of September 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

Vacancies June 2019

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 30th of June 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2019) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

Vacancies March 2019

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 31st of March 2019.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

Vacancies December 2018

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 31st of December 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

Vacancies September 2018

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 30th of September 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
Vacant3MonthsOrMoreQF text Qualifier for Vacant3MonthsOrMore Qualifier information
PostsUnderReview numeric Number of posts under review

Vacancies June 2018

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 30th of June 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
Vacant3MonthsOrMoreQF text Qualifier for Vacant3MonthsOrMore Qualifier information
PostsUnderReview numeric Number of posts under review

Vacancies March 2018

Number of vacancies and posts under review for Nursing and Midwifery within NHS Scotland as of the 31st of March 2018.

Column Type Label Description
Date numeric Date on which the data has been collated
HB text 9-digit code for health board (2018) and 6-digit codes for special health boards. The Scotland total is also included. Health board labels Special health board labels
HBQF text Qualifier for HB, indicating Scotland totals Qualifier information
WorkforceRegionGrouping text The workforce region the vacancy is in
SubJobFamily text The sub area of nursing of the vacancy
AFCBand text Agenda for change pay bands
Establishment numeric The total number of posts allocated to the specific area of nursing or midwifery, in a specific band for each board
EstablishmentQF text Qualifier for Establishment Qualifier information
StaffInPost numeric Staff currently in post in the specific area of nursing or midwifery, in a specific band for each board
TotalVacancies numeric Total number of Vacancies
TotalVacanciesQF text Qualifier for TotalVacancies Qualifier information
Vacant3MonthsOrMore numeric Vacancies open for 3 months or more
PostsUnderReview numeric Number of posts under review

2. Practitioners services

Dental Practices and Patient Registrations

This dataset contains address data and practice sizes for all NHS dental practices in Scotland.

Dental Practices

Address details and list sizes for all NHS dental practices in Scotland, as at September and December 2018; March, June, September, and December 2019; March, June, September, and December 2020; March, June, September, and December 2021; and March, September, and December 2022.

Column Type Label Description
DentalPracticeCode numeric Numeric dental practice location code
AddressLine1 text Name of Dental Practice - first line of dental practice address
AddressLine2 text Second line of dental practice address
AddressLine3 text Third line of dental practice address
Postcode text Postcode of dental practice
HB text Health board code (2018) for location of dental practice Health board labels
HSCP text Health and Social Care Partnership (2018) code for location of dental practice HSCP labels
CA text Council Area code (2018) for location of dental practice Council area labels
DataZone text Data zone code (2011) for location of dental practice Data Zone labels
Registrations numeric The number of patients registered with the GP practice, also referred to as list size
RegistrationsQF text Qualifier for Registrations Qualifier information

GP Practice Contact Details and List Sizes

This dataset contains information on contact details and list sizes for all GP practices in Scotland.

Column Type Label Description
PracticeCode numeric Five digit numeric GP practice code
PracticeName text Name of the GP practice
PracticeListSize numeric The number of patients registered with the GP practice
AddressLine1 text Address Line 1 of the GP practice
AddressLine2 text Address Line 2 of the GP practice
AddressLine3 text Address Line 3 of the GP practice
AddressLine4 text Address Line 4 of the GP practice
Postcode text Postcode of the GP practice
TelephoneNumber text Telephone number of the GP practice
PracticeType text GP practice contract type
Dispensing text Whether the practice is a dispensing practice (Y/N)
HB text Health board Code (2014) for GP practice Health board labels
HSCP text Health and Social Care Partnership Code (2016) for GP practice Health and Social Care Partnership labels
CA text Council area Code (2011) for GP practice Council area labels
DataZone text Datazone Code (2011) for GP practice Data Zone 2011 labels

GP Practice Population Demographics

This dataset contains information on list sizes for all GP practices in Scotland by age and sex.

Column Type Label Description
Date numeric Date on which data was extracted
PracticeCode numeric Five digit numeric GP Practice Code GP Practice labels
HB text Health board code for GP Practice (2014) Health board labels
HSCP text Health and Social Care Partnership Code for GP Practice (2016) Health and Social Care Partnership labels
Sex text The Sex of the registered patients as Male, Female or All
SexQF text Qualifier for Sex Qualifier information
AllAges numeric Total number of registered patients
Ages0to4 numeric Number of registered patients aged 0-4 years
Ages0To4QF text Qualifier for Ages0To4QF Qualifier information
Ages5to14 numeric Number of registered patients aged 5-14 years
Ages5To14QF text Qualifier for Ages5To14 Qualifier information
Ages15to24 numeric Number of registered patients aged 15-24 years
Ages15To24QF text Qualifier for Ages15To24 Qualifier information
Ages25to44 numeric Number of registered patients aged 25-44 years
Ages25To44QF text Qualifier for Ages25To44 Qualifier information
Ages45to64 numeric Number of registered patients aged 45-64 years
Ages45To64QF text Qualifier for Ages45To64 Qualifier information
Ages65to74 numeric Number of registered patients aged 65-74 years
Ages65To74QF text Qualifier for Ages65To74 Qualifier information
Ages75to84 numeric Number of registered patients aged 75-84 years
Ages75To84QF text Qualifier for Ages75To84 Qualifier information
Ages85plus numeric Number of registered patients aged 85 years and over
Ages85PlusQF text Qualifier for Ages85Plus Qualifier information

General Practitioner Contact Details

This dataset contains a lookup file of contact details for General Practitioners (GPs) and the practice they are registered at. The information includes General Medical Council (GMC) number, address, telephone details of their practice.

Column Type Label Description
GeneralMedicalCouncilNumber numeric General Medical Council number of general practitioner
GPDesignation text The designation of the GP as Performer, Performer Registrar, Performer Retainee or Performer Salaried
Forename text Forename of general practitioner
MiddleInitial text Middle initial of general practitioner
Surname text Surname of general practitioner
Sex text Sex of general practitioner
PracticeCode numeric Five digit numeric GP Practice Code GP Practice labels
GPPracticeName text Name of GP Practice
AddressLine1 text Address line 1 of GP Practice
AddressLine2 text Address line 2 of GP Practice
AddressLine3 text Address line 3 of GP Practice
AddressLine4 text Address line 4 of GP Practice
Postcode text Postcode of GP Practice
TelephoneNumber text Telephone number of GP Practice
HB text Health board Code (2019) of GP Practice Health board labels
HSCP text Health and Social Care Partnership code of GP Practice Health and Social Care Partnership labels