Skip to content

Instantly share code, notes, and snippets.

@infrahumano

infrahumano/collisions_injuries.csv

Last active March 2, 2019 15:38
Show Gist options
  • Save infrahumano/6f5772c1b86a5e1ab2ccff4be316b15c to your computer and use it in GitHub Desktop.
Save infrahumano/6f5772c1b86a5e1ab2ccff4be316b15c to your computer and use it in GitHub Desktop.
Download ZIP
Number of pedestrian fatalities in Canada 1999-2016
Raw
collisions_injuries.csv
Injury Severity Person Position Total 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
Total Total 44167 2980 2904 2758 2921 2777 2735 2898 2871 2753 2431 2216 2238 2023 2075 1951 1846 1895 1895
Total Driver/Operator 26745 1760 1685 1669 1750 1650 1644 1787 1800 1660 1525 1378 1350 1240 1239 1188 1129 1154 1137
Total Front row, center 598 58 43 45 54 49 34 52 23 34 32 28 34 26 22 16 19 19 10
Total Front row, right outboard, including motorcycle passenger in sidecar 5862 440 465 391 446 404 390 421 380 355 298 267 295 245 259 193 221 186 206
Total Second row, left outboard, including motorcycle passenger 1344 93 108 87 85 104 84 77 94 90 72 51 68 49 54 52 55 68 53
Total Second row, center 501 42 37 36 33 35 35 25 23 37 30 23 20 27 35 23 9 16 15
Total Second row, right outboard 1293 97 90 85 94 81 92 97 87 84 57 66 74 49 60 50 42 47 41
Total Third row, left outboard 35 0 1 2 2 3 3 1 1 4 0 1 2 0 1 3 2 7 2
Total Third row, center 217 16 19 17 17 18 17 17 13 8 8 3 10 3 20 13 3 13 2
Total Third row, right outboard 36 0 2 0 3 1 2 2 2 3 4 3 1 0 0 1 2 7 3
Total Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Position unknown, but the person was definitely an occupant 1019 44 47 67 50 36 49 51 60 83 81 62 61 41 47 76 50 55 59
Total Sitting on someone�s lap 4 0 0 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1
Total Outside passenger compartment 116 3 7 7 9 2 3 6 4 6 6 9 7 11 6 14 5 6 5
Total Pedestrian 6167 414 373 334 363 382 369 342 371 379 309 317 306 322 328 309 304 300 345
Total Unknown 160 9 21 15 14 8 5 15 11 9 6 8 10 9 3 6 4 2 5
Total Other 60 3 6 1 0 2 4 3 1 1 3 0 0 1 1 7 1 15 11
Total Not applicable 10 1 0 1 0 2 4 2 0 0 0 0 0 0 0 0 0 0 0
No Injury Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Driver/Operator 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Front row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Front row, right outboard, including motorcycle passenger in sidecar 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Second row, left outboard, including motorcycle passenger 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Second row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Second row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Third row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Third row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Third row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Position unknown, but the person was definitely an occupant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Sitting on someone�s lap 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Outside passenger compartment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Pedestrian 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Unknown 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
No Injury Not applicable 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Driver/Operator 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Front row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Front row, right outboard, including motorcycle passenger in sidecar 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Second row, left outboard, including motorcycle passenger 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Second row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Second row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Third row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Third row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Third row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Position unknown, but the person was definitely an occupant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Sitting on someone�s lap 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Outside passenger compartment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Pedestrian 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Unknown 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Injured Not applicable 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Total 44167 2980 2904 2758 2921 2777 2735 2898 2871 2753 2431 2216 2238 2023 2075 1951 1846 1895 1895
Fatalities Driver/Operator 26745 1760 1685 1669 1750 1650 1644 1787 1800 1660 1525 1378 1350 1240 1239 1188 1129 1154 1137
Fatalities Front row, center 598 58 43 45 54 49 34 52 23 34 32 28 34 26 22 16 19 19 10
Fatalities Front row, right outboard, including motorcycle passenger in sidecar 5862 440 465 391 446 404 390 421 380 355 298 267 295 245 259 193 221 186 206
Fatalities Second row, left outboard, including motorcycle passenger 1344 93 108 87 85 104 84 77 94 90 72 51 68 49 54 52 55 68 53
Fatalities Second row, center 501 42 37 36 33 35 35 25 23 37 30 23 20 27 35 23 9 16 15
Fatalities Second row, right outboard 1293 97 90 85 94 81 92 97 87 84 57 66 74 49 60 50 42 47 41
Fatalities Third row, left outboard 35 0 1 2 2 3 3 1 1 4 0 1 2 0 1 3 2 7 2
Fatalities Third row, center 217 16 19 17 17 18 17 17 13 8 8 3 10 3 20 13 3 13 2
Fatalities Third row, right outboard 36 0 2 0 3 1 2 2 2 3 4 3 1 0 0 1 2 7 3
Fatalities Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fatalities Position unknown, but the person was definitely an occupant 1019 44 47 67 50 36 49 51 60 83 81 62 61 41 47 76 50 55 59
Fatalities Sitting on someone�s lap 4 0 0 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1
Fatalities Outside passenger compartment 116 3 7 7 9 2 3 6 4 6 6 9 7 11 6 14 5 6 5
Fatalities Pedestrian 6167 414 373 334 363 382 369 342 371 379 309 317 306 322 328 309 304 300 345
Fatalities Unknown 160 9 21 15 14 8 5 15 11 9 6 8 10 9 3 6 4 2 5
Fatalities Other 60 3 6 1 0 2 4 3 1 1 3 0 0 1 1 7 1 15 11
Fatalities Not applicable 10 1 0 1 0 2 4 2 0 0 0 0 0 0 0 0 0 0 0
Unknown Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Driver/Operator 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Front row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Front row, right outboard, including motorcycle passenger in sidecar 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Second row, left outboard, including motorcycle passenger 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Second row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Second row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Third row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Third row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Third row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Position unknown, but the person was definitely an occupant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Sitting on someone�s lap 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Outside passenger compartment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Pedestrian 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Unknown 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Unknown Not applicable 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Driver/Operator 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Front row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Front row, right outboard, including motorcycle passenger in sidecar 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Second row, left outboard, including motorcycle passenger 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Second row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Second row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Third row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Third row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Third row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fourth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fourth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fourth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fifth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fifth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Fifth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Sixth row, left outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Sixth row, center 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Sixth row, right outboard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Position unknown, but the person was definitely an occupant 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Sitting on someone�s lap 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Outside passenger compartment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Pedestrian 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Unknown 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Not applicable Not applicable 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Raw
plot.R
library(tidyverse)
read_csv('collisions_injuries.csv',
skip=1, col_names=c('type', 'position', 'total', 1999:2016)) %>%
filter(type == 'Fatalities', position == 'Pedestrian') %>%
select(4:21) %>% gather(year, pedestrian_fatalities) %>%
ggplot(aes(x=year, y=pedestrian_fatalities, group=1)) +
geom_line(color='orangered') + geom_point() + theme_minimal() +
xlab('Year') + ylab('Pedestrian Fatalities') +
ggtitle('Pedestrian Fatalities in Canada 1999-2016\n(National Collision Database)')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment