We request that any publications that come from these data sets cite the paper that originated this data set in their work.

School Shooting data 1998 through August 2018 — List of all school shootings of any type over those years

The Excel file with the data is available here.


Red Flag/Extreme Risk Order Laws

The paper is available here. Information to replicate tables and robustness checks for paper is available here.


Detailed information on mass public shootings from 1998 through May 2021

An Excel spreadsheet that lists all the mass public shootings over this time period is available here: Mass Public Shooting cases 1998 through May 2021.


How a Botched Study Fooled the World About the U.S. Share of Mass Public Shootings: U.S. Rate is Lower than Global Average” 2019

The paper is available to be downloaded here.

“Brought Into the Open: How the U.S. Compares to Other Countries in the Rate of Public Mass Shooters” 2020

This paper is available to be downloaded here.

Appendix 1 Foreign Cases

Appendix 2 US Cases

Excel file for International Mass Public Shootings (more information on the exact calculations is available on request, the rest of the file was too large to place on the website for download)

The data for mass public shootings around the world from 1998 to 2017 is available here.

“Undocumented Immigrants, U.S. Citizens, and Convicted Criminals in Arizona,” by John R. Lott, Jr.

The paper is available here.  The data as a STATA file is available here.  See also the codebook and the “do file” (also a STATA file).


Documented information on attacks on gun-free zones (see here).

“Do White Police Officers Unfairly Target Black Suspects?” by John R. Lott, Jr. and Carlisle E. Moody

The paper is available here.

Data and do file can be downloaded here.

Australian Data on homicides and suicides from 1915 to 2014 is available here.

More Guns, Less Crime (3rd Ed., University of Chicago Press, 2010)

MGLCRevision graphing before and after by year.smcl

MGLCRevision Table 4b reverse order.smcl


MGLCRevision Table 4a.smcl

MGLC Rev State

By Decade

MGLC Rev State

Most of this data involves STATA 7.0 data sets. The reason for using this is that the county level data involves a much larger set of control variables than can readily be handled by other statistical packages.  To help with the variable names:

for the demographics

pp = percent of the population

w= white

b= black

n= neither black or white

m= male

f= female

1019= 10 to 19 years of age, etc

so ppbm1019 = percent of the population that is black male 10 to 19 years of age

rpcpi = real per capita personal income

rpcim = real per capita income maintenance (welfare type payments)

rpcui = real per capita unemployment insurance

rpcrpo = real per capita retirement gov payments (SS, medicare)

CCWage = age eligible to have a concealed handgun permit

assaultweaponsban2 = assault weapon ban, either state or federal

the crime data is the natural log of the crime rate (though .01 is added to the crime rate when it is equal to zero)

ao stands for the arrest rate data by type of crime

The data and its sources are described in the data appendix for my book More Guns, Less Crime (University of Chicago Press, 3rd edition, 2010).

More data sets can be obtained by clicking on the following links which will take you to the download page:

The data and “do” file for the original paper by Lott and Mustard, “Crime, Deterrence, and Right-to-Carry Concealed Handguns,” Journal of Legal Studies, Vol. 26, no. 1, January 1997: 1-68 is available here.
STATA data set: sendcounty1997.dta
Do file:

Terms of Use: All material posted on this website has been copyrighted since 2013 by John R. Lott, Jr. All rights reserved.