ARHS by Council Area

URL: https://www.opendata.nhs.scot/dataset/c4db1692-fa02-4a1c-af4c-6039c74633ea/resource/b0b520e8-3507-46cd-a9b5-cff03007bb57/download/arhs_council_area_28_02_2023.csv

Data on alcohol related hospital statistics by Council Areas. The Scotland total is also included in the file. Publication Date 17 November 2020

Size: 1.56MB

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

Download resource

Data Dictionary

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

Additional Information

Field Value
Data last updated February 28, 2023
Metadata last updated January 25, 2018
Created January 25, 2018
Format text/csv
License UK Open Government Licence (OGL)
createdover 6 years ago
datastore activeTrue
formatCSV
has viewsTrue
idb0b520e8-3507-46cd-a9b5-cff03007bb57
last modifiedover 1 year ago
mimetypetext/csv
on same domainTrue
package idc4db1692-fa02-4a1c-af4c-6039c74633ea
position2
revision id5c0ba7ee-f7e1-4802-a873-cfc1b6ac1d5b
size2 MiB
stateactive
url typeupload