Activity by Location of Treatment, Age and Sex

URL: https://www.opendata.nhs.scot/dataset/9e032286-e5bf-4eb0-837d-c0a05fe0d839/resource/fd11b8ef-6ca8-4298-9c55-4ecf097eeb07/download/inpatient_and_day_case_by_location_of_treatment_age_sex.csv

Age and sex breakdown for inpatient and daycase activity (episode and stays) by location of treatment.

Size: 39.1MB

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

Download resource

Data Dictionary

Column Type Label Description
FinancialYear text The reference period as financial year (YYYY/YY).
FinancialYearQF text Qualifier for FinancialYear

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

HB text 9-digit code for NHS board of treatment, country code for Scotland and 6-digit codes for other residential categories

NHS Board information NHS Special Board information

HBQF text
Location text 5-digit code for location of treatment and country code for Scotland.

Location labels

LocationQF text Qualifier for Location indicating aggregated data.

Qualifier information

Age text
AgeQF text
Sex text
SexQF text
Episodes numeric Number of episodes.
EpisodesQF text Qualifier for Episodes.

Qualifier information

Stays numeric Number of stays.
StaysQF text Qualifier for Stays.

Qualifier information

TotalLengthofEpisode numeric Total length of episodes (days).
TotalLengthofEpisodeQF text Qualifier for TotalLengthofEpisode.

Qualifier information

TotalLengthofStay numeric Total length of stays (days).
TotalLengthofStayQF text Qualifier for TotalLengthofStay.

Qualifier information

AverageLengthofEpisodeRate numeric European Age-sex Standardised Rate per 100,000 population for AverageLengthofEpisode.
AverageLengthofEpisodeRateQF text Qualifier for AverageLengthofEpisodeRate.

Qualifier information

AverageLengthofStayRate numeric European Age-sex Standardised Rate per 100,000 population for AverageLengthofStay.
AverageLengthofStayRateQF text Qualifier for AverageLengthofStayRate.

Qualifier information

Patients numeric Number of patients.
PatientsQF text Qualifier for Patients.

Qualifier information

Additional Information

Field Value
Data last updated September 26, 2023
Metadata last updated September 28, 2020
Created September 28, 2020
Format text/csv
License UK Open Government Licence (OGL)
createdover 3 years ago
datastore activeTrue
formatCSV
has viewsTrue
idfd11b8ef-6ca8-4298-9c55-4ecf097eeb07
last modified6 months ago
mimetypetext/csv
on same domainTrue
package id9e032286-e5bf-4eb0-837d-c0a05fe0d839
position4
revision id5d89e71f-0790-477d-adec-1245994a02cd
size35.7 MiB
stateactive
url typeupload