A Table That Shows The UK Region For All Postcode Areas

Are you analysing a bunch of addresses, and want to quickly group them into UK regions? That’s what I was doing recently, and did not find it trivially easy.
A quick visit to your favourite search engine will reveal a list of UK post code areas, and their corresponding towns. But that’s not actually as useful as it might seem. Many large towns and cities take their postcode from another large town or city, often in a different county. Basingstoke (Hampshire) has RG postcodes (Reading, Berkshire), for example.
In London, the problem is reversed. The capital has eight of its own postcodes, but the outer London boroughs have their own. Sorting a diverse list of postcodes does not immediately reveal which are ‘London’.
Sometimes it’s better to group locations by broader UK regions. That’s what I wanted to do with a list of over a thousand UK addresses. Eventually I found a site that (in the hope of selling you a handy map) groups all the postcodes by region. I was able to create a lookup table from that information, which I could then use to sort and count the number of addresses in each region. Continue reading “A Table That Shows The UK Region For All Postcode Areas”