Activity by Board of Residence and Specialty
Specialty breakdown for inpatient and daycase activity (episode and stays) by health board of residence of the patients.
Size: 14.6MB
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Quarter | text | The reference period as quarter (YYYYQN) | |
| QuarterQF | text | Qualifier for Quarter indicating provisional data | |
| HB | text | 9-digit code for health board of residence based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories | |
| HBQF | text | Qualifier for HB indicating aggregated data | |
| Location | text | 9-digit code for health board of residence, council area and country code for Scotland and 6-digit codes for other residential categories | Health board labels Council area labels Country labels Residential Categories |
| LocationQF | text | Qualifier for Location indicating aggregated data | |
| 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 | |
| Specialty | text | Specialty code | |
| SpecialtyName | text | The name of the Specialty | |
| Episodes | numeric | Number of episodes | |
| LengthOfEpisode | numeric | Total length of episodes | |
| AverageLengthOfEpisode | numeric | Average length of an episode | |
| AverageLengthOfEpisodeQF | text | Qualifier for AverageLengthOfEpisode indicating where this data item is not applicable | |
| Spells | numeric | Number of spells. A specialty spell is a period of time that a patient spends as an inpatient in a specialty at a given location. However, a patient may change consultant, significant facility, and/or hospital during a specialty spell. | |
| LengthOfSpell | numeric | Total length of spells | |
| AverageLengthOfSpell | numeric | Average length of a spell | |
| AverageLengthOfSpellQF | text | Qualifier for AverageLengthOfSpell indicating where this data item is not applicable |
Additional Information
| Field | Value |
|---|---|
| Data last updated | May 28, 2025 |
| Metadata last updated | November 14, 2019 |
| Created | November 14, 2019 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | over 5 years ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | d59528c3-0a61-4fdd-8ed9-f6822838c78c |
| last modified | 5 months ago |
| mimetype | text/csv |
| on same domain | True |
| package id | d73b93ab-b09f-4d39-9cfb-0e5e34085803 |
| position | 3 |
| revision id | 5d2548b9-4a7b-430a-a583-0f060865b0af |
| size | 15.4 MiB |
| state | active |
| url type | upload |