Hospital Bed Turnover Rates
This dataset provides detailed records of hospital bed assignments and releases, including timing, department, bed type, turnover reasons, and cleaning status. It enables healthcare administrators to analyze bed utilization, optimize patient flow, and improve resource planning. The data supports operational efficiency studies and strategic decision-making in hospital management.
Sample rows
preview · 8 of 60 rows · all 14 columns| record_idstring | bed_status_after_releasestring | length_of_stay_hoursfloat | cleaning_requiredboolean | hospital_idstring | hospital_namestring | departmentstring | bed_idstring | bed_typestring | assignment_datetimedatetime | release_datetimedatetime | patient_idstring | turnover_reasonstring | cleaning_completed_datetimedatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC0001 | Available | 74.08 | true | HSP001 | Green Valley Medical Center | ICU | ICU-BED-01 | ICU | 2024-04-01T08:15:00 | 2024-04-04T10:20:00 | PAT-1001 | Discharge | 2024-04-04T12:00:00 |
| REC0002 | Available | 150.38 | true | HSP001 | Green Valley Medical Center | General Surgery | GS-BED-03 | Standard | 2024-04-02T09:10:00 | 2024-04-08T14:33:00 | PAT-1002 | Discharge | 2024-04-08T16:00:00 |
| REC0003 | Available | 93.75 | true | HSP002 | Eastside Regional Hospital | Pediatrics | PED-BED-02 | Pediatric | 2024-04-03T13:45:00 | 2024-04-07T11:30:00 | PAT-2001 | Transfer | 2024-04-07T13:00:00 |
| REC0004 | Available | 50.5 | true | HSP003 | Lakeside Community Hospital | Maternity | MAT-BED-05 | Maternity | 2024-04-04T07:30:00 | 2024-04-06T10:00:00 | PAT-3003 | Discharge | 2024-04-06T11:30:00 |
| REC0005 | Available | 35 | true | HSP002 | Eastside Regional Hospital | ICU | ICU-BED-03 | ICU | 2024-04-03T19:00:00 | 2024-04-05T06:00:00 | PAT-2002 | Death | 2024-04-05T08:00:00 |
| REC0006 | Reserved | 6 | false | HSP003 | Lakeside Community Hospital | General Surgery | GS-BED-04 | Standard | 2024-04-02T14:00:00 | 2024-04-02T20:00:00 | PAT-3004 | Transfer | blank |
| REC0007 | Available | 51.33 | true | HSP002 | Eastside Regional Hospital | ICU | ICU-BED-04 | ICU | 2024-04-01T12:00:00 | 2024-04-03T15:20:00 | PAT-2003 | Discharge | 2024-04-03T18:00:00 |
| REC0008 | Available | 72 | true | HSP001 | Green Valley Medical Center | Pediatrics | PED-BED-05 | Pediatric | 2024-04-05T09:30:00 | 2024-04-08T09:30:00 | PAT-1005 | Cleaning | 2024-04-08T10:30:00 |
| REC0009 | Available | 81 | true | HSP003 | Lakeside Community Hospital | ICU | ICU-BED-02 | ICU | 2024-04-02T23:00:00 | 2024-04-06T08:00:00 | PAT-3005 | Transfer | 2024-04-06T10:30:00 |
| REC0010 | Available | 75 | true | HSP002 | Eastside Regional Hospital | Maternity | MAT-BED-01 | Maternity | 2024-04-07T16:00:00 | 2024-04-10T19:00:00 | PAT-2004 | Discharge | 2024-04-10T20:15:00 |
| REC0011 | Reserved | 27 | false | HSP001 | Green Valley Medical Center | General Surgery | GS-BED-01 | Standard | 2024-04-06T10:00:00 | 2024-04-07T13:00:00 | PAT-1006 | Discharge | blank |
| REC0012 | Available | 53.25 | false | HSP002 | Eastside Regional Hospital | Pediatrics | PED-BED-03 | Pediatric | 2024-04-08T07:15:00 | 2024-04-10T12:30:00 | PAT-2005 | Discharge | blank |
| REC0013 | Available | 73.25 | true | HSP003 | Lakeside Community Hospital | ICU | ICU-BED-01 | ICU | 2024-04-08T08:15:00 | 2024-04-11T09:30:00 | PAT-3006 | Death | 2024-04-11T12:00:00 |
| REC0014 | Available | 67.25 | true | HSP001 | Green Valley Medical Center | Maternity | MAT-BED-03 | Maternity | 2024-04-09T15:45:00 | 2024-04-12T11:00:00 | PAT-1007 | Discharge | 2024-04-12T13:00:00 |
| REC0015 | Reserved | 13.5 | false | HSP003 | Lakeside Community Hospital | General Surgery | GS-BED-07 | Standard | 2024-04-11T07:30:00 | 2024-04-11T21:00:00 | PAT-3007 | Transfer | blank |
| REC0016 | Available | 100.75 | true | HSP002 | Eastside Regional Hospital | ICU | ICU-BED-05 | ICU | 2024-04-09T10:00:00 | 2024-04-13T14:45:00 | PAT-2006 | Discharge | 2024-04-13T16:30:00 |
| REC0017 | Under Maintenance | 47 | false | HSP001 | Green Valley Medical Center | Pediatrics | PED-BED-04 | Pediatric | 2024-04-10T09:00:00 | 2024-04-12T08:00:00 | PAT-1008 | Other | blank |
| REC0018 | Available | 42 | true | HSP003 | Lakeside Community Hospital | Maternity | MAT-BED-06 | Maternity | 2024-04-13T15:30:00 | 2024-04-15T09:30:00 | PAT-3008 | Discharge | 2024-04-15T12:00:00 |
| REC0019 | Available | 19 | true | HSP001 | Green Valley Medical Center | General Surgery | GS-BED-06 | Standard | 2024-04-12T17:00:00 | 2024-04-13T12:00:00 | PAT-1009 | Cleaning | 2024-04-13T13:00:00 |
| REC0020 | Available | 34 | false | HSP002 | Eastside Regional Hospital | Pediatrics | PED-BED-01 | Pediatric | 2024-04-14T08:00:00 | 2024-04-15T18:00:00 | PAT-2007 | Discharge | blank |
What the 60 rows show
from the 60-row sampleAvailable (bed status after release) stands out: mean length_
- 70%cleaning_
required = true - 48.8median length_
of_ stay_ hours - 4bed types
- 5turnover reasons
- 8departments
- 10hospital names
Median 48.8, from 4.8 to 150.4.
- string 9
- float 1
- datetime 3
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
record_id | string | Unique identifier for each bed turnover event recordunique | REC0001 |
hospital_id | string | Unique identifier for the hospital where the bed turnover occurred10 hospitals | HSP001 |
hospital_name | string | Name of the hospital10 names | Sunrise Medical Center |
department | string | Hospital department or ward where the bed is located (e.g., ICU, General Surgery, Pediatrics)8 departments | ICU |
bed_id | string | Unique identifier for the specific hospital bed | ICU-BED-01 |
bed_type | string | Type of bed (e.g., Standard, ICU, Pediatric, Maternity)4 types | ICU |
patient_id | string | Unique identifier for the patient assigned to the bed (can be anonymized)optional | PAT-1001 |
turnover_reason | string | Reason for bed turnover (e.g., Discharge, Transfer, Death, Cleaning)Discharge · Transfer · Death · Cleaning · Other | Discharge |
bed_status_after_release | string | Status of the bed after release (e.g., Available, Under Maintenance, Reserved)Available · Under Maintenance · Reserved | Available |
| Numbers 1 column | |||
length_of_stay_hours | float | Calculated length of stay in hours for the bed assignment (release_datetime - assignment_datetime)0 or more | 74.08 |
| Dates and times 3 columns | |||
assignment_datetime | datetime | Date and time when the bed was assigned to a patient | 2024-04-01T08:15:00 |
release_datetime | datetime | Date and time when the bed was released (patient discharged or transferred) | 2024-04-04T10:20:00 |
cleaning_completed_datetime | datetime | Date and time when cleaning was completed (if applicable)optional | 2024-04-04T12:00:00 |
| True or false 1 column | |||
cleaning_required | boolean | Indicates if cleaning was required before the next assignment | true |
Use it for
A healthcare dashboard
The cleaning_
required rate, length_ of_ stay_ hours by bed_ status_ after_ release and a breakdown of hospital_ id. Excel, Power BI or Tableau. Why do the 44 Available rows have a mean length_
of_ stay_ hours of 52.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records60REC000174.08AvailableREC0002150.38AvailableREC00066Reserved
A software demo
Believable records with hospital_
id, hospital_ name and department to fill a screen in front of a buyer.
This dataset60 rows14 columns
Yours1,000 rows14 columns
blueprint · hospital-bed-turnover-rates
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Record admission and discharge dates
- Beds must be uniquely identified
- Calculate average turnover time
- Highlight beds with >30% occupancy drop
- Flag prolonged stays exceeding 14 days
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- hospital-bed-turnover-rates