Analyze Open Data from the UK Land Registry

This example performs some data analytics on a dataset containing all property transactions in the UK for the past 25 years or so. It is a fairly large dataset and it contains interesting insights about the state of the housing market in the United Kingdom.

The data from the UK land registry is freely available online. It can be easily loaded in a PostgreSQL server by following the instructions here.

You can now register it as an EntityStore.

You can quickly see how many records are present.

Over 24 million rows, over 3 GB of data.

What are the most expensive cities?

Using Interpreter, you can find out where they are.

Then put them on a map.

There appears to be a large outlier: Gatwick. Take a look at what is happening there.

Apparently Gatwick has very few data points, but you can filter the data for cities with more than 100 transactions.

And put them on a map.

They all appear to be suburbs of London. You might want to give the county of London a closer look, by looking at the evolution of price over the years.

And compare it to the rest of the country.

You can clearly see that London was much less affected by the 2008 recession than the rest of the country.