Bad Drivers: bad-drivers.csv

Table actions

This table contains data behind the story Dear Mona, Which State Has The Worst Drivers?

Variable Source
State N/A
Number of drivers involved in fatal collisions per billion miles National Highway Traffic Safety Administration, 2012
Percentage Of Drivers Involved In Fatal Collisions Who Were Speeding National Highway Traffic Safety Administration, 2009
Percentage Of Drivers Involved In Fatal Collisions Who Were Alcohol-Impaired National Highway Traffic Safety Administration, 2012
Percentage Of Drivers Involved In Fatal Collisions Who Were Not Distracted National Highway Traffic Safety Administration, 2012
Percentage Of Drivers Involved In Fatal Collisions Who Had Not Been Involved In Any Previous Accidents National Highway Traffic Safety Administration, 2012
Car Insurance Premiums ($) National Association of Insurance Commissioners, 2011
Losses incurred by insurance companies for collisions per insured driver ($) National Association of Insurance Commissioners, 2010

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

51 rows sorted by Percentage Of Drivers Involved In Fatal Collisions Who Had Not Been Involved In Any Previous Accidents

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Percentage Of Drivers Involved In Fatal Collisions Who Were Speeding, Percentage Of Drivers Involved In Fatal Collisions Who Were Alcohol-Impaired, Percentage Of Drivers Involved In Fatal Collisions Who Were Not Distracted, Percentage Of Drivers Involved In Fatal Collisions Who Had Not Been Involved In Any Previous Accidents

Link rowid State Number of drivers involved in fatal collisions per billion miles Percentage Of Drivers Involved In Fatal Collisions Who Were Speeding Percentage Of Drivers Involved In Fatal Collisions Who Were Alcohol-Impaired Percentage Of Drivers Involved In Fatal Collisions Who Were Not Distracted Percentage Of Drivers Involved In Fatal Collisions Who Had Not Been Involved In Any Previous Accidents ▼ Car Insurance Premiums ($) Losses incurred by insurance companies for collisions per insured driver ($)
18 18 Kentucky 21.4 19 23 78 76 872.51 137.13
23 23 Michigan 14.1 24 28 95 77 1110.61 152.26
31 31 New Jersey 11.2 16 28 86 78 1301.52 159.85
40 40 Rhode Island 11.1 34 38 92 79 1148.99 148.58
1 1 Alabama 18.8 39 30 96 80 784.55 145.08
22 22 Massachusetts 8.2 23 35 87 80 1011.14 135.63
33 33 New York 12.3 32 29 88 80 1234.31 150.01
34 34 North Carolina 16.8 39 31 94 81 708.24 127.82
41 41 South Carolina 23.9 38 41 96 81 858.97 116.29
43 43 Tennessee 19.5 21 29 82 81 767.91 155.57
7 7 Connecticut 10.8 46 36 87 82 1068.73 167.02
36 36 Ohio 14.1 28 34 99 82 697.73 133.52
30 30 New Hampshire 11.6 35 30 87 83 746.54 120.21
20 20 Maine 15.1 38 30 87 84 661.88 96.57
26 26 Missouri 16.1 43 34 92 84 790.32 144.45
50 50 Wisconsin 13.8 36 33 39 84 670.31 106.62
17 17 Kansas 17.8 27 24 77 85 780.45 133.8
27 27 Montana 21.4 39 44 84 85 816.21 85.15
35 35 North Dakota 23.9 23 42 99 86 688.75 109.72
42 42 South Dakota 19.4 31 33 98 86 669.31 96.87
48 48 Washington 10.6 42 33 82 86 890.03 111.62
12 12 Hawaii 17.5 54 41 82 87 861.18 120.92
16 16 Iowa 15.7 17 25 97 87 649.06 114.47
44 44 Texas 19.4 40 38 91 87 1004.75 156.83
49 49 West Virginia 23.8 34 28 97 87 992.61 152.56
24 24 Minnesota 9.6 23 29 88 88 777.18 133.35
39 39 Pennsylvania 18.2 50 31 96 88 905.99 153.86
47 47 Virginia 12.7 19 27 87 88 768.95 153.72
5 5 California 12.0 35 28 91 89 878.41 165.63
28 28 Nebraska 14.9 13 35 93 90 732.28 114.82
38 38 Oregon 12.8 33 26 67 90 804.71 104.61
51 51 Wyoming 17.4 42 32 81 90 791.14 122.04
11 11 Georgia 15.6 19 25 95 93 913.15 142.8
2 2 Alaska 18.1 41 25 90 94 1053.48 133.93
10 10 Florida 17.9 21 29 92 94 1160.13 144.18
37 37 Oklahoma 19.9 32 29 92 94 881.51 178.86
4 4 Arkansas 22.4 18 26 94 95 827.34 142.39
6 6 Colorado 13.6 37 28 79 95 835.5 139.91
15 15 Indiana 14.5 25 29 95 95 710.46 108.92
46 46 Vermont 13.6 30 30 96 95 716.2 109.61
3 3 Arizona 18.6 35 28 84 96 899.47 110.35
14 14 Illinois 12.8 36 34 94 96 803.11 139.15
45 45 Utah 11.3 43 16 88 96 809.38 109.48
13 13 Idaho 15.3 36 29 85 98 641.96 82.75
19 19 Louisiana 20.5 35 33 73 98 1281.55 194.78
32 32 New Mexico 18.4 19 27 67 98 869.85 120.75
8 8 Delaware 16.2 38 30 87 99 1137.87 151.48
21 21 Maryland 12.5 34 32 71 99 1048.78 192.7
29 29 Nevada 14.7 37 32 95 99 1029.87 138.71
9 9 District of Columbia 5.9 34 27 100 100 1273.89 136.05
25 25 Mississippi 17.6 15 31 10 100 896.07 155.77

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "bad-drivers/bad-drivers" (
"State" TEXT,
  "Number of drivers involved in fatal collisions per billion miles" REAL,
  "Percentage Of Drivers Involved In Fatal Collisions Who Were Speeding" INTEGER,
  "Percentage Of Drivers Involved In Fatal Collisions Who Were Alcohol-Impaired" INTEGER,
  "Percentage Of Drivers Involved In Fatal Collisions Who Were Not Distracted" INTEGER,
  "Percentage Of Drivers Involved In Fatal Collisions Who Had Not Been Involved In Any Previous Accidents" INTEGER,
  "Car Insurance Premiums ($)" REAL,
  "Losses incurred by insurance companies for collisions per insured driver ($)" REAL
);