| Name | Description | Type | Additional information |
|---|---|---|---|
| ServiceID |
The service id |
unsigned integer |
None. |
| Duration |
The journey duration in seconds |
integer |
None. |
| IdleDuration |
The journey duration in seconds |
integer |
None. |
| Distance |
The journey distance in meters |
integer |
None. |
| StartDate |
The time the journey started |
date |
None. |
| EndDate |
The time the journey ended |
date |
None. |
| StartStreet |
The start street |
string |
None. |
| StartTown |
The start town |
string |
None. |
| StartCountry |
The start country |
string |
None. |
| StartPostcode |
The start postcode |
string |
None. |
| EndStreet |
The end street |
string |
None. |
| EndTown |
The end town |
string |
None. |
| EndCountry |
The end country |
string |
None. |
| EndPostcode |
The end postcode |
string |
None. |
| SpeedingEventCount |
The number of speeding events |
integer |
None. |
| IsPrivate |
True if the journey is private, false if the journey is business |
boolean |
None. |
| DriverName |
The drivers name |
string |
None. |