Tag Archives: 2014

World Cup 2014 Data

It’s been a while since the last post I made on this blog, but it’s World Cup season so I had to contribute something.

I’ve collected some player/team data from the FIFA website which anyone can download and find interesting stuff. I’ve only put basic data in there, nothing too technical, but there is a collection of passing and tracking stats and a handful of other categories for every game so far: World_Cup_2014_group_stage < Click to download data in .xlsx format

If you use this data and see any problems with it let me know. For the USA-Ghana match, a handful of the stats didn’t seem to be published in the usual format so that one is incomplete. I also noticed that the high-intensity distance covered stats for the same game looked strange (probably incorrect) – use with caution.

Here is a small selection of charts based on the published dataset…




(*NB I removed values for USA-Ghana in the above chart)




Srna and Di Maria pop up a couple of times with top speeds clocked over 31km/h. Aurier was observed at the fastest speed of 33.52km/h in the Ivory Coast-Colombia game.


For total distance covered Bradley makes 3 appearances in the top 20 for his efforts in all 3 games.


Premier League Fixture Chart In Numbers 2013/14

EPL Fixtures in numbersI like spreadsheets so when faced with the new season’s premier league fixtures, I was delighted to translate them into numbers and create a table – which I have shared with you above. At the very least I’ve made a reasonably nice-looking heat map.

The games are all shown 1-38 in the current published chronolgical order. We all know this subject to change – but this is the current expected fixture order.

Those of you looking critically at the table will have some questions, so I’ll outline the simple methodology I used – which will either allow you to accept the flawed process or shake your head in mild irritation and carry on with your day.


I split the league into quintiles, which was easier said than done outside the top 4. Spurs could have had a case for being classed as a ‘top 4’ team, perhaps Everton and Liverpool too – considering Everton’s excellent home record last season and Liverpool’s excellent last 19 games. But I stuck with the quintiles rigidly. This gave me a dilemma as to who should be in each pot outside of the top 4 – I solved the dilemma by considering bookie’s odds for relegation and various club ranking systems.

Those of you who know I am a Newcastle fan will scoff at the fact that they are in the 5-8 group (and I do feel guilty about their position) but their odds for relegation were longest after the ‘big 7’. Also sorry Norwich fans for placing your team in the bottom group alongside the promoted teams – blame the bookies for that.

I scored match difficulty in a rather simple and linear way, allocating higher points to away games and matches against the top teams – the scoring chart is below:

Quintile Venue Difficulty
1-4 Away 6
1-4 Home 5
5-8 Away 5
5-8 Home 4
9-12 Away 4
9-12 Home 3
13-16 Away 3
13-16 Home 2
17-20 Away 2
17-20 Home 1

I don’t actually think that team abilities in the league will sit on a linear scale – looking at last season’s table will show the big points gap between 7th and 8th, then a group of teams separated by 9pts between places 8-16. So I might add a new table based on a more considered scale for this reason in a later post.

Pressure Points

Below is a 5-game average difficulty chart for the fixtures throughout the season:

EPL Fixtures in numbers 5-game aveFrom the above, it seems as though Villa, Fulham, Stoke and Man Utd all have the most difficult starts to the season.

Man Utd have away games at Man City, Liverpool and Swansea in their first 5, along with a home match against Chelsea – hardly an easy start for Moyes (their other match is home to Crystal Palace – arguably more straightforward).

As for fast starts, don’t be surprised if Spurs, Man City, Arsenal, Norwich and West Ham get a few good early results to shoot towards the top of the table.

We can also see the likely pressure points of the season – Arsenal’s season could be over unless they can navigate games 15-19 safely (Everton home, Man City away, Chelsea home, West Ham away, Newcastle away). And if Mourinho’s Chelsea are still in the hunt for the title with 7 games to go few should bet against them.

Lastly I’ve added the range and standard deviation to the chart to attempt to give some insight into how consistent the difficulty of each team’s games is through the season. It suggests that we might expect Fulham and Arsenal to fluctuate more between hot and cold streaks (e.g. headlines might read ‘Jol is a genius’ and ‘sack Jol’ at various times, ditto Wenger) whilst Newcastle are a bit more likely to achieve a more constant haul of points during the season (expect to hear ‘sack Kinnear’ regardless throughout the season!).