tn_dmv_impaired_driving_crashes

io.github.pipeworx-io/tn-dmv · Verify this server

Count Tennessee injury and fatal traffic crashes involving alcohol or drugs, from the Department of Safety and Homeland Security crash file for calendar year 2022. Each record is one person involved in an impaired-driving crash, carrying crash severity (fatal, suspected serious injury, suspected minor injury), the driver age group and gender, the investigating law-enforcement agency, date, time and coordinates. Answers "how many fatal DUI crashes in Tennessee", "which age group is involved in the most alcohol-related crashes in Tennessee", "drug-involved crashes by police agency", or "impaired driving crashes by month". Group results by age_group, gender, severity, agency, substance or month, and get a sample of the underlying records with latitude and longitude for mapping.