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

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

Spells numeric
SpellsQF text
SpellsRate numeric
SpellsRateQF text
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

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

Qualifier information

AverageLengthofSpellRate numeric
AverageLengthofSpellRateQF text
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 24, 2024
Metadata last updated September 28, 2020
Created September 28, 2020
Format text/csv
License UK Open Government Licence (OGL)
createdover 4 years ago
datastore activeTrue
formatCSV
has viewsTrue
id1d7fcc3c-00f6-4cea-a079-9f9b35d79e78
last modified7 months ago
mimetypetext/csv
on same domainTrue
package id9e032286-e5bf-4eb0-837d-c0a05fe0d839
position2
revision id86a68c7b-8db4-434c-8d3c-022871948952
size12.8 MiB
stateactive
url typeupload