Acute Hospital Outpatient Activity By Health Board Residence

$179 / year

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 new and Did Not Attend (DNA) appointments; and split by specialty and health board of treatment for return and total appointments and the number of attendances for outpatient activity for acute hospital care services.

Complexity

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 March 2018. 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. The data used is sourced from hospital administrative systems across Scotland and extracted from the following three datasets held by Information Services Division (ISD):
– SMR01: The SMR01 dataset comprises episode-based patient records relating to all inpatients and day cases discharged from non-obstetric and non-psychiatric specialties
– SMR00: The SMR00 dataset contains patient-based information on appointments at outpatient clinics in all specialties (except A&E and Genito-Urinary Medicine) in NHS Scotland
– ISD(S)1: ISD(S)1 is the only source of bed occupancy and bed availability data and contains summarised data by NHS Board of Treatment, hospital and specialty

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. There were just over 1 million (1,045,140) outpatient attendances from 1 January to 31 March 2018. Of these, 34 percent (356,257 attendances) were new cases. The remaining 66 percent (688,883 attendances) were patients returning for follow up appointments. 9 percent of new outpatient appointments were not attended without prior warning.

Date Created

2018-05-01

Last Modified

2018-06-26

Version

2018-06-26

Update Frequency

Quarterly

Temporal Coverage

1st January 2013 to 31st March 2018

Spatial Coverage

Scotland

Source

John Snow Labs; Information Services Division (ISD) Scotland;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Health Board of Residence, Scotland Hospital Care, Scotland Outpatient Activity, Scotland Outpatient Appointments, Scotland Outpatient Attendances

Other Titles

Acute Hospital Care Split by Different Outpatient Activity Variables, Hospitals' Quality of Care Comparison for Outpatient Health Board of Residence, Hospital Care Outpatient Appointments and Attendances Records By Sex, Age, SIMD and Speciality

NameDescriptionTypeConstraints
Quarter_DateIdentifies the final date of the quarter.date-
Quarter_CoverageIndicates the quarter period in text format.string-
Health_Board_CodeIndicates 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_NameIndicates the health board name.string-
Location_CodeIndicates either the 5 digit hospital code; 9 digit health board or council code; or “scot” for Scotland.string-
Location_NameIndicates the name of the location.string-
Outpatient_Activity_VariablesIndicates the variables of outpatient activity for health board residence.string-
Variable_CodeIndicates the variable code of outpatient activity for health board residence.string-
Variable_DescriptionIndicates the variable description or rating of outpatient activity for health board residence.string-
Variable_RatingIndicates the variable rating of outpatient activity for health board residence.integerlevel : Ordinal
Appointment_TypeIndicates the type of the appointment for health board residence.string-
CountIndicates the number of appointments.integerlevel : Ratio
RateIndicates only available for DNAs, i.e. DNA (Did Not Attend) rate.numberlevel : Ratio
Quarter DateQuarter CoverageHealth Board CodeHealth Board NameLocation CodeLocation NameOutpatient Activity VariablesVariable CodeVariable DescriptionVariable RatingAppointment TypeCountRate
2013-12-31Oct - Dec-13S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend10159.842901474
2014-03-31Jan - Mar-14S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend9599.345156889
2014-06-30Apr - Jun-14S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend100910.03680493
2014-09-30Jul - Sep-14S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend115411.32482826
2014-12-31Oct - Dec-14S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend9689.792615073
2015-03-31Jan - Mar-15S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend10149.296781883
2015-06-30Apr - Jun-15S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend9149.251012146
2015-09-30Jul - Sep-15S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend8909.09555442
2015-12-31Oct - Dec-15S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend10869.911472118
2016-03-31Jan - Mar-16S08000015NHS Ayrshire & ArranS12000008East AyrshireAllDid Not Attend9499.593610999