safety_incidents
First aid, security and safety incidents involving guests or employees. One row is one incident.
- One row is
- one incident
- Columns
- 13
- Rows in Sample
- 19,963
- Rows in Standard
- 19,963
- Rows in Full
- 19,963
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| incident_idkey | integer | Unique id for the row. | |
| occurred_at | date and time | When it happened. | 2018-01-01 10:05 to 2025-12-31 19:28 |
| location_type | text | In a park, in a hotel, or at Paseo Velaluz. | Paseo Velaluz; resort hotel; theme or water park |
| park_code | text | The park, when it happened in one. Can be empty. | CE; PT; PY |
| hotel_id | integer | The hotel, when it happened in one. Can be empty. | |
| attraction_id | integer | The ride, for ride evacuations. Can be empty. | |
| downtime_id | integer | The breakdown behind a ride evacuation. Can be empty. | |
| incident_type | text | What happened. | cut or scrape; employee injury; guest altercation; heat illness; insect sting; lost child; motion sickness; ride evacuation; slip or fall |
| person_type | text | Guest or employee. | employee; guest |
| employee_id | integer | The employee hurt, for employee injuries. Can be empty. | |
| severity | text | Minor, moderate or serious. | minor; moderate; serious |
| response_minutes | decimal | Minutes until help arrived. | 0.6 to 41.2 |
| outcome | text | How it ended. | guest removed from property; guests walked off safely; resolved by security; reunited with party; transported to hospital; treated at first aid station; treated on site |
How it connects
This table points to
- attraction_id matches attractions.attraction_id
- downtime_id matches ride_downtime.downtime_id
- employee_id matches employees.employee_id
- hotel_id matches hotels.hotel_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| incident_id | occurred_at | location_type | park_code | hotel_id | attraction_id | downtime_id | incident_type | person_type | employee_id | severity | response_minutes | outcome |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30000001 | 2018-01-01 10:05:17 | theme or water park | CE | slip or fall | guest | minor | 5.5 | treated on site | ||||
| 30000002 | 2018-01-01 11:09:15 | theme or water park | CE | cut or scrape | guest | minor | 3.8 | treated on site | ||||
| 30000003 | 2018-01-01 11:12:47 | theme or water park | PT | slip or fall | guest | minor | 8.7 | treated on site | ||||
| 30000004 | 2018-01-01 12:21:04 | theme or water park | CE | lost child | guest | minor | 24.7 | reunited with party | ||||
| 30000005 | 2018-01-01 15:00:37 | theme or water park | PT | slip or fall | guest | minor | 3.8 | treated on site |