Pages

Sunday, June 1, 2014

Stats from the World Cup 2014 squads

The World Cup pits nation against nation in a quest to find the world's most accomplished footballing country.  However, the sport known as the 'world game' definitely lives up to it's name as we look at the trends relating the country a player represents with the country they live in and play in week by week.

Here are some interesting stats based on the preliminary squads list on Wikipedia as of May 27, 2014, to which I applied some basic python scripting.

Home Grown

These teams in the round of 32 have the highest number of players based in their country of origin.

Squad SizeHome Grown%
Russia2424100
England232295.65
Italy302790
Germany272074.07
Mexico231669.57
Iran301963.33
Spain291758.62
Netherlands301653.33

Home Away From Home

On the other end of the scale, these countries' national teams have the lowest number of locally based players.

Squad SizeHome Grown%
Ghana2613.85
Uruguay2514
Cameroon2827.14
Ivory Coast2827.14
Bosnia and Herzegovina30310
Columbia30310
Belgium24312.5
Argentina26415.38
Algeria30516.67
Nigeria30516.67
Brazil23417.39

Cashed Up Clubs

These clubs are home to the most number of Brazil bound players.
Bayern Munich15
Manchester United14
Barcelona13
Real Madrid13
Napoli13
Juventus13
Chelsea12
Manchester City12
Liverpool10
Arsenal10
Atlético Madrid10
Paris Saint-Germain10


Best Places to Play

These countries are the ones whose national leagues contain the most number of Brazil-bound players.

England121
Italy96
Germany87
Spain70
France54
Russia38
Mexico31
Netherlands28
Turkey28
USA25
Portugal22


Biggest Losers

These are the countries whose national leagues have the most players in the world cup, without the country making it to Brazil.

Turkey28
Ukraine10
Scotland7
China6
Norway6
Wales5
Austria3
Canada3
Qatar3
Saudi Arabia3
Sweden3
United Arab Emirates 3

Lone Star

Some countries are not so attractive to the big names.  These countries' leagues have just one single player representing Brazil.

Denmark1
Paraguay1
Ghana1
Bulgaria1
New Zealand            1
Uruguay1
Hungary1
Kuwait1

Thursday, January 2, 2014

Happy New Year!

Gelukkig nieuwjaar!

Having just arrived back in Amsterdam after 2 weeks travelling over Christmas, we were pretty tired but still excited to be spending new years (or Oud en Nieuw as it is called in Dutch) with our friends in Almere.  It was a really nice evening spent in their newly purchased and renovated house.

One of the highlights of the night was the fireworks.  In Australia it is illegal to have fireworks so it is not something I have grown up with, but in the Netherlands it is legal to buy them in the few days leading up to New Year's Eve, and to set them of from 2pm to 2am on New Year's itself.  We were on a flight back from Switzerland at around 4pm and as the plane was approaching Amsterdam, we could see flashes from the fireworks across the country.


The loud explosions grew increasingly close together as we approached midnight.  At around 11:30, we went outside to let a few of ourselves that Roeland had got for us.  We then went back up to the top floor of their house where we had an incredible view of the fireworks which were going off constantly in every direction, even from the street just a few metres below us.  While the display was much smaller and not choreographed like the major displays put on by Australian cities, it made up for this with sheer persistence as the fireworks continued well past 1am.



Aftermath of the fireworks on the street the next morning