Activity by Board of Treatment and Specialty

URL: https://www.opendata.nhs.scot/dataset/d73b93ab-b09f-4d39-9cfb-0e5e34085803/resource/c3b4be64-5fb4-4a2f-af41-b0012f0a276a/download/inpatient_and_daycase_by_nhs_board_of_treatment_and_specialty.csv

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

Size: 8.61MB

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 codes for health board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for special board

Health board labels Country labels Special Health Board

HBQF text Qualifier for HB indicating aggregated data

Qualifier information

Location text 5-digit codes for hospital, 9-digit codes for health board of treatment and country code for Scotland and 6-digit codes for special boards

Health board labels Country labels Special Health Board Hospitals

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
idc3b4be64-5fb4-4a2f-af41-b0012f0a276a
last modified23 hours ago
mimetypetext/csv
on same domainTrue
package idd73b93ab-b09f-4d39-9cfb-0e5e34085803
position7
revision idfdf8fcc3-b583-46d7-964f-4a4979bba33a
size9.2 MiB
stateactive
url typeupload