Project Info

Project Request Date: 04/15/2020
Project Requested By: Nate Dean
Principle Investigator: Tony Fields

Initial Inquiry

A data request was made for the following:
1 – Total Fatalities by year, total fatalities during the day and night (using defined periods)
2 – Total Unrestrained Fatalities by year, total fatalities during the day and time time (using defined periods)
3 – All Crashes by year, total crashes during the day and time time (using defined periods)
Time Periods = Day = 3:00 AM – 2:59 PM; Night = 3:00 PM to 2:59 AM

Project Write-up & Data Provided

KTC staff queried the relevant SQL databases and summarized the output in a table.