This took us a while longer to sort out. There is an interesting new category in the property price data which dates back to 1999 – it is called “other”. What it actually pertains to is commercial property or at least “non-residential” whereas all the other property transactions are for housing. There are actually very few recorded transactions in total, just 26,000, and the further back you go in time the fewer there seem to be records of. If you see here http://ukcrimestats.com/PropertySales/NationalPicture#Totals from the source data I’d say we have 2 years of quality data, of around 1,000 sales a month which makes up about 92%. From before then, the data is a bit iffy and questionably sporadic and sparse, so I wouldn’t try to to infer anything from any earlier than that – the data looks incomplete.
Also, we have also fixed a bug on this page http://ukcrimestats.com/Officers/Neighbourhood/ – a special thanks to Marie to pointing it out to us – the page shows you which neighbourhoods have the largest and smallest teams but the previous update misalligned some datasets, no more. We realise our population figures for Police Forces are a bit out of date and it is difficult to track with neighbourhood population figures as these are all too often missing or old from the api – I am writing to the Home Office later today about this for some assistance. So in the meantime, we are just starting working on a new methodology based on postcode population which should be done by the end of the week.
We have also “refreshed” historical data from Dec 2010 to Dec 2012 – and have kept a record of the previous data files, Scroll down this page to see source data files so you can see how they have changed if you want to.
Let us know your thoughts on email@example.com – we had no choice really as most people now access this site by mobile and tablet we have now added a google searchbox – our bespoke searchbox is still available further down the page on the right.
Today, most Britons live at relatively high population density in an urban environment and don’t move around that much on foot from where they live or work. A mile can actually cover very different neighbourhoods or include hotspots that may have little bearing on your immediate environment. That’s why we realised that we needed to add in two new radius levels for crime for all 1.7 million postcodes (except Scotland). As you’ll see here in this example postcode;
there is a dropdown box for 0.5 and 0.25 miles as well as the default of 1 mile.
As always, a word of caution, the last month’s sales – property prices paid in England and Wales – are typically at least 50% missing – see here http://ukcrimestats.com/PropertySales/NationalPicture#Totals – so we would fully expect when we have the next month’s data to see May’s figures revised from 23,371 up to the 50-80k range.
Please note this is different data from the ONS House price index which uses mortgage financed transactions data collected by the Council of Mortgage Lenders which does not cover all mortgage lenders. And not everyone buys with a mortgage of course. We use the Land Registry data, which details each transaction and location.
We will shortly have May 2015 data uploaded for property prices. One of the things we’ve noticed by the way with property data is the latest month is always incomplete – see here http://ukcrimestats.com/PropertySales/NationalPicture#Totals . Basically, the latest month is always less than 50% complete. And the previous few months are often heavily revised, the earlier data is much more stable. So we are taking our time to make sure that it is correct.
In the meantime, we’re quite excited about the new capabilities we can offer subscribers, here’s just one;
1. http://ukcrimestats.com/PropertySales/Analysis the ability to see across the whole of England and Wales, which subdivision, postcode district/sector, LSOA or MSOA, had the greatest increase/decrease in either total value of sales or average price or even maximum or minimum price between two selected time points of all types of properties or filtered according to property type?
You can also export the data too so you can get a very clear national snapshot based on price paid data.
Property data for May 2015 will be updated shortly too. We’ve also fixed a couple of bugs that creeped in;
i) http://ukcrimestats.com/LSOA/ – the report and export generating function is now working flawlessly
ii) http://ukcrimestats.com/MembersArea/Analysis/ (only visible to subscribers) – this page which allows users to see which Police Force all the way down to subdivision, postcode sector, workzone etc. had the largest or smallest increase by percentage or total / or specific type of crime across the whole country between two dates. This is now working well too.