Columbus Murders by Zip Code 2008-2012




I have been wanting to do these maps for awhile now, as there have been several searches on the site for them and they weren’t available. The maps look at Columbus murders by zip code 2008-2012, highlighting which zip codes have seen the most murders by year and across the period as a whole.

2008
Columbus murders by zip code
In 2008, almost all murders were contained within the I-270 boundaries. The East and South Sides were the worst areas.

2009

In 2009, there began to be a bit of diffusion on where murder was taking place. While parts of the urban core remained the worst areas, suburban areas also saw the occasional murder.

2010

The diffusion continued in 2010.

2011

And in 2011.

2012

2012 was the most diffuse of all the years, with no heavily concentrated areas, even in the urban core as much. Meanwhile, most of the suburban zip codes within Franklin County saw at least 1 murder.

The question is, what do we make of this? This is only a 5-year data set, but it may be supporting evidence for current urban trends. The first trend being that the urban core is rapidly gentrifying in many areas. The second being that poverty is, through economic and development trends, is spreading further out from the core. Concentrated poverty and crime go hand in hand, so while the suburbs may see a bit of increase in crime, the urban core is starting to see less. Something to watch over time to see if such trends continue.

2008-2012

What strikes me about the 5-year map is that Grandview/Upper Arlington have been entirely murder free while every zip around them have had at least one. Also, Downtown is also relatively murder free, as is Bexley and the Clintonville areas.

Of course, zip codes include large areas. What are the neighborhoods that are actually seeing murders and which ones are not? To find out, we’ll have to go down to the tract level. Over the next few days, I’ll post those maps.

More local crime statistics back to 1985 can be found here: Columbus Crime Statistics
The https://www.columbus.gov/police/ site provides annual reports, crime descriptions and other local department information.



Global Bike-Share System Map




Global bike-share system map

Global Bike Share Map

This map shows the location of every bike share system in the world. The map gives data on system size, bike availability at stations, station totals and locations. You can even pull up ridership reports and run animations! Columbus will be getting a bike share system that opens in July, so expect it to show up on this map in the coming months!

Metro Population by Distance from Downtown




Metro population by distance from downtown

One of the more interesting things the Census measures is the population from “City Hall”, or basically the metro population by distance from downtown. The metric measure population at every mile out from the center of each city’s downtown area. Since city boundaries come in all different sizes, this is a good way to compare urban populations.

I looked at the 15 largest Midwest metros for these numbers.

First, here is a breakdown of aggregate population at each mile marker in 2010. Aggregate means that with each mile added, the population within all previous miles are added together.

Mile 0
1. Chicago: 63,120
2. Minneapolis: 31,036
3. Milwaukee: 21,587
4. Cincinnati: 17,681
5. St. Louis: 17,359
6. Grand Rapids: 16,099
7. Omaha: 15,582
8. Indianapolis: 14,058
9. Kansas City: 13,709
10. Akron: 12,479
11. Cleveland: 9,471
12. Dayton: 9,182
13. Detroit: 8,709
14. Toledo: 8,304
15. Columbus: 7,416

This is a pretty bad showing in this list. In 2010, Columbus had the lowest downtown population, or population at Mile 0, of any of the largest 15 Midwest metros.

Mile 1
1. Chicago: 181,714
2. Minneapolis: 123,526
3. Milwaukee: 86,261
4. Grand Rapids: 75,613
5. Cincinnati: 65,264
6. Omaha: 56,244
7. Toledo: 55,739
8. Akron: 53,715
9. Columbus: 49,667
10. Indianapolis: 45,079
11. Dayton: 41,053
12. St. Louis: 40,184
13. Kansas City: 32,900
14. Detroit: 32,810
15. Cleveland: 32,193

By Mile 1, Columbus starts to move up rapidly, however.

Mile 2
1. Chicago: 318,522
2. Minneapolis: 228,927
3. Milwaukee: 208,776
4. Cincinnati: 138,235
5. Columbus: 134,826
6. Grand Rapids: 127,535
7. Akron: 122,395
8. Omaha: 113,044
9. Indianapolis: 102,412
10. Dayton: 101,817
11. Toledo: 94,058
12. St. Louis: 94,038
13. Kansas City: 77,388
14. Cleveland: 64,721
15. Detroit: 64,046

Mile 3
1. Chicago: 508,949
2. Minneapolis: 325,198
3. Milwaukee: 319,111
4. Columbus: 221,466
5. Cincinnati: 205,624
6. Grand Rapids: 184,887
7. Akron: 177,674
8. Omaha: 168,724
9. Toledo: 166,569
10. Indianapolis: 166,266
11. St. Louis: 160,117
12. Kansas City: 155,802
13. Dayton: 152,789
14. Cleveland: 139,945
15. Detroit: 109,104

Mile 4
1. Chicago: 764,400
2. Minneapolis: 448,499
3. Milwaukee: 438,629
4. Cincinnati: 315,665
5. Columbus: 314,557
6. Omaha: 253,723
7. St. Louis: 251,432
8. Grand Rapids: 247,473
9. Indianapolis: 240,970
10. Akron: 227,825
11. Cleveland: 227,309
12. Kansas City: 216,483
13. Dayton: 214,614
14. Toledo: 213,529
15. Detroit: 198,341

Mile 5
1. Chicago: 1,067,434
2. Minneapolis: 585,588
3. Milwaukee: 552,064
4. Columbus: 404,642
5. Cincinnati: 400,254
6. Cleveland: 361,475
7. St. Louis: 336,573
8. Indianapolis: 320,919
9. Omaha: 311,189
10. Grand Rapids: 305,307
11. Akron: 296,787
12. Detroit: 282,986
13. Toledo: 271,187
14. Kansas City: 269,936
15. Dayton: 262,069

So while Columbus’ downtown is down at the bottom in this list to start, it ends up being a top 5 within just a few miles. Clearly, though, the city needs to do better at getting people in the center.

What about further out? Let’s keep going.

Mile 10
1. Chicago: 2,763,025
2. Minneapolis: 1,312,640
3. Detroit: 1,053,920
4. Columbus: 993,957
5. Milwaukee: 944,415
6. Cleveland: 918,511
7. Indianapolis: 871,050
8. St. Louis: 864,336
9. Cincinnati: 862,932
10. Kansas City: 797,442
11. Omaha: 588,484
12. Dayton: 586,178
13. Akron: 502,710
14. Grand Rapids: 482,599
15. Toledo: 454,859

Mile 20
1. Chicago: 4,738,903
2. Detroit: 2,663,489
3. Minneapolis: 2,542,565
4. St. Louis: 1,878,365
5. Kansas City: 1,618,823
6. Cincinnati: 1,592,905
7. Cleveland: 1,549,799
8. Indianapolis: 1,511,675
9. Columbus: 1,432,067
10. Milwaukee: 1,317,062
11. Omaha: 788,498
12. Dayton: 757,623
13. Akron: 673,654
14. Grand Rapids: 602,220
15. Toledo: 558,219

Columbus seems to hold its own from Mile 2 through about Mile 15 or 16, and then begins to fall back as full metro populations begin to take shape.

So now we know the exact populations by distance, but what about how those are changing over time? Here are the same miles and their total change from 2000 to 2010.

Aggregate Change 2000-2010
By Mile 1

1. Chicago: 48,288
2. Minneapolis: 7,969
3. St. Louis: 5,881
4. Cleveland: 3,174
5. Milwaukee: 2,250
6. Kansas City: 1,009
7. Omaha: -53
8. Columbus: -1,049
9. Detroit: -3,601
10. Indianapolis: -4,739
11. Grand Rapids: -5,236
12. Cincinnati: -6,112
13. Akron: -8,916
14. Toledo: -10,118
15. Dayton: -10,165

By Mile 2
1. Chicago: 31,824
2. Minneapolis: 3,462
3. Omaha: 408
4. St. Louis: -1,523
5. Milwaukee: -2,399
6. Cleveland: -3,388
7. Kansas City: -4,807
8. Columbus: -6,004
9. Grand Rapids: -9,279
10. Detroit: -11,019
11. Indianapolis: -15,532
12. Cincinnati: -15,749
13. Akron: -15,874
14. Toledo: -16,771
15. Dayton: -20,826

By Mile 3
1. Chicago: 13,414
2. Minneapolis: 257
3. Omaha: -28
4. Milwaukee: -4,550
5. Columbus: -8,509
6. Grand Rapids: -8,818
7. St. Louis: -12,153
8. Kansas City: -14,528
9. Akron: -18,107
10. Toledo: -21,469
11. Cleveland: -23,287
12. Indianapolis: -23,973
13. Cincinnati: -24,548
14. Dayton: -27,652
15. Detroit: -29,905

By Mile 4
1. Minneapolis: 2,381
2. Omaha: 1,376
3. Milwaukee: -4,943
4. Grand Rapids: -8,612
5. Columbus: -9,650
6. Chicago: -12,130
7. Kansas City: -17,813
8. Akron: -18,533
9. Toledo: -22,039
10. St. Louis: -22,415
11. Indianapolis: -27,912
12. Dayton: -31,173
13. Cincinnati: -32,342
14. Cleveland: -41,948
15. Detroit: -61,209

By Mile 5
1. Omaha: 1,800
2. Minneapolis: 1,798
3. Milwaukee: -4,090
4. Columbus: -7,924
5. Grand Rapids: -8,112
6. Akron: -19,405
7. Kansas City: -21,986
8. Toledo: -26,094
9. Indianapolis: -28,401
10. Dayton: -33,066
11. St. Louis: 35,038
12. Cincinnati: -38,698
13. Chicago: -48,898
14. Cleveland: -70,067
15. Detroit: -89,973

By Mile 10
1. Columbus: 59,873
2. Indianapolis: 37,721
3. Omaha: 25,330
4. Grand Rapids: 10,284
5. Minneapolis: -1,544
6. Milwaukee: -2,369
7. Akron: -6,207
8. Dayton: -17,223
9. Kansas City: -19,048
10. Toledo: -21,636
11. Cincinnati: -39,767
12. St. Louis: -58,549
13. Cleveland: -120,862
14. Chicago: -172,571
15. Detroit: -239,616

By Mile 20
1. Indianapolis: 213,270
2. Columbus: 183,014
3. Kansas City: 144,634
4. Minneapolis: 141,652
5. Omaha: 97,813
6. Cincinnati: 46,813
7. Milwaukee: 27,876
8. Grand Rapids: 24,505
9. Akron: 8,625
10. Dayton: -7,484
11. Toledo: -9,112
12. St. Louis: -21,917
13. Cleveland: -88,522
14. Chicago: -215,802
15. Detroit: -291,258

Metro Area Demographics provides a greater picture of the Columbus metro’s population and demographic data.



Columbus Housing Market April 2013



Columbus housing market April 2013 Columbus, Ohio

The Columbus Board of Realtors released home sales data for April and YTD recently. Their area covers an area a bit larger than the Columbus metro, so I tried to stick with just those areas within it. I also tried to avoid capturing essentially the same area (school district vs city boundary). There are a few exceptions where I wanted to highlight specific areas or neighborhoods of Columbus.

LSD=Local school district
CSD=City school district

Top 10 Home Sales % Change since April 2012
1. Bexley city: +137.5%
2. Sunbury city: +125.0%
3. Delaware LSD: +82.4%
4. Lancaster CSD: +74.2%
5. Hilliard city: +66.7%
6. Marysville CSD: +64.3%
7. Pataskala city: +57.1%
8. London CSD: +50.0%
9. Upper Arlington CSD: +48.9%
10. South-Western CSD: +47.8%

Top 10 Home Sales % Change 2013 Year to Date
1. Sunbury city: +78.6%
2. Lithopolis city: +66.7%
3. Bexley city: +50.0%
4. Gahanna city: +46.1%
5. Hilliard city: +45.5%
6. Delaware CSD: +44.3%
7. Westerville city: +40.3%
8. Whitehall city: +37.5%
9. Marysville CSD: +36.7%
10. Lancaster CSD: +36.0%

Bottom 10 Home Sales % Change since April 2012
1. Powell city: -55.6%
2. Minerva Park city: -50.0%
3. Whitehall city: -42.9%
4. German Village: -36.4%
5. Downtown: -29.6%
6. Obetz city: -20.0%
7. New Albany city: -14.3%
8. Worthington city: -12.5%
9. Grandview Heights city: -11.1%
10. Circleville CSD: -11.1%

Bottom 10 Home Sales % Change 2013 Year to Date
1. Obetz city: -61.9%
2. Granville CSD: -31.3%
3. Worthington city: -11.3%
4. New Albany city: -5.8%
5. Grandview Heights city: -3.7%
6. Valleyview city: 0.0%
7. Powell city: +3.7%
8. Canal Winchester CSD: +3.9%
9. Newark CSD: +10.1%
10. Johnstown CSD: +11.5%

So it looks like, so far… in the urban core, Bexley, Upper Arlington and Whitehall are all having a good sales year, while Worthington and Grandview Heights are not. Downtown had a bad April, but is doing well for the year. Same with German Village. Suburbs performing well include Delaware, Hilliard and Sunbury. Those performing badly include New Albany and Powell.

Top 10 Turnover (Average # of Days on the Market before Sold) in April 2013
1. Valleyview city: 0 Days
2. Plain City CSD: 25 Days
3. Sunbury city: 27 Days
4. German Village: 29 Days
4. Obetz city: 29 Days
4. Worthington city: 29 Days
5. Powell city: 43 Days
6. Upper Arlington CSD: 47 Days
7. Beechwold/Clintonville: 49 Days
8. Gahanna city: 52 Days
8. Pataskala city: 52 Days
9. Lithopolis city: 54 Days
10. Grandview Heights city: 56 Days

Bottom 10 Turnover for April 2013
1. Circleville CSD: 164 Days
2. London CSD: 131 Days
3. Newark CSD: 123 Days
4. Minerva Park city: 116 Days
5. Downtown: 105 Days
6. Marysville CSD: 102 Days
7. Lancaster CSD: 98 Days
8. Delaware CSD: 92 Days
9. Blacklick: 88 Days
10. Bexley city: 80 Days

Top 10 Turnover 2013 Year to Date
1. Worthington city: 42 Days
2. Plain City CSD: 46 Days
3. Obetz city: 48 Days
4. Upper Arlington CSD: 60 Days
5. Pickerington city: 65 Days
6. Pataskala city: 67 Days
6. Whitehall city: 67 Days
7. Beechwold/Clintonville: 68 Days
7. Grandview Heights city: 68 Days
7. Minerva Park city: 68 Days
8. Groveport LSD: 69 Days
8. Reynoldsburg LSD: 69 Days
8. South Western CSD: 69 Days
9. German Village: 70 Days
9. Powell city: 70 Days
9. Westerville city: 70 Days
9. Worthington city: 70 Days
10. Columbus city: 72 Days

Bottom 10 Turnover 2013 Year to Date
1. Valleyview city: 151 Days
2. Circleville CSD: 148 Days
3. Newark CSD: 117 Days
4. London CSD: 115 Days
5. Bexley city: 97 Days
6. Lancaster CSD: 96 Days
7. Delaware CSD: 90 Days
7. Hilliard city: 90 Days
7. New Albany city: 90 Days
8. Johnstown LSD: 89 Days
9. Downtown: 87 Days
9. Lithopolis city: 87 Days
9. Marysville CSD: 87 Days
10. West Jefferson LSD: 86 Days

# of Months Total On-Market Housing Supply Would Last if No Other Homes Became Available, April 2013- Top 10
1. Valleyview city: 1.6 Months
2. Worthington city: 1.8 Months
3. Grandview Heights city: 2.0 Months
4. Upper Arlington CSD: 2.3 Months
5. Sunbury city: 2.5 Months
6. Hilliard city: 2.7 Months
7. Beechwold/Clintonville: 2.8 Months
8. Powell city: 2.9 Months
8. Westerville city: 2.9 Months
9. Gahanna city: 3.1 Months
10. Johnstown LSD: 3.2 Months

And Bottom 10
1. Granville CSD: 9.2 Months
2. London CSD: 8.7 Months
3. Circleville CSD: 8.6 Months
4. Newark CSD: 7.4 Months
5. Pataskala city: 5.9 Months
6. Lancaster CSD: 5.8 Months
7. Obetz city: 5.0 Months
8. South Western CSD: 4.8 Months
9. Canal Winchester CSD, Marysville CSD, New Albany city, Reynoldsburg CSD: 4.6 Months
10. Columbus city, Grove City city: 4.5 Months

With the supply numbers, generally anything around 5 months is considered a healthy supply. Well over and the market is saturated, well under it’s undersupplied. For the record, Downtown’s supply is 4.1 months.

Top 10 Average Sales Price % Change Year to Date
1. Valleyview city: +52.3%
2. Circleville CSD: +29.8%
3. Johnstown LSD: +26.7%
4. Minerva Park city: +23.7%
5. Gahanna city: +22.6%
6. Marysville CSD: +22.3%
7. Downtown: +19.9%
8. Lancaster CSD: +17.6%
9. Reynoldsburg CSD: +14.0%
10. Bexley city: +11.3%

Bottom 10
1. Grandview Heights city: -26.1%
2. Pataskala city: -22.3%
3. Obetz city: -15.6%
4. Granville CSD: -10.9%
5. Sunbury city: -10.8%
6. Blacklick: -10.5%
7. German Village: -5.3%
8. New Albany city: -3.5%
9. Westerville city: -3.2%
10. Plain City LSD: -1.9%

If you don’t see a market listed you’re curious about, check out the April 2013 Market Report may have what you’re looking for.



February Updates Planned



I have a lot of new additions planned for February. I will continue the ongoing updates on the new Census Tract Data page. This project is probably going to take a few months, as there are literally hundreds of census tracts and I plan to present data for each one. I wanted to do this specifically because it’s so difficult to find one site with this information. The US Census has it, but unfortunately it’s separated into invidual census years. Demographics for them are even harder to find. So I hope that those out there, like myself, who love this kind of stuff will find it useful and interesting.

Also, I plan to add a few more catergories to the Demographics Page.

Other than the tract and demographic page updates, I also plan to highlight at least a few individual projects from the past, present and future in regards to development. I will also update the ongoing yearly development list page, as there have been several new projects announced or that I’ve found that need to be added.

I will also be posting February’s weather records as well as a late report on the Blizzard of 1978.

Finally, I will be posting December’s unemployment and jobs report when it is finalized.

And as always, any major news stories about the city or metro will be posted as they show up.

So yeah, definitely a busy month planned with a ton to get done. I may be setting the bar a bit too high!