TexasCHLforum.com

Happy to help!

I'm going to see if I can figure out another way to represent the data, that's a bit more amenable to casual perusal. The problem is that you're dealing with at least 3 dimensions of data- year, crime, and rates.

Maybe a graph with a drop-down that lets you specify a particular crime, or overall? Or a drop down for year, with all crimes or total rates, etc?

Let me think on it for a bit, I'm sure I can come up with something.

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.

Chas.

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-

HOAX BOMBS
DEADLY WEAPON IN PENAL INSTITUTION
INJURY CHILD (multiple..)
OWNER/OPER (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!!

Chas.

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" onclick="window.open(this.href);return false; 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-

"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.)

Thanks,

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.

Aha! We got 2 years of data..

http://www.txdps.state.tx.us/administra ... vrates.htm" onclick="window.open(this.href);return false;



The gap between the rates has never been higher. In 2009, the rate for CHL holders of being convicted of any crime is 25 per 100,000. The rate for the general public over 21 years old? 383 per 100,000. That's 15 times the rate of CHL holders.

Any idea when the 2008 numbers will be out? I'd like to update my graph as well..

I spent some time looking at the summary data from the DPS site and came up with the following:



I didn't do the breakdown of data per offense, just a summary. I compared the conviction rate of CHL holders (per 100k permit holders) to the conviction rate of the general public (per 100k population > 21 yoa). There are more numbers in the excel worksheet.

Population data: http://www.dshs.state.tx.us/CHS/popdat/detailX.shtm" onclick="window.open(this.href);return false;
Conviction data: http://www.txdps.state.tx.us/administra ... vrates.htm" onclick="window.open(this.href);return false;