I blogged a few weeks ago about the newest suicide prevention coalition in Lincoln, of which I am a member. The second meeting is coming up, and I volunteered to assemble some data. My IT staff extracted .csv files from the police records management system for me. I dropped these into an Excel workbook and attacked the data with pivot tables and filters, creating several charts, and a couple maps with ArcGIS for the coalition. I've invested about four hours in this project.
There weren't any big surprises for me, but it is rather interesting to examine this over such a long period, and may be informative to the other coalition members. The four charts below show the year-by-year trend over the past two decades for completed and attempted suicides. These data show that attempts are relatively flat despite a population increase of over 60,000, while completed suicides and trending up.
The group is focusing on young people in the age range of 10 through 24. As a result, I have broken out charts specifically for that age group in addition to the overall data. I'll publish a few more next week, so this will be a series of about four posts. If you click on each graph, you will get a larger version that is easier to read.