Charles L. Cotton wrote:
Ashlar wrote:Chas, I wanted to ask you- how do you aggregate the similar crimes? Could you post how you 'roll up' crimes, for those of us who may not know how the crimes are coded?
If you can explain it, I could combine my spreadsheet with yours, so that you'd have individual crimes as well as an overall rate.
I already have the individual crimes in the spreadsheet. The first tab is the per 100,000 comparison; the most meaningful to the public. The detail is in the other tabs.
Thanks.. looking at the DPS report and comparing to the spreadsheet, there were a few that I wasn't sure how you rolled them up, like-
DEADLY WEAPON IN PENAL INSTITUTION
INJURY CHILD (multiple..)
Charles L. Cotton wrote:I've uploaded the crime comparison spreadsheet that includes 2008 and 2009 just released by DPS. The numbers are absolutely incredible and getting better. The overall comparison went from 7 times less likely to commit a crime to 13 times! The other examples I pulled out are equally impressive. You can see them in the first post in this thread.
Keep up the great work folks!!
Charles, a small quibble with your figure for TX Population, 21+ (2009 was all I checked)
You have it in the spreadsheet as 18,602,244.
If you go to http://www.dshs.state.tx.us/CHS/popdat/detailX.shtm
and click on 2009, in the resulting spreadsheet, row 45-
Texas 2009 '21+' -- 17,074,479
Is there a reason you're using the 17+ number?
From the DPS report-[quote] "Total Convictions in Texas" includes all convictions reported to the state criminal history repository for the offense during
the calendar year for individuals age 21 or over
. CCH Conviction counts based on CDN codes 310, 311, 326, 331, 332,
334, 397, and 398.[/b]
Am I missing something?
(Using my calculation, that 13x less likely goes up to 15x less likely.)