School Shootings - Patterns? Stats included

GO_HORNS_GO · Jun 1, 2022

I am not trying to trivialize or marginalize this in any way. Just trying to look at some raw data and thought I would share.

I was looking to see if there were any patterns on school shootings (deaths) since Columbine on 4/20/1999. Since that day in 1999, there have been 374 people killed in school shootings across our country. (Honestly, thought it was more). There have been an additional 672 people injured during those shootings over the same amount of time. (total of 1046 killed or injured). Note: List does include college shootings, school related functions, and at school buses.

First is number of deaths by month/year:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
1999				15	0						1	0	16
2000		1			1	2		2	0			0	6
2001			3		2								5
2002	3	1								4			8
2003				3	1				2				6
2004		1			0								1
2005		0	11				1		0		1		13
2006		0	0					3	6	6			15
2007	1		0	33					1	1	0		36
2008	0	10						2	0	3	1		16
2009	0			0	2	0			0				2
2010		1			0				1	1	1	0	4
2011	2		1	0	0			0	2	0		2	7
2012	0	3	2	7				0	0	1		27	40
2013	4		1	1	0	6		1		2	0	2	17
2014	3	0	0	1	0	3			0	6	2	0	15
2015	0	1	0	1	0			1	1	13	2		19
2016	0	2		1		4			3	0		0	10
2017	1		0	3	2	0			1	2	6	3	18
2018	4	18	5	0	11			1	2	1		1	43
2019	2	2	0	2	2	0	0	0	1	1	9	1	20
2020	3	3	1				1		1			1	10
2021		1	1	2	0			2	2	2	5	1	16
2022	2	3	2	0	24
Total	25	47	27	69	45	15	2	12	23	43	28	38	374

Now, number of injuries:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
1999				21	6						0	6	33
2000		0			0	0		0	2			1	3
2001			20		0								20
2002	5	0								2			7
2003				4	3				0				7
2004		2			4								6
2005		1	7				2		1		2		13
2006		1	2					5	6	5			19
2007	0		1	23					1	5	1		31
2008	1	25						0	0	4	0		30
2009	5			3	0	3			1				12
2010		3			1				3	2	0	1	10
2011	2		6	3	1			1	0	1		2	16
2012	1	4	0	3				3	0	4		2	17
2013	10		0	5	0	4		3		4	6	2	34
2014	12	3	0	0	4	4			5	1	4	4	37
2015	5	5	1	1	9			0	3	16	1		41
2016	1	8		2		3			4	8		0	26
2017	2		1	1	0	2			4	0	20	0	30
2018	20	26	7	2	20			3	2	1		0	81
2019	8	2	3	18	11	1	1	12	10	1	8	5	80
2020	5	1	3				1		1			0	11
2021		0	1	1	3			10	13	15	15	4	62
2022	4	4	5	5	28								46
Total	81	85	57	92	90	17	4	37	56	69	57	27	672

From this, it looks like the worst months are Feb, Apr, May and Oct. I would assume Apr/May due to end of school year. June - August with school out are the smallest months.

Now, by State:

State	Deaths
California	45
Texas	43
Virginia	40
Connecticut	27
Florida	25
Colorado	21
Washington	15
Oregon	14
Minnesota	13
Louisiana	12
Pennsylvania	12
Illinois	9
Michigan	9
Arizona	8
North Carolina	8
Tennessee	8
Arkansas	5
Kentucky	5
New Mexico	5
Ohio	5
Wisconsin	5
Georgia	4
Nevada	4
South Carolina	4
Alabama	3
Indiana	3
Maryland	3
Massachusetts	3
West Virginia	3
Delaware	2
Nebraska	2
New Jersey	2
Vermont	2
D.C.	1
Iowa	1
Mississippi	1
Missouri	1
Rhode Island	1
Alaska	0
District of Columbia	0
Hawaii	0
Idaho	0
Kansas	0
New York	0
Oklahoma	0
South Dakota	0
Utah	0
Wyoming	0
Grand Total	374

This seems to be all over the place. States with large populations seem to lead the nation. Surprised to see New York with zero. States at the top are mixed politically too.

	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	Total
California		0	2						0	1	0	1	2	7	6	1	2	3	9	0	7	2	2		45
Texas												1	1	0	0		1	1	2	10	0	5	0	22	43
Virginia				3					33		0		2		0					0	0		0	2	40
Connecticut														27		0					0				27
Florida		1							0	1				2	1	2	0			17	1	0		0	25
Colorado	15							2				0			2						2		0		21
Washington		2	2						1	1				0		6			1		2				15
Oregon								0								2	10				2				14
Minnesota					2		10																0	1	13
Louisiana		0			1					3	1				0		0		2	0	0	1	3	1	12
Pennsylvania			0		2			6							0	0		0		1	1	0	1	1	12
Illinois							0			6	0	0		1	1	0			1	0	0	0	0	0	9
Michigan		1								1		0			0	1	0	0		2	0		4	0	9
Tennessee							2			1				0	0	0	1			0	1		2	1	8
North Carolina								1				0	0		0	0	2			2	2		1	0	8
Arizona				4													1	2				1	0		8
Wisconsin				1				1				1					0	1			0			1	5
New Mexico	1															0			3		0		1	0	5
Arkansas		2								2											0		1		5
Kentucky															3	0				2					5
Ohio					1				1	0				3		0		0	0		0				5
South Carolina																1		2					0	1	4
Georgia	0												0		0	1	1		0	2	0			0	4
Nevada								0							2		1			1					4
Maryland				0		0								0			0			3	0		0	0	3
Alabama												1			0			0		1	0	1	0		3
Indiana			1										0			1		0		1					3
Massachusetts											1				1			1							3
West Virginia								3																	3
Delaware									1														1		2
Nebraska													2												2
New Jersey				0			1														1				2
Vermont								2																	2
Iowa																0								1	1
D.C.					0	1		0																	1
Mississippi															1					0	0		0		1
Missouri								0							0		0			0	1		0		1
Rhode Island																				1					1
District of Columbia																									0
Kansas																									0
Alaska																									0
Hawaii																									0
Idaho																									0
New York																									0
Oklahoma																									0
South Dakota																									0
Utah																									0
Wyoming																									0
Grand Total	16	6	5	8	6	1	13	15	36	16	2	4	7	40	17	15	19	10	18	43	20	10	16	31	374

Out of 375 school shootings from 4/20/99 (Columbine) there have been 374 deaths. 156 shootings resulted in 1 or more deaths. The remainder had zero deaths but did include injuries:

Date	Year	Location	State	Deaths	Injuries
04/16/07	2007	Blacksburg, Virginia	Virginia	33	23
12/14/12	2012	Newtown, Connecticut	Connecticut	27	2
05/24/22	2022	Uvalde, Texas	Texas	22	18
02/14/18	2018	Parkland, Florida	Florida	17	17
04/20/99	1999	Columbine, Colorado	Colorado	15	21
03/21/05	2005	Red Lake, Minnesota	Minnesota	10	7
10/01/15	2015	Roseburg, Oregon	Oregon	10	9
05/18/18	2018	Santa Fe, Texas	Texas	10	13
04/02/12	2012	Oakland, California	California	7	3
10/02/06	2006	Nickel Mines, Pennsylvania	Pennsylvania	6	5
02/14/08	2008	DeKalb, Illinois	Illinois	6	21
06/07/13	2013	Santa Monica, California	California	6	4
11/14/17	2017	Rancho Tehama Reserve, California	California	6	18
10/24/14	2014	Marysville, Washington	Washington	5	1
10/28/02	2002	Tucson, Arizona	Arizona	4	0
11/30/21	2021	Oxford Township, Michigan	Michigan	4	7
01/16/02	2002	Grundy, Virginia	Virginia	3	3
09/02/06	2006	Shepherdstown, West Virginia	West Virginia	3	0
02/08/08	2008	Baton Rouge, Louisiana	Louisiana	3	0
02/27/12	2012	Chardon, Ohio	Ohio	3	3
01/15/13	2013	Hazard, Kentucky	Kentucky	3	0
06/01/16	2016	Los Angeles, California	California	3	0
04/10/17	2017	San Bernardino, California	California	3	1
12/07/17	2017	Aztec, New Mexico	New Mexico	3	0
11/14/19	2019	Santa Clarita, California	California	3	3
06/28/00	2000	Seattle, Washington	Washington	2	0
08/28/00	2000	Fayetteville, Arkansas	Arkansas	2	0
03/05/01	2001	Santee, California	California	2	13
05/16/01	2001	Parkland, Washington	Washington	2	0
04/24/03	2003	Red Lion, Pennsylvania	Pennsylvania	2	0
09/24/03	2003	Cold Spring, Minnesota	Minnesota	2	0
08/24/06	2006	Essex Junction, Vermont	Vermont	2	3
09/27/06	2006	Bailey, Colorado	Colorado	2	0
10/26/08	2008	Conway, Arkansas	Arkansas	2	1
01/05/11	2011	Omaha, Nebraska	Nebraska	2	2
09/28/11	2011	Jurupa Valley, California	California	2	0
12/08/11	2011	Blacksburg, Virginia	Virginia	2	0
03/06/12	2012	Jacksonville, Florida	Florida	2	0
10/21/13	2013	Sparks, Nevada	Nevada	2	2
12/13/13	2013	Centennial, Colorado	Colorado	2	0
06/10/14	2014	Troutdale, Oregon	Oregon	2	1
02/12/16	2016	Glendale, Arizona	Arizona	2	0
09/28/16	2016	Townville, South Carolina	South Carolina	2	2
05/04/17	2017	Irving, Texas	Texas	2	0
10/25/17	2017	Grambling, Louisiana	Louisiana	2	0
01/23/18	2018	Marshall County, Kentucky	Kentucky	2	18
03/02/18	2018	Mount Pleasant, Michigan	Michigan	2	0
03/20/18	2018	Great Mills, Maryland	Maryland	2	1
04/30/19	2019	Charlotte, North Carolina	North Carolina	2	4
11/23/19	2019	Union City, California	California	2	0
11/26/19	2019	Salmon Creek, Washington	Washington	2	1
02/03/20	2020	Commerce, Texas	Texas	2	1
02/01/22	2022	Bridgewater, Virginia	Virginia	2	1
11/19/99	1999	Deming, New Mexico	New Mexico	1	0
02/29/00	2000	Flint, Michigan	Michigan	1	0
05/26/00	2000	Lake Worth, Florida	Florida	1	0
03/30/01	2001	Gary, Indiana	Indiana	1	0
02/20/02	2002	Milwaukee, Wisconsin	Wisconsin	1	0
04/14/03	2003	New Orleans, Louisiana	Louisiana	1	3
05/09/03	2003	Cleveland, Ohio	Ohio	1	3
02/02/04	2004	Washington, D.C.	D.C.	1	1
03/02/05	2005	Dover, Tennessee	Tennessee	1	0
07/18/05	2005	Newark, New Jersey	New Jersey	1	2
11/08/05	2005	Jacksboro, Tennessee	Tennessee	1	2
08/30/06	2006	Hillsborough, North Carolina	North Carolina	1	2
09/29/06	2006	Cazenovia, Wisconsin	Wisconsin	1	0
01/03/07	2007	Tacoma, Washington	Washington	1	0
09/21/07	2007	Dover, Delaware	Delaware	1	1
10/10/07	2007	Cleveland, Ohio	Ohio	1	5
02/12/08	2008	Oxnard, California	California	1	0
08/14/08	2008	Federal Way, Washington	Washington	1	0
08/21/08	2008	Knoxville, Tennessee	Tennessee	1	0
10/16/08	2008	Detroit, Michigan	Michigan	1	3
11/12/08	2008	Fort Lauderdale, Florida	Florida	1	0
05/18/09	2009	Cambridge, Massachusetts	Massachusetts	1	0
05/18/09	2009	Larose, Louisiana	Louisiana	1	0
02/05/10	2010	Madison, Alabama	Alabama	1	0
09/28/10	2010	Austin, Texas	Texas	1	1
10/01/10	2010	Salinas, California	California	1	0
11/29/10	2010	Marinette, Wisconsin	Wisconsin	1	0
03/31/11	2011	Houston, Texas	Texas	1	5
10/19/12	2012	Chicago, Illinois	Illinois	1	0
01/16/13	2013	Chicago, Illinois	Illinois	1	0
03/18/13	2013	Orlando, Florida	Florida	1	0
04/18/13	2013	Cambridge, Massachusetts	Massachusetts	1	0
08/23/13	2013	Sardis, Mississippi	Mississippi	1	2
01/21/14	2014	West Lafayette, Indiana	Indiana	1	0
01/24/14	2014	Orangeburg, South Carolina	South Carolina	1	0
01/25/14	2014	Los Angeles, California	California	1	0
04/11/14	2014	Detroit, Michigan	Michigan	1	0
06/05/14	2014	Seattle, Washington	Washington	1	3
10/03/14	2014	Fairburn, Georgia	Georgia	1	0
11/20/14	2014	Tallahassee, Florida	Florida	1	3
11/20/14	2014	Miami, Florida	Florida	1	1
02/14/15	2015	Merced, California	California	1	0
04/13/15	2015	Goldsboro, North Carolina	North Carolina	1	0
08/27/15	2015	Savannah, Georgia	Georgia	1	0
09/03/15	2015	Sacramento, California	California	1	2
10/09/15	2015	Flagstaff, Arizona	Arizona	1	3
10/09/15	2015	Houston, Texas	Texas	1	1
10/22/15	2015	Nashville, Tennessee	Tennessee	1	3
11/01/15	2015	Winston-Salem, North Carolina	North Carolina	1	1
11/20/15	2015	North Las Vegas, Nevada	Nevada	1	0
04/23/16	2016	Antigo, Wisconsin	Wisconsin	1	2
06/08/16	2016	Dorchester, Massachusetts	Massachusetts	1	3
09/09/16	2016	Alpine, Texas	Texas	1	2
01/27/17	2017	Naperville, Illinois	Illinois	1	0
09/13/17	2017	Rockford, Washington	Washington	1	3
01/20/18	2018	Winston-Salem, North Carolina	North Carolina	1	0
01/31/18	2018	Philadelphia, Pennsylvania	Pennsylvania	1	0
02/24/18	2018	Savannah, Georgia	Georgia	1	0
03/07/18	2018	Birmingham, Alabama	Alabama	1	2
05/18/18	2018	Jonesboro, Georgia	Georgia	1	3
08/04/18	2018	Edgewood, Maryland	Maryland	1	0
09/05/18	2018	Providence, Rhode Island	Rhode Island	1	1
09/11/18	2018	North Las Vegas, Nevada	Nevada	1	0
10/29/18	2018	Matthews, North Carolina	North Carolina	1	1
12/13/18	2018	Richmond, Indiana	Indiana	1	0
01/07/19	2019	Belmont, California	California	1	0
01/11/19	2019	Eugene, Oregon	Oregon	1	0
02/12/19	2019	Kansas City, Missouri	Missouri	1	0
02/17/19	2019	Arapahoe County, Colorado	Colorado	1	0
05/04/19	2019	Eugene, Oregon	Oregon	1	0
05/07/19	2019	Highlands Ranch, Colorado	Colorado	1	8
09/06/19	2019	Pittsburgh, Pennsylvania	Pennsylvania	1	0
10/13/19	2019	Nashville, Tennessee	Tennessee	1	0
11/13/19	2019	Los Angeles, California	California	1	0
11/15/19	2019	Pleasantville, New Jersey	New Jersey	1	2
12/19/19	2019	Naples, Florida	Florida	1	0
01/11/20	2020	Dallas, Texas	Texas	1	1
01/14/20	2020	Bellaire, Texas	Texas	1	0
01/31/20	2020	Antioch, California	California	1	0
02/04/20	2020	Baton Rouge, Louisiana	Louisiana	1	0
03/15/20	2020	Humble, Texas	Texas	1	0
07/27/20	2020	Oro Valley, Arizona	Arizona	1	0
09/16/20	2020	Sonora, California	California	1	0
12/17/20	2020	Birmingham, Alabama	Alabama	1	0
02/26/21	2021	New Orleans, Louisiana	Louisiana	1	0
03/01/21	2021	Pine Bluff, Arkansas	Arkansas	1	0
04/12/21	2021	Knoxville, Tennessee	Tennessee	1	1
04/27/21	2021	Smyrna, Delaware	Delaware	1	0
08/13/21	2021	Albuquerque, New Mexico	New Mexico	1	0
08/27/21	2021	Sharon Hill, Pennsylvania	Pennsylvania	1	4
09/01/21	2021	Winston-Salem, North Carolina	North Carolina	1	0
09/07/21	2021	Buena Park, California	California	1	0
10/13/21	2021	Grambling, Louisiana	Louisiana	1	1
10/17/21	2021	Grambling, Louisiana	Louisiana	1	7
11/30/21	2021	Humboldt, Tennessee	Tennessee	1	2
12/06/21	2021	Wilmington, California	California	1	2
01/19/22	2022	Pittsburgh, Pennsylvania	Pennsylvania	1	0
01/29/22	2022	Beloit, Wisconsin	Wisconsin	1	0
02/01/22	2022	Richfield, Minnesota	Minnesota	1	1
03/07/22	2022	Des Moines, Iowa	Iowa	1	2
03/31/22	2022	Greenville, South Carolina	South Carolina	1	0
05/18/22	2022	Murfreesboro, Tennessee	Tennessee	1	1
05/31/22	2022	New Orleans, Louisiana	Louisiana	1	2
05/20/99	1999	Conyers, Georgia	Georgia	0	6
12/06/99	1999	Fort Gibson, Oklahoma	Oklahoma	0	6
09/26/00	2000	New Orleans, Louisiana	Louisiana	0	2
12/01/00	2000	San Diego, California	California	0	1
03/07/01	2001	Williamsport, Pennsylvania	Pennsylvania	0	1
03/22/01	2001	El Cajon, California	California	0	6
01/15/02	2002	New York City, New York	New York	0	2
10/07/02	2002	Bowie, Maryland	Maryland	0	1
10/29/02	2002	Jersey City, New Jersey	New Jersey	0	1
04/02/03	2003	Washington, D.C.	D.C.	0	1
02/09/04	2004	East Greenbush, New York	New York	0	1
05/07/04	2004	Randallstown, Maryland	Maryland	0	4
02/08/05	2005	Chicago, Illinois	Illinois	0	1
09/13/05	2005	Chicago, Illinois	Illinois	0	1
02/23/06	2006	Roseburg, Oregon	Oregon	0	1
03/14/06	2006	Reno, Nevada	Nevada	0	2
09/17/06	2006	Pittsburgh, Pennsylvania	Pennsylvania	0	5
09/22/06	2006	Washington, D.C.	D.C.	0	1
10/09/06	2006	Joplin, Missouri	Missouri	0	0
03/07/07	2007	Compton, California	California	0	1
11/07/07	2007	Miami Gardens, Florida	Florida	0	1
01/23/08	2008	Jonesboro, Arkansas	Arkansas	0	1
02/04/08	2008	Memphis, Tennessee	Tennessee	0	1
02/11/08	2008	Miami Gardens, Florida	Florida	0	1
02/11/08	2008	Memphis, Tennessee	Tennessee	0	1
02/27/08	2008	Little Rock, Arkansas	Arkansas	0	1
09/02/08	2008	Willoughby, Ohio	Ohio	0	0
01/09/09	2009	Chicago, Illinois	Illinois	0	5
04/26/09	2009	Hampton, Virginia	Virginia	0	3
06/16/09	2009	San Francisco, California	California	0	3
09/03/09	2009	San Bruno, California	California	0	1
02/19/10	2010	DeKalb, Illinois	Illinois	0	1
02/23/10	2010	Littleton, Colorado	Colorado	0	2
05/11/10	2010	Bladenboro, North Carolina	North Carolina	0	1
09/08/10	2010	Detroit, Michigan	Michigan	0	2
10/08/10	2010	Carlsbad, California	California	0	2
12/06/10	2010	Aurora, Colorado	Colorado	0	1
03/25/11	2011	Martinsville, Indiana	Indiana	0	1
04/19/11	2011	Houston, Texas	Texas	0	3
05/23/11	2011	Pearl City, Hawaii	Hawaii	0	1
08/19/11	2011	Albany, Georgia	Georgia	0	1
10/24/11	2011	Fayetteville, North Carolina	North Carolina	0	1
12/09/11	2011	Edinburg, Texas	Texas	0	2
01/10/12	2012	Houston, Texas	Texas	0	1
02/23/12	2012	Bremerton, Washington	Washington	0	1
08/16/12	2012	Memphis, Tennessee	Tennessee	0	2
08/27/12	2012	Perry Hall, Maryland	Maryland	0	1
09/07/12	2012	Normal, Illinois	Illinois	0	0
10/31/12	2012	Los Angeles, California	California	0	4
01/10/13	2013	Taft, California	California	0	2
01/12/13	2013	Detroit, Michigan	Michigan	0	1
01/15/13	2013	St. Louis, Missouri	Missouri	0	2
01/22/13	2013	Houston, Texas	Texas	0	3
01/31/13	2013	Atlanta, Georgia	Georgia	0	2
04/12/13	2013	Christiansburg, Virginia	Virginia	0	2
04/16/13	2013	Grambling, Louisiana	Louisiana	0	3
05/14/13	2013	Birmingham, Alabama	Alabama	0	0
08/20/13	2013	Decatur, Georgia	Georgia	0	0
08/22/13	2013	Memphis, Tennessee	Tennessee	0	0
08/30/13	2013	Winston-Salem, North Carolina	North Carolina	0	1
10/04/13	2013	Pine Hills, Florida	Florida	0	2
11/02/13	2013	Greensboro, North Carolina	North Carolina	0	1
11/03/13	2013	Lithonia, Georgia	Georgia	0	2
11/13/13	2013	Pittsburgh, Pennsylvania	Pennsylvania	0	3
12/04/13	2013	Winter Garden, Florida	Florida	0	1
12/19/13	2013	Fresno, California	California	0	1
01/09/14	2014	Jackson, Tennessee	Tennessee	0	1
01/13/14	2014	New Haven, Connecticut	Connecticut	0	1
01/14/14	2014	Roswell, New Mexico	New Mexico	0	3
01/17/14	2014	Philadelphia, Pennsylvania	Pennsylvania	0	2
01/20/14	2014	Chester, Pennsylvania	Pennsylvania	0	1
01/27/14	2014	Carbondale, Illinois	Illinois	0	1
01/28/14	2014	Nashville, Tennessee	Tennessee	0	1
01/30/14	2014	Palm Bay, Florida	Florida	0	1
01/31/14	2014	Des Moines, Iowa	Iowa	0	1
02/10/14	2014	Salisbury, North Carolina	North Carolina	0	1
02/10/14	2014	Lyndhurst, Ohio	Ohio	0	0
02/12/14	2014	Los Angeles, California	California	0	1
02/22/14	2014	Augusta, Georgia	Georgia	0	1
03/25/14	2014	College Park, Georgia	Georgia	0	0
05/04/14	2014	Augusta, Georgia	Georgia	0	1
05/05/14	2014	Augusta, Georgia	Georgia	0	1
05/08/14	2014	Lawrenceville, Georgia	Georgia	0	1
05/14/14	2014	Richmond, California	California	0	1
09/09/14	2014	Miami, Florida	Florida	0	1
09/11/14	2014	Taylorsville, Utah	Utah	0	1
09/27/14	2014	Terre Haute, Indiana	Indiana	0	1
09/30/14	2014	Albemarle, North Carolina	North Carolina	0	1
09/30/14	2014	Louisville, Kentucky	Kentucky	0	1
12/12/14	2014	Portland, Oregon	Oregon	0	4
01/15/15	2015	Milwaukee, Wisconsin	Wisconsin	0	3
01/16/15	2015	Ocala, Florida	Florida	0	2
02/04/15	2015	Frederick, Maryland	Maryland	0	2
02/23/15	2015	Daytona Beach, Florida	Florida	0	3
03/30/15	2015	University City, Missouri	Missouri	0	1
04/16/15	2015	Paradis, Louisiana	Louisiana	0	1
05/12/15	2015	Jacksonville, Florida	Florida	0	2
05/24/15	2015	Flint, Michigan	Michigan	0	7
09/30/15	2015	Harrisburg, South Dakota	South Dakota	0	1
01/22/16	2016	Indianapolis, Indiana	Indiana	0	1
01/29/16	2016	Philadelphia, Pennsylvania	Pennsylvania	0	0
02/09/16	2016	Muskegon Heights, Michigan	Michigan	0	4
02/29/16	2016	Middletown, Ohio	Ohio	0	4
10/11/16	2016	Mobile, Alabama	Alabama	0	1
10/13/16	2016	Columbus, Ohio	Ohio	0	2
10/18/16	2016	San Francisco, California	California	0	4
10/25/16	2016	Sandy, Utah	Utah	0	1
12/01/16	2016	Bountiful, Utah	Utah	0	0
01/20/17	2017	West Liberty, Ohio	Ohio	0	1
01/20/17	2017	Seattle, Washington	Washington	0	1
03/21/17	2017	King City, California	California	0	1
06/14/17	2017	Chicago, Illinois	Illinois	0	2
09/20/17	2017	Mattoon, Illinois	Illinois	0	1
11/13/17	2017	Albany, Georgia	Georgia	0	2
01/10/18	2018	Denison, Texas	Texas	0	0
01/22/18	2018	Italy, Texas	Texas	0	1
01/22/18	2018	New Orleans, Louisiana	Louisiana	0	1
02/01/18	2018	Los Angeles, California	California	0	5
02/05/18	2018	Oxon Hill, Maryland	Maryland	0	1
02/09/18	2018	Nashville, Tennessee	Tennessee	0	1
02/27/18	2018	Itta Bena, Mississippi	Mississippi	0	1
02/27/18	2018	Norfolk, Virginia	Virginia	0	1
03/07/18	2018	Jackson, Mississippi	Mississippi	0	1
03/08/18	2018	Mobile, Alabama	Alabama	0	1
03/09/18	2018	Lexington, Kentucky	Kentucky	0	1
03/13/18	2018	Seaside, California	California	0	1
04/12/18	2018	Raytown, Missouri	Missouri	0	1
04/20/18	2018	Ocala, Florida	Florida	0	1
05/11/18	2018	Palmdale, California	California	0	1
05/16/18	2018	Dixon, Illinois	Illinois	0	1
05/25/18	2018	Noblesville, Indiana	Indiana	0	2
08/17/18	2018	Wellington, Florida	Florida	0	2
08/20/18	2018	Atlanta, Georgia	Georgia	0	0
08/30/18	2018	San Francisco, California	California	0	1
09/10/18	2018	Memphis, Tennessee	Tennessee	0	1
01/02/19	2019	Jersey City, New Jersey	New Jersey	0	0
01/03/19	2019	Miami, Florida	Florida	0	0
01/04/19	2019	Columbus, Mississippi	Mississippi	0	1
01/19/19	2019	Overland Park, Kansas	Kansas	0	2
01/25/19	2019	Mobile, Alabama	Alabama	0	2
01/30/19	2019	Lithonia, Georgia	Georgia	0	1
01/30/19	2019	Prairie View, Texas	Texas	0	0
01/31/19	2019	Memphis, Tennessee	Tennessee	0	1
01/31/19	2019	Humble, Texas	Texas	0	1
02/08/19	2019	Baltimore, Maryland	Maryland	0	1
02/11/19	2019	Seaside, California	California	0	0
02/14/19	2019	Rio Rancho, New Mexico	New Mexico	0	0
02/26/19	2019	Montgomery, Alabama	Alabama	0	1
02/28/19	2019	Cheyenne, Wyoming	Wyoming	0	0
03/07/19	2019	Grambling, Louisiana	Louisiana	0	1
03/22/19	2019	Blounstville, Alabama	Alabama	0	1
03/27/19	2019	Holmes County, Mississippi	Mississippi	0	1
04/01/19	2019	Prescott, Arkansas	Arkansas	0	1
04/25/19	2019	Texas City, Texas	Texas	0	3
04/25/19	2019	Stone Mountain, Georgia	Georgia	0	10
05/06/19	2019	Riverview, Florida	Florida	0	0
05/07/19	2019	Savannah, Georgia	Georgia	0	1
05/08/19	2019	Chicago, Illinois	Illinois	0	1
05/17/19	2019	Jacksonville, Florida	Florida	0	1
06/21/19	2019	Flint, Michigan	Michigan	0	1
07/02/19	2019	Anchorage, Alaska	Alaska	0	1
07/19/19	2019	San Diego, California	California	0	0
08/08/19	2019	Montgomery, Alabama	Alabama	0	0
08/27/19	2019	Los Angeles, California	California	0	1
08/30/19	2019	Toledo, Ohio	Ohio	0	1
08/31/19	2019	Mobile, Alabama	Alabama	0	10
09/13/19	2019	Newport News, Virginia	Virginia	0	3
09/14/19	2019	Fort Worth, Texas	Texas	0	2
09/20/19	2019	Philadelphia, Pennsylvania	Pennsylvania	0	2
09/27/19	2019	Richmond, California	California	0	3
10/22/19	2019	Santa Rosa, California	California	0	1
11/05/19	2019	Hazleton, Pennsylvania	Pennsylvania	0	1
11/11/19	2019	Baltimore, Maryland	Maryland	0	1
12/02/19	2019	Waukesha, Wisconsin	Wisconsin	0	1
12/03/19	2019	Oshkosh, Wisconsin	Wisconsin	0	2
12/04/19	2019	Jackson, Mississippi	Mississippi	0	1
12/16/19	2019	New Haven, Connecticut	Connecticut	0	1
01/08/20	2020	Belle Glade, Florida	Florida	0	1
01/14/20	2020	Fort Worth, Texas	Texas	0	2
01/23/20	2020	Oxnard, California	California	0	1
03/05/20	2020	Weston, Florida	Florida	0	1
03/11/20	2020	Shenango Township, Pennsylvania	Pennsylvania	0	2
07/29/20	2020	Collinsville, Illinois	Illinois	0	1
09/16/20	2020	Macomb, Illinois	Illinois	0	1
09/19/20	2020	San Francisco, California	California	0	0
03/08/21	2021	Chesterfield, South Carolina	South Carolina	0	1
04/26/21	2021	Plymouth, Minnesota	Minnesota	0	0
05/06/21	2021	Rigby, Idaho	Idaho	0	3
08/18/21	2021	Orangeburg, South Carolina	South Carolina	0	3
08/27/21	2021	Woodridge, Virginia	Virginia	0	2
08/27/21	2021	Wilmington, North Carolina	North Carolina	0	1
09/04/21	2021	Towson, Maryland	Maryland	0	3
09/20/21	2021	Newport News, Virginia	Virginia	0	4
09/21/21	2021	Wichita, Kansas	Kansas	0	3
09/24/21	2021	Fairfield, Alabama	Alabama	0	1
09/30/21	2021	Memphis, Tennessee	Tennessee	0	1
09/30/21	2021	Newton, Mississippi	Mississippi	0	1
10/01/21	2021	Houston, Texas	Texas	0	1
10/06/21	2021	Arlington, Texas	Texas	0	4
10/12/21	2021	Chicago, Illinois	Illinois	0	2
11/01/21	2021	Madison, Mississippi	Mississippi	0	0
11/19/21	2021	Aurora, Colorado	Colorado	0	3
11/26/21	2021	Campbell, California	California	0	2
11/29/21	2021	Phoenix, Arizona	Arizona	0	1
12/08/21	2021	Kansas City, Missouri	Missouri	0	2
01/04/22	2022	Rockford, Illinois	Illinois	0	2
01/09/22	2022	Murfreesboro, North Carolina	North Carolina	0	0
01/11/22	2022	Albuquerque, New Mexico	New Mexico	0	0
01/19/22	2022	Sanford, Florida	Florida	0	1
01/21/22	2022	Derwood, Maryland	Maryland	0	1
02/08/22	2022	Catonsville, Maryland	Maryland	0	1
02/09/22	2022	Minneapolis, Minnesota	Minnesota	0	1
03/04/22	2022	Olathe, Kansas	Kansas	0	3
04/05/22	2022	Erie, Pennsylvania	Pennsylvania	0	1
04/22/22	2022	Washington, District of Columbia	District of Columbia	0	4
05/09/22	2022	Suwanee, Georgia	Georgia	0	1
05/17/22	2022	Chicago, Illinois	Illinois	0	1
05/19/22	2022	Hammond, Louisiana	Louisiana	0	3
05/19/22	2022	Kentwood, Michigan	Michigan	0	2
			Totals	374	672

Texas is the only state to have 2 school shootings that resulted in 10+ deaths (Uvalde and Santa Fe).
There have been 14 school related shootings (3.7% of the total number) that have resulted in 5+ deaths, totaling 180 (48.1%) deaths.
According to the Austin American Statesman, it found that more than 2/3rds of the shooters are under the age of 18 and the median age for school shooters was 16.
Virginia Tech shooter (worst since Columbine) used two pistols. Santa Fe shooter used shotgun and .38 revolver.

41to38 · Jun 1, 2022