_______________
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 |
I love this thing, thank you Edgar.
ReplyDeleteBit 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?
ReplyDeleteAnyway, 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!
Edgar,
ReplyDeleteMany thanks!
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.
ReplyDeleteIf 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).
@seventeen17
ReplyDeleteCaceres 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.
@edgar
ReplyDeleteyes, you're right looking at the official fifa lists, but do you see the inconsistency? unless carceres is about to sign for juventus?
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@seventeen17
ReplyDeleteI 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.
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 ;)
ReplyDeleteHi Ron!
ReplyDeleteUnfortunately, 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.