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.

Stratospheric London

I've recently been looking at the Land Registry's price paid data for England and Wales. This is now open data and the Land Registry recently published all data going back to 2009 and by November 2013 they have promised to release all price paid data going back to 1995. I've been looking at the period from January to May this year to see - at a very basic level - what is happening in terms of the total volume and value of sales across England and Wales. As expected, this simply tells us that the London property market is 'stratospheric', as the Evening Standard recently reported. A few summary stats and charts before I go on holiday...

• Total value of sales in England and Wales between January and May 2013: £51 billion.
• Total value of sales in Greater London: £14 billion (28% of the total)
• Total value of sales in Westminster: £1.6 billion.

Explore the data and charts for yourself in the spreadsheet I put together here. The original data comes from the Land Registry's price paid data. I've used the original source files to produce some summary stats by Local Authority, City/Town and County. If you want to know more about the data, make sure you read the Land Registry's FAQs. 

Data produced by Land Registry © Crown copyright 2013.

This data covers the transactions received at Land Registry in the period 1 January 2013 to 31 May 2013. © Crown copyright 2013.

The London Problem Revisited

I've been thinking about the matter of London and the kind of 'two-speed Britain' stories which have been in the press recently. The idea is that London's continued growth and prosperity - in contrast to the rest of the UK - is a problem. The BBC covered this via Stephanie Flanders in March and the Guardian did a piece on it in May this year. The Economist even did a special supplement on London last year, entitled 'On a High' in which they covered a range of issues, not just economic growth - e.g. a map and some of my work on deprivation on p. 7 of the pdf. These kinds of stories always generate a lot of debate (see the comments on the Guardian piece for an example) of the 'London vs. the rest' variety but I suppose the thing that sticks in my mind is that none of this is really new. The precise nature of London's recent resurgence is perhaps unique but it's hardly a new problem. I was reminded of this last week at the Centre for Urban Policy Studies 30th Anniversary conference in Manchester when Sir Brian Briscoe quoted from the Barlow Report of 1940 (photo below - yes, I actually have a real copy to hand!). 

This in turn reminded me of the 1985 edition of the Planner magazine that I've had on my desk for some time. Why do I have this? Because it's a special issue to commemorate the life of former Chief Planner and University of Sheffield Professor JR James, who featured on the front cover of the April 1985 edition, five years after his untimely death in September 1980. In this edition, leading planners of the time gave a series of lectures on seminal reports - Peter Hall on The Barlow Report, Gerald Wibberley on The Scott Report and HR Parker on The Uthwatt Report.

Peter Hall's reading  of Barlow is fascinating for many reasons but I found it interesting that he chose to pick out the exact same quote that Sir Brian Briscoe did last week: "the continued drift of population to London and the Home Counties constitutes a social, economic and strategical problem which demands immediate attention" (p. 202 - see below for copy of the original, in paragraph 5).

These words were written in very different times (e.g. it was published shortly after the outbreak of WW2 and in fact some of the content had to be changed to reflect this) but the over-arching message of a dominant London and a lagging rest of Britain resonates today. The policy solutions proposed in 1940, however, are rather different to those suggested today. For example, there was a strong emphasis on regionalism in the Barlow Report - unlike today. Further, there was a real concern about what could be done to address this nationally problematic uneven development (well, at least in theory) - e.g. Part IV from p. 185 is entitled 'Remedies ... And to Report what Remedial Measures, if any, should be taken in the National Interest'. So, this is not just an historical curiosity. On p. 197 we have more on 'methods of decentralisation or dispersal', which many today would like to see.

As for the man himself, Sir Anderson Montague-Barlow (image at bottom of page), I'm not sure what he'd make of the current rhetoric of a 'two-speed' UK but I'm sure he'd recognise that it's nothing new. The question that remains in my mind is whether this London boom will continue indefinitely and what the consequences of that might be. Some final thoughts for now...

1. Lost in much of this two-speed UK talk is the fact that inequality and poverty in London are quite extreme. That's what I was getting at in my very small contribution to the Economist supplement last year and in another Guardian piece. This is something that Ben Hennig has been looking at in more detail in recent times - see here for more.

2. Much less has been said about why this London/rest issue might be a problem and - more importantly - what might be done about it. Certainly, I don't think we'll see a Barlow-style Royal Commission about this any time soon.

3. What about the contribution of the rest of the UK to London's growth - e.g. in sending graduates, commuters, funding for infrastructure, and public transport - to name just four factors. The question here might be to what extent is London's growth down to the fact that it has a Barlow-esque gravity? Easy to answer but harder to quantify.

4. Are we witnessing a 'London supernova'? Will this bright shining star gradually fade? Fancy rhetoric, but worth thinking about, given the cyclical nature of boom and bust. See p. 52-54 of this RTPI report for more.

5. And, finally, we ought to look at old books and magazines more! 

HS2 geodata - for download

Yesterday I wrote a short post on the Guardian's Datablog about my difficulties getting hold of the route data for the proposed routes for the new high speed rail lines in England. Coincidentally (or maybe not) HS2 responded to my request at almost exactly the same time as the piece appeared online. Anyway, sometimes it does take time for public bodies to respond to requests so my real question was why the shapefiles were not available for download, given that they are available under the Open Government Licence. I have a few ideas about why this must be but it would be good to have some information from this on HS2, though maybe they're too busy with other things! Clarity on this issue might, however, reduce the likelihood of data conspiracy theories and enhance transparency.

Anyway, enough about that. So that other people don't have the same wait as me to get hold of the GIS data I've made them available here via the link below. A few important points to bear in mind...

1. The Phase 1 (London to West Midlands) route is the 'post-consultation' route from January 2012.

2. The Phase 2 (Leeds and Manchester) routes are the 'initial preferred routes' from January 2013.

3. There is an interactive map of the Phase 1 route on the HS2 web pages, which is quite useful.

4. Users of the data need to remember to acknowledge the source.

5. It's not my data - I'm just making it available.

6. You can also get these files from Barry Cornelius, but not - as yet - from data.gov.uk

7. The route data available for download here doesn't necessarily reflect the precise location of where the train lines will be built - particularly for Phase 2. 

HS2 shapefiles, as of 2 May 2013

Population 'explosion' in English city centres

A paper I wrote about English urban policy and the 'return' to the city is now out in Cities, so I thought I'd blog about it. It's just something I wrote after the first release of small area data from the 2011 Census and the results are not entirely surprising to those with a knowledge of these things but the scale of change over the decade from 2001 to 2011 was pretty big, particularly in the case of Manchester, which I've written about previously. I also reflect upon wider international issues associated with 'reurbanization' (with a z because it's a US journal!) so I think that although the focus is on England it should have wider resonance.

I discuss this growth in the context of New Labour's urban policies, and particularly those which emerged from the Urban White Paper of 2000. Although some of the aims were achieved (e.g. making city centres look nicer, with better design), I conclude that the changes have been mostly superficial and that perpetually high levels of inner city deprivation in cities which were the main foci for urban policy during this period does not represent a very positive legacy, despite the 'success' of getting people to move back to the city. The fact that this picked up immediately by @urbandata suggests that these themes are also relevant in the United States, and beyond. It's a short paper but I hope to follow up on it at some point* with more detailed data on tenure, etc. to dig a little deeper.

*This is normally code for 'it will never happen'!

Deprivation in your area - search and zoom

After making a new website when the Scottish Index of Multiple Deprivation 2012 was released, I've been looking at some of my old English IMD web pages and tools and so have decided - in anticipation of the next update to the IMD - to add a 'search and zoom' tool so that anyone who is interested can find out what deprivation is like in their area - or any other area of England you are interested in. Like my previous versions of this kind of thing it's based on Google Maps but in the version seen in the screenshot below you can simply enter a place, neighbourhood, postcode or address (or even an organisation, like Centre for Cities) into the search box and it will go straight there after clicking 'search'. Click the image or the link below to use the tool.

IMD Search and Zoom

As usual with these kinds of maps, if you click on an area the pop-up will give you more information. The next update of the IMD was to have been in 2013 but I'm not sure if that is still going to happen. However, I've updated this tool just in case so that I can add in the next update whenever it becomes available. The Scottish version of this tool is on this page, but I have not yet done the same for Wales or Northern Ireland.

Child poverty in the United Kingdom - for small areas

As I mentioned in my last post, I'm currently doing some work on child poverty and social mobility. I did this for English parliamentary constituency areas in 2011 but the problem I had then was that I didn't have a dataset that covered the entire UK at the small area level. Since then, however, I've been looking more into the HMRC's child poverty statistics and their revised local child poverty measure (linked to the Child Poverty Act 2010). To cut a long story short... I've mapped child poverty at the small area level for the whole UK - for those areas where child poverty is at 33.3% or higher (the UK average is 20.6%). The map is zoomed to London but you can zoom around and use the full screen version. Click on an area to find out more.

Full screen map

The highest value in the UK is in part of Springburn in Glasgow - with a value of 83.3% of children in poverty according to the HMRC definition. The highest value for anywhere outside Scotland is 75.0% in part of east central Manchester. 

Some technical information... The small areas used are Super Output Areas in England, Wales and Northern Ireland. In Scotland, Data Zones are used. These have around half the population of Super Output Areas (around 800, compared to 1600). Using these smaller areas means that Scottish areas dominate the list of the highest child poverty neighbourhoods in the UK. In the HMRC definition, 'children' are all dependent children aged 0 to 19. They also provide data on child poverty rate for children under 16 and this figure is usually about a half to one percentage point higher (e.g. 21.1% for under 16 compared to 20.6% for the whole UK). The data are from the most recent release - 2010.