During lunchtime, for a laugh, I downloaded this spreadsheet and made a chart from it.

The data in the spreadsheet shows the house-price to earnings ratio for all London boroughs, from 1997 to 2013. This number tells us how affordable local property is for people who live and work in a particular area.

In an ideal world you’d want it to be relatively stable—if property is expensive in one high-income area and cheap in another low-income area they might still have similar house-price/earnings ratios. And over time, you would want salaries and house prices to go up or down more or less together—if you wanted the affordability of property to remain constant, that is.

Anyway, here’s the chart. You’ll need to click on it to see the full-size version.

House price to earnings ratio in inner London boroughs

The biggest surprise for me upon making this was not so much that this ratio has grown over the years, or the fact that this growth has occurred in every borough. It’s more that the gap between boroughs has become so vast.