Simon Rogers 

The Guardian rosetta: the Datablog reference guide to nearly everything

Looking for ISO country codes? This is now the place to come. We want to make it easier to map data and keep it consistent. Take a look at our reference guide to IDs, codes and names and see how you can help make it better• Get the data
  
  

Ptolomeo's 15th century world map
The Guardian datablog reference guide: Ptolomeo's 15th century world map. Photograph: HO/Reuters Photograph: HO/Reuters

• UPDATED: NOW INCLUDING DCLG LOCAL GOV CODES

The actual Rosetta stone is a crucially important ancient Egyptian artifact instrumental in advancing modern understanding of Egyptian hieroglyphic writing.

Data visualisation today can be similarly tricky - country spellings vary wildly, to take one example. The Guardian uses Burma, for instance, while the UN prefers Myanmar. Is it North Korea or the Democratic People's Republic of Korea?

Closer to home, the Press Association will talk about the parliamentary constituency of Hampshire East, while the Office for National Statistics uses East Hampshire. You get the idea.

Recently we've been trying to help our datasets work in the world of linked data - the idea that data needs to be consistently readable across the web. We've started adding ISO country codes to country-level data, for instance and we're going to add in any other codes we can think of to make it easier for you to map our numbers.

So, we've started compiling a reference spreadsheet on Google docs. So far on it we have:

• ISO country codes
• Internet domains
• UK parliamentary constituencies, local authorities and NHS trusts plus their strategic health authorities
• US presidents and UK prime ministers
• British university codes from UCAS
• US state codes

It's just the beginning - we're going to update this all the time. What would be useful for you? Let us know and we'll get the reference.

Download the data

DATA: download the reference spreadsheet

More data

Data journalism and data visualisations from the Guardian

World government data

Search the world's government data with our gateway

Development and aid data

Search the world's global development data with our gateway

Can you do something with this data?

Flickr Please post your visualisations and mash-ups on our Flickr group
• Contact us at data@guardian.co.uk

Get the A-Z of data
More at the Datastore directory

Follow us on Twitter
Like us on Facebook

 

Leave a Comment

Required fields are marked *

*

*