Employee Growth in London, 2001 to 2012

The Office for National Statistics has released a new dataset on the number of employees across London's 983 MSOAs. The data are sourced from the Inter-Departmental Business Register (IDBR) and they reveal some interesting trends. Naturally, I had to do a 3D map of this, so take a look at the image below for the obvious growth points...

Massive absolute growth in the City of London and Canary Wharf - and some other central MSOAs in Camden, Southwark and Westminster, but also massive growth in employment in Uxbridge.

Click on the image to enlarge

The number of employees in the City of London increased by 36%, compared to 267% in Canary Wharf and 170% in an Uxbridge MSOA. By contrast, one part of Islington had 78,600 employees in 2001 but only 57,000 in 2012 - a drop of 27%. This area of Islington is immediately north of the City of London and includes Clerkenwell and Finsbury.

If you're interested in this kind of thing it's definitely worth looking at the original dataset.

NEETs in England, 2000 to 2011 (Animated Chart)

The news last week that the number of 16 to 24 year olds in England not in education, employment or training (NEET) reached an all-time high was widely covered, and quite shocking since there are now 1.16 million 16 to 24 year olds in this category. I thought it might be quite interesting to look at the data more closely to see how it compares to other time periods. The Department for Education publish the NEET data on a quarterly basis and the most recent data are for the third quarter of 2011 at the regional level. "What would the quarterly data look like in an animated bar chart?", I hear you say. Click the image below to find out!

Click to see a full size version of this animation.

I should say that you'll need to watch the clip a few times in order to make sense of it (and use the pause button), but once you get your head round it, it tells an interesting story (it also dances a bit like an equalizer on an old stereo). The lowest NEET total for England was in the second quarter of 2000 (629,000) and the highest total comes from the third quarter of 2011 (1,163,000). The highest regional percentage figure for NEETs was in the third quarter of 2011 in the North West (23.9%) and the lowest was in the last quarter of 2003 and the first quarter of 2004 in the South West (7.4%).

Lots of interesting stories here but the most striking thing is the total number of NEETs in England. 

Note: I created this using Google's motion charts and recorded it using Camtasia.

Deprivation and Map Distortion (SIMD 2009)

I'm doing a seminar at the Employment Research Institute in Edinburgh later this month on the topic of employment deprivation in England and Scotland. Recent posts have mostly been about England and patterns of deprivation there and I've been neglecting my native land. So, I thought I would use some of the data to take a look at patterns of deprivation in Scotland using a population-weighted cartogram. The result is below (click to view full size).

Now I need to get on with some more in-depth analysis of employment data...