Diagnosis

URL: https://www.opendata.nhs.scot/dataset/4ace86c2-2c0f-4620-b544-932148c2c4d3/resource/c6d26491-2268-46e5-8d56-a08fd466aba0/download/mental-health-inpatient-activity-diagnosis-trend.csv

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.

Size: 871KB

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

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

Additional Information

Field Value
Data last updated March 28, 2023
Metadata last updated September 20, 2018
Created September 20, 2018
Format text/csv
License UK Open Government Licence (OGL)
createdover 4 years ago
datastore activeTrue
formatCSV
has viewsTrue
idc6d26491-2268-46e5-8d56-a08fd466aba0
last modified7 hours ago
mimetypetext/csv
on same domainTrue
package id4ace86c2-2c0f-4620-b544-932148c2c4d3
position3
revision id986ef4c1-f2ec-488b-9ff6-3cb748e7d0e1
size947.2 KiB
stateactive
url typeupload