Category Archives: Data-driven Analysis

Main Fish Producers in the world. Facts and Figures

In 2012 EU has published a report on Fisheries Policy in Europe with the main figures and facts from the official Member States and  statistics data from Eurostat, FAO and EU Fleet Register.

A great catch

A great catch

The main world producer of fish is China, that represents about 34,4 % of global fisheries and aquaculture production. China is followed by India (5,4 %), Peru (4,8 %) and Indonesia (4,7). The EU is the fourth producer of fish in the world with 4,4 % of global fisheries. Within the EU the main producers in terms of volume  are  Spain, Denmark and the United Kingdom.

Main fish producers worldwide

Main fish producers worldwide

Within the European Union the main species caught are European sprat (11%),  Herring (10%), Mackerel (7%) and Sand eels (7%).

Main species caught in the EU (percentage of total volume in tonnes live weight)

Main species caught in the EU (percentage of total volume in tonnes live weight)

For the main report with figures and facts on employment in the fisheries sector, vehicles and aquaculture production please click here.

Contraceptive use around the world

The map below displays a percentage of contraceptive use in selected countries. The data come from United Nations Population Division Database on Contraceptive Use (Department of Economic and Social Affairs). The data refer to married women aged between 15-39. Contraception in this table includes use of the birth control pill, the IUD (intra-uterine device), condoms, male and female sterilization and other modern methods.  Bulgaria with 86 % ranks as the country with the highest usage of contraceptive, followed by China 84 % and Switzerland 82%.

Here is the list used to create the table. For more data check out here.

country amount
Bulgaria 86 %
China 84 %
Switzerland 82 %
Spain 81 %
Korea, South 80 %
Brazil 77 %
Colombia 77 %
United States 76 %
Canada 75 %
New Zealand 75 %
Vietnam 75 %
Iran 73 %
Thailand 72 %
Ukraine 68 %
Kazakhstan 66 %
Mexico 66 %
Jamaica 66 %
Ecuador 66 %
Turkey 64 %
Peru 64 %
Romania 64 %
Domenican Republic 64 %
Turkmenistan 62 %
Bahrain 62 %
Lebanon 61 %
Armenia 60 %
Nicaragua 60 %
Kyrgyzstan 60 %
Mongolia 60 %
El Salvador 60 %
Italy 60 %
Lithuania 58 %
Paraguay 57 %
Indonesia 57 %
Algeria 57 %
Egypt 56 %
Uzbekistan 56 %
South Africa 56 %
Bangladesh 54 %
Zimbabwe 54 %
Cape Verde 53 %
Jordan 53 %
Austria 51 %
Belarus 50 %
Morocco 50 %
Honduras 50 %
Kuwait 50 %
Bolivia 48 %
Latvia 48 %
India 48 %
Philippines 46 %
Qatar 43 %
Libya 40 %
Georgia 40 %
Kenya 39 %
Guatemala 38 %
Gabon 33 %
Burma 33 %
Saudi Arabia 32 %
Malawi 31 %
Nepal 28 %
Haiti 28 %
United Arab Emirates 28 %
Papua New Guinea 26 %
Zambia 25 %
Oman 24 %
Pakistan 24 %
Cambodia 24 %
Ghana 22 %
Yemen 21 %
Comoros 21 %
Madagascar 19 %
Cameroon 19 %
Benin 16 %
Cote d’Ivoire 15 %
Nigeria 15 %
Central African Republic 15 %
Uganda 15 %
Senegal 13 %
Rwanda 13 %
Burkina Faso 12 %
Niger 8 %
Ethiopia 8 %
Mali 7 %
Mozambique 6 %
Guinea 6 %
Eritrea 5 %
Chad 4 %

Age at first marriage for women and men

Age at first marriage for women

click on the image to see an interactive bubble map

Age at first marriage for men

Alcohol Consumption in Italy

I found this extremely interesting. This graph shows alcohol consumption in Italy every two years starting from 1960 up till 20008. The data comes from OECD website. As seen on the graph, alcohol consumption in Italy has dropped drastically from 19,2 liters per capita in 1960 to only 8 liters per capita in 2008. Italy, together with France and Spain, are one of the biggest producers of great wine, but the consumption has been dropping dramatically starting from the 70ies. Italy has actually one of the lowest alcohol consumption levels in Europe. I do confirm, from my own experience of 6 years living in Italy, that Italians do have moderate consumption of wine, but the risky drinking, like in my home country Russia, simply does not exist. They also drink less and less wine during lunchtime, perhaps, due to a new lifestyle, having lunches at work in front of their computers.

2009 Alcohol consumption map

The map of alcohol consumption in 2009 only on some countries. The data was found at OECD website.

In many countries in this world alcohol abuse remains a big problem. It carries a risk of health and social consequences. According to WHO harmful use of alcohol results in the death of 2.5 million people every year. The biggest boozers in Europe are found in France, Portugal etc. Here is the data from OECD (data for some countries like Italy, Belgium comes from 2008):

Country Alcohol Consumption per capita
Australia 10.1
Austria 12,2
Belgium 9.7
Canada 8.2
Chile 8.6
Czech Republic 12.1
Denmark 10.1
Estonia 12
Finland 10
France 12.3
Germany 9.7
Greece 9.2
Hungary 11.8
Iceland 7.3
Ireland 11.3
Israel 2.5
Italy 8
Japan 7.4
Korea 8.9
Luxembourg 11.8
Mexico 5.9
Netherlands 9.4
New Zealand 9.3
Norway 6.7
Poland 10.2
Portugal 12.2
Slovak Republic 9
Slovenia 11,5
Spain 10
Sweden 7,4
Switzerland 10,1
Turkey 2.2
United Kingdom 10.2
United States 8.8

Labour costs per hour in EU Countries in 2011

26 April Eurostat published a news release on estimated hourly labour costs in 27 EU countries in 2011. The highest salary per hour was estimated in Belgium ( 39,3 EURO) and the lowest in Bulgaria with only 3,5 EURO per hour. According to the report, labour costs are made up of costs for wages and salaries, plus employer’s social contributions. The estimated results covered companies with more than 10 employees and are based on the 2008 Labour Cost Survey and the Labour Cost Index.

Labour cost index  is a short-term indicator that shows the development of hourly labour costs received by employers. It is simply calculated dividing the labour cost by the number of hours worked.

Labour Cost Survey  gives structural information on labour costs. The survey is conducted every four years. The
most recent LCS refers to information for the year 2008.

Please not that data for Romania and Spain for 2009 and 2010 were not estimated by Eurostat, but were provided by the Member States. Also the data for Greece and Romania are from 2010, the data for last year is still not available.

Details to the table:

Belgium 39.3 EURO

Bulgaria 3.5

Czech Republic 10.5

Denmark 38.6

Germany 30.1

Estonia 8.1

Ireland 27.4

Greece 17.5

Spain 20.6

France 34.2

Italy 26.8

Cyprus 16.5

Latvia 5.9

Lithuania 5.5

Luxembourg 33.7

Hungary 7.6

Malta 11.9

Netherlands 31.1

Austria 29.2

Poland 7.1

Portugal 12.1

Romania 4.2

Slovenia 14.4

Slovakia 8.4

Finland 29.7

Sweden 39.1

United Kingdom 20.1

Norway 44.2

Deutsche Welle Fans on Facebook

Deutsche Welle has thousands of fans on Facebook who want to stay up-to-date with DW’s news. The idea behind the graph is to see what DW department has received the biggest number of “likes” on Facebook so far. Click on the map to see the exact figures. If you can not see the visualization, you might need to install the latest Java plug-in or the latest version of Adobe Flash Player on your computer.

The creation of the Treemap Chart, using an open source tool Many Eyes in 4 steps:

1.  First things first. I had chosen my data  by simply searching for “Deutsche Welle” on Facebook. This time I manually added the relevant data set to an excel file.

2.  I uploaded my data set on the Many Eyes website.

3.  I then chose Treemap Chart that I found suitable for the visualization of my data set. On the website there are various visualization options including bar and pie charts, matrix charts, stack and line graphs, tag cloud and world tree etc.

4.  Last but not least. I customized, saved  and published my visualization on the website. You can also easily embed it to your blog or website and what is what you see on my blog.


Open Source Tools for Media people

Here is a short list of open source tools that I, as a beginner data journalist, have been using to create maps, timelines, charts and other exciting stuff since a year or so. Journalists, media experts or just anyone attracted by new freely available online technologies will, hopefully, find this list useful. My list is short because it is impossible to keep track of all the new tools that appear online with a faster-than-light speed and to be equally good at all of them. So I have chosen only 7 tools as a start that have become an important part of my DNA.

Google Refine  – a must-to-know online tool to clean your messy data, to transform your data into different formats and to do much more.

Tableau Public  – another great  tool that helps to create interactive visualizations of your data and publish them online.

ManyEyes  – a good open source visualization tool developed by IBM. All you have to do is upload your own data sets or use a pre-existing one on the site, choose among many options the visualisation and enjoy the results. Similar tools include Factual , Socrata, iCharts, ChartTool and ChartGo.

Wordle  – a free tool that transforms your texts into colorful word clouds. Here is more information from their website on what the tool does:

Wordle is a toy for generating “word clouds” from text that you provide. The clouds give greater prominence to words that appear more frequently in the source text. You can tweak your clouds with different fonts, layouts, and color schemes. The images you create with Wordle are yours to use however you like. You can print them out, or save them to the Wordle gallery to share with your friends.

Dipity  – one of my favorite free tools online that allow you to create timelines and add various links, pictures, text to it. It is very easy to use and edit or embed it to your blog or website, once you have an account.

Youshikoder  – is for those who love  to perform content analysis, including keywords search and count, in various languages.

TextAnalyzer  – a free online tool that helps you to find and count most frequent phrases in different languages

Presidential Elections in Russia, March 2012

Map on the final results of votes for Vladimir Putin by Regions.


Public transport in Russia in 1992 and 2010

This morning for the first time I started using an online visualization software "Many Eyes" where you can upload your own data and create visualizations in different formats.