Acitivity by Council Area and Specialty

URL: https://www.opendata.nhs.scot/dataset/9e032286-e5bf-4eb0-837d-c0a05fe0d839/resource/1d7fcc3c-00f6-4cea-a079-9f9b35d79e78/download/inpatient_and_day_case_by_council_area_specialty.csv

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

Size: 13.0MB

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

Qualifier information

CA text 9-digit code for council area of residence, country code for Scotland and 6-digit codes for other residential categories

Link to code descriptions

CAQF text Qualifier for CA

Qualifier information

Specialty text Specialty.

Specialties

SpecialtyQF text Qualifier for Specialty

Qualifier information

SpecialtyName text The name of the Specialty.

Specialties

SpecialtyNameQF text Qualifier for SpecialtyName

Qualifier information

SpecialtyGrouping text Specialty Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined.

[Specialty Groupings] (https://www.publichealthscotland.scot/media/13029/specialty-groupings.xlsx)

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 TotalLengthofEpisode.
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 TotalLengthofStay
TotalLengthofStayRateQF text Qualifier for TotalLengthofStayRate.

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

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
id1d7fcc3c-00f6-4cea-a079-9f9b35d79e78
last modified6 months ago
mimetypetext/csv
on same domainTrue
package id9e032286-e5bf-4eb0-837d-c0a05fe0d839
position2
revision id456add60-1761-473e-9b4c-c8008c0cdcf9
size12.9 MiB
stateactive
url typeupload