When I hear about city murder rates, I always wonder whether that refers to the city proper, or the greater metro-area. City murder rates are usually higher because suburbs tend to be safer. But city borders can be arbitrary- when considering two similar metro-areas, one city could have larger borders, which then makes it appear safer because it includes more suburban-type neighborhoods. To help clear this up, I used FBI data to graph the city murder rate versus the murder rate for the entire metropolitan statistical area (MSA):

New Orleans is the clear outlier. Detroit, Baltimore, and St. Louis have similarly high murder rates in the city, but New Orleans has a uniquely high murder rate for the MSA. The murder rate for the greater metro area of New Orleans is about as high as the city of Memphis or Atlanta (unlabeled).
The trend line shows the average relationship between the city rate and the MSA rate. Virgina Beach is noticeably above the trend line, but that is because the Virginia Beach MSA is a combination of multiple cities, including the less-safe Norfolk and Newport News, unlike most other MSAs which tend to be a single large city and surrounding suburbs.
In each case, the largest city by population in the MSA is graphed, and only MSAs with at least a million residents are included.
The same graph is reproduced below as an interactive, which provides hover text for unlabeled cities:
The relationship between city murder rate and MSA murder rate is fairly strong (R square = 0.57). But this is at least partly driven by the inclusion of city rates in the MSA rate. The graph below shows city rate and the non-city rate- the MSA rate minus the murders and population from the city.
Notice there is almost no relationship between city murder rate and suburb murder rate (R Square = 0.02).
Cities lowest on the graph and to the left have the safest suburbs relative to the city. Milwaukee's murder rate is the most segregated along city borders- a person in the city is 28 times more likely to be murdered than a person in the metropolitan area outside of the city.
*Some MSAs did not have all member cities/municipalities report crime data. In these cases, I used the FBI's estimated totals. All cities had reporting for at least 94% of their population, with the exception of Indianapolis (86%).
New Orleans is the clear outlier. Detroit, Baltimore, and St. Louis have similarly high murder rates in the city, but New Orleans has a uniquely high murder rate for the MSA. The murder rate for the greater metro area of New Orleans is about as high as the city of Memphis or Atlanta (unlabeled).
The trend line shows the average relationship between the city rate and the MSA rate. Virgina Beach is noticeably above the trend line, but that is because the Virginia Beach MSA is a combination of multiple cities, including the less-safe Norfolk and Newport News, unlike most other MSAs which tend to be a single large city and surrounding suburbs.
In each case, the largest city by population in the MSA is graphed, and only MSAs with at least a million residents are included.
The same graph is reproduced below as an interactive, which provides hover text for unlabeled cities:
The relationship between city murder rate and MSA murder rate is fairly strong (R square = 0.57). But this is at least partly driven by the inclusion of city rates in the MSA rate. The graph below shows city rate and the non-city rate- the MSA rate minus the murders and population from the city.
Notice there is almost no relationship between city murder rate and suburb murder rate (R Square = 0.02).
Cities lowest on the graph and to the left have the safest suburbs relative to the city. Milwaukee's murder rate is the most segregated along city borders- a person in the city is 28 times more likely to be murdered than a person in the metropolitan area outside of the city.
*Some MSAs did not have all member cities/municipalities report crime data. In these cases, I used the FBI's estimated totals. All cities had reporting for at least 94% of their population, with the exception of Indianapolis (86%).
John, I am trying to contact one of the top authors on Tableau about getting on viz of the day but it is tough to find contact information for you two. Please e-mail me at cdjohnson013@Gmail.com or check out my viz at
ReplyDeletehttps://public.tableau.com/profile/clinton.johnson6689#!/vizhome/LeagueofLegendsStronkestADCs2/Dashboard1
Thanks, and sorry for the plug but I'm honestly just trying to get a contact point
Thanks Clinton. I'm not familiar with League of Legends, but it looks like a cool way to use Tableau to understand one of your other interests. You can find me on twitter @keltz_, or contact me on email- john.keltz at gmail.
DeleteNice post!! Thanks for sharing.
ReplyDeleteDermology anti aging Serum
dermology anti aging cream
Dermology
dermology hair removal cream
dermology hair removal cream
dermology hair removal cream
dermology cellulite cream
Xtreme No
Xtremeno
hgh energizer
https://www.quester.pk/question/who-is-sultan-salman-khan-movie-heroine/
ReplyDeletehttps://www.quester.pk/question/does-ufone-have-3g-coverage-in-dg-khan/
https://www.quester.pk/question/does-ufone-have-3g-coverage-in-depalpur/
https://www.quester.pk/question/does-ufone-have-3g-coverage-in-daska/
https://www.quester.pk/question/does-ufone-have-3g-coverage-in-chiniot/
Kingoroot App is very popular android rooting tool which is based on Windows And Android
ReplyDeletekingoroot for pc
Patriots vs Falcons
ReplyDeleteNew England Patriots vs Atlanta Falcons
Falcons vs Patriots
Super Bowl 2017
Super Bowl
2017 Super Bowl
NFL Super Bowl 2017
Super Bowl 2017
ReplyDeleteSuper Bowl 2017 live
Super Bowl 2017
2017 Super Bowl
NFL Super Bowl 2017
Patriots vs Falcons
Falcons vs Patriots
Super Bowl 51
ReplyDeletePatriots vs Falcons
Super Bowl 2017
Falcons vs Patriots
Watch Super Bowl 2017
Super Bowl 2017 halftime show
Super Bowl 2017 Live
super bowl 2017
ReplyDeletesuper bowl 2017 live
super bowl 2017 time
2017 super bowl
watch super bowl 2017
Grammy 2017 will be at 5:00 PM - 8:30 PM on Sunday, February 12, 2017 in Los Angeles at the Staples Center. Read more:
ReplyDeleteGrammys
Grammy 2017
Grammys 2017
2017 Grammys
Watch Grammy 2017
Grammy Awards
Grammy Awards 2017
Vidmate is just about the best streaming service that I have come across and wouldn't want to exchange it for anything else. I had been looking forward to using Vidmate on my PC but I haven't gotten around to follow the instructions on how to do it. None-the-less Vidmate is a miracle. Free Vidmate
ReplyDeleteAdjustable rate loans come in many flavors. In addition to the one year ARM, you can obtain a 3/1, 5/1, 7/1 or 10/1 ARM loans, which fixes the rate for 3 to 10 years, and then becomes a one year adjustable thereafter.guarantor loans
ReplyDeleteAs far as societal costs, information is as often as possible hard to condense with respect to non-road level criminality.אחלה עורך דין תעבורה בישראל
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteIn the event that you are gotten in any criminal case at that point employing an accomplished and learned criminal lawyer is vital on the off chance that you need to win the case as in some cases law isn't that straightforward and easy.Traffic lawyer
ReplyDeleteIf crime somehow managed to be disposed of the assembling section of the economy would be discolored. Diminished assembling would prompt a decline in the Gross Domestic Product.תביעות ייצוגיות
ReplyDeletehttps://pokesniper.online/kingo-root/
ReplyDelete