Skip to content

Instantly share code, notes, and snippets.

@vigorousnorth
Created March 28, 2018 20:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vigorousnorth/bcba470bc671cbe08937c1f7adf347b4 to your computer and use it in GitHub Desktop.
Save vigorousnorth/bcba470bc671cbe08937c1f7adf347b4 to your computer and use it in GitHub Desktop.
We can make this file beautiful and searchable if this error is corrected: It looks like row 52 should actually have 9 columns, instead of 10. in line 51.
State,suicide-firearm,suicide-suffocation,suicide-poisoning,suicide-other,homicide-firearm,homicide-other,police-firearm,others
Wyoming,56.6,13.8,13.2,2.8,5.9,5.5,0.4,1.8
Idaho,54.9,14.6,14.3,3.3,6.2,4.5,1.0,1.2
Montana,54.2,14.4,13.9,2.6,6.4,5.9,0.9,1.7
West Virginia,51.2,11.9,8.9,2.2,14.4,8.5,1.0,1.9
Alaska,49.5,17.0,8.1,2.5,13.0,8.1,0.7,1.1
Vermont,49.3,17.9,15.3,4.6,5.5,4.8,0.7,1.9
North Dakota,49.1,23.2,10.1,5.2,5.4,5.0,,2.0
Kentucky,48.7,13.1,8.6,2.4,17.2,8.0,0.6,1.4
Maine,46.9,18.7,16.3,5.9,5.4,4.5,1.0,1.3
Oregon,46.1,16.6,15.0,5.7,8.1,5.8,1.3,1.2
Utah,45.4,19.9,17.8,3.3,6.5,4.6,1.2,1.3
Oklahoma,43.1,14.3,9.8,2.0,18.2,9.6,0.6,2.4
Arkansas,42.8,11.9,9.2,2.2,22.6,9.4,0.5,1.4
South Dakota,42.5,26.0,12.3,1.9,4.6,10.1,1.0,1.6
New Hampshire,42.2,22.7,19.0,5.3,4.2,4.6,0.6,1.4
Tennessee,42.2,10.9,9.5,2.6,24.2,8.9,0.3,1.4
Alabama,41.6,9.2,5.5,2.1,30.4,9.1,0.3,1.8
Kansas,41.2,17.0,13.0,3.5,15.9,7.0,0.7,1.7
Colorado,40.9,18.7,17.1,3.6,10.6,6.8,0.9,1.4
Iowa,40.7,22.6,16.6,4.3,7.1,6.1,0.6,2.0
Nebraska,40.5,19.5,12.1,3.3,14.2,8.2,0.7,1.5
Nevada,40.5,13.3,15.1,3.9,16.1,8.4,1.1,1.6
Washington,40.2,16.9,16.2,6.7,10.6,6.7,1.1,1.6
Virginia,39.9,13.2,11.3,3.7,20.7,8.4,0.8,2.0
Arizona,39.6,13.7,11.8,3.0,20.3,9.4,0.8,1.4
South Carolina,39.6,10.7,8.2,2.3,26.6,10.4,0.5,1.7
Georgia,39.1,10.9,7.5,2.1,27.7,10.3,0.6,1.8
Minnesota,38.8,20.8,15.8,5.9,9.8,6.6,0.6,1.7
North Carolina,38.5,11.3,11.6,2.6,24.7,9.6,0.4,1.3
Mississippi,38.3,8.6,5.2,1.3,32.7,12.0,0.6,1.3
Missouri,38.0,13.6,10.9,2.4,24.3,8.5,0.4,1.9
Wisconsin,37.9,19.2,15.4,5.1,13.6,6.1,0.6,2.1
Indiana,37.7,15.8,11.4,2.4,21.5,8.5,0.7,2.0
New Mexico,37.4,16.8,13.0,2.8,15.0,11.9,1.6,1.5
Texas,37.3,14.6,8.7,2.3,23.1,10.8,0.6,2.6
Florida,36.2,14.1,13.6,5.1,19.9,8.9,0.4,1.8
Ohio,35.6,17.0,11.9,3.6,20.0,9.1,0.6,2.2
Pennsylvania,35.4,16.6,11.5,4.7,22.3,7.2,0.5,1.8
Louisiana,33.1,8.5,4.7,1.6,39.6,10.8,0.3,1.4
Michigan,32.1,15.6,11.6,3.0,26.5,9.0,0.5,1.7
Delaware,30.9,16.8,12.4,6.5,22.0,8.4,1.0,2.0
California,25.3,17.2,11.4,6.4,26.2,9.5,1.3,2.7
Maryland,23.5,13.2,8.0,4.1,34.8,13.2,1.3,1.9
Connecticut,23.4,25.7,15.9,7.2,17.1,9.1,,1.6
Illinois,21.7,17.8,10.6,5.2,31.3,10.8,,2.6
Rhode Island,20.5,29.3,16.5,9.4,13.1,9.0,,2.2
New York,18.8,19.6,10.0,10.2,20.9,17.7,0.5,2.3
Hawaii,17.0,40.1,12.5,12.6,5.1,9.9,0.8,2.0
Massachusetts,16.9,32.3,16.3,8.0,13.9,9.8,0.6,2.2
New Jersey,16.5,22.7,11.4,8.6,23.6,15.1,,2.1
Washington, DC,5.4,6.4,3.5,2.4,60.5,18.7,1.2,1.9
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment