Skip to content
As the demand increases for statistics and data to measure the impact of the COVID-19 pandemic, we have had to change our data gathering and release practices, focussing efforts on priority analysis and statistics. https://gov.wales/statistics-and-research
Data Provider: Welsh Government NHS beds summary data by year
None
[Collapse]Specialty[Filtered]
-
[Collapse]Specialty 1[Filter]
-
Specialty 2[Filter]
Measure1
Measure[Filter]
Year[Filter]
Click here to sortAverage daily available bedsAverage daily number of staffed beds in which inpatients are being or could be treated without any change in facilities or staff being made. On some occasions, \'average daily occupied beds\' may exceed \'average daily available beds\'. In these instances \'percentage occupancy\' has been set to 100%.Click here to sortAverage daily occupied bedsAverage daily number of beds occupied by inpatients under the care of a consultant in a particular specialty. On some occasions, \'average daily occupied beds\' may exceed \'average daily available beds\'. This can be due to both patient management as well as recording methods. In these instances \'percentage occupancy\' has been set to 100%.Click here to sortAverage duration of stayThe length of time, on average, each inpatient physically occupied a bed (in days). Calculated by multiplying \'average daily occupied beds\' by 365 and dividing by \'inpatient cases\'. Care should be taken when using these figures if the corresponding \'inpatient cases\' is small, because this may result in a large value due to the calculation performed. Data for this field is not published from 2012-13. More detail is provided in the notes section below.Click here to sortBed use factorAverage number of patients using each bed during the period under review. Calculated by dividing \'inpatient cases\' by \'average daily available beds. Care should be taken when using these figures if the corresponding \'average daily available beds\' is small, because this may result in a large value due to the calculation performed. Data for this field is not published from 2012-13. More detail is provided in the notes section below.Click here to sortInpatient cases (deaths and discharges)All inpatients who have gone through the full admission procedure as an emergency or those admitted electively with the intention of staying in hospital at least one night and who have subsequently been discharged (or transferred to another hospital) or have died in hospital. Infants born in a maternity department, healthy persons accompanying inpatients and sick staff treated in their own quarters are not included. Data for this field is not published from 2012-13. More detail is provided in the notes section below.Click here to sortPercentage occupancyPercentage of time that beds are occupied. Calculated by multiplying \'average daily occupied beds\' by 100 and dividing by \'average daily available beds\'. On some occasions, \'average daily occupied beds\' may exceed \'average daily available beds\'. In these instances \'percentage occupancy\' has been set to 100%. Care should be taken when using these figures if the corresponding \'average daily available beds\' is small, because this may result in a large value due to the calculation performed.Click here to sortTurnover intervalThe average length of time, in days, that the bed is empty between each patient. Calculated multiplying \'average daily unoccupied beds\' by 365 and dividing by \'inpatient cases\'. On some occasions, \'average daily occupied beds\' may exceed \'average daily available beds\', leading to a negative value for \'turnover interval\'. Care should be taken when using these figures if the corresponding \'inpatient cases\' is small, because this may result in a large value due to the calculation performed. Data for this field is not published from 2012-13. More detail is provided in the notes section below.
1989-9019,855.115,242.711.723.9475,515.076.83.5
1990-9119,412.814,806.011.224.9482,473.076.33.5
1991-9218,638.314,320.210.426.8500,336.076.83.2
1992-9318,075.713,791.710.027.9504,347.076.33.1
1993-9417,474.813,501.69.729.1508,155.077.32.9
1994-9516,834.212,948.09.230.5513,417.076.92.8
1995-9615,950.912,442.18.832.3515,950.078.02.5
1996-9715,582.512,206.88.633.1516,312.078.32.4
1997-9815,179.411,944.08.434.3520,013.078.72.3
1998-9914,896.911,819.48.335.1522,747.079.32.1
1999-0014,723.411,779.08.435.0514,698.080.02.1
2000-0114,564.611,728.38.335.3513,757.080.52.0
2001-0214,434.111,724.18.435.3509,355.081.21.9
2002-0314,264.911,767.18.734.6492,972.082.51.8
2003-0414,208.911,799.58.635.4503,457.083.01.7
2004-0514,017.611,632.98.535.6499,485.083.01.7
2005-0613,811.111,447.58.336.4502,150.082.91.7
2006-0713,582.611,248.98.037.8514,090.082.81.7
2007-0813,357.111,055.37.838.6516,050.082.81.6
2008-0913,115.810,821.57.540.1525,641.082.51.6
2009-1012,806.710,431.17.539.9510,902.081.51.7
2010-1112,149.310,294.27.541.2500,358.084.71.4
2011-1211,809.710,062.47.243.2510,281.085.21.2
2012-13Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2012-13. More information is provided in the notes section below.11,497.09,923.2.The data item is not applicable.The data item is not applicable.The data item is not applicable86.3.The data item is not applicable
2013-14Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2013-14. More information is provided in the notes section below.11,241.59,653.2.The data item is not applicable.The data item is not applicable.The data item is not applicable85.9.The data item is not applicable
2014-15Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2014-15. More information is provided in the notes section below.11,061.59,588.7.The data item is not applicable.The data item is not applicable.The data item is not applicable86.7.The data item is not applicable
2015-16Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2015-16. More information is provided in the notes section below.10,934.79,505.0.The data item is not applicable.The data item is not applicable.The data item is not applicable86.9.The data item is not applicable
2016-17Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2016-17. More information is provided in the notes section below.10,856.79,492.8.The data item is not applicable.The data item is not applicable.The data item is not applicable87.4.The data item is not applicable
2017-18Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2017-18. More information is provided in the notes section below.10,712.39,323.9.The data item is not applicable.The data item is not applicable.The data item is not applicable87.0.The data item is not applicable
2018-19Data for deaths and discharges, average length of stay, turnover interval and bed use factor is not published for 2017-18. More information is provided in the notes section below.10,563.79,170.5.The data item is not applicable.The data item is not applicable.The data item is not applicable86.8.The data item is not applicable

Metadata

Title

NHS beds summary data since 1989-90

Last update

29 August 2019 29 August 2019

Next update

August 2020 (provisional)

Publishing organisation

Welsh Government

Source 1

QueSt1 return, NHS Wales Informatics Service (NWIS)

Source 2

NHS Wales Informatics Service (NWIS)

Contact email

stats.healthinfo@gov.wales

Designation

None

Lowest level of geographical disaggregation

Wales

Geographical coverage

Wales

Languages covered

English and Welsh

Data licensing

You may use and re-use this data free of charge in any format or medium, under the terms of the Open Government License - see http://www.nationalarchives.gov.uk/doc/open-government-licence

General description

This table presents summary information, from the QueSt1 return, provided by the NHS Wales Informatics Service (NWIS), on bed use in Wales.

The data do not present data on average length of stay, turnover interval and bed use factor. These indicators are calculated using data on deaths and discharges which is no longer collected via the QS1 return, and need to be derived from the Patient Episode Database for Wales (PEDW) for 2012-13 onwards. When carrying out more detailed analysis of the deaths and discharges data from PEDW in preparation for the 2012-13 release, data quality issues arose in relation to assessment unit (AU) activity reporting in QS1 and in PEDW and how this should be treated in the data. It was identified that there is inconsistency in the reporting of assessment units, with some LHBs reporting AU activity within their beds data, and others omitting them. This inconsistency in the reporting of AU activity is also likely to affect historic data.

Please find information on changes to the data published on NHS beds, as per the given weblink.


Data collection and calculation

Please find this information in the related statistical release, as per the given weblink.

Frequency of publication

Annual

Data reference periods

Provides data on bed use in Wales since 1989-90.

Users, uses and context

Please find this information in the related statistical release, as per the given weblink.

Revisions information

Please find this information in the related statistical release, as per the given weblink.

Statistical quality

Ysbyty Gwynedd and University Hospital Llandough submitted data under the neurology specialty in 2016-17. This has been reported under other neurology, as this is consistent with how data is submitted by other hospitals.

Recoding in 2017-18: From April 2016, new codes were introduced for describing specialties to add more detail to data collections. Until all health boards are able to report data consistently using the more detailed codes, we have recoded specialties as their previous description to avoid inconsistent reporting. Specifically, ‘Breast Surgery’ data has been recoded as ‘General Surgery’ which is how it has been recorded historically. We recoded ‘Stroke Medicine’ as ‘General Medicine’ and ‘Interventional Radiology’ as ‘Radiology’.

Please find this information in the related statistical release, as per the given weblink.

Weblinks

Statistical Release:
https://gov.wales/nhs-beds

Keywords

Beds; patients