- Acute Hospital Care Performance Measure Episodes Comparison for Inpatient and Daycase Activity
- Acute Hospitals' Quality of Care Comparison for Inpatient Episodes By Health Board Residence
- Hospital Care Inpatient Episodes Data By Sex, Age, SIMD and Speciality
- Acute Care Hospitals
- Scotland Hospital Admissions
- Inpatient and Daycase Hospitals
- Scotland Inpatient Activity
- Scotland Emergency Admissions
- Scotland Elective Admissions
Inpatient and Daycase Activity Episodes By Health Board Residence
This dataset includes information split by location for health board of residence, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for episodes and length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity for acute hospital care services.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
The quarterly acute hospital activity publication provides data on outpatient activity, inpatient and day case activity and beds for National Health Service (NHS) Scotland. This data release covers the period from the quarter ending March 2013 to the quarter ending September 2019. The aim of this dataset is to summarize the completeness of the data used in the publication and provide details of known issues with national data affecting this release. NHS Ayrshire & Arran has suggested that there may be some affected records before January 2016. The Board is used to implement a change to ensure that no additional records are generated when patients are transferred to discharge lounges, which should take place in the near future. The data used NHS Ayrshire & Arran also suggested that the decreases in elective inpatient admissions can be attributed to winter pressures:
NHS Borders: Decreases were observed in elective inpatient admissions, whilst increases were seen in internal transfer activity. NHS Borders has suggested that inpatients falls are in General Surgery and Orthopaedics.
NHS Dumfries & Galloway: Dumfries & Galloway Royal Infirmary (Y104H) moved location in December 2017, and inpatient and day case (SMR01) episodes are now recorded under a new code Y146H.
NHS Fife: Decreases were observed in elective inpatient admissions and day cases. Internal transfer activity has increased.
NHS Forth Valley: Decreases were seen in elective inpatient admissions and day cases.
NHS Greater Glasgow & Clyde: Decreases in elective and emergency inpatient admissions, and day cases whilst internal transfer activity increased. NHS Greater Glasgow and Clyde have advised that their backlog of SMR01s / completeness levels will be impacting on their submitted data / activity.
NHS Highland: Decreases in elective inpatient admissions and internal transfers whilst day case activity increased. NHS Highland has suggested that the increases in day cases are due to the way in which Ambulatory Emergency Care patients are now reported in SMR01.
NHS Lanarkshire: Decreases in elective admissions and day case activity.
NHS Lothian: Increases were observed in internal transfers. NHS Lothian has observed at the source records for some of these internal transfer patients in Trakcare and identified admission records which are not being included when submitted to Information Services Division (ISD).
NHS Orkney: Increases in elective admissions, emergency admissions and day cases.
NHS Shetland: Decreases in all inpatient and daycase activity elective admissions, emergency admissions and day cases.
NHS Tayside: Decreases in elective inpatient admissions and day case activity.
NHS Western Isles: Increases in elective and emergency admissions whilst declines were witnessed in day case and transfer activity.
Golden Jubilee: Decreases were observed in elective and emergency admissions. However, it should be noted that any changes are based on relatively small numbers which will impact on the percentage change.
This data has been used to assess the performance of these services, to plan for future needs, to look at quality improvement, to see how services are changing over time and many other uses.
About this Dataset
1st April 2017 to 31st December 2021
John Snow Labs; Information Services Division (ISD) Scotland;
|Source License URL|
|Source License Requirements||
Acute Care Hospitals, Scotland Hospital Admissions, Inpatient and Daycase Hospitals, Scotland Inpatient Activity, Scotland Emergency Admissions, Scotland Elective Admissions
Acute Hospital Care Performance Measure Episodes Comparison for Inpatient and Daycase Activity, Acute Hospitals' Quality of Care Comparison for Inpatient Episodes By Health Board Residence, Hospital Care Inpatient Episodes Data By Sex, Age, SIMD and Speciality
|Quarter_Date||Indicates the final date of the quarter.||date||-|
|Quarter_Coverage||Indicates the quarter period in text format.||string||-|
|Health_Board_Code||Indicates either the 9 digit health board code or "scot" for Scotland. For the residence data files, the Health board code and name is in relation to the health board of residence. For the treatment data files, the Health board code and name is in relation to the health board of treatment.||string||-|
|Health_Board_Name||Indicates the health board name.||string||-|
|Location_Code||Indicates either the 5 digit hospital code; 9 digit health board or council code; or “scot” for Scotland.||string||-|
|Location_Name||Indicates the name of the location.||string||-|
|Measure||Indicates inpatient/admissions type: elective inpatients; emergency inpatients; transfers; all daycases; all inpatients; all inpatients and daycases.||string||-|
|Inpatient_And_Daycase_Activity_Variables||Indicates the variables of inpatient and daycase activity for health board residence.||string||-|
|Variable_Code||Indicates the variable code of inpatient and daycase activity for health board residence.||string||-|
|Variable_Description||Indicates the variable description of inpatient and daycase activity for health board residence.||string||-|
|Variable_Rating||Indicates the variable rating of inpatient and daycase activity for health board residence.||integer||level : Ordinal|
|Episodes||Indicates the number of episodes.||integer||level : Ratio|
|Length_of_Stay||Indicates the total length of stay.||integer||level : Ratio|
|Average_Length_of_Stay||Indicates the average length of stay.||number||level : Ratio|
|Quarter Date||Quarter Coverage||Health Board Code||Health Board Name||Location Code||Location Name||Measure||Inpatient And Daycase Activity Variables||Variable Code||Variable Description||Variable Rating||Episodes||Length of Stay||Average Length of Stay|
|2017-06-30||Apr - Jun-17||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||753||2298||3.0518|
|2017-09-30||Jul - Sep-17||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||744||2594||3.4866|
|2017-12-31||Oct - Dec-17||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||784||2631||3.3559|
|2018-03-31||Jan - Mar-18||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||684||2156||3.152|
|2018-06-30||Apr - Jun-18||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||705||1863||2.6426|
|2018-09-30||Jul - Sep-18||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||653||1684||2.5789|
|2018-12-31||Oct - Dec-18||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||705||1892||2.6837|
|2019-03-31||Jan - Mar-19||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||773||1606||2.0776|
|2019-06-30||Apr - Jun-19||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||747||1675||2.2423|
|2019-09-30||Jul - Sep-19||S08000015||NHS Ayrshire & Arran||S12000008||East Ayrshire||Elective Inpatients||All||651||1963||3.0154|