Activity by Health Board of Residence and ...

URL: https://www.opendata.nhs.scot/dataset/9e032286-e5bf-4eb0-837d-c0a05fe0d839/resource/b44274f2-fa84-4fdf-9a84-5675c2123cef/download/inpatient_and_day_case_by_nhs_board_of_residence_specialty.csv

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

Size: 6.56MB

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 9-digit code for NHS 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.
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 Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined.

Specialty Groupings

SpecialtyGroupingQF text Qualifier for SpecialtyGrouping

Qualifier information

Episodes numeric Number of episodes.
EpisodesQF text Qualifier for Episodes.

Qualifier information

EpisodesRate numeric European Age-sex Standardised Rate per 100,000 population for Episodes.
EpisodesRateQF text Qualifier for EpisodesRate.

Qualifier information

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

Qualifier information

StaysRate numeric European Age-sex Standardised Rate per 100,000 population for Stays.
StaysRateQF text Qualifier for StaysRate.

Qualifier information

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

Qualifier information

TotalLengthofEpisodeRate numeric European Age-sex Standardised Rate per 100,000 population for LengthofEpisode.
TotalLengthofEpisodeRateQF text Qualifier for TotalLengthofEpisodeRate.

Qualifier information

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

Qualifier information

TotalLengthofStayRate numeric European Age-sex Standardised Rate per 100,000 population for LengthofStay.
TotalLengthofStayRateQF text Qualifier for TotalLengthofStayRate.
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

PatientsRate numeric European Age-sex Standardised Rate per 100,000 population for Patients.
PatientsRateQF text Qualifier for PatientsRate.

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
idb44274f2-fa84-4fdf-9a84-5675c2123cef
last modified6 months ago
mimetypetext/csv
on same domainTrue
package id9e032286-e5bf-4eb0-837d-c0a05fe0d839
position8
revision id28401ff1-6c5b-485d-b801-82e8035d9193
size6.5 MiB
stateactive
url typeupload