Geography
Where the archives say it happened
Two licensed historical datasets of US shootings, mapped and tabulated with their own definitions attached. They disagree about what counts, they stopped collecting years ago, and neither one is a census of the country.
Not current coverage. The CNN school archive ends in 2018 and the Stanford mass-shootings archive ends in 2016. Nothing here describes what has happened since. An empty result for a recent date range means no archive covers it, not that no shooting occurred.
Sources, licences and archive health
State: archive. Historical archives; not current US shooting coverage.
CNN school shootings archive
Coverage 2009-01-08 to 2018-12-11 · not current coverage · Archived; no scheduled refresh
What this source counts: K–12 school-property incidents in which at least one person other than the shooter was shot; includes qualifying accidental discharges and BB-gun injuries, with the stated law-enforcement/security exception.
- Source rows
- 180
- Included
- 180
- Flagged uncertain
- 0
- Excluded by the source
- 0
- Rows with no coordinate
- 3
Copyright (c) 2019 CNN. Licensed MIT. Pinned to commit 9cf80befac (2019-07-26), 27,619 bytes, SHA-256 b8c1447035f03eda…, checked 2026-09-13. No endorsement by the source is implied.
What this source says about its own limits
- Historical selected incidents, not a current or exhaustive US census.
- Coordinates are supplied by the source; point precision is unknown.
- County and metropolitan-area assignments are unavailable.
Stanford Mass Shootings in America archive
Coverage 1966-08-01 to 2016-06-26 · not current coverage · Archived; no scheduled refresh
What this source counts: At least three shooting victims, excluding the shooter; excludes identifiably gang-, drug-, or organized-crime-related shootings. Included, uncertain, and excluded source flags are retained.
- Source rows
- 335
- Included
- 325
- Flagged uncertain
- 6
- Excluded by the source
- 4
- Rows with no coordinate
- 0
Stanford Mass Shootings in America, courtesy of the Stanford Geospatial Center and Stanford Libraries. Licensed CC-BY-4.0. Pinned to commit 7025a75fdc (2018-03-26), 489,585 bytes, SHA-256 9d42ea9d72bc7280…, checked 2026-09-13. No endorsement by the source is implied.
What this source says about its own limits
- Historical selected incidents, not a current or exhaustive US census.
- Coordinates are supplied by the source; point precision is unknown.
- County and metropolitan-area assignments are unavailable.
- The source warns that changing online reporting creates historical ascertainment bias.
- Native CaseIDs 156 and 168 are reused for different incidents; explicit disambiguation preserves all rows.
515 source rows across both archives reconcile to 501 incidents in this selection, of which 498 carry a coordinate and 3 do not. 4 cross-source overlaps were manually reviewed and merged.
Filter
What this selection contains
- Incidents matching
- 501
- On the map
- 498
- Table only, no coordinate
- 3
- School definition
- 180
- Mass definition
- 325
- Date unknown
- 0
Showing all archived incidents. The two definition counts overlap and must not be added: 4 reviewed events appear under both. Uncertain records are excluded in this selection.
Map of 498 located incidents
Skip the map’s 498 points and go to the incident table
- School — CNN archive, 2009 to 2018. K–12 school property, at least one person other than the shooter shot.
- Mass — Stanford archive, 1966 to 2016. At least three shooting victims excluding the shooter.
- In both archives — one of the four manually reviewed overlaps. The two definitions are kept separate; the counts are not added.
- Hollow marker — the source flagged the record uncertain. Shown only while “include uncertain records” is on.
498 mapped points, every incident this filter matched that carries a coordinate — not the thirty rows below. 3 more incidents have no usable coordinate and are in the table only. Dates run from 1966-08-01 to 2018-12-11.
Albers equal-area conic projection of the coordinates the archives supply, scaled to fit the current selection. This map displays incident points, without boundary outlines or shaded regions. The pinned Census county and metro polygons are used separately to derive the approximate place labels below; they are modern boundaries, not event-date boundaries. Point precision is unknown: these are the source files’ own coordinates, not verified street addresses, and markers overlap where incidents are close together. Drawn extent 21.3°N to 61.2°N, 161.8°W to 69.7°W.
Selecting a point filters the table to that incident’s date and state and jumps to its row.
Counts by place
Counts of archived incidents per state, largest first. These are counts, not rates, and not a ranking of risk: the archives select for particular kinds of event and stop at different years.
- California (CA)54
- Florida (FL)39
- Texas (TX)34
- Georgia (GA)27
- Alabama (AL)22
- Illinois (IL)21
- Michigan (MI)19
- North Carolina (NC)19
- Washington (WA)18
- Ohio (OH)15
- Arizona (AZ)14
- New York (NY)14
- Tennessee (TN)14
- Pennsylvania (PA)12
- Virginia (VA)12
- Kentucky (KY)11
- Louisiana (LA)11
- Maryland (MD)10
- Missouri (MO)10
- South Carolina (SC)10
- Wisconsin (WI)10
- Colorado (CO)9
- Oklahoma (OK)8
- Minnesota (MN)7
- New Mexico (NM)7
- Nevada (NV)7
- Kansas (KS)6
- Massachusetts (MA)6
- Mississippi (MS)6
- Arkansas (AR)5
- Indiana (IN)5
- New Jersey (NJ)5
- Oregon (OR)5
- Nebraska (NE)4
- Utah (UT)4
- Connecticut (CT)3
- Iowa (IA)3
- Alaska (AK)2
- Hawaii (HI)2
- Montana (MT)2
- South Dakota (SD)2
- District of Columbia (DC)1
- Delaware (DE)1
- Idaho (ID)1
- Maine (ME)1
- Vermont (VT)1
- West Virginia (WV)1
- Wyoming (WY)1
County and metropolitan area
Approximate, and not the boundaries of the day. January 1, 2026 boundaries applied to historical incident points; not event-date boundaries.
Each label is produced by testing the source archive’s own coordinate against a pinned boundary polygon. The coordinate’s precision is unknown and is not a verified street address, the polygons are generalized to 0.001 degrees, and a point within 0.002 degrees of an edge is left unknown rather than assigned. An incident’s county label can therefore name an area that did not exist under that name on the date of the incident.
Derived from U.S. Census Bureau TIGER geographic data; not endorsed by the Census Bureau. Boundaries: U.S. Census Bureau TIGERweb, 2026-01-01 vintage, retrieved 2026-09-13. US federal government work (17 USC 105).
Which boundary layers, and how they were checked
- Counties (or statistically equivalent entities); January 1, 2026 vintage3,235 features, independently counted at 3,235; 8,147,620 bytes, SHA-256
4445f6eb4d509e66… - Metropolitan Statistical Areas; January 1, 2026 vintage393 features, independently counted at 393; 1,893,130 bytes, SHA-256
055b5ef53c15657e…
Method ray_cast_polygon_holes_v1; event-date boundaries: no. Licence: US federal government work (17 USC 105) (reference). Projection version 2c96e789c4fc6df1….
Counties and county equivalents
493 of 501 incidents in this selection carry a derived label, across 279 areas. These counts cover the whole selection, not the table page below.
- Cook County, IL (17031)14
- Los Angeles County, CA (06037)13
- Maricopa County, AZ (04013)10
- Fulton County, GA (13121)8
- Miami-Dade County, FL (12086)8
- Wayne County, MI (26163)8
- Harris County, TX (48201)7
- King County, WA (53033)6
- Orange County, CA (06059)6
- San Diego County, CA (06073)6
Show the remaining 269 areas
- Allegheny County, PA (42003)5
- Clark County, NV (32003)5
- Jefferson County, AL (01073)5
- Milwaukee County, WI (55079)5
- Orange County, FL (12095)5
- Tulsa County, OK (40143)5
- Bell County, TX (48027)4
- Bernalillo County, NM (35001)4
- Broward County, FL (12011)4
- Davidson County, TN (47037)4
- Douglas County, NE (31055)4
- Duval County, FL (12031)4
- Franklin County, OH (39049)4
- Jefferson County, KY (21111)4
- Orange County, NC (37135)4
- Orleans Parish, LA (22071)4
- St. Louis County, MO (29189)4
- Arapahoe County, CO (08005)3
- Cumberland County, NC (37051)3
- Cuyahoga County, OH (39035)3
- Dallas County, TX (48113)3
- Hillsborough County, FL (12057)3
- Lafayette Parish, LA (22055)3
- Lee County, AL (01081)3
- Madison County, AL (01089)3
- Mobile County, AL (01097)3
- Montgomery County, AL (01101)3
- Pima County, AZ (04019)3
- Prince George's County, MD (24033)3
- Riverside County, CA (06065)3
- Salt Lake County, UT (49035)3
- San Bernardino County, CA (06071)3
- San Francisco County, CA (06075)3
- Shelby County, TN (47157)3
- Snohomish County, WA (53061)3
- Spokane County, WA (53063)3
- Suffolk County, MA (25025)3
- Aiken County, SC (45003)2
- Alameda County, CA (06001)2
- Baltimore County, MD (24005)2
- Bexar County, TX (48029)2
- Caddo Parish, LA (22017)2
- Capitol Planning Region, CT (09110)2
- Charleston County, SC (45019)2
- El Paso County, CO (08041)2
- Essex County, NJ (34013)2
- Fayette County, KY (21067)2
- Grayson County, TX (48181)2
- Gwinnett County, GA (13135)2
- Hamilton County, OH (39061)2
- Hennepin County, MN (27053)2
- Honolulu County, HI (15003)2
- Jackson County, MO (29095)2
- Jefferson County, CO (08059)2
- Kalamazoo County, MI (26077)2
- Kings County, CA (06031)2
- Kings County, NY (36047)2
- Lee County, FL (12071)2
- Marion County, FL (12083)2
- Mason County, WA (53045)2
- Monroe County, NY (36055)2
- Monterey County, CA (06053)2
- Multnomah County, OR (41051)2
- Oakland County, MI (26125)2
- Oklahoma County, OK (40109)2
- Palm Beach County, FL (12099)2
- Philadelphia County, PA (42101)2
- Pierce County, WA (53053)2
- Rice County, MN (27131)2
- Rockdale County, GA (13247)2
- San Joaquin County, CA (06077)2
- San Juan County, NM (35045)2
- Santa Barbara County, CA (06083)2
- Santa Clara County, CA (06085)2
- Sedgwick County, KS (20173)2
- Travis County, TX (48453)2
- Waukesha County, WI (55133)2
- Wyandotte County, KS (20209)2
- Allen County, IN (18003)1
- Anchorage Municipality, AK (02020)1
- Anderson County, TX (48001)1
- Anson County, NC (37007)1
- Baltimore city, MD (24510)1
- Bay County, FL (12005)1
- Beltrami County, MN (27007)1
- Bergen County, NJ (34003)1
- Berkshire County, MA (25003)1
- Bethel Census Area, AK (02050)1
- Blount County, AL (01009)1
- Boone County, KY (21015)1
- Brevard County, FL (12009)1
- Brewster County, TX (48043)1
- Bronx County, NY (36005)1
- Broome County, NY (36007)1
- Buchanan County, VA (51027)1
- Butler County, IA (19023)1
- Butler County, KS (20015)1
- Butler County, OH (39017)1
- Butts County, GA (13035)1
- Calcasieu Parish, LA (22019)1
- Caroline County, VA (51033)1
- Carson City, NV (32510)1
- Cattaraugus County, NY (36009)1
- Champaign County, IL (17019)1
- Champaign County, OH (39021)1
- Charles Mix County, SD (46023)1
- Chatham County, GA (13051)1
- Chaves County, NM (35005)1
- Chesapeake city, VA (51550)1
- Chittenden County, VT (50007)1
- Clackamas County, OR (41005)1
- Clay County, FL (12019)1
- Clayton County, GA (13063)1
- Clearwater County, MN (27029)1
- Cobb County, GA (13067)1
- Coconino County, AZ (04005)1
- Coles County, IL (17029)1
- Colquitt County, GA (13071)1
- Columbia County, GA (13073)1
- Coryell County, TX (48099)1
- Craighead County, AR (05031)1
- Cumberland County, NJ (34011)1
- DeKalb County, GA (13089)1
- DeKalb County, IL (17037)1
- Denton County, TX (48121)1
- Denver County, CO (08031)1
- District of Columbia, DC (11001)1
- Douglas County, GA (13097)1
- Douglas County, MO (29067)1
- Douglas County, OR (41019)1
- Edgecombe County, NC (37065)1
- Edgefield County, SC (45037)1
- El Dorado County, CA (06017)1
- Elbert County, GA (13105)1
- Ellis County, TX (48139)1
- Elmore County, AL (01051)1
- Erie County, OH (39043)1
- Erie County, PA (42049)1
- Faulkner County, AR (05045)1
- Fergus County, MT (30027)1
- Floyd County, GA (13115)1
- Forest County, WI (55041)1
- Franklin County, NC (37069)1
- Frederick County, MD (24021)1
- Fresno County, CA (06019)1
- Fulton County, NY (36035)1
- Galveston County, TX (48167)1
- Geauga County, OH (39055)1
- Genesee County, MI (26049)1
- Geneva County, AL (01061)1
- Giles County, TN (47055)1
- Gloucester County, VA (51073)1
- Grant County, WA (53025)1
- Greenville County, SC (45045)1
- Greenwood County, SC (45047)1
- Habersham County, GA (13137)1
- Halifax County, VA (51083)1
- Hamilton County, IN (18057)1
- Hamilton County, TN (47065)1
- Harford County, MD (24025)1
- Harlan County, KY (21095)1
- Harvey County, KS (20079)1
- Henderson County, KY (21101)1
- Henrico County, VA (51087)1
- Herkimer County, NY (36043)1
- Hidalgo County, TX (48215)1
- Hinds County, MS (28049)1
- Houston County, AL (01069)1
- Independence County, AR (05063)1
- Ingham County, MI (26065)1
- Iredell County, NC (37097)1
- Jackson County, MI (26075)1
- Johnson County, IA (19103)1
- Kennebec County, ME (23011)1
- Kent County, MI (26081)1
- Kern County, CA (06029)1
- Kitsap County, WA (53035)1
- Knox County, TN (47093)1
- Lake County, IN (18089)1
- Lake County, OH (39085)1
- Lancaster County, PA (42071)1
- Lane County, OR (41039)1
- Latah County, ID (16057)1
- Lauderdale County, MS (28075)1
- Lawrence County, TN (47099)1
- Lenoir County, NC (37107)1
- Leon County, FL (12073)1
- Levy County, FL (12075)1
- Lincoln County, MS (28085)1
- Lincoln County, SD (46083)1
- Macon County, IL (17115)1
- Madison County, TN (47113)1
- Madison Parish, LA (22065)1
- Mahoning County, OH (39099)1
- Marion County, IN (18097)1
- Marshall County, KY (21157)1
- McCracken County, KY (21145)1
- Mecklenburg County, NC (37119)1
- Merced County, CA (06047)1
- Mercer County, NJ (34021)1
- Meriwether County, GA (13199)1
- Modoc County, CA (06049)1
- Monongalia County, WV (54061)1
- Montgomery County, MD (24031)1
- Montgomery County, PA (42091)1
- Montgomery County, VA (51121)1
- Moore County, NC (37125)1
- Morgan County, IN (18109)1
- Muskegon County, MI (26121)1
- Muskogee County, OK (40101)1
- Nash County, NC (37127)1
- Nassau County, NY (36059)1
- New Castle County, DE (10003)1
- New York County, NY (36061)1
- Norfolk County, MA (25021)1
- Nueces County, TX (48355)1
- Okaloosa County, FL (12091)1
- Onondaga County, NY (36067)1
- Ouachita County, AR (05103)1
- Panola County, MS (28107)1
- Pinellas County, FL (12103)1
- Plymouth County, MA (25023)1
- Polk County, IA (19153)1
- Portsmouth city, VA (51740)1
- Powell County, MT (30077)1
- Prince William County, VA (51153)1
- Pueblo County, CO (08101)1
- Pulaski County, AR (05119)1
- Rankin County, MS (28121)1
- Richland County, SC (45079)1
- Richmond city, VA (51760)1
- Richmond County, GA (13245)1
- Roanoke city, VA (51770)1
- Rowan County, NC (37159)1
- Rutherford County, TN (47149)1
- Saginaw County, MI (26145)1
- Schuyler County, NY (36097)1
- Scott County, IL (17171)1
- Scott County, MO (29201)1
- Sheridan County, WY (56033)1
- Smith County, TX (48423)1
- Solano County, CA (06095)1
- Somerset County, PA (42111)1
- Spartanburg County, SC (45083)1
- St. Clair County, IL (17163)1
- St. Mary's County, MD (24037)1
- Stanly County, NC (37167)1
- Stearns County, MN (27145)1
- Stokes County, NC (37169)1
- Suffolk County, NY (36103)1
- Sullivan County, TN (47163)1
- Sumter County, AL (01119)1
- Tarrant County, TX (48439)1
- Tehama County, CA (06103)1
- Texas County, MO (29215)1
- Tishomingo County, MS (28141)1
- Troup County, GA (13285)1
- Uvalde County, TX (48463)1
- Volusia County, FL (12127)1
- Wake County, NC (37183)1
- Ware County, GA (13299)1
- Washburn County, WI (55129)1
- Washoe County, NV (32031)1
- Washtenaw County, MI (26161)1
- Weber County, UT (49057)1
- Western Connecticut Planning Region, CT (09190)1
- Will County, IL (17197)1
- Winnebago County, WI (55139)1
- Yuba County, CA (06115)1
8 incidents have no county or county equivalent label. That is a refusal to guess, not a count of zero, and those incidents stay in the table and on the map. The reasons an incident lands here:
near_boundary: the source point falls within the boundary tolerance, so no area is claimed rather than one being pickedoverlap: the source point matched more than one area, so neither is claimedoutside: the source point falls outside every boundary in the layersource_state_conflict: the derived area's state disagrees with the state the source row states, so neither is claimedmissing_point: the source row carries no coordinate at allinvalid_point: the source row's coordinate is not a usable position
Metropolitan areas
493 of 501 incidents in this selection carry a derived label, across 149 areas. These counts cover the whole selection, not the table page below.
Non-metropolitan: 59 incidents. They are inside a county and outside every metropolitan area in the layer: a known non-metropolitan classification, not an unknown one. These are counted, not missing, and they are kept out of the ranking below because they are not a metropolitan area. Micropolitan places fall in here too: the layer holds metropolitan statistical areas only.
- Los Angeles-Long Beach-Anaheim, CA Metro Area (31080)19
- Atlanta-Sandy Springs-Roswell, GA Metro Area (12060)18
- Chicago-Naperville-Elgin, IL-IN Metro Area (16980)17
- Miami-Fort Lauderdale-West Palm Beach, FL Metro Area (33100)14
- Seattle-Tacoma-Bellevue, WA Metro Area (42660)11
- Detroit-Warren-Dearborn, MI Metro Area (19820)10
- Phoenix-Mesa-Chandler, AZ Metro Area (38060)10
- New York-Newark-Jersey City, NY-NJ Metro Area (35620)9
- Houston-Pasadena-The Woodlands, TX Metro Area (26420)8
- Milwaukee-Waukesha, WI Metro Area (33340)7
Show the remaining 139 areas
- Washington-Arlington-Alexandria, DC-VA-MD-WV Metro Area (47900)7
- Birmingham, AL Metro Area (13820)6
- Dallas-Fort Worth-Arlington, TX Metro Area (19100)6
- Denver-Aurora-Centennial, CO Metro Area (19740)6
- Riverside-San Bernardino-Ontario, CA Metro Area (40140)6
- San Diego-Chula Vista-Carlsbad, CA Metro Area (41740)6
- Augusta-Richmond County, GA-SC Metro Area (12260)5
- Boston-Cambridge-Newton, MA-NH Metro Area (14460)5
- Cleveland, OH Metro Area (17410)5
- Jacksonville, FL Metro Area (27260)5
- Killeen-Temple, TX Metro Area (28660)5
- Las Vegas-Henderson-North Las Vegas, NV Metro Area (29820)5
- Nashville-Davidson--Murfreesboro--Franklin, TN Metro Area (34980)5
- Orlando-Kissimmee-Sanford, FL Metro Area (36740)5
- Pittsburgh, PA Metro Area (38300)5
- San Francisco-Oakland-Fremont, CA Metro Area (41860)5
- St. Louis, MO-IL Metro Area (41180)5
- Tulsa, OK Metro Area (46140)5
- Albuquerque, NM Metro Area (10740)4
- Baltimore-Columbia-Towson, MD Metro Area (12580)4
- Charlotte-Concord-Gastonia, NC-SC Metro Area (16740)4
- Cincinnati, OH-KY-IN Metro Area (17140)4
- Columbus, OH Metro Area (18140)4
- Durham-Chapel Hill, NC Metro Area (20500)4
- Kansas City, MO-KS Metro Area (28140)4
- Louisville/Jefferson County, KY-IN Metro Area (31140)4
- Montgomery, AL Metro Area (33860)4
- New Orleans-Metairie, LA Metro Area (35380)4
- Omaha, NE-IA Metro Area (36540)4
- Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metro Area (37980)4
- Tampa-St. Petersburg-Clearwater, FL Metro Area (45300)4
- Wichita, KS Metro Area (48620)4
- Auburn-Opelika, AL Metro Area (12220)3
- Fayetteville, NC Metro Area (22180)3
- Huntsville, AL Metro Area (26620)3
- Indianapolis-Carmel-Greenwood, IN Metro Area (26900)3
- Lafayette, LA Metro Area (29180)3
- Memphis, TN-MS-AR Metro Area (32820)3
- Mobile, AL Metro Area (33660)3
- Portland-Vancouver-Hillsboro, OR-WA Metro Area (38900)3
- Salt Lake City-Murray, UT Metro Area (41620)3
- Spokane-Spokane Valley, WA Metro Area (44060)3
- Tucson, AZ Metro Area (46060)3
- Virginia Beach-Chesapeake-Norfolk, VA-NC Metro Area (47260)3
- Austin-Round Rock-San Marcos, TX Metro Area (12420)2
- Cape Coral-Fort Myers, FL Metro Area (15980)2
- Charleston-North Charleston, SC Metro Area (16700)2
- Colorado Springs, CO Metro Area (17820)2
- Dothan, AL Metro Area (20020)2
- Farmington, NM Metro Area (22140)2
- Hanford-Corcoran, CA Metro Area (25260)2
- Hartford-West Hartford-East Hartford, CT Metro Area (25540)2
- Jackson, MS Metro Area (27140)2
- Kalamazoo-Portage, MI Metro Area (28020)2
- Lexington-Fayette, KY Metro Area (30460)2
- Little Rock-North Little Rock-Conway, AR Metro Area (30780)2
- Minneapolis-St. Paul-Bloomington, MN-WI Metro Area (33460)2
- Ocala, FL Metro Area (36100)2
- Oklahoma City, OK Metro Area (36420)2
- Raleigh-Cary, NC Metro Area (39580)2
- Richmond, VA Metro Area (40060)2
- Rochester, NY Metro Area (40380)2
- Rocky Mount, NC Metro Area (40580)2
- Salinas, CA Metro Area (41500)2
- San Antonio-New Braunfels, TX Metro Area (41700)2
- San Jose-Sunnyvale-Santa Clara, CA Metro Area (41940)2
- Santa Maria-Santa Barbara, CA Metro Area (42200)2
- Sherman-Denison, TX Metro Area (43300)2
- Shreveport-Bossier City, LA Metro Area (43340)2
- Stockton-Lodi, CA Metro Area (44700)2
- Urban Honolulu, HI Metro Area (46520)2
- Anchorage, AK Metro Area (11260)1
- Ann Arbor, MI Metro Area (11460)1
- Bakersfield-Delano, CA Metro Area (12540)1
- Binghamton, NY Metro Area (13780)1
- Blacksburg-Christiansburg-Radford, VA Metro Area (13980)1
- Bremerton-Silverdale-Port Orchard, WA Metro Area (14740)1
- Bridgeport-Stamford-Danbury, CT Metro Area (14860)1
- Burlington-South Burlington, VT Metro Area (15540)1
- Carson City, NV Metro Area (16180)1
- Champaign-Urbana, IL Metro Area (16580)1
- Chattanooga, TN-GA Metro Area (16860)1
- Columbia, SC Metro Area (17900)1
- Corpus Christi, TX Metro Area (18580)1
- Crestview-Fort Walton Beach-Destin, FL Metro Area (18880)1
- Decatur, IL Metro Area (19500)1
- Deltona-Daytona Beach-Ormond Beach, FL Metro Area (19660)1
- Des Moines-West Des Moines, IA Metro Area (19780)1
- Erie, PA Metro Area (21500)1
- Eugene-Springfield, OR Metro Area (21660)1
- Flagstaff, AZ Metro Area (22380)1
- Flint, MI Metro Area (22420)1
- Fort Wayne, IN Metro Area (23060)1
- Fresno, CA Metro Area (23420)1
- Gainesville, FL Metro Area (23540)1
- Grand Rapids-Wyoming-Kentwood, MI Metro Area (24340)1
- Greenville-Anderson-Greer, SC Metro Area (24860)1
- Iowa City, IA Metro Area (26980)1
- Jackson, MI Metro Area (27100)1
- Jackson, TN Metro Area (27180)1
- Jonesboro, AR Metro Area (27860)1
- Kingsport-Bristol, TN-VA Metro Area (28700)1
- Knoxville, TN Metro Area (28940)1
- Lake Charles, LA Metro Area (29340)1
- Lancaster, PA Metro Area (29540)1
- Lansing-East Lansing, MI Metro Area (29620)1
- Lexington Park, MD Metro Area (30500)1
- McAllen-Edinburg-Mission, TX Metro Area (32580)1
- Merced, CA Metro Area (32900)1
- Morgantown, WV Metro Area (34060)1
- Muskegon-Norton Shores, MI Metro Area (34740)1
- Ogden, UT Metro Area (36260)1
- Oshkosh-Neenah, WI Metro Area (36780)1
- Paducah, KY-IL Metro Area (37140)1
- Palm Bay-Melbourne-Titusville, FL Metro Area (37340)1
- Panama City-Panama City Beach, FL Metro Area (37460)1
- Pinehurst-Southern Pines, NC Metro Area (38240)1
- Pittsfield, MA Metro Area (38340)1
- Pueblo, CO Metro Area (39380)1
- Reno, NV Metro Area (39900)1
- Roanoke, VA Metro Area (40220)1
- Rome, GA Metro Area (40660)1
- Sacramento-Roseville-Folsom, CA Metro Area (40900)1
- Saginaw, MI Metro Area (40980)1
- Sandusky, OH Metro Area (41780)1
- Savannah, GA Metro Area (42340)1
- Sioux Falls, SD-MN Metro Area (43620)1
- Spartanburg, SC Metro Area (43900)1
- St. Cloud, MN Metro Area (41060)1
- Syracuse, NY Metro Area (45060)1
- Tallahassee, FL Metro Area (45220)1
- Trenton-Princeton, NJ Metro Area (45940)1
- Tyler, TX Metro Area (46340)1
- Utica-Rome, NY Metro Area (46540)1
- Vallejo, CA Metro Area (46700)1
- Vineland, NJ Metro Area (47220)1
- Winston-Salem, NC Metro Area (49180)1
- Youngstown-Warren, OH Metro Area (49660)1
- Yuba City, CA Metro Area (49700)1
8 incidents have no metropolitan area label. That is a refusal to guess, not a count of zero, and those incidents stay in the table and on the map. The reasons an incident lands here:
county_near_boundary: the county lookup was inconclusive (the point is within the boundary tolerance), so no metro is claimed eithercounty_overlap: the county lookup matched more than one area, so no metro is claimed eithercounty_outside: the point falls outside every county, so no metro is claimed eithermissing_point: the source row carries no coordinate at allcounty_invalid_point: the coordinate is not usable, so no metro is claimed
Still no rates. Counts by county or metro area are not rates by county or metro area. No population denominator compatible with these archives’ selection criteria is supplied, and dividing by one from elsewhere would compare a selected, definition-specific sample against a complete population.
Rates per population: unavailable
Counts are not rates. No compatible population denominator is supplied with these archives, and dividing archive counts by a population figure from elsewhere would compare a selected, definition-specific sample against a complete one. Until a matching denominator exists, this page shows counts only.
Incidents
| Date | Incident | Place | Definition | Location on map | Source rows |
|---|---|---|---|---|---|
| 2014-08-08 | Albuquerque, NM | Albuquerque, New MexicoCounty: Bernalillo County, NM (approximate, 2026 boundary)Metro: Albuquerque, NM Metro Area (approximate, 2026 boundary) |
| 35.1529, -106.7791Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-06-29 | New Orleans, LA | New Orleans, LouisianaCounty: Orleans Parish, LA (approximate, 2026 boundary)Metro: New Orleans-Metairie, LA Metro Area (approximate, 2026 boundary) |
| 30.0687, -89.9315Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-06-23 | Kelly High School | Benton, MissouriCounty: Scott County, MO (approximate, 2026 boundary)Metro: Non-metropolitan, a classification, not a missing value |
| 37.0444, -89.4719Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-06-10 | Reynolds High School | Troutdale, OregonCounty: Multnomah County, OR (approximate, 2026 boundary)Metro: Portland-Vancouver-Hillsboro, OR-WA Metro Area (approximate, 2026 boundary) |
| 45.5285, -122.4026Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-06-08 | Las Vegas, NV | Las Vegas, NevadaCounty: Clark County, NV (approximate, 2026 boundary)Metro: Las Vegas-Henderson-North Las Vegas, NV Metro Area (approximate, 2026 boundary) |
| 36.1893, -115.3265Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-06-05 | Seattle, WA | Seattle, WashingtonCounty: King County, WA (approximate, 2026 boundary)Metro: Seattle-Tacoma-Bellevue, WA Metro Area (approximate, 2026 boundary) |
| 47.6220, -122.3236Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-05-23 | Isla Vista, CA | Isla Vista, CaliforniaCounty: Santa Barbara County, CA (approximate, 2026 boundary)Metro: Santa Maria-Santa Barbara, CA Metro Area (approximate, 2026 boundary) |
| 34.4146, -119.8581Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-05-21 | Clarke Street Elementary School | Milwaukee, WisconsinCounty: Milwaukee County, WI (approximate, 2026 boundary)Metro: Milwaukee-Waukesha, WI Metro Area (approximate, 2026 boundary) |
| 43.0663, -87.9493Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-05-03 | Horizon Elementary School | Everett, WashingtonCounty: Snohomish County, WA (approximate, 2026 boundary)Metro: Seattle-Tacoma-Bellevue, WA Metro Area (approximate, 2026 boundary) |
| 47.9207, -122.2370Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-04-29 | Kennesaw, GA | Kennesaw, GeorgiaCounty: Cobb County, GA (approximate, 2026 boundary)Metro: Atlanta-Sandy Springs-Roswell, GA Metro Area (approximate, 2026 boundary) |
| 34.0253, -84.6177Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-04-24 | Paul Robeson High School | Chicago, IllinoisCounty: Cook County, IL (approximate, 2026 boundary)Metro: Chicago-Naperville-Elgin, IL-IN Metro Area (approximate, 2026 boundary) |
| 41.7700, -87.6366Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-04-21 | St. Mary Catholic School | Griffith, IndianaCounty: Lake County, IN (approximate, 2026 boundary)Metro: Chicago-Naperville-Elgin, IL-IN Metro Area (approximate, 2026 boundary) |
| 41.5307, -87.4294Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-04-11 | East English Village Preparatory Academy | Detroit, MichiganCounty: Wayne County, MI (approximate, 2026 boundary)Metro: Detroit-Warren-Dearborn, MI Metro Area (approximate, 2026 boundary) |
| 42.4092, -82.9296Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-04-02 | Killeen, TX | Killeen, TexasCounty: Bell County, TX (approximate, 2026 boundary)Metro: Killeen-Temple, TX Metro Area (approximate, 2026 boundary) |
| 31.0793, -97.7339Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-03-23 | San Francisco, CA | San Francisco, CaliforniaCounty: San Francisco County, CA (approximate, 2026 boundary)Metro: San Francisco-Oakland-Fremont, CA Metro Area (approximate, 2026 boundary) |
| 37.7546, -122.4424Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-03-07 | Madison Parish High School | Tallulah, LouisianaCounty: Madison Parish, LA (approximate, 2026 boundary)Metro: Non-metropolitan, a classification, not a missing value |
| 32.4157, -91.1992Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-02-20 | Raytown Success Academy | Raytown, MissouriCounty: Jackson County, MO (approximate, 2026 boundary)Metro: Kansas City, MO-KS Metro Area (approximate, 2026 boundary) |
| 39.0940, -94.5688Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-02-20 | Alturas, CA | Alturas, CaliforniaCounty: Modoc County, CA (approximate, 2026 boundary)Metro: Non-metropolitan, a classification, not a missing value |
| 41.4911, -120.5491Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2014-02-10 | Salisbury High School | Salisbury, North CarolinaCounty: Rowan County, NC (approximate, 2026 boundary)Metro: Charlotte-Concord-Gastonia, NC-SC Metro Area (approximate, 2026 boundary) |
| 35.6648, -80.4849Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-01-31 | North High School | Des Moines, IowaCounty: Polk County, IA (approximate, 2026 boundary)Metro: Des Moines-West Des Moines, IA Metro Area (approximate, 2026 boundary) |
| 41.6177, -93.6223Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-01-17 | Valley Charter High School | Philadelphia, PennsylvaniaCounty: Philadelphia County, PA (approximate, 2026 boundary)Metro: Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metro Area (approximate, 2026 boundary) |
| 40.0331, -75.1446Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-01-14 | Berrendo Middle School | Roswell, New MexicoCounty: Chaves County, NM (approximate, 2026 boundary)Metro: Non-metropolitan, a classification, not a missing value |
| 33.4736, -104.5115Precision unknown; supplied by CNN school shootings archive. |
|
| 2014-01-09 | Liberty Technology Magnet High School | Jackson, TennesseeCounty: Madison County, TN (approximate, 2026 boundary)Metro: Jackson, TN Metro Area (approximate, 2026 boundary) |
| 35.6750, -88.7593Precision unknown; supplied by CNN school shootings archive. |
|
| 2013-12-28 | Montgomery, AL | Montgomery, AlabamaCounty: Montgomery County, AL (approximate, 2026 boundary)Metro: Montgomery, AL Metro Area (approximate, 2026 boundary) |
| 32.3473, -86.2673Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2013-12-19 | Edison High School | Fresno, CaliforniaCounty: Fresno County, CA (approximate, 2026 boundary)Metro: Fresno, CA Metro Area (approximate, 2026 boundary) |
| 36.7199, -119.8058Precision unknown; supplied by CNN school shootings archive. |
|
| 2013-12-13 | Arapahoe High School | Centennial, ColoradoCounty: Arapahoe County, CO (approximate, 2026 boundary)Metro: Denver-Aurora-Centennial, CO Metro Area (approximate, 2026 boundary) |
| 39.5817, -104.9628Precision unknown; supplied by CNN school shootings archive. |
|
| 2013-12-04 | West Orange High School | Winter Garden, FloridaCounty: Orange County, FL (approximate, 2026 boundary)Metro: Orlando-Kissimmee-Sanford, FL Metro Area (approximate, 2026 boundary) |
| 28.5428, -81.5673Precision unknown; supplied by CNN school shootings archive. |
|
| 2013-11-03 | Stephenson High School | Stone Mountain, GeorgiaCounty: DeKalb County, GA (approximate, 2026 boundary)Metro: Atlanta-Sandy Springs-Roswell, GA Metro Area (approximate, 2026 boundary) |
| 33.7736, -84.1246Precision unknown; supplied by CNN school shootings archive. |
|
| 2013-11-01 | Los Angeles, CA | Los Angeles, CaliforniaCounty: Los Angeles County, CA (approximate, 2026 boundary)Metro: Los Angeles-Long Beach-Anaheim, CA Metro Area (approximate, 2026 boundary) |
| 34.1762, -118.5400Precision unknown; supplied by Stanford Mass Shootings in America archive. |
|
| 2013-10-21 | Sparks Middle School | Sparks, NevadaCounty: Washoe County, NV (approximate, 2026 boundary)Metro: Reno, NV Metro Area (approximate, 2026 boundary) |
| 39.5517, -119.7694Precision unknown; supplied by CNN school shootings archive. |
|
Overlaps between the two archives
Only explicit reviewed named-venue links merge source records. Other overlaps may remain; category counts are not additive.
Chardon High School · Chardon High School
Manually reviewed date, state and named-school agreement in both pinned datasets.
Sandy Hook Elementary · Sandy Hook Elementary School
Manually reviewed date, state and named-school agreement in both pinned datasets.
Sparks Middle School · Sparks Middle School
Manually reviewed date, state and named-school agreement in both pinned datasets.
Marysville-Pilchuck High School · Marysville-Pilchuck High School
Manually reviewed date, state and named-school agreement in both pinned datasets.
2016-02-09 · unresolved candidate, counted separately
Muskegon Heights: date/city and generic high-school description suggest overlap, but named-venue corroboration is insufficient; not merged. Stanford marks it uncertain.
Limits of this data
- Historical selected incidents; reporting and definition differences prevent treating these as current national rates.
- Only explicitly reviewed cross-source overlaps are merged; other overlaps may remain. Category counts are not additive.
- Source coordinates have unknown precision and are not verified rooftop locations.
- County and metro labels are approximate point-in-polygon estimates using January 1, 2026 Census boundaries, not event-date boundaries.
- Near-boundary, ambiguous and missing points remain unknown; non-metropolitan is separate from unknown.
- Rates are disabled because no compatible population denominator is supplied.
Archive version fed61bae40f2764e…, imported 2026-09-13 04:08:57 UTC, rendered 2026-09-13 18:57:20 UTC.