Activity by Council Area and Deprivation
Deprivation breakdown for inpatient and daycase activity (episode and stays) by council area of residence of the patients.
Size: 1.79MB
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: Elective Inpatients; Emergency Inpatients; Transfers; All Day cases; All Inpatients; All Inpatients and Day cases | |
| AdmissionTypeQF | text | Qualifier for AdmissionType | |
| CA | text | 9-digit code for council area of residence, country code for Scotland, and 6-digit codes for other residential categories | |
| CAQF | text | Qualifier for CA | |
| SIMD | text | Scottish Index of Multiple Deprivation (SIMD) quintile; 1(Most Deprived) - 5(Least Deprived); Most appropriate SIMD release used for each year | |
| SIMDQF | text | Qualifier for SIMD | |
| Episodes | numeric | Number of episodes. | |
| EpisodesQF | text | Qualifier for Episodes. | |
| EpisodesRate | numeric | European Age-sex Standardised Rate per 100,000 population for Episodes. | |
| EpisodesRateQF | text | Qualifier for EpisodesRate. | |
| Stays | numeric | Number of stays. | |
| StaysQF | text | Qualifier for Stays. | |
| StaysRate | numeric | European Age-sex Standardised Rate per 100,000 population for Stays. | |
| StaysRateQF | text | Qualifier for StaysRate. | |
| TotalLengthofEpisode | numeric | Total length of episodes (days). | |
| TotalLengthofEpisodeQF | text | Qualifier for TotalLengthofEpisode. | |
| TotalLengthofEpisodeRate | numeric | European Age-sex Standardised Rate per 100,000 population for TotalLengthofEpisode. | |
| TotalLengthofEpisodeRateQF | text | Qualifier for TotalLengthofEpisodeRate. | |
| TotalLengthofStay | numeric | Total length of stays (days). | |
| TotalLengthofStayQF | text | Qualifier for TotalLengthofStay. | |
| TotalLengthofStayRate | numeric | European Age-sex Standardised Rate per 100,000 population for TotalLengthofStay. | |
| TotalLengthofStayRateQF | text | Qualifier for TotalLengthofStayRate. | |
| AverageLengthofEpisodeRate | numeric | European Age-sex Standardised Rate per 100,000 population for AverageLengthofEpisode. | |
| AverageLengthofEpisodeRateQF | text | Qualifier for AverageLengthofEpisodeRate. | |
| AverageLengthofStayRate | numeric | European Age-sex Standardised Rate per 100,000 population for AverageLengthofStay. | |
| AverageLengthofStayRateQF | text | Qualifier for AverageLengthofStayRate. | |
| Patients | numeric | Number of patients. | |
| PatientsQF | text | Qualifier for Patients. | |
| PatientsRate | numeric | European Age-sex Standardised Rate per 100,000 population for Patients. | |
| PatientsRateQF | text | Qualifier for PatientsRate. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | September 30, 2025 |
| Metadata last updated | September 24, 2020 |
| Created | September 24, 2020 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | over 5 years ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | f9c0185e-c2f9-4925-80d0-cbb0481bfed2 |
| last modified | 29 days ago |
| mimetype | text/csv |
| on same domain | True |
| package id | 9e032286-e5bf-4eb0-837d-c0a05fe0d839 |
| position | 1 |
| revision id | a96ae01e-394d-4859-8e96-13a3cd8d3e33 |
| size | 1.5 MiB |
| state | active |
| url type | upload |
