Hokay ... wish I could post a picture of the "Mass Shootings in 2023",
https://www.gunviolencearchive.org/charts-and-maps ,
(I wonder how many would be called "mass shootings" by the FBI's definition of the term), but for the western US, working west to east, north to south:
Seattle; Portland; SF Bay Area; Sacramento; Stockton; Fresno; LA Area; San Bernardino; San Diego - mostly Dem-misgoverned cities
SW Utah; Phoenix; Tucson - Arizona cities' mayors are both Dems
Boulder (?, the dots are very obviously shifted northward from actual locations of major CO cities); Denver, Colorado Springs - only the latter has an R mayor
Brownsville(?); Lubbock; DFW; Austin-San Antonio area; Houston area - I'll leave it to Texas folk more familiar with those cities and areas to comment, but I'm pretty sure the relevant cities mostly have Dem mayors.
I'll leave central and eastern US cities to anyone caring to continue looking at the details of the map. It's an analysis that won't be to the liking of DU-onlurkers.