kunkello's notebook

Dinge, die mir durch den Kopf gehen…

Captain Number-Crunch (part 3)

leave a comment »

This is starting to be fun. Well, for me at least. While in the first article I mainly looked at things from a club and league perspective, yesterday I have tried to display what kind of “continental migration” is going on for the players participating in this World Cup. Now, for the third part of this series of analysis I focused on the European national teams and the leagues from those countries, and it was one of those moments where a simple table and the numbers it contained suddenly made a whole lot of sense. The table I am speaking of is this one:

What you see in this table is the European countries represented in this World Cup with their ranking in the UEFA team coefficient ranking (based on league’s performance in the European cup competitions). The 2nd data column shows how many different leagues (based on countries, not actually different leagues, ie. first and second division count as one) are represented in each national team. Next columns show in how many different national teams the leagues from each country are represented in and the last one how many “home” players (playing in the country’s own leagues) are represented in each national team.

The data plays out perfectly and I separated this into three categories. First, you have the “importers”, countries that have a lot of players from different leagues, but few of their top players play outside of their own league. The three only countries in the World Cup that recruit their national team exclusively from their home leagues can be found here: England, Italy and Germany (Ballack-less), in addition to that you have Spain with a trio of players earning their hefty paychecks in the Premier League.

The second group is the “importers-exporters”, countries/leagues that attract plenty of foreign talent and whose top players also venture out to play in one of the top leagues. I was surprised to see France so clearly in this group, as the league has clearly established itself as a top league in Europe, giving Italy and Germany a run for their money (quite literally). Still, less than half their top players play at home (=exporter) and there is players from 15 different national teams in this World Cup represented in the French leagues (=importer).

The last group is the “exporters”, countries/leagues, where almost all of the top players venture out to play in other leagues, and the three examples in this World Cup are Slovakia, Serbia and Slovenia. For each of these national teams, only two players still play at home. Two countries, Switzerland and Denmark, are borderline cases in terms of the “importer” criteria, as they only have 4 and 3 national teams represented in their respective leagues.

What was also striking, but probably not surprising, was that how clear the separation of the three groups correlates with the UEFA ranking. I say not surprising because of course top players tend to move to better leagues and leave the home leagues in a weaker position, but nevertheless, I wouldn’t have expected the result so clear.

So that’s it for today. For me this was the most interesting part of the series so far. As always, I hope some of the stuff I am discovering you also find interesting. Feel free to drop a comment if you are interested in any specific way to dissect league/team/nationality data of the World Cup players.


Written by Dierk

June 9, 2010 at 5:50 pm

Posted in English, Football and me

Tagged with , ,

Captain Number-Crunch (part 2)

with 2 comments

Continental Player Migration

Continental Player Migration

Today I am taking a look at where do players from their continental association’s national teams actually play their league football. I tried to show this in the above charts. The arrows are depicting to which leagues/continents they have migrated, the numbers in the oval shapes are the players staying on their “home” continent and the diamond shapes are players that do not have any team affiliation (all data as per http://www.fifa.com squad lists from June 6).

You can see that all players representing a national team from a UEFA federation actually play their football inside a league under the UEFA umbrella. The largest share of “migrants” is playing for the African national teams, which makes a lot of sense, as the money available in African leagues is probably fairly limited.

The opposite seems true for the Asian national teams, where still almost three quarters are playing in their home continent, which again seems logical, given the fact that there’s good money to be made in some Asian leagues (Japan, the Arab subcontinent’s leagues) but there’s also the effect of the North Korean team where 20 out of the 23 players are playing at home.

South American players are also well travelled, as 7 out of 10 ten are playing in Europe, and chances are that the other 3 out of 10 are hoping to do so as well after the World Cup.

A more balanced picture is offered by the Concacaf teams, where the split between players from “home” and cross-continental players is pretty even, as players representing Mexican and Honduras leagues are the majority of the “home” players of the Concacaf teams.

That’s probably all for today, let’s see what more I can pull out of the data set for tomorrow…

Written by Dierk

June 8, 2010 at 9:49 am

Posted in English, Football and me

Tagged with , , ,

Captain Number-Crunch (part 1)

leave a comment »

Update June 9, 2010: I have replaced the old text-based tables with image files, whereas the first of the two images replaces the first two previous text-based tables. I hope this adds to the readability of this article.

In a forum discussion about UEFA’s coefficient ranking for next season, I ended up giving my opinion on how I see the German teams performing in the upcoming season, putting up the vague statement, that Bundesliga’s representatives will collect significantly less points in 2010/11 than they did in the season that just ended. I reasoned that due to the fact that many players of next year’s European cup participants will be starring in this summer’s world cup, hence overall performance of the German Bundesliga teams will drop due to late season fatigue. This combined with the fact that Germany will have to do reasonably well to maintain its lead over Italy in what is now the provisional 2010/11 UEFA ranking, this might not be that easy of a task as it seems based on the current almost 5 point advantage going into the season.

Once I had clicked “send”, I started to ponder on what I had just written and figured it might be a good idea to investigate how the players called up by their national teams for the World Cup would distribute over teams and leagues across the globe, and if there is really any one league that might be at a disadvantage come next year in European cup play due to their stars showing signs of fatigue early or late in the season due to the shortened summer break they likely will enjoy.

As somebody who spends most of his time running Excel sheets and trying to synthesize somewhat meaningful analysis from those, it was fairly obvious I wasn’t going to probe in Google and the deep and dark alleys of the world wide web to find ready made analysis, but I was going to take matters in my own hands, seek out and pull raw data and crunch those numbers myself.

The result of this you will find now in this blog post, my very first (well, this particular one is 1b, as the original I posted in German). I hope one or the other reader will find the data presented here interesting, and most likely I won’t stop with this one entry, but will make some effort to provide additional data views in subsequent entries, like for example at one point adding actual minutes played to this statistic, to remove the “world cup tourist effect” from the analysis.

Like in the German version, some excuses upfront, first, while I don’t have to worry about umlauts in the English version of my writing, the excuse that I am still lacking in the “art of keeping things short” is valid here as well. So please forgive me if I drag on and you feel I don’t get to the point…

So here is part one:

National team call-ups by country (leagues)

(combining all leagues of any given country, first, second and lower divisions):


(next are the leagues from Japan and Mexico, whose participants are mainly in the respective country’s national teams, but a few of them also represent “smaller” countries’ teams in the region)

So what to make of this? Well, first it is probably anything but surprising that the English league’s teams are leading the pack here, being the big spenders in European football, all the way down to the “bottom-feeding” teams. And the English scouts seem to be roaming the entire globe for talent, as with only a few exceptions, a Premiership or Championship player can be found in all the lineups of this World Cup (North Korea being the not so surprising exception, alongside Germany and Italy and two others).

Opposed to the English league, the other league dominating European cup competitions, Spain’s Primera Division, is only sending 59 players to the World Cup, of which alone 20 are representing “La Furia Roja”. But not only do the Spanish teams send less players to South Africa, they also only are represented in 15, less than half, of the teams in the tournament. Does that mean, that Spanish scouts don’t like to travel? Or is the buying power outside of teams like Barca and Real Madrid (and maybe Valencia, Sevilla and Atletico) so limited that the global reach for talent does not develop and teams rely on their youth squads and “known entities” such as 2nd tier South American stars to fill up their line ups?

With next year’s European cup season in mind, I of course wanted to know how many players are participating in the tournament from teams that have qualified for European cup play next year. We shall be curious whether the English teams will hit a wall at one point next year. Not only do they play one of the more exhausting schedules of any European league (20 team league, 2 cup competitions), but on average they are sending 2 more players per team to the World Cup than the next league.

Another thing jumping out at me is the fact that a large number of players sent by Spanish teams are from the league’s European Cup participants. This could further add to the theory that mainly the big teams in Spain have the financial breadth (by which means ever) to invest in national team players, independent of their nationality.

The difference between Germany and Italy is not very big, just half a player on average. But you can see that there is a discrepancy between the national team players in total for the league and those playing for teams qualified for European football. In the former, Germany is leading, in the latter case Italy is ahead. That might indicate a somewhat wider distribution of financial means in Germany, while Italy could be more “top heavy” in terms of monetary strength .

Last but not least, another data set:

Which teams are sending the most players?

… and to how many national squads, and how many to the “own” or “home” squad?


Edit on June 9th: spox-community user amicaro pointed me to mistake, which is hereby corrected: of course ManU has representatives in 4 national teams not one like the previous table stated. Also, please note that the cutoff is in this list is arbitrary, there’s a couple of other teams with 7 players and plenty with 6 and less, ManU I kept on the list, as their June 8th fifa.com data still lists Nani, so anybody using the original, unadjusted reference, will count 6 players from ManU.

… and that’s where I stop, but I really had to put my VfB into this text somewhere. Interestingly enough, there’s two completely different “foreign legion troups” in this list, seen from a model-for-success perspective, as you have Internazionale sending 10 players to the World Cup, none of them from Italy itself, and then you have Portsmouth, similarly with 8 cappers, again none playing for the Three Lions. Opposite to those teams you have the FC Germany Munich (ouch, blow to the stomach of my VfB Stuttgart fan-self) and FC Spain Barcelona (ouch, creating an identity crisis for many of my Barcelona/Catalan friends) and of course Panthinaikos Greece…

Other parts in this series:
part 2
part 3

Written by Dierk

June 7, 2010 at 10:06 pm

Posted in English, Football and me

Tagged with , ,

Captain Number-Crunch (Teil 1)…

with 4 comments

Update, 9. Juni: ich habe die urpsruenglichen drei Texttabellen durch zwei Bilddateien ersetzt, wobei das erste der beiden Bilder zwei der vorigen Texttabellen ersetzt. Ich hoffe dies sorgt fuer mehr Uebersicht und bessere Lesbarkeit.

In einem Forum zur UEFA Fuenfjahreswertung habe ich mich dazu hinreissen lassen, meine Einschaetzung zum Abschneiden der deutschen Mannschaften in 2010/11 abzugeben, und habe die vage Behauptung aufgestellt, naechste Saison wuerden die Bundesligavertreter deutlich weniger Punkte sammeln als in der gerade abgelaufenen Spielzeit. Begruendet habe ich das mit der Tatsache, dass sehr viele Nationalspieler der naechstjaehrigen Europokalteilnehmer ueber den Sommer bei der WM aktiv sind, und deswegen naechstes Jahr weniger Erfolge zu erwarten sind als in der Vorsaison. Diese Aussage verknuepft mit der Tatsache, dass es in der UEFA Fuenfjahreswertung nun darum gehen wird, einen Vorsprung auf die Italiener zu verteidigen, und dies angesichts des mangelnden Sommerurlaubs der Topspieler doch nicht ganz so einfach sein werde.

Als ich dann schon auf “senden” gedrueckt hatte, und mir anschliessend nochmal die Zeit nahm, ueber das Geschriebene nachzudenken, kam ich auf die Idee nachzuforschen, wie sich die an der WM teilnehmenden Spieler denn tatsaechlich auf die einzelnen Ligen und Mannschaften verteilen, und welche Liga vielleicht einen Nachteil im naechsten Jahr haben koennte, wenn den Topstars vielleicht irgendwann dank des verkuerzten Sommerurlaubs die Puste ausgehen wuerde.

Als jemand, der den ganzen Tag wenig anderes macht, als irgendwelche Excel Tabellen zu erstellen und versucht daraus einigermassen sinnvolle Analysen abzuleiten, lag es natuerlich nahe, mich nicht auf Google und die weltlichen Weiten des Netzes zu verlassen, sondern einfach mal selbst Hand anzulegen (aehem), Datenmaterial zu besorgen und fleissig Pivottabellen zu erstellen.

Was dabei herausgekommen ist, fliesst nun in diesen, meinen allerersten Blogeintrag. Ich hoffe, es findet sich der ein oder andere interessierte Leser, und wenn dem so sei, vielleicht bleibt es auch nicht bei diesem einen Eintrag, und ich werde mir die Muehe machen, diese Statistik noch um weitere Elemente zu bereichern, so zum Beispiel tatsaechliche Spielminuten bei der WM und solche Spaesse.

Wofuer ich mich schon mal entschuldigen moechte ist zum einen, dass ich keine Umlaute schreibe, da ich auf einer internationalen Tastatur tippe, und irgendwann habe ich mir abgewoehnt, jedesmal Umlaute zu korrigieren, oder das Tastaturlayout zu wechseln. Ich hoffe es stoert nicht all zu sehr. Zum anderen, hab ich noch nicht so die Erfahrung im kurz fassen, wie es sich fuer einen Blog-Schreiber vielleicht gehoert. Ich hoffe, das Ganze ist nicht schon zu und wird nicht noch langatmig(er).

Also, los geht’s mit dem ersten Teil:

Spielerentsendungen nach Land

(alle Ligen eines jeweiligen Landes zusammen, also z.B. 1. und 2. Bundesliga)

(danach kommen schon die Ligen aus Japan und Mexiko, deren Vertreter hauptsaechlich in der jeweiligen einheimischen Nationalmannschaft kicken, bzw. einige wenige in “kleineren” Natis aus der jeweiligen Region)

Was laesst sich daraus herauslesen? Na ja, zunaechst mal ist es sicher nicht ueberraschend, dass die englischen Ligen vorne sind, denn wird nicht dort das meiste Geld in die Mannschaften gesteckt, und zwar von allen Teams? Ausserdem scheinen die Jagdgruende der englischen Scouts “global” ausgelegt, denn mit wenigen Ausnahmen findet sich ein Premier League oder Championship Spieler in praktisch jeder der teilnehmenden Nationalmannschaften (nicht sehr ueberraschenderweise ist Nordkorea eine der Ausnahmen, aber auch Deutschland und Italien).

Im Gegensatz dazu die Liga, die zusammen mit der Premier League das europaeische Fussballgeschehen dominiert: die spanische Liga ensendet nur 59 Spieler, wovon auch noch 20 Spieler der “Furia Roja” sind. Und auch die Quote der vertretenen Nationen ist deutlich niedriger. Bedeutet dies, dass das spanische Scouting eher regional eingeschraenkt ist? Oder die Finanzkraft ausserhalb von Mannschaften wie Barca, Real und vielleicht noch Valencia, Sevilla und Atletico nicht ausreicht, um A-Kaliber internationale Profis zu verpflichten und daher verstaerkt auf Nachwuchsspieler und Profis aus der zweiten Reihe, z.B. aus Argentinien und Brasilien, zurueckgegriffen wird?

Mit Hinblick auf die kommende Europapokalsaison wollte ich natuerlich auch wissen, wieviele Spieler aus Mannschaften kommen, die naechstes Jahre in den Wettbewerben der UEFA vertreten sind.

Hier darf man gespannt sein, ob die Englischen Mannschaften naechstes Jahr ein Ausdauerproblem bekommen. Nicht zuletzt hat die Premier League wohl einen sehr kraftraubenden Kalender (20 Mannschaften in der PL, zwei Pokalwettbewerbe), auch sind im Schnitt 2 Spieler mehr pro Europapokalvertreter bei der WM dabei als beim naechsten Verfolger.

Was hier nochmals heraussticht ist, dass der Grossteil der teilnehmenden Spieler der spanischen Vereinsmannschaften auch aus dem Kreise der Europapokalteilnehmer kommt. Dies koennte die These von weiter oben bestaetigen, dass Hauptsaechlich die grossen Mannschaften in Spanien fluessig genug sind, in Nationalspieler (gleich welcher Herkunft) zu investieren.

Der Unterschied, zwischen Deutschland und Italien ist nicht sehr gross, gerade mal 0.5 Spieler im Durchschnitt. Allerdings zeigt sich die Diskrepanz zwischen der Gesamtzahl der Nationalspieler, die bei der WM vertreten sind und die Zahl derer, die von “Topklubs” (wenn man Europapokalteilnehmer so definieren darf) entsendet werden. Im ersten Fall liegt Deutschland knapp vor Italien, im zweiten doch deutlich dahinter. Ist dies ein Indiz fuer eine finanziell eher breiter aufgestellte Bundesliga im Vergleich zu einer “spitzenlastigen” Serie A?

Zu guter letzt noch ein weiteres Gimmick:

Welche Vereinsmannschaften stellen die meisten Spieler ab?

… und in wieviele verschiedene Nationalmannschaften, und wieviele in die eigene, heimische Nationalmannschaft?


Hinzugefuegt am 9. Juni: Es folgen noch einige weitere Mannschaften mit 7 und 6 Spielern, den Cut-Off habe ich also willkuerlich gesetzt. ManU habe ich noch reingenommen, weil es in den fifa.com Daten per heute noch 6 Spieler sind (und ja es sind 4 Nationen bei ManU, vielen Dank fuer den Hinweis an amicaro aus der spox-community).

Aber hier hoere ich jetzt auf fuer heute, meinen VfB musste ich auf jeden Fall irgendwo noch unterbringen. Interessanterweise gibt es zwei komplett Gegenteilige vermeintliche “Soeldnertruppen” in dieser Liste, zumindest was den Erfolg betrifft. Sowohl Inter Mailand als auch Portsmouth haben eine Vielzahl von Nationalspielern aus aller Herren Laender, ausser aus dem eigenen, heimischen, der Erfolg war jedoch exakt gegensaetzlich. Im Gegensatz dazu gibt es den FC Deutschland Muenchen (ouch, das tut weh als VfB Fan) den FC Spanien Barcelona (ouch, das muss meine Freunde in Barcelona schmerzen) und den FC Panathinaikos Griechenland….

Hier geht’s zu Teil 2 (Englisch) und Teil 3.

Deutschland 35 Spieler (von 84 = 42%, 5.8/EP-teilnehmer)

Written by Dierk

June 7, 2010 at 6:13 pm