Nathan Yau did a fascinating segmentation of an entire year to illustrate some insightful trends. Inspired by Nathan's work, I wondered if there were more or different patterns of risk that might repeat themselves over a longer period, so I downloaded five years of it to get a big enough set to look at what time of the day or night is especially prone to fatal traffic incidents from a day-of-the-week perspective and also from a time-of-year perspective.
Finally, I did some basic segmentation mapping to get a rough geographic sense of where rates of different sorts of accidents were more or less likely to occur (take these with a grain of salt).
Structure abounds in traffic fatality data.
Incidentally, every one of these charts is a simple Excel pivot table -including the so called maps. More on fake mapping here. Click on the image to get a readable version.
Tweet Follow @JohnNelsonIDV Follow @idvsolutions