6.7 yrs of DC traffic deaths, by ward and mode.
a couple things stick out:
- W6 & esp. W7 have actually gotten better the last few years. W8 *had* been, until 2023.
- W2 had dropped quite a bit, until the pandemic.
- With a third of the year still to come, W2 and W8 are already well above recent yearly totals.
- W5 is shockingly consistently deadly. The particulars change year to year, but the same number of people are killed, year after year.
- "Vision Zero isn't a cycling program."
@20002ist @swiderski FWIW, I don't think there are any YTD fatalities where the boundary changes impact the reporting here. One edge case (pedestrian on. S. Cap and N) is reported by DC as being on the Ward 6 side, and the Ward 7 fatality west of the river is not "new" to the ward this year.
@LhasaCM @20002ist as I said to @vj at https://twitter.com/swiderskiji/status/1701593983938412923, I'm just using the DDOT dashboard (https://dcgis.maps.arcgis.com/apps/dashboards/a2f1cca5159e4c6eae197895d2e08336)'s aggregation into wards, so this accounts for redistricting as well or poorly as DDOT does.
I suspect anything pre-redistricting in the areas that moved would appear under the new Ward, but it doesn't look there were any.
(To be clear, for years previous to 2023, these are _full-year_ totals, not YTD.)
@swiderski @20002ist @vj For sure - you're just sharing the visual of DDOT's data. My point (since I was curious when you had first shared it) was whether or not the changing boundaries would impact anything. My quick check just showed that using the previous boundaries the comparisons are not impacted (since no 2023 fatalities have been recorded in an area that shifted wards).
@swiderski do you have this code publicly available?
@thebostonlol lol thanks for the interest, but there's only one line of actual code:
> ggplot(deaths_by_ward%>%filter(year>2016 & ward != "unk"), aes(x=year, y=deaths)) + geom_col(aes(fill=mode)) + scale_fill_brewer(palette = "Paired", direction = -1) + facet_wrap(vars(ward))
the data side is a CSV with columns year, ward, mode, deaths, assembled by hand based on DDOT's Fatal and Injury Crashes Dashboard at https://dcgis.maps.arcgis.com/apps/dashboards/a2f1cca5159e4c6eae197895d2e08336 😹😿
@swiderski you make it seem so easy 😂 I guess a coherent data source does push things along the path quite nicely
@thebostonlol heh. The dashboard is actually kind of a pain, but (as long as you only care about 2017 and later) it is fairly comprehensive, and I've been poking at it for several years....
There is a fair amount on opendata.DC.gov if you're wanting to dig more into DC crash data, but this is admittedly fairly surface—and I'm letting them do the hard parts...
@swiderski Does this account for the changes in ward boundaries?