Preparing data to create your own interactive map

Behind every visualization is data. After some extensive internal testing we are preparing to release a wizard to create map visualizations next week. This wizard will require the data in spreadsheet form as a Google Spreadsheet. (We’d welcome suggestions on future formats and sources). An example of the data for the current visualization on literacy is available as a Google Doc for you to view and adapt to your own data. The first two columns are required along with at least one additional column of data. The first column is a country code (e.g. ES for Spain) while the second is the label to display when this country is clicked (e.g. Spain or España). Any additional columns are custom columns to hold data to shade countries by or to display as a bar graph or text label in the right-hand panel. There is a row for each country for which data is available. If all data points are unavailable for a given country, it is safe to delete the row for the country. Lastly, it is optional to add a “world” row which is optionally shown when the visualization first loads.

Data

Resulting Visualization (updated and slightly different from image below)

Note: This post was originally published on the OII's Interactive Visualisations Tool blog on 24 October 2012 11:26 pm. It might have been updated since then in its original location. The post gives the views of the author(s), and not necessarily the position of the Oxford Internet Institute.