Activity by Board of Residence and Specialty

URL: https://www.opendata.nhs.scot/dataset/d73b93ab-b09f-4d39-9cfb-0e5e34085803/resource/d59528c3-0a61-4fdd-8ed9-f6822838c78c/download/inpatient_and_daycase_by_nhs_board_of_residence_and_specialty.csv

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

Size: 14.6MB

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

Download resource

Data Dictionary

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

Additional Information

Field Value
Data last updated May 28, 2024
Metadata last updated November 14, 2019
Created November 14, 2019
Format text/csv
License UK Open Government Licence (OGL)
createdover 4 years ago
datastore activeTrue
formatCSV
has viewsTrue
idd59528c3-0a61-4fdd-8ed9-f6822838c78c
last modified23 hours ago
mimetypetext/csv
on same domainTrue
package idd73b93ab-b09f-4d39-9cfb-0e5e34085803
position3
revision id2cc36d53-337a-4e58-9835-4f38d7317ef6
size15.5 MiB
stateactive
url typeupload