employees
Everyone employed at any point from 2018 to 2025. One row is one employee.
- One row is
- one employee
- Columns
- 10
- Rows in Sample
- 17,007
- Rows in Standard
- 17,007
- Rows in Full
- 17,007
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 |
|---|---|---|---|
| employee_idkey | integer | Unique id for the row. | |
| first_name | text | First name. | |
| last_name | text | Last name. | |
| hire_date | date | First day. | 2001-01-12 to 2025-12-28 |
| termination_date | date | Last day. Empty for current employees. Can be empty. | 2018-01-06 to 2026-01-01 |
| termination_reason | text | Why they left. Can be empty. | dismissed; end of season; resigned; retired |
| employment_type | text | Full-time, part-time or seasonal. | full-time; part-time; seasonal |
| position_id | integer | Most recent position. | |
| department_id | integer | Most recent department. | |
| location_id | integer | Most recent work location. Can be empty. |
How it connects
This table points to
- position_id matches positions.position_id
- department_id matches departments.department_id
- location_id matches work_locations.location_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| employee_id | first_name | last_name | hire_date | termination_date | termination_reason | employment_type | position_id | department_id | location_id |
|---|---|---|---|---|---|---|---|---|---|
| 200001 | Jorge | Brown | 2020-12-06 | 2022-02-13 | dismissed | seasonal | 401 | 4 | 122 |
| 200002 | Kayla | Torres | 2019-06-28 | 2022-07-15 | resigned | full-time | 201 | 2 | 35 |
| 200003 | Ricardo | Sanchez | 2023-01-04 | 2023-03-28 | resigned | full-time | 101 | 1 | 84 |
| 200004 | Trevor | Thompson | 2024-07-14 | 2024-10-24 | resigned | full-time | 401 | 4 | 153 |
| 200005 | Diego | Aguilar | 2014-10-17 | part-time | 501 | 5 | 139 |