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