Tn Dmv Impaired Driving Crashes
tn_dmv_impaired_driving_crashesCount 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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max sample records returned alongside the counts (default 10, max 200). | |
| agency | No | Investigating agency substring. State troopers are published as "THP District 3 - Nashville" and similar, so "THP" selects all of them; city forces read "METROPOLITAN NASHVILLE POLICE DEPT", "MEMPHIS POLICE DEPT"; counties read "SHERIFF". | |
| gender | No | Published as "M" or "F"; "male"/"female" are accepted. | |
| group_by | No | Breakdown dimension: age_group, gender, severity, agency, substance, month. Defaults to age_group. | |
| severity | No | Crash severity substring: "fatal", "serious injury", "minor injury". | |
| age_group | No | Age band substring as published, e.g. "21 to 24", "80 & Up", "16 to 17". | |
| substance | No | "alcohol", "drugs", "both" (alcohol and drugs together), or "either" (default — any impairment). |