Friday, May 14, 2010

World Cup provisional squads statistics

I didn't plan on doing this, but since Dorian asked...

353 clubs have players in this provisional list (thank you PDF Unlock), with three players currently unattached: Craig Moore (Australia), Simon Elliott and Dave Mulligan (both New Zealand).

England is the best represented league - 139 players, with Germany (94), Italy (93), Spain (74) and France (58) completing the top 5.

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

1. Russia (16)
2. Turkey (15)
3. Scotland (12)
4. Belgium (10)
5. Israel (7)

Here's the top 25 for all leagues:

1 England 139
2 Germany 94
3 Italy 93
4 Spain 74
5 France 58
6 Netherlands 47
7 Japan 34
8 Greece 33
9 Mexico 25
10 Portugal 23
11 South Africa 21
12 Honduras 20
12 Korea DPR 20
14 Argentina 19
15 Korea Republic 18
16 Russia 16
16 Switzerland 16
18 Turkey 15
19 Chile 14
19 Denmark 14
21 New Zealand 13
22 Scotland 12
22 USA 12
24 Belgium 10
25 Algeria 8
25 Brazil 8

By club

17 - Chelsea
14 - Barcelona
12 - Liverpool, Panathinaikos, Real Madrid
11 - Ajax, Arsenal, Bayern Munich, Juventus, Tottenham Hotspur
10 - Inter
9 - AC Milan, Everton, Udinese, Wolfsburg
8 - AZ Alkmaar, Basel, Manchester City, Twente Enschede, Valencia, VfB Stuttgart
7 - April 25, Benfica, Hamburger SV, Lyon, Manchester Utd., Marseille, Portsmouth, PSV Eindhoven, Rennes, Villarreal, West Ham Utd.

Top 10 oldest players

David JAMES England Portsmouth 39.810958
Sander BOSCHKER Netherlands Twente Enschede 39.59178
Marcus HAHNEMANN USA Wolverhampton 37.936986
Mark SCHWARZER Australia Fulham 37.627397
Cuauhtemoc BLANCO Mexico Veracruz 37.345205
Oscar PEREZ Mexico Chiapas 37.304109
LEE Woon Jae Korea Republic Suwon Bluewings 37.073972
Fabio CANNAVARO Italy Juventus 36.69041
Carlos PAVON Honduras Real Espana 36.619178
Martin PALERMO Argentina Boca Juniors 36.539726

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

Top 10 youngest players

Christian ERIKSEN Denmark Ajax 18.25753
Vincent ABOUBAKAR Cameroon Coton Sport 18.32055
Nassim BEN KHALIFA Switzerland Grasshopper Club 18.34521
Thomas OAR Australia Utrecht 18.43836
Chris WOOD New Zealand West Bromwich Albion 18.44658
Xherdan SHAQIRI Switzerland Basel 18.60548
Jacques ZOUA Cameroon Basel 18.69863
Terna SUSWAN Nigeria Lobi Stars 18.70137
Joel MATIP Cameroon Schalke 04 18.77808
Konstantinos MANOLAS Greece AEK Athens 18.92877


Average squad age

Italy 28.22128
England 28.14813
Paraguay 28.12767
Denmark 28.11196
Brazil 27.97461
Japan 27.84931
Australia 27.71078
Honduras 27.53023
Portugal 27.50511
Netherlands 27.38137
France 27.36886
Argentina 27.21068
Korea Republic 27.1611
South Africa 27.12922
Cote d'Ivoire 26.95927
Mexico 26.95637
Uruguay 26.90906
USA 26.88164
New Zealand 26.7821
Slovenia 26.7411
Greece 26.71918
Slovakia 26.59726
Algeria 26.51397
Switzerland 26.47644
Spain 26.24502
Chile 26.22036
Nigeria 25.62146
Germany 25.48219
Serbia 25.47525
Korea DPR 25.32329
Cameroon 25.19726
Ghana 24.83598

Local players vs. foreign players

England are the only team with 100% local players. Italy (Giuseppe Rossi) and Germany (Michael Ballack) have only 1 foreign based player in their lists.

Korea DPR, Japan and Spain are the other 3 teams with more than 85% (86.67% to be more exact) local players.

At the other end, Australia were very close to 0 local players - only Jason Culina representing the A-League in the Socceroos' list.

Other teams with less than 15%: Nigeria, Cote d'Ivoire (both 6,66%), Cameroon (10%), Slovakia (10.34%), Slovenia and Ghana (both 13.33%)

Team - Local based - Total players - Percentage

England 30 30 100
Italy 29 30 96.67
Germany 26 27 96.3
Korea DPR 20 23 86.96
Japan 26 30 86.67
Spain 26 30 86.67
Greece 21 30 70
Honduras 20 30 66.67
South Africa 19 30 63.33
Mexico 16 26 61.54
Korea Republic 18 30 60
France 17 30 56.67
Netherlands 16 30 53.33
New Zealand 13 30 43.33
Portugal 12 30 40
Chile 11 30 36.67
Denmark 11 30 36.67
Switzerland 11 30 36.67
Argentina 10 30 33.33
USA 9 30 30
Algeria 8 30 26.67
Paraguay 6 30 20
Brazil 5 30 16.67
Serbia 5 30 16.67
Uruguay 4 26 15.38
Ghana 4 30 13.33
Slovenia 4 30 13.33
Slovakia 3 29 10.34
Cameroon 3 30 10
Cote d'Ivoire 2 30 6.67
Nigeria 2 30 6.67
Australia 1 30 3.33

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. Great info Edgar! Thank you again.
    I'd love to see this done for final 23 men squads.

    ReplyDelete
  2. Great job!!!

    Juan

    ReplyDelete
  3. Edgar,
    Thank you very much! Especially for the added age work. Truly interesting.
    -Dorian

    ReplyDelete
  4. Thanks for doing this, because I was planning on it and now I don't have to! Although I was waiting for the final squads...

    ReplyDelete
  5. Scaryice told the truth! Now, we are ALL waiting for the same information when the 23-man squad lists are released.

    ReplyDelete
  6. P.S.: But, this is already great. Thank you for the information. Have you this on a .xls file?

    ReplyDelete
  7. It seems I should focus more on players stats :D If I'll have the time, I'll also post the final 23 men squads stats. That's if scaryice doesn't post them first. :)

    I have some info in an Excel file, but I parsed it in a MSSQL DB.

    If anyone wants the Excel file, use the e-mail address from my profile.

    ReplyDelete
  8. Keep it up! Please!!

    ITV commentary team.

    ReplyDelete
  9. Spreadsheet updated to include final 23-man squads.

    http://spreadsheets.google.com/ccc?key=0AketNFot9zMvdGhCYzg0d3JyX2lSRVFSR005azVpcUE&hl=en

    ReplyDelete