driver_dimension

Maps directly to the Driver dimension table using the driver_[COLUMN NAME] naming convention. For example driver_last_name to query the last_name column of the Driver dimension table.

SELECT 

 "distance" AS "distance",

 "driver_last_name" AS "last name"

FROM 

 "driver_day" 

WHERE 

 "driver_last_name" is not null AND

 "distance" is not null

GROUP BY 

 "distance", "driver_last_name"

ORDER BY 

 "distance" DESC

LIMIT

 20;

start_day_dimension

Maps directly to the Date dimension table using the start_day_[COLUMN NAME] naming convention. For example start_day_name_of_week to query the name_of_week column of the Date dimension table.

SELECT 

 "driver_name" AS "driver name",

 "distance" AS "distance",

 "start_day_date" AS "Date"

FROM 

 "driver_day" 

WHERE 

 "driver_name" is not null AND

 "distance" is not null AND

 "start_day_is_weekday" = true

GROUP BY 

 "driver_name", "distance", "start_day_date"

ORDER BY 

 "start_day_date" DESC

LIMIT

 20;

distance

Total distance traveled by this driver, across vehicles, in the user's default distance units (miles or kilometers).

29012

total_idle

The duration spent in a vehicle status of idling by this driver, in seconds.

615

hard_accel

The number of hard acceleration events recorded during this trip.

3

hard_brake

The number of hard acceleration events recorded during this trip.

6

seatbelt_violations

The number of seatbelt violations recorded for this driver.

2

speeding_over_posted

The number of speeding over posted violation events recorded for this driver.

1

speeding_excessive

The number of excessive speeding events recorded for this driver.

2

engine_time

The total engine running time recorded for this driver, in seconds.

3600

fuel_used

The amount of fuel used by this driver, in the user's default volume units (gallons or liters).

103

total_non_productive_idle

The total time spent in a non-productive idle status by this driver, in seconds.

95

best_distance

best_duration

dtc_count

The number of diagnostic trouble codes logged during the trip.

0

idle_over_ten_minutes

The number of 'idling over ten minutes' events triggered.

3