New territory

The former state “United Korea” has been added as a possible territory in Gapminder World. So far the only indicator with any data for this territory is population.

Note for members in the Gapminder world community: the formal name-match name for this area is “Korea, United”, and the borders corresponds to North and South Korea.  

Download indicators to excel

It is now possible to download each of the indicators in gapminder world to excel.

Simply go to the list of current indicators in Gapminder World and click the link “download indicator to excel”, which you find in the sixth column.

Note that the row heights of the cells are not automatically adjusted in the downloaded files, so there might be texts in some cells that are not seen without going to the cell.

New “indicator” to display years by colors 1820-2010

A new indicator called “years 1820-2010″ has been added (you find it under “other”).

It is similar to the indicator “year 1950-“, i.e. it simply displays the year, with the only difference that this one covers a longer period. This is more suitable if you want to look at longer periods, e.g. air pollution and income. Use “year 1950-” when you want to look at a shorter time period.

By using this indicator for the color of the bubbles (which you do in the top right corner of the graph) and using “trails” for a selection of countries you can more easily compare the development over time of these countries.

Here you see an example of this (opens in a new window). In the graph you see a comparison of the development of both incomes and sulfur emissions of India, Malaysia and United Kingdom between 1860 and 2000.  The blue and green bubbles show the situation in the second half of the 19th century and the red bubbles show the situation in late 20th century.   

Here is a link to the spreadsheet of the indicator.

New "indicator" to make it possible to display years by colors

A new indicator called “year 1950-” has been added (you find it under “other”).

It simply shows the year, i.e. when we look at data for 1960 the indicator will be 1960 for all countries.

By using this indicator for the color of the bubbles (which you do in the top right corner of the graph) and using “trails” for a selection of countries you can more easily compare the development over time of these countries.

Here you see an example of this (opens in a new window). The development of China, USA, Botswana and South Africa between 1950 and 2005 is compared.  The blue bubbles show the situation in the 50’s, the green bubbles show the situation in the 70’s and so on.

Note: the indicator only starts at 1950 so obervations before 1950 will be without colors.

Here is a link to the spreadsheet of the indicator.

New Indicator: Public & private health expenditure (% of GDP)

On request we now add the new indicator “Public & private health expenditure (% of GDP)”.

It shows how big share of the average person’s income is being spent on health care, whether it is through the tax they pay, the health insurance they have or through out-of pocket expenses.

Here the indicator is compared with Infant Mortality in Gapminder World.

Here is a link to the spreadsheet of the indicator.

Unfortunatly the indicator only covers the years 2000-2004 (with three exceptions), so any tips on where we can find data covering more years are most welcomed.

New indicator: growth in income per person

On request we now add the new indicator “Growth in income per person (% per year)”, defined as the annual growth in Gross Domestic Product per person (percent increase from one year to next). It covers the period 1961-2005.

Note: this indicator is not necessary fully consistent with the “Income per person” indicator since different sources has been used.

Here “Growth in income per person” has been displayed against the level of “Income per person” in Gapminder World.

Here is a link to the spreadsheet of the indicator.

Population updated and expanded

The indicator population has been updated and expanded to cover more countries and territories and a longer time span. It now covers 251 countries and territories, including all of the 192 UN member states. 205 of them have data going back to at least 1820 (and 51 goes back as far as 1600).

Furthermore, the documentation has been more systematic (the full documentation will be available in a few weeks).

NOTE: the unit has been changed from “1000 persons” to “number of persons”.

NOTE 2: some of the observations (particulary the earlier ones) is based on very rough estimates. See the (coming) documentation for details.