Project Info

Project Request Date: 02/19/2020
Project Requested By: Mike Vaughn
Principle Investigator: Tony Fields

Initial Inquiry

• Total number of Roadway Departure K Crashes for each county for each year from 2014 to 2018
• Total number of Roadway Departure A Crashes for each county for each year from 2014 to 2018
• Total number of Intersection K Crashes for each county for each year from 2014 to 2018
• Total number of Intersection A Crashes for each county for each year from 2014 to 2018

Project Write-up & Data Provided

I wrote a series of custom SQL queries to return aggregated crash data (counts) by county for roadway departure and intersection crashes. All tabular data were compiled into one master table and submitted to Mr. Vaughn.