Although the Ohio Attorney General publishes quarterly concealed carry statistics on the licenses issued and renewed, I wanted to know the total number of concealed carry licenses in Ohio and whether existing license holders are renewing. Since concealed carry licenses are valid for five years I realized that I had almost all of the data I needed to calculate those numbers. My only problem was the missing reports for the 1st quarter of 2010 and the 4th quarter of 2012 so I had to estimate them. The formula for the total number of active licenses is the sum of the licenses issued and renewed over the last five years. The formula for the renewal rate is licenses renewed divided by the sum of the licenses issued and renewed from the same quarter five years ago. Since the attorney general data starts in 2008 I was only able to calculate the total concealed carry licenses for the last three years. Here is my best guess at the renewal rate and year over year growth rate for the last two of years.
|Date||Licenses Issued||Licenses Renewed||Total Licenses||Renewal Rate||License YoY Growth Rate|