Bad Drivers: bad-drivers.csv

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

51 rows sorted by Losses incurred by insurance companies for collisions per insured driver ($)

View and edit SQL

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

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
);
Powered by Datasette · Query took 63.016ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub