Friday, June 4, 2010

World Cup final squads statistics

Updated to fix league standings as Wellington Phoenix play in the A-League. Thanks Jarryd!
_______________
As promised...

Also check the provisional squad statistics to see the changes.

298 clubs from 52 leagues have players in the final squad lists, with three players currently unattached: Craig Moore (Australia), Simon Elliott and Dave Mulligan (both New Zealand).

England is the best represented league - 118 players, with Germany (84), Italy (80), Spain (59) and France (45) completing the top 5.

Top 5 leagues of countries not qualified to the World Cup:

1. Russia (14)
2. Turkey (13)
3. Scotland (10)
4. Belgium (7)
5. Israel (6)

Here's the top 25 for all leagues:

1 England 118
2 Germany 84
3 Italy 80
4 Spain 59
5 France 45
6 Netherlands 34
7 Japan 25
8 Greece 21
8 Mexico 21
10 Korea DPR 20
10 Portugal 20
12 South Africa 17
13 Honduras 14
13 Russia 14
15 Korea Republic 13
15 Turkey 13
17 Argentina 11
18 Chile 10
18 Scotland 10
18 Switzerland 10
21 Australia 9
21 Denmark 9
23 Belgium 7
23 USA 7
25 Brazil 6
25 Israel 6

By club

13 - Barcelona, Chelsea
12 - Liverpool
11 - Bayern Munich
10 - Arsenal, Inter, Panathinaikos, Real Madrid
9 - Ajax, Juventus, Wolfsburg
8 - Portsmouth, Tottenham Hotspur, Udinese
7 - AC Milan, April 25, Everton, Hamburger SV, Lyon, Manchester City, Manchester Utd., Twente Enschede, Valencia, VfB Stuttgart

Top 10 oldest players

David JAMES Portsmouth England 39.868
Sander BOSCHKER Twente Enschede Netherlands 39.649
Marcus HAHNEMANN Wolverhampton USA 37.995
Mark SCHWARZER Fulham Australia 37.685
Cuauhtemoc BLANCO Veracruz Mexico 37.403
Oscar PEREZ Jaguares Mexico 37.362
LEE Woon Jae Suwon Bluewings Korea Republic 37.132
Fabio CANNAVARO Juventus Italy 36.748
Carlos PAVON Real Espana Honduras 36.677
Martin PALERMO Boca Juniors Argentina 36.597

Blanco is the oldest outfield player in this list, followed by Cannavaro and Pavon. No change from the provisional list.

Top 10 youngest players

Christian ERIKSEN Ajax Denmark 18.315
Vincent ABOUBAKAR Coton Sport Cameroon 18.378
Chris WOOD West Bromwich Albion New Zealand 18.504
Xherdan SHAQIRI Basel Switzerland 18.663
Joel MATIP Schalke 04 Cameroon 18.836
Lukman HARUNA Monaco Nigeria 19.512
Jonathan MENSAH Free State Stars Ghana 19.907
PAK Sung Hyok Sobaeksu Korea DPR 20.027
Rene KRHIN Inter Slovenia 20.052
Sotiris NINIS Panathinaikos Greece 20.184

Plenty of changes here.

Ghanian Daniel Agyei (20.578) is the youngest keeper (18th overall). In fact, in Agyei and Stephen Ahorlu (21.759), Ghana have the two youngest keepers in the tournament.

Average squad age

Italy are no longer the oldest team in the tournament, being replaced by Brazil. Ghana remain the youngest team.

1 Brazil 29.165
2 England 29.153
3 Australia 28.992
4 Paraguay 28.740
5 Italy 28.735
6 Honduras 28.388
7 Denmark 28.277
8 Japan 28.248
9 Portugal 28.162
10 Netherlands 28.104
11 Greece 28.087
12 France 28.062
13 New Zealand 27.868
14 Argentina 27.619
15 Korea Republic 27.583
16 Mexico 27.573
17 South Africa 27.313
18 USA 27.276
19 Slovenia 27.175
20 Switzerland 27.148
21 Uruguay 27.084
22 Côte d'Ivoire 27.073
23 Algeria 26.696
24 Slovakia 26.529
25 Serbia 26.433
26 Chile 26.358
27 Spain 26.352
28 Nigeria 26.313
29 Cameroon 25.584
30 Germany 25.349
31 Korea DPR 25.294
32 Ghana 24.717

Looking at the first 11 (going by shirt numbers):

1 Australia 31.640
2 Mexico 30.324
3 New Zealand 30.067
4 Paraguay 29.852
5 England 29.453
6 Italy 29.450
7 Brazil 29.427
8 Portugal 29.185
9 Greece 29.167
10 Denmark 29.151
11 Japan 28.420
12 Switzerland 28.333
13 Nigeria 28.192
14 Netherlands 28.178
15 France 28.046
16 Korea Republic 27.961
17 Spain 27.897
18 Argentina 27.878
19 Algeria 27.846
20 Honduras 27.844
21 USA 27.769
22 Slovakia 27.448
23 South Africa 27.106
24 Serbia 26.993
25 Côte d'Ivoire 26.889
26 Slovenia 26.808
27 Cameroon 26.696
28 Uruguay 26.247
29 Chile 26.068
30 Korea DPR 26.015
31 Ghana 25.707
32 Germany 25.497

Highest players

1 Nikola ZIGIC FW Serbia Valencia 202
2 Peter CROUCH FW England Tottenham Hotspur 201
3 Konstantinos CHALKIAS GK Greece PAOK 198
4 Uwa ECHIEJILE DF Nigeria Rennes 198
5 Matthew BOOTH DF South Africa Mamelodi Sundowns 198
6 Jasmin HANDANOVIC GK Slovenia Mantova 197
7 Maarten STEKELENBURG GK Netherlands Ajax 197
8 Nwankwo KANU MF Nigeria Portsmouth 197
9 Per MERTESACKER DF Germany Werder Bremen 196
10 David JAMES GK England Portsmouth 196
11 Mark SCHWARZER GK Australia Fulham 196

Shortest players

1 Aaron LENNON MF England Tottenham Hotspur 165
2 Clemente RODRIGUEZ DF Argentina Estudiantes La Plata 166
3 Arthur BOKA DF Cote dIvoire VfB Stuttgart 166
4 Walter MARTINEZ FW Honduras Marathon 166
5 Danilo TURCIOS MF Honduras Olimpia Tegucigalpa 166
6 MUN In Guk MF Korea DPR April 25 167
7 Mathieu VALBUENA FW France Marseille 167
8 Sebastian FERNANDEZ FW Uruguay Banfield 167

Average height

Serbia are the tallest team, followed by Greece and Denmark. I never knew Greeks are this tall. Chile are the shortest team, with Korea DPR and South Africa the other two teams below 178 cm.

1 Serbia 185.957
2 Greece 185.261
3 Denmark 184.87
4 New Zealand 184.739
5 Germany 184.478
6 Nigeria 184.087
7 Slovakia 184.043
8 Slovenia 183.87
9 Australia 183.783
10 Switzerland 183.261
11 Cameroon 182.652
12 Brazil 182.609
13 Korea Republic 182.478
14 Algeria 182.174
15 France 181.957
16 England 181.739
17 Portugal 181.478
18 Italy 181.261
19 Netherlands 181.087
20 USA 181.087
21 Côte d'Ivoire 180.957
22 Paraguay 180.913
23 Spain 180.913
24 Uruguay 180.522
25 Japan 178.783
26 Ghana 178.435
27 Argentina 178.043
28 Honduras 178
29 Mexico 178
30 South Africa 177.913
31 Korea DPR 177.739
32 Chile 176.478

Looking only at the first 11 (going by shirt numbers):

1 Greece 186.273
2 New Zealand 186.091
3 Germany 185.364
4 Denmark 185.273
5 Nigeria 185.182
6 Slovenia 184.818
7 Switzerland 184.818
8 Australia 184.545
9 Serbia 183.364
10 Slovakia 182.818
11 Algeria 182.727
12 England 182.727
13 Brazil 182.636
14 Uruguay 182.545
15 Netherlands 181.364
16 Italy 181.273
17 Korea Republic 181.273
18 France 181.091
19 Portugal 180.545
20 Paraguay 180.455
21 USA 180.273
22 Cameroon 180
23 Ghana 180
24 Honduras 179.636
25 Spain 179.636
26 Côte d'Ivoire 179
27 Argentina 178.364
28 Mexico 177.727
29 Chile 176.909
30 Japan 176.818
31 Korea DPR 176.364
32 South Africa 176.182

Local players vs. foreign players

England, Germany and Italy are the only teams with 100% local players.

Korea DPR, Japan and Spain are the other 3 teams with more than 80% local players.

Australia, Cameroon and Côte d'Ivoire have only one local based player each.

Team - Local players - Percentage

England 23 100
Germany 23 100
Italy 23 100
Korea DPR 20 86.96
Spain 20 86.96
Japan 19 82.61
South Africa 16 69.57
Greece 14 60.87
Honduras 14 60.87
Mexico 14 60.87
Korea Republic 13 56.52
France 11 47.83
Netherlands 9 39.13
New Zealand 9 39.13
Portugal 9 39.13
Chile 7 30.43
Denmark 7 30.43
Switzerland 7 30.43
Argentina 6 26.09
Paraguay 4 17.39
USA 4 17.39
Algeria 3 13.04
Brazil 3 13.04
Ghana 3 13.04
Serbia 2 8.7
Slovakia 2 8.7
Slovenia 2 8.7
Uruguay 2 8.7
Australia 1 4.35
Cameroon 1 4.35
Côte d'Ivoire 1 4.35

About me:

Christian, husband, father x 3, programmer, Romanian. Started the blog in March 2007. Quit in April 2018. You can find me on LinkedIn.

10 comments:

  1. I love this thing, thank you Edgar.

    ReplyDelete
  2. Bit unsure about your stats - sure Chelsea have 13 if you include Stoch (who has been on loan at Twente), but in that case Barcelona have 14 because they have Carceres from Uruguay who has been on loan at Juventus - right?

    Anyway, looks like Drogba and Ferdinand are already out which could mean these stats are old within a couple of hours. Which is a real shame because I love this sort of information!

    ReplyDelete
  3. I'm not too sure about your stats regarding league representation. Wellington Phoenix compete in the Australian A-League and Team Wellington compete in the New Zealand Football Championship.

    If you include Michael Beauchamp's move to Melboure Heart 3 weeks ago, the Australian A-League will have 10 World Cup representatives (Culina, Smeltz, Paston, Sigmund, Lochhead, Brown, Bertos, Moss, Brockie & Beauchamp)and the NZFC will have 4 (Vicelich, Barron, Bannetyne & Clapham).

    ReplyDelete
  4. @seventeen17

    Caceres is listed at Juventus: Uruguay squad

    @Jarryd

    Yes, you're right. I assumed if a team is listed as being based in a country, it will also be competing in that country's league. Will fix it in a couple of minutes.

    ReplyDelete
  5. @edgar

    yes, you're right looking at the official fifa lists, but do you see the inconsistency? unless carceres is about to sign for juventus?

    ReplyDelete
  6. Edgar, this is brilliant stuff! I have a small request... Can you please post the actual Raw Data for all 32 teams? All I need is the team name, the players' names, their ages, number of caps, their height and their weight. I am a Maths school teacher and the information will be fantastic to use in my stats lessons!! Thank you soooo much! Mr M

    ReplyDelete
  7. @seventeen17

    I agree, but I really don't have the time to go through all the list and check each player's status. I'm afraid this will have to do for now :)

    @Mr M

    Use the e-mail address from my profile.

    ReplyDelete
  8. Brilliant work mate! Is it possible to post the average squad age NOT including the keeper? The advanced age of some keepers can greatly skew the overall average age I think, especially for the first 11. England is a typical example ;)

    ReplyDelete
  9. Hi Ron!

    Unfortunately, with all the squad changes due to injuries, I think it's no longer relevant. For instance, I'm pretty sure Dawson won't start for England.

    ReplyDelete