Weekly Length of Stay by Age Group for ...
Weekly number of admissions, total length of stay (days) and average length of stay (days), for patients admitted as an emergency to a hospital in Scotland identified from Rapid Preliminary Inpatient Data (RAPID), with laboratory-confirmed respiratory infections broken down by Age Group, for 3 respiratory conditions (COVID-19, Influenza and RSV (respiratory syncytial virus)).
The case definition includes patients admitted as an emergency to a medical specialty in acute hospitals (excluding surgical, maternity/obstetrics and mental health specialties, and emergency admissions with patient injury codes) who have a PCR test result, taken within a period of between 14 days before the admission date and 48 hours after the admission date. COVID-19 test results can include LFD results (from 05 Jan 2022).
The length of stay is calculated as the difference between the discharge date and the date of admission in days.
RAPID figures are subject to change and particularly for the most recent week may be incomplete for some Boards.
More detailed metadata is available from the Metadata tab of the PHS Viral Respiratory Diseases Surveillance dashboard
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Season | text | Flu season (year starting at week 40) | |
| ISOyear | numeric | ISO year when admission took place | |
| ISOweek | numeric | ISO week when admission took place | |
| WeekBeginning | numeric | First day of the week (Monday) when admission took place. Format YYYYMMDD | |
| WeekEnding | numeric | Last day of the week (Sunday) when admission took place. Format YYYYMMDD | |
| Country | text | 9-digit geography code for Scotland | https://www.opendata.nhs.scot/dataset/geography-codes-and-labels |
| Pathogen | text | COVID-19, Influenza, RSV (respiratory syncytial virus) | |
| AgeGroup | text | Age groups are <1, 1 to 4, 5 to 14, 15 to 44, 45 to 64, 65 to 74, 75+ | |
| NumberOfAdmissions | numeric | Number of laboratory-confirmed cases admitted to hospital in the week for the specified age group | |
| TotalLengthOfStay | numeric | Combined length of stay for all admissions in the week for the specified age group | |
| AverageLengthOfStay | numeric | The average (mean) length of stay for all admissions in the week for the specified age group |
Additional Information
| Field | Value |
|---|---|
| Data last updated | December 24, 2025 |
| Metadata last updated | December 17, 2025 |
| Created | December 17, 2025 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | 12 days ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | f837965e-ed50-47ab-a39a-9b41a7ab19b4 |
| last modified | 5 days ago |
| mimetype | text/csv |
| on same domain | True |
| package id | 49dc2d88-1cb0-4420-a5ea-d1bbada62fb2 |
| position | 16 |
| revision id | ae134871-a827-46a8-acaa-a34f85aa08b4 |
| size | 184.4 KiB |
| state | active |
| url type | upload |