Bed Occupancy from RAPID for Covid, Flu and RSV
Weekly bed occupancy derived from records on admissions as an emergency to a hospital in Scotland in Rapid Preliminary Inpatient Data (RAPID), where patients had laboratory-confirmed COVID-19, Influenza and respiratory syncytial virus (RSV).
Hospital occupancy is calculated from admission and discharge dates provided in RAPID, with inpatient days counted from date of admission to date of discharge. As discharge dates are often missing or completed late in RAPID, missing dates are imputed for Occupancy and LOS calculations. Occupancy for a week is calculated as the mean over the 7 days.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Season | text | This represents the respiratory season that the test positivity figure relates to. A season runs from week 40 to week 39 the next year. | |
| ISOyear | numeric | The ISO year that the count relates to. | |
| ISOweek | numeric | The ISO week that the count relates to. | |
| WeekBeginning | timestamp | The first day of the week (Monday) the count refers to. This is stored as a numeric value in the format YYYYMMDD. | |
| WeekEnding | timestamp | The last day of the week (Sunday) the count refers to. This is stored as a numeric value in the format YYYYMMDD. | |
| Country | text | 9-digit geography code for Scotland | https://www.opendata.nhs.scot/dataset/geography-codes-and-labels |
| Pathogen | text | Occupancy is available for patients testing positive for COVID-19, Influenza and RSV. | |
| BedOccupancy | numeric | The number of inpatients (beds occupied) at the last day of the week. | |
| SevenDayAverageInpatients | text | The average number of inpatients (beds occupied) over all days of the week. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | October 16, 2025 |
| Metadata last updated | October 16, 2025 |
| Created | October 16, 2025 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | 22 hours ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | 71386655-e276-4565-bb1e-484a7d530c87 |
| last modified | 22 hours ago |
| mimetype | text/csv |
| on same domain | True |
| package id | 49dc2d88-1cb0-4420-a5ea-d1bbada62fb2 |
| position | 13 |
| revision id | 917a4b1d-f891-44a4-aaf4-58b0c51d4812 |
| size | 54.6 KiB |
| state | active |
| url type | upload |