Activity by Board of Residence and Deprivation

URL: https://www.opendata.nhs.scot/dataset/d73b93ab-b09f-4d39-9cfb-0e5e34085803/resource/77d3d413-d7d6-4ad7-b89c-9e30ae75c64e/download/inpatient_and_daycase_by_nhs_board_of_residence_and_simd.csv

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

Size: 2.79MB

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

SIMD numeric Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year

SIMD open data

SIMDQF text Qualifier for SIMD indicating where the quintile is not applicable/unknown

Qualifier information

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

Stays numeric Number of stays
LengthOfStay numeric Total length of stays
AverageLengthOfStay numeric Average length of a stay
AverageLengthOfStayQF text Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable

Qualifier information

Additional Information

Field Value
Data last updated February 27, 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
id77d3d413-d7d6-4ad7-b89c-9e30ae75c64e
last modified1 month ago
mimetypetext/csv
on same domainTrue
package idd73b93ab-b09f-4d39-9cfb-0e5e34085803
position2
revision id111c07b5-606a-4f25-8ea2-5c63d11b2c12
size3 MiB
stateactive
url typeupload