Bed Occupancy from RAPID by Health Board for ...
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), broken down by NHS Board.
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 | numeric | The first day of the week (Monday) the count refers to. This is stored as a numeric value in the format YYYYMMDD. | |
| WeekEnding | numeric | The last day of the week (Sunday) the count refers to. This is stored as a numeric value in the format YYYYMMDD. | |
| Pathogen | text | Occupancy is available for patients testing positive for COVID-19, Influenza and RSV. | |
| HBName | text | Name of NHS Board. | |
| HBcode | text | Health Board code based on boundaries as at 1st April 2019. Health Board is assigned based on postcode of residence, if postcode is missing location defaults to the Health Board of submitting laboratory. | https://www.opendata.nhs.scot/dataset/geography-codes-and-labels |
| HBQF | text | Qualifier=‘d’ if derived (Total). | https://www.opendata.nhs.scot/dataset/statistical-qualifiers |
| 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 | December 24, 2025 |
| Metadata last updated | December 19, 2025 |
| Created | December 19, 2025 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | 9 days ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | f93b7351-d4b0-4b3e-bd19-bc997ee8b55c |
| last modified | 5 days ago |
| mimetype | text/csv |
| on same domain | True |
| package id | 49dc2d88-1cb0-4420-a5ea-d1bbada62fb2 |
| position | 15 |
| revision id | 0207e889-435d-45e8-98dd-6a36c336c195 |
| size | 1 MiB |
| state | active |
| url type | upload |