Louisiana is kind of unique, especially post Katrina. South Louisiana is a hard drinking cuture. New Orleans is thug central. Baton Rouge took in a huge population from New Orleans post Katrina, clogging that city. Traffic and congestion is a huge issue as a result. Part of Baton Rouge is trying to split off (St George) in an effort to distance themselves from the "bad part." I'd bet the vast majority of the violence is from illegal guns in New Orleans and North Baton Rouge. If you cut the state in half (around Alexandria), the stats would be surprisingly different. The south has huge French Catholic and Italian Catholic influences ... both hotheads and drinkers. The north is almost entirely Protestant, teatotaller (anti alcohol), fundie, Bible Belters. They don't tend to shoot each other.
I've no experience with Missouri so no clue. I would imagine it is harder to bring so many illegal guns into Hawaii though, so that may influence their stats. I'm curious about the number of illegal guns as much as the legally owned ones.