	CaseID	Title	Location	City	State	Latitude	Longitude	Number of Victim Fatalities	Total Number of Fatalities	Number of Victims Injured	...	History of Mental Illness - General	Data Source 1	Data Source 2	Data Source 3	Data Source 4	Data Source 5	Data Source 6	Data Source 7	Military Experience	Class
0	1.0	University of Texas at Austin	Austin, Texas	Austin	Texas	30.198887	-97.844159	16.0	17.0	32.0	...	Yes	http://en.wikipedia.org/wiki/Charles_Whitman	Lexington Examiner (KY) - September 23, 2012	http://news.google.com/newspapers?id=lkk0AAAAI...	http://news.google.com/newspapers?id=PPUjAAAAI...	http://books.google.com/books?id=ClYEAAAAMBAJ&...	NaN	NaN	Yes	SPK
1	2.0	Rose-Mar College of Beauty	Mesa, Arizona	Mesa	Arizona	33.422687	-111.816320	5.0	5.0	1.0	...	Yes	"Slaughter In The College Of Beauty." Time 88....	Section: Lexington True Crime Examiner	http://www.nydailynews.com/news/crime/beauty-s...	http://books.google.com/books?id=Cre7qsswRiwC&...	NaN	NaN	NaN	Unknown	MS
2	3.0	New Orleans Police Shootings	New Orleans, Louisiana	New Orleans	Louisiana	30.068724	-89.931474	9.0	10.0	13.0	...	Yes	http://news.google.com/newspapers?nid=1144&dat...	http://theadvocate.com/home/4828836-125/rampag...	http://www.trutv.com/library/crime/notorious_m...	http://books.google.com/books?id=TfEDmROcZwEC&...	NaN	NaN	NaN	Unknown	SPK
3	4.0	Clara Barton Elementary School	Chicago, Illinois	Chicago	Illinois	41.839280	-87.688181	1.0	1.0	3.0	...	Yes	http://news.google.com/newspapers?nid=1338&dat...	http://news.google.com/newspapers?nid=1144&dat...	http://www.leagle.com/xmlResult.aspx?page=1&xm...	NaN	NaN	NaN	NaN	Unknown	MS
4	5.0	Olean High School	Olean, New York	Olean	New York	42.081854	-78.432139	3.0	3.0	7.0	...	No	http://buffalo.ynn.com/content/top_stories/622...	School Shootings: a History Part One of a seri...	http://www.newswithviews.com/Erica/Carle10.htm	http://books.google.com/books?id=ZuKoSskEWyIC&...	"Olean High School Shooting". Larrie Benton Za...	NaN	NaN	Unknown	MS
5	6.0	Los Angeles Computer Learning Center	Los Angeles, California	Los Angeles	California	34.176221	-118.539954	1.0	1.0	7.0	...	Unknown	http://news.google.com/newspapers?nid=1314&dat...	http://books.google.com/books?id=EPwmTueA1m0C&...	http://www.newspapers.com/newspage/15323499/	NaN	NaN	NaN	NaN	Unknown	MS
6	7.0	Cal State Fullerton	Fullerton, California	Fullerton	California	33.884042	-117.927850	7.0	7.0	2.0	...	Yes	http://ranchosantamargarita.patch.com/articles...	http://www.ocregister.com/articles/allaway-257...	http://www.dailytitan.com/2011/11/csuf-massacr...	http://criminalminds.wikia.com/wiki/Edward_All...	http://www.dailytitan.com/2011/11/csuf-massacr...	NaN	NaN	Unknown	MS
7	8.0	Grover Cleveland Elementary School	San Diego, California	San Diego	California	32.863573	-117.128163	2.0	2.0	9.0	...	Yes	http://www.utsandiego.com/news/2012/dec/14/loo...	http://www.newsnet5.com/dpp/news/local_news/i-...	http://www.examiner.com/article/the-san-diego-...	http://signofthetimes.yuku.com/topic/1258#.Uvb...	https://www.mail-archive.com/seeknfind@ashlist...	NaN	NaN	Unknown	MS
8	9.0	University of South Carolina	Columbia, South Carolina	Columbia	South Carolina	34.050988	-80.820775	2.0	2.0	5.0	...	Unknown	http://news.google.com/newspapers?nid=1755&dat...	https://news.google.com/newspapers?nid=1310&da...	http://news.google.com/newspapers?nid=1891&dat...	http://news.google.com/newspapers?nid=1338&dat...	NaN	NaN	NaN	Unknown	MS
9	10.0	Valley High School	Las Vegas, Nevada	Las Vegas	Nevada	36.189319	-115.326487	1.0	1.0	2.0	...	Yes	http://news.google.com/newspapers?id=CB4eAAAAI...	http://news.google.com/newspapers?id=QBtKAAAAI...	http://www.leagle.com/xmlResult.aspx?page=1&xm...	http://news.google.com/newspapers?nid=1345&dat...	http://www.lasvegassun.com/news/1999/apr/23/sl...	NaN	NaN	Unknown	MS
10	11.0	Welding shop in Miami	Miami, Florida	Miami	Florida	25.796539	-80.208404	8.0	9.0	3.0	...	Yes	http://www.nytimes.com/1982/08/21/us/gunman-in...	http://news.google.com/newspapers?id=uuYLAAAAI...	http://www.motherjones.com/politics/2012/12/ma...	http://www.nytimes.com/1982/08/24/us/no-charge...	http://www.nytimes.com/1982/10/14/us/florida-c...	NaN	NaN	Unknown	MS
11	12.0	Wah Mee Club in Seattle	Seattle, Washington	Seattle	Washington	47.621996	-122.323646	13.0	13.0	1.0	...	Unknown	http://www.historylink.org/index.cfm?DisplayPa...	http://www.komonews.com/news/archive/4196186.html	http://seattletimes.com/html/localnews/2010428...	http://wahmee.com/wahmeebook.html	http://murderpedia.org/male.N/images/ng_benjam...	NaN	NaN	Unknown	MS
12	13.0	Johnston Post Office	Johnston, South Carolina	Johnston	South Carolina	33.832729	-81.805158	1.0	1.0	3.0	...	Yes	http://www.alternet.org/story/24798/excerpt%3A...	http://www.reocities.com/HotSprings/5782/inmem...	http://sc.findacase.com/research/wfrmDocViewer...	http://news.google.com/newspapers?nid=861&dat=...	http://www.21cpw.com/BGP.pdf	NaN	NaN	Unknown	MS
13	14.0	49th Street Elementary School	Los Angeles, California	Los Angeles	California	34.176221	-118.539954	2.0	3.0	12.0	...	Yes	http://www.nytimes.com/1984/02/25/us/girl-kill...	http://books.google.com/books?id=YbQDAAAAMBAJ&...	http://articles.latimes.com/1985-02-24/news/mn...	http://www.ourweekly.com/issues-archive/tracki...	http://www.apnewsarchive.com/1985/New-Proposal...	NaN	NaN	Unknown	MS
14	15.0	Ianni's Club in Dallas	Dallas, Texas	Dallas	Texas	32.794806	-96.766311	6.0	6.0	1.0	...	Yes	http://www.nycrimecommission.org/mass-shooting...	http://www.nytimes.com/1984/06/30/us/6-die-in-...	http://www.mail-archive.com/deathpenalty@lists...	http://www.garylavergne.com/WTDexcerpt.htm	http://books.google.com/books?id=Hr3OBwP-lbUC&...	NaN	NaN	Unknown	MS
15	16.0	McDonald's restaurant in San Ysidro	San Ysidro, California	San Ysidro	California	32.555556	-117.047656	21.0	22.0	19.0	...	Yes	http://www.nycrimecommission.org/mass-shooting...	http://www.utsandiego.com/san-ysidro-massacre/	http://en.wikipedia.org/wiki/San_Ysidro_McDona...	http://www.history.com/this-day-in-history/twe...	http://www.sandiegouniontribune.com/san-ysidro...	NaN	NaN	Unknown	MS
16	17.0	Goddard Junior High School	Goddard, Kansas	Goddard	Kansas	37.671294	-97.550705	1.0	1.0	3.0	...	Yes	http://news.google.com/newspapers?nid=1345&dat...	http://news.google.com/newspapers?nid=1356&dat...	http://news.google.com/newspapers?nid=1499&dat...	http://news.google.com/newspapers?nid=1906&dat...	http://ks.findacase.com/research/wfrmDocViewer...	NaN	NaN	Unknown	MS
17	18.0	Atlanta Post Office	Atlanta, Georgia	Atlanta	Georgia	33.762997	-84.423133	2.0	2.0	1.0	...	Yes	http://articles.latimes.com/1985-03-07/news/mn...	http://www.apnewsarchive.com/1985/Postal-Clerk...	http://www.leagle.com/decision/198891983BR836_...	http://books.google.com/books?id=aiQ09D7nWxYC&...	http://news.google.com/newspapers?nid=1964&dat...	http://books.google.com/books?id=3B4lTTZE58oC&...	http://psychwatch.blogspot.com/2007/04/link-be...	Unknown	MS
18	19.0	New York Technical College	Brooklyn, New York	Brooklyn	New York	40.679276	-73.939513	1.0	1.0	4.0	...	Yes	http://www.nytimes.com/1986/08/16/nyregion/stu...	http://news.google.com/newspapers?nid=1917&dat...	http://www.apnewsarchive.com/1986/Five-Shot-On...	http://articles.philly.com/1986-08-14/news/260...	http://joycedavid.com/wp-content/uploads/2013/...	NaN	NaN	Unknown	MS
19	20.0	Post office in Edmond, Oklahoma	Edmond, Oklahoma	Edmond	Oklahoma	35.668892	-97.414388	14.0	15.0	6.0	...	Yes	http://digital.library.okstate.edu/encyclopedi...	http://newsok.com/sherrill-feared-mental-illne...	http://enidnews.com/opinion/x518655735/Aug-20-...	http://en.wikipedia.org/wiki/Patrick_Sherrill	http://www.fdungan.com/usps2.htm	NaN	NaN	Unknown	MS

20 rows × 48 columns