Hospital Bed Availability and Occupancy by Sector

$79 / year

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.

Complexity

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.

Date Created

2017-08-24

Last Modified

2018-05-24

Version

2018-05-24

Update Frequency

Quarterly

Temporal Coverage

2017-06 to 2018-03

Spatial Coverage

England

Source

John Snow Labs => National Health Service, England NHS Digital

Source License URL

John Snow Labs Standard License

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

Name Description Type Constraints
Bed_TypeType of beds open "overnight" or "day only"stringrequired : 1
QuarterQuarter of the year in which the data was collected.stringrequired : 1
YearData collection Yeardaterequired : 1
MonthData collection monthstringrequired : 1
Region_CodeRegion code of the NHS organizations that operate beds.string-
Organization_CodeNHS Organization unique codestring-
Organization_NameName of the NHS organizations that operate bedsstring-
Available_Beds_in_TotalTotal available bed daysintegerlevel : Ratio
Available_Beds_in_General_and_AcuteBeds available in general and acute sectorsintegerlevel : Ratio
Available_Beds_in_Learning_DisabilitiesBeds available in Learning Disabilitiesintegerlevel : Ratio
Available_Beds_in_MaternityBeds available in Maternityintegerlevel : Ratio
Available_Beds_in_Mental_IllnessBeds available in Mental Illnessintegerlevel : Ratio
Occupied_Beds_in_TotalBeds occupied in totalintegerlevel : Ratio
Occupied_Beds_in_General_and_AcuteBeds occupied in general and acute sectorsintegerlevel : Ratio
Occupied_Beds_in_Learning_DisabilitiesBeds available in learning disabilitiesintegerlevel : Ratio
Occupied_Beds_in_MaternityBeds available in maternityintegerlevel : Ratio
Occupied_Beds_in_Mental_IllnessBeds available in Mental Illnessintegerlevel : Ratio
Percent_Occupied_Beds_in_TotalPercentage of beds occupied in total (occupied beds in total / available beds in total x 100)numberlevel : Ratio
Percent_Occupied_Beds_in_General_AcutePercentage of beds occupied in general and acute sectorsnumberlevel : Ratio
Percent_Occupied_Beds_in_Learning_DisabilitiesPercentage of beds occupied in Learning Disabilitiesnumberlevel : Ratio
Percent_Occupied_Beds_in_MaternityPercentage of beds occupied in Maternitynumberlevel : Ratio
Percent_Occupied_Beds_in_Mental_IllnessPercentage of beds occupied in Mental Illnessnumberlevel : Ratio
Bed_TypeQuarterYearMonthRegion_CodeOrganization_CodeOrganization_NameAvailable_Beds_in_TotalAvailable_Beds_in_General_and_AcuteAvailable_Beds_in_Learning_DisabilitiesAvailable_Beds_in_MaternityAvailable_Beds_in_Mental_IllnessOccupied_Beds_in_TotalOccupied_Beds_in_General_and_AcuteOccupied_Beds_in_Learning_DisabilitiesOccupied_Beds_in_MaternityOccupied_Beds_in_Mental_IllnessPercent_Occupied_Beds_in_TotalPercent_Occupied_Beds_in_General_AcutePercent_Occupied_Beds_in_Learning_DisabilitiesPercent_Occupied_Beds_in_MaternityPercent_Occupied_Beds_in_Mental_Illness
Day onlyQ12017JuneY57 R1C SOLENT NHS TRUST
Day onlyQ42018MarchY57 R1C SOLENT NHS TRUST
Day onlyQ32017DecemberY57 R1C SOLENT NHS TRUST
Day onlyQ22017SeptemberY57 R1C SOLENT NHS TRUST
Day onlyQ12017JuneY54 RV9 HUMBER NHS FOUNDATION TRUST
Day onlyQ12017JuneY56 RPG OXLEAS NHS FOUNDATION TRUST
Day onlyQ12017JuneY57 RWV DEVON PARTNERSHIP NHS TRUST
Day onlyQ12017JuneY57 RTQ 2GETHER NHS FOUNDATION TRUST
Day onlyQ42018MarchY54 RV9 HUMBER NHS FOUNDATION TRUST
Day onlyQ42018MarchY56 RPG OXLEAS NHS FOUNDATION TRUST