De Dmv Crash Stats
de_dmv_crash_statsCount reported traffic crashes in Delaware from the state's Public Crash Data file, broken down by year, county, weather, light condition, road surface, impact type or day of week, with filters for alcohol-involved, drug-involved, pedestrian, motorcycle, bicycle and work-zone crashes. Answers "how many car crashes happen in Delaware each year", "how many drunk driving crashes in Delaware", "pedestrian crashes in New Castle County", and "how many crashes involved a motorcycle in Delaware". Covers roughly 37,000 reported crashes a year for crash years 2009 through 2025, in the three Delaware counties: New Castle, Kent and Sussex.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | Four-digit crash year, 2009–2025, e.g. "2025". | |
| limit | No | Max rows to return (default 30, max 200). | |
| county | No | Delaware county: "New Castle", "Kent" or "Sussex". | |
| group_by | No | Breakdown dimension: year (default), county, weather, light, road_surface, impact, day_of_week, crash_class. | |
| work_zone | No | true to count only crashes in a work zone. | |
| drug_involved | No | true to count only crashes flagged as drug-involved. | |
| alcohol_involved | No | true to count only crashes flagged as alcohol-involved. | |
| bicycle_involved | No | true to count only crashes involving a bicycle. | |
| motorcycle_involved | No | true to count only crashes involving a motorcycle. | |
| pedestrian_involved | No | true to count only crashes involving a pedestrian. |