England deprivation mapped with Google Fusion
I’ve been building up a collection of border files for us to use in Google Fusion table maps – and these are the key ones. You can download these as KML files or as CSVs. Or merge them with your data. If you have a shp file you what to convert to Google Fusion tables try shpescape, which will do it for you.
And there’s a new site too which looks promising: Inquiron, which converts geofiles into a variety of formats.
Google’s Public Data explorer is a good place to find others too.
I would love this to become more comprehensive – do you have any borders you can share?
UK borders
- Health boundaries (pre 2010)
- Health: New England health boundaries, Care Commissioning groups
- Local Authorities, UK (post-2010)
- Lower Super Output Areas (LSOAs, used for deprivation and census and updated after 2011)
- Middle Super Output Area (MSOA)
- Police Force Areas
- Regions
Data journalist, writer, speaker and author of 'Facts are Sacred', published Faber & Faber. Created the 
Terrific work! This is the type of info that are supposed to be shared around the internet. Shame on the seek engines|Google} for no longer positioning this submit higher! Come on over and discuss with my website . Thank you =)
Posted by storgatan | February 6, 2013, 5:22 pmIt’s actually the data here (http://www.education.gov.uk/researchandstatistics/datasets/a00196810/schools-pupils-and-their-characteristics-january-2) on Free School meals that I am trying to map (which I have seen on the Guardian already….). I tried using both the id codes and the names but it didn’t work. I went through the tutorial on your blog and that worked fine so not sure what I am doing wrong. Will keep trying!
Posted by Sandra Smith | February 1, 2013, 7:44 pmLet me know how you get on
Posted by Simon Rogers | February 1, 2013, 11:22 pmHi. I’ve come to this via the comments page on the Guardian. I’m trying to map some DoE data:
http://www.education.gov.uk/researchandstatistics/statistics/allstatistics/a00196810/schools-pupils-and-their-characteristics-january-2
using Fusion tables. When I try to merge the Local Authorities UK data with my data it says, ” Unable to perform merge….”. I can get it to work with this table here
https://www.google.com/fusiontables/DataSource?docid=1vhqibzb2utSzEPM_HncDwf-BXMSklbx5kxyL_Q
but the coverage is very patchy – maybe only 15 % of LAs are being picked up. Any suggestions or alternative tables?
Posted by Sandra Smith | February 1, 2013, 2:35 pmHi Sandra – are you merging it on the id codes or the names? The id codes are the ones to use
Posted by Simon Rogers | February 1, 2013, 6:03 pmFYI I tried to access your US counties file but got a permissions error.
Posted by Sharon Machlis | January 30, 2013, 2:03 pmHi – my bad. Just sorted the permissions and should be fine now.
Posted by Simon Rogers | January 31, 2013, 1:08 amLovely work – thanks!
Posted by Simon Rogers | January 28, 2013, 10:06 pmHi Simon, here’s a Fusion Table that I put together for Counties in England: https://www.google.com/fusiontables/DataSource?docid=19DqHxxbkdgsEmXVooB7vRHRit8wVnVAEcP9W5lA
Posted by Adele Gilpin | January 28, 2013, 7:03 pmGreat overview… and I’ve got one for you:
Germany: geometric data of constituencies http://www.bundeswahlleiter.de/en/bundestagswahlen/BTW_BUND_13/wahlkreiseinteilung/kartographische_darstellung.html
Posted by Mila Frerichs (@mila_frerichs) | January 28, 2013, 11:14 am