Skip to content

it_tickets

Help desk tickets raised by employees. One row is one ticket.

One row is
one ticket
Columns
12
Rows in Sample
35,859
Rows in Standard
35,859
Rows in Full
35,859

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
ticket_idkeyintegerUnique id for the row.
opened_atdate and timeWhen it was raised.2018-01-01 06:00 to 2025-12-31 20:02
requester_employee_idintegerWho raised it. Links to employees.
assigned_teamtextIT team that owned it.Business Applications; Data and Reporting; Guest App and Web; Network and Infrastructure; POS and Venue Systems; Service Desk
assigned_employee_idintegerWho worked it. Links to employees.
system_idintegerThe system concerned, if any. Can be empty.
categorytextKind of request.
prioritytextP1 most urgent to P4 least.P1; P2; P3; P4
sla_target_hoursintegerHours the team commits to close a ticket of this priority in.4 to 168
first_response_atdate and timeWhen someone first replied. Can be empty.2018-01-01 16:10 to 2025-12-31 23:12
closed_atdate and timeWhen it was closed. Empty while open. Can be empty.2018-01-01 23:32 to 2025-12-31 23:20
statustextResolved, open, or closed automatically after 60 days without resolution.closed: aged out; open; resolved

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

ticket_idopened_atrequester_employee_idassigned_teamassigned_employee_idsystem_idcategoryprioritysla_target_hoursfirst_response_atclosed_atstatus
7000012018-01-01 06:00:00212410Service Desk21413810software installP41682018-01-02 19:18:192018-01-04 09:07:54resolved
7000022018-01-01 13:48:46210609Business Applications217002configuration changeP2242018-01-03 08:18:142018-01-04 18:26:13resolved
7000032018-01-01 15:37:54209146Service Desk209422email or calendarP2242018-01-01 16:29:572018-01-02 13:03:00resolved
7000042018-01-01 15:49:46212446Network and Infrastructure200025network outageP2242018-01-01 18:21:422018-01-05 16:00:57resolved
7000052018-01-01 15:59:13202311Guest App and Web201461app bugP142018-01-01 16:10:392018-01-01 23:32:28resolved

Download from Kaggle