Others titles
- Day Bed Occupancy in England Hospitals
- Overnight Bed Occupancy Rate Hospital
- NHS Hospital Bed Occupancy Rate
Keywords
- Bed Occupancy Data
- Bed Availability Data
- Occupancy Rate
- Health Beds
- Types of Hospital Beds
Hospital Bed Availability and Occupancy by Sector
This dataset provides information on the total number of available and occupied bed days for facility wards open “overnight” and “day only” by NHS (National Health Service) Trust by Sector.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The KH03 is a quarterly collection from all NHS organizations that operate beds, open overnight or day only. It collects the total number of available bed days and the total number of occupied bed days by consultant main specialty. The new quarterly KH03 collects bed occupancy data, for levels of care other than critical care (excludes Clinical Care Intensity for General Patients code 11 for intensive therapy, including high dependency care), by consultant main specialty. It covers beds open overnight and day only, but not residential care beds.
Bed availability data is not required by consultant specialty on the return as some beds may be available for more than one specialty to use, depending on need. Instead, there is one available figure for each group where beds can be used flexibly. Bed availability is required for the sectors general and acute, mental illness, learning disabilities and maternity. The occupied bed days will be added to calculate occupancy rates for each of these sectors. It will be possible to analyze the data to show changes in how beds are utilized by each of the consultant specialties within the sectors. As bed availability data is only collected at the sector level, occupancy rates will only be available at the sector level.
About this Dataset
Data Info
Date Created | 2017-08-24 |
---|---|
Last Modified | 2022-11-24 |
Version | 2022-11-24 |
Update Frequency |
Quarterly |
Temporal Coverage |
2022 |
Spatial Coverage |
England |
Source | John Snow Labs; National Health Service, England NHS Digital; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | Bed Occupancy Data, Bed Availability Data, Occupancy Rate, Health Beds, Types of Hospital Beds |
Other Titles | Day Bed Occupancy in England Hospitals, Overnight Bed Occupancy Rate Hospital, NHS Hospital Bed Occupancy Rate |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Bed_Type | Type of beds open "overnight" or "day only" | string | required : 1 |
Quarter | Quarter of the year in which the data was collected. | string | required : 1 |
Year | Data collection Year | date | required : 1 |
Period | Data collection period | string | required : 1 |
Region_Code | Region code of the NHS organizations that operate beds. | string | - |
Organization_Code | NHS Organization unique code | string | - |
Organization_Name | Name of the NHS organizations that operate beds | string | - |
Available_Beds_in_Total | Total available bed days | integer | level : Ratio |
Available_Beds_in_General_and_Acute | Beds available in general and acute sectors | integer | level : Ratio |
Available_Beds_in_Learning_Disabilities | Beds available in Learning Disabilities | integer | level : Ratio |
Available_Beds_in_Maternity | Beds available in Maternity | integer | level : Ratio |
Available_Beds_in_Mental_Illness | Beds available in Mental Illness | integer | level : Ratio |
Occupied_Beds_in_Total | Beds occupied in total | integer | level : Ratio |
Occupied_Beds_in_General_and_Acute | Beds occupied in general and acute sectors | integer | level : Ratio |
Occupied_Beds_in_Learning_Disabilities | Beds available in learning disabilities | integer | level : Ratio |
Occupied_Beds_in_Maternity | Beds available in maternity | integer | level : Ratio |
Occupied_Beds_in_Mental_Illness | Beds available in Mental Illness | integer | level : Ratio |
Percent_Occupied_Beds_in_Total | Percentage of beds occupied in total (occupied beds in total / available beds in total x 100) | number | level : Ratio |
Percent_Occupied_Beds_in_General_Acute | Percentage of beds occupied in general and acute sectors | number | level : Ratio |
Percent_Occupied_Beds_in_Learning_Disabilities | Percentage of beds occupied in Learning Disabilities | number | level : Ratio |
Percent_Occupied_Beds_in_Maternity | Percentage of beds occupied in Maternity | number | level : Ratio |
Percent_Occupied_Beds_in_Mental_Illness | Percentage of beds occupied in Mental Illness | number | level : Ratio |
Data Preview
Bed Type | Quarter | Year | Period | Region Code | Organization Code | Organization Name | Available Beds in Total | Available Beds in General and Acute | Available Beds in Learning Disabilities | Available Beds in Maternity | Available Beds in Mental Illness | Occupied Beds in Total | Occupied Beds in General and Acute | Occupied Beds in Learning Disabilities | Occupied Beds in Maternity | Occupied Beds in Mental Illness | Percent Occupied Beds in Total | Percent Occupied Beds in General Acute | Percent Occupied Beds in Learning Disabilities | Percent Occupied Beds in Maternity | Percent Occupied Beds in Mental Illness |
Overnight | Q1 | 2022 | June | Y56 | R1H | BARTS HEALTH NHS TRUST | 1856 | 1716 | 140.0 | 1773 | 1656 | 117.0 | 95.5 | 96.47 | 83.51 | ||||||
Overnight | Q1 | 2022 | June | Y56 | R1K | LONDON NORTH WEST UNIVERSITY HEALTHCARE NHS TRUST | 999 | 931 | 68.0 | 945 | 915 | 31.0 | 94.66 | 98.29 | 44.99 | ||||||
Overnight | Q1 | 2022 | June | Y56 | RAL | ROYAL FREE LONDON NHS FOUNDATION TRUST | 1150 | 1067 | 83.0 | 1.0 | 884 | 845 | 39.0 | 1.0 | 76.88 | 79.18 | 47.2 | ||||
Overnight | Q1 | 2022 | June | Y56 | RAN | ROYAL NATIONAL ORTHOPAEDIC HOSPITAL NHS TRUST | 150 | 150 | 89 | 89 | 59.72 | 59.72 | 100.0 | ||||||||
Overnight | Q1 | 2022 | June | Y56 | RAP | NORTH MIDDLESEX UNIVERSITY HOSPITAL NHS TRUST | 506 | 470 | 36.0 | 506 | 470 | 36.0 | 100.0 | 100.0 | 100.0 | ||||||
Overnight | Q1 | 2022 | June | Y56 | RAS | THE HILLINGDON HOSPITALS NHS FOUNDATION TRUST | 348 | 309 | 40.0 | 309 | 292 | 18.0 | 88.78 | 94.55 | 44.09 | ||||||
Overnight | Q1 | 2022 | June | Y56 | RAT | NORTH EAST LONDON NHS FOUNDATION TRUST | 413 | 172 | 12.0 | 229.0 | 366 | 151 | 7.0 | 208.0 | 88.55 | 87.61 | 56.67 | ||||
Overnight | Q1 | 2022 | June | Y56 | RAX | KINGSTON HOSPITAL NHS FOUNDATION TRUST | 456 | 401 | 55.0 | 401 | 358 | 43.0 | 87.9 | 89.3 | 77.68 | 90.92 | |||||
Overnight | Q1 | 2022 | June | Y56 | RF4 | BARKING, HAVERING AND REDBRIDGE UNIVERSITY HOSPITALS NHS TRUST | 973 | 911 | 62.0 | 894 | 841 | 53.0 | 91.85 | 92.29 | 85.47 | ||||||
Overnight | Q1 | 2022 | June | Y56 | RJ1 | GUY'S AND ST THOMAS' NHS FOUNDATION TRUST | 1419 | 1321 | 98.0 | 1067 | 1020 | 48.0 | 75.21 | 77.16 | 48.95 |