Acitivity by Location of Treatment and Specialty

URL: https://www.opendata.nhs.scot/dataset/9e032286-e5bf-4eb0-837d-c0a05fe0d839/resource/0b1007b1-ce39-434a-807a-2d7555f9ef27/download/inpatient_and_day_case_by_location_of_treatment_specialty.csv

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

Size: 9.87MB

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 indicating provisional 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

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

Current Hospital locations

Location Lookup

Country labels

LocationQF text Qualifier for Location indicating aggregated data.

Qualifier information

Specialty text Specialty.

Specialties

SpecialtyQF text Qualifier for Specialty indicating aggregated data.

Qualifier information

SpecialtyName text The name of the Specialty.
SpecialtyNameQF text Qualifier for SpecialtyName indicating aggregated data.

Qualifier information

SpecialtyGrouping text

Specialty Groupings

SpecialtyGroupingQF 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
id0b1007b1-ce39-434a-807a-2d7555f9ef27
last modified6 months ago
mimetypetext/csv
on same domainTrue
package id9e032286-e5bf-4eb0-837d-c0a05fe0d839
position5
revision id215c1db5-cb81-4ab9-808e-2f92a06bb0a1
size11.2 MiB
stateactive
url typeupload