Introduction

As the Premier League draws to a close, of interest are the final league standings; who will win the league, who will finish in the top four, and who will be relegated. In recent weeks I’ve been producing forecasts of individual match outcomes, including for the Premier League (see, for example, http://rpubs.com/jjreade/forc_130315). In this document I use those forecasts to iterate to the end of the season, updating league tables and Elo scores along the way, to determine who is most likely to finish where. First I describe my method, then present some results of interest, and compare my results to those of bookmakers.

Method

Forecasts are created using an ordered logistic model for the ordered outcome for match \(i\) and time \(t\): \[ y_{it} = \left\{\begin{array}{lll}0 && \text{if away win,}\\0.5 && \text{if draw,}&&1 && \text{if away win.}\right. \]

The model is estimated over every historical top division match in England.

The method is as follows:

We now load up the results of one such replication.

library(knitr)
loc <- "/home/readejj/Dropbox/Teaching/Reading/ec313/2015/Football-forecasts/"
final.standings.1 <- read.csv(paste(loc,"prem-final-2015-03-19.csv",sep=""),
                              stringsAsFactor=F)
final.standings.1$X <- NULL

Rather than attempt to calculate probabilities of final outcomes, which are complicated functions of individual matches, we can thus refer to the number of repliactions in which particular events occur as estimated probabilities, or likelihoods, of their occurring. Our statistical model, updated for each week’s matches with imputed outcomes, takes into account form, league position and longer-term strength.

For example, we might think about where a particular team is likely to finish, such as Chelsea, Manchester City or Arsenal:

plot(table(final.standings.1$Chelsea)/1000,
     main="Likelihood of particular position finish for Chelsea",
     xlab="Position",ylab="Probability",col="blue")

plot(table(final.standings.1$Man.City)/1000,
     main="Likelihood of particular position finish for Man City",
     xlab="Position",ylab="Probability",col="lightblue")

plot(table(final.standings.1$Arsenal)/1000,
     main="Likelihood of particular position finish for Arsenal",
     xlab="Position",ylab="Probability",col="red")

plot(table(final.standings.1$QPR)/1000,
     main="Likelihood of particular position finish for QPR",
     xlab="Position",ylab="Probability",col="blue")

Hence this shows us that in over 80% of the replications, Chelsea won the Premiership, which we translate into an 82.6% chance of them winning. The distributions for Manchester City and Arsenal are more spread, with there being a small chance City win the league (<10%), a NaN% chance of them finishing second, and hence a NaN% chance of them finishing below second (with even a NaN% chance of them finishing outside the top 4). Arsenal’s probabilities are centred around finishing third being most likely.

At the bottom, QPR appear likely to be relegated, and there’s nearly a 50% change they finish bottom of the table. There’s only a 14.8% of them avoiding relegation (finishing in positions 18-20).

We can look more generally at positions rather than teams;

par(mar=c(9,4,4,5)+.1)
plot(colSums(final.standings.1[,-1]>17)/10,type="h",xaxt="n",
     main="Likelihood of being relegated",xlab="",ylab="Probability")
axis(1,at=1:20,labels=colnames(final.standings.1[,-1]),las=2)
abline(h=0,lty=3)
abline(h=10,lty=2)
abline(h=20,lty=2)
abline(h=30,lty=2)
abline(h=40,lty=2)
abline(h=50,lty=2)

Considering relegation, this plot provides the number of replications in which teams finished in the bottom three positions and hence would have been relegated. Clearly Leicester and QPR are highly likely to be relegated, with Burnley, Sunderland seemingly more likely than Aston Villa or Hull to join them.

Considering the Premiership title:

par(mar=c(9,4,4,5)+.1)
plot(colSums(final.standings.1[,-1]==1)/10,type="h",xaxt="n",ylim=range(0,100),
     main="Likelihood of being Premiership champions",xlab="",ylab="Probability")
axis(1,at=1:20,labels=colnames(final.standings.1[,-1]),las=2)
abline(h=0,lty=3)
abline(h=10,lty=2)
abline(h=20,lty=2)
abline(h=30,lty=2)
abline(h=40,lty=2)
abline(h=50,lty=2)

clean.data <- function(data) {
  require(zoo)
  colnames(data)[1] <- "Date.Time"
  colnames(data)[-1] <- gsub("^.*?\\d+_(\\w+)[.]href.*?$","\\1",colnames(data)[-1])
  data <- data[,-NCOL(data)]
  data$Date.Time <- as.Date(substring(data$Date.Time,2),"%Y-%m-%d")
  data <- data[is.na(data$Date.Time)==F,]
  data <- data[order(data$Date.Time),]
  for(i in colnames(data)[nchar(colnames(data))==2]) {
    data[,i] <- gsub("<div class=.*?>(.*?)</div>","\\1",data[,i])
    data[,i] <- gsub("<div class=.*?>(.*?)\\s+$","\\1",data[,i])
    data[,i] <- gsub(">","",data[,i])
    data[,i] <- gsub("^\\s+|\\s+$","",data[,i])
    #need to turn fractional odds into decimal odds
    numerator <- gsub("(\\d+)/(\\d+)$","\\1",data[,i])
    denominator <- gsub("(\\d+)/(\\d+)$","\\2",data[,i])
    data[,i] <- as.numeric(numerator)+1
    data[numerator!=denominator,i] <- as.numeric(numerator[numerator!=denominator])/as.numeric(denominator[numerator!=denominator])+1
    data[,i] <- na.locf(data[,i],na.rm=F)
  }
  return(data)
}

winner.bk <- data.frame(stringsAsFactors=F)
bk.dir <- "/home/readejj/Dropbox/Research/Data for Ideas/Betting/football/eos/2015-03-20/winner"
bk.teams <- dir(bk.dir,pattern="*.csv")
for(i in bk.teams) {
  temp <- read.csv(paste(bk.dir,i,sep="/"),stringsAsFactors=F)
  temp <- clean.data(temp)
  temp$team <- gsub("[.]csv","",i)
  winner.bk <- rbind(winner.bk,temp)
}
## Loading required package: zoo
## 
## Attaching package: 'zoo'
## 
## The following objects are masked from 'package:base':
## 
##     as.Date, as.Date.numeric
#axis(1,at=1:20,labels=colnames(final.standings.1[,-1]),las=2)
bk.teams <- winner.bk$team[winner.bk$Date.Time=="2015-03-20"]
for(t in bk.teams) {
  lines(rep(grep(t,gsub("[.]","-",tolower(colnames(final.standings.1[,-1])))),sum(nchar(colnames(winner.bk))==2)),
        100/winner.bk[winner.bk$Date.Time=="2015-03-20" & winner.bk$team==t,colnames(winner.bk)[nchar(colnames(winner.bk))==2]],type="p",pch=2)
}

In this plot, we have added bookmaker prices collected today for the Premiership title; relative to bookmakers, our model under-estimates the likelihood of a Chelsea Premiership title, which at the moment appears a near certainty. Bookmakers put the likelihood at nearer to 90%. The likelihoods for the remaining teams are in line with bookmaker prices, i.e. very unlikely.

Next the top four, the positions in which teams qualify for the lucrative European Champions League:

par(mar=c(9,4,4,5)+.1)
plot(colSums(final.standings.1[,-1]<5)/10,type="h",xaxt="n",
     main="Likelihood of finishing in the top four",xlab="",ylab="Probability")
axis(1,at=1:20,labels=colnames(final.standings.1[,-1]),las=2)
abline(h=0,lty=3)
abline(h=10,lty=2)
abline(h=20,lty=2)
abline(h=30,lty=2)
abline(h=40,lty=2)
abline(h=50,lty=2)

This final plot suggests that despite Liverpool’s excellent run of late, their tough run of fixtures in the final few matches means they are less likely than Man United to make the top four.

Finally, we print one of our replications in full, to give an idea of one possible reality (at least in terms of match outcomes) that our probabilities are based upon:

res.eng.0 <- read.csv(paste(loc,"prem-one-rep-2015-03-19.csv",sep=""),stringsAsFactors=F)
kable(res.eng.0[res.eng.0$date>"2015-03-19",])
X match_id date div_id division team1_id team1 goals1 goals2 team2 team2_id outcome season tier R.1 R.2 E.1 weight pts1 pts2 pld1 pld2 gs1 gs2 gd1 gd2 pos1 pos2 form1 form2 pts.D pts.D.2 pld.D pld.D.2 gs.D gs.D.2 gd.D gd.D.2 pos.D pos.D.2 form.D form.D.2 season.d X.Intercept.
262 47031 tgc689717 2015-04-29 1 English Premier 1527 Leicester 1.0662417 1.0662417 Chelsea 536 0.5 2014 1 1379.963 1817.706 0.0744781 60 25 71 33 33 30.20629 64.61810 -20.3991302 36.6602429 20 1 7.0135201 8.027347 -46 2116 0 0 -34.4118095 1184.1726324 -57.0593731 3255.7720533 19 361 -1.0138264 1.0278439 57.96508 1
291 47060 tgc689746 2015-03-22 1 English Premier 2093 QPR 0.6928898 2.3531327 Everton 942 0.0 2014 1 1362.412 1469.315 0.3508313 60 22 31 29 29 30.00000 36.00000 -22.0000000 -5.0000000 20 14 2.9950000 5.002500 -9 81 0 0 -6.0000000 36.0000000 -17.0000000 289.0000000 6 36 -2.0075000 4.0300563 57.96508 1
292 47061 tgc689747 2015-03-22 1 English Premier 1310 Hull 0.6928898 2.3531327 Chelsea 536 0.0 2014 1 1381.102 1817.706 0.0749314 60 28 64 29 28 26.00000 58.00000 -11.0000000 35.0000000 16 1 9.0250000 12.032500 -36 1296 1 1 -32.0000000 1024.0000000 -46.0000000 2116.0000000 15 225 -3.0075000 9.0450562 57.96508 1
293 47062 tgc689748 2015-03-21 1 English Premier 2477 Stoke 2.7138053 0.6544322 C Palace 646 1.0 2014 1 1611.376 1558.734 0.5751827 60 42 33 29 29 33.00000 34.00000 -2.0000000 -6.0000000 8 12 10.0175000 10.037500 9 81 0 0 -1.0000000 1.0000000 4.0000000 16.0000000 -4 16 -0.0200000 0.0004000 57.96508 1
294 47063 tgc689749 2015-03-21 1 English Premier 1823 Newcastle 2.7138053 0.6544322 Arsenal 142 1.0 2014 1 1505.609 1809.917 0.1478278 60 35 57 29 29 32.00000 56.00000 -14.0000000 26.0000000 11 3 4.9675000 15.065000 -22 484 0 0 -24.0000000 576.0000000 -40.0000000 1600.0000000 8 64 -10.0975000 101.9595063 57.96508 1
295 47064 tgc689750 2015-03-21 1 English Premier 2471 Southampton 2.7138053 0.6544322 Burnley 435 1.0 2014 1 1626.101 1408.079 0.7781699 60 50 25 29 29 40.00000 26.00000 19.0000000 -21.0000000 6 18 8.0025000 4.992500 25 625 0 0 14.0000000 196.0000000 40.0000000 1600.0000000 -12 144 3.0100000 9.0601000 57.96508 1
296 47065 tgc689751 2015-03-21 1 English Premier 2590 Tottenham 0.6928898 2.3531327 Leicester 1527 0.0 2014 1 1674.540 1379.963 0.8449749 60 50 19 29 28 46.00000 24.00000 4.0000000 -20.0000000 7 20 10.0225000 1.980000 31 961 1 1 22.0000000 484.0000000 24.0000000 576.0000000 -13 169 8.0425000 64.6818063 57.96508 1
297 47066 tgc689752 2015-03-21 1 English Premier 1718 Man City 2.7138053 0.6544322 West Brom 2744 1.0 2014 1 1623.188 1536.886 0.6217048 60 58 33 29 29 59.00000 27.00000 31.0000000 -9.0000000 2 13 10.0725000 11.032500 25 625 0 0 32.0000000 1024.0000000 40.0000000 1600.0000000 -11 121 -0.9600000 0.9216000 57.96508 1
298 47067 tgc689753 2015-03-21 1 English Premier 154 Aston Villa 1.0662417 1.0662417 Swansea 2513 0.5 2014 1 1521.122 1504.837 0.5234184 60 28 40 29 29 19.00000 33.00000 -19.0000000 -5.0000000 16 9 6.0200000 7.005000 -12 144 0 0 -14.0000000 196.0000000 -14.0000000 196.0000000 7 49 -0.9850000 0.9702250 57.96508 1
299 47068 tgc689754 2015-03-22 1 English Premier 1563 Liverpool 1.0662417 1.0662417 Man Utd 1724 0.5 2014 1 1806.928 1774.098 0.5471055 60 54 56 29 29 43.00000 50.00000 13.0000000 24.0000000 5 4 16.0600000 13.062500 -2 4 0 0 -7.0000000 49.0000000 -11.0000000 121.0000000 1 1 2.9975000 8.9850062 57.96508 1
300 47069 tgc689755 2015-03-21 1 English Premier 2802 West Ham 2.7138053 0.6544322 Sunderland 2493 1.0 2014 1 1442.016 1390.012 0.5742854 60 39 26 29 29 39.00000 23.00000 2.0000000 -20.0000000 10 17 2.9800000 2.965000 13 169 0 0 16.0000000 256.0000000 22.0000000 484.0000000 -7 49 0.0150000 0.0002250 57.96508 1
301 47070 tgc689756 2015-04-05 1 English Premier 435 Burnley 1.0662417 1.0662417 Tottenham 2590 0.5 2014 1 1408.079 1674.540 0.1774283 60 25 50 30 30 26.65443 46.69289 -23.0593731 2.3397571 18 7 3.9788392 7.005931 -25 625 0 0 -20.0384576 401.5397833 -25.3991302 645.1158140 11 121 -3.0270918 9.1632847 57.96508 1
302 47071 tgc689757 2015-04-04 1 English Premier 2744 West Brom 2.7138053 0.6544322 QPR 2093 1.0 2014 1 1536.886 1362.412 0.7319142 60 33 22 30 30 27.65443 30.69289 -11.0593731 -23.6602429 14 20 10.0188392 2.993431 11 121 0 0 -3.0384576 9.2322246 12.6008698 158.7819202 -6 36 7.0254082 49.3563604 57.96508 1
303 47072 tgc689758 2015-04-04 1 English Premier 536 Chelsea 1.0662417 1.0662417 Stoke 2477 0.5 2014 1 1817.706 1611.376 0.7663355 60 67 45 29 30 60.35313 35.71381 36.6602429 0.0593731 1 8 14.0441840 12.032081 22 484 -1 1 24.6393274 607.0964560 36.6008698 1339.6236715 -7 49 2.0121027 4.0485571 57.96508 1
304 47073 tgc689759 2015-04-04 1 English Premier 1527 Leicester 1.0662417 1.0662417 West Ham 2802 0.5 2014 1 1379.963 1442.016 0.4116360 60 22 42 29 30 26.35313 41.71381 -18.3397571 4.0593731 19 9 5.0016840 4.994581 -20 400 -1 1 -15.3606726 235.9502619 -22.3991302 501.7210329 10 100 0.0071027 0.0000504 57.96508 1
305 47074 tgc689760 2015-04-04 1 English Premier 942 Everton 1.0662417 1.0662417 Southampton 2471 0.5 2014 1 1469.315 1626.101 0.2885310 60 34 53 30 30 38.35313 42.71381 -3.3397571 21.0593731 12 6 7.0166840 8.012081 -19 361 0 0 -4.3606726 19.0154653 -24.3991302 595.3175536 6 36 -0.9953973 0.9908158 57.96508 1
306 47075 tgc689761 2015-04-06 1 English Premier 646 C Palace 2.7138053 0.6544322 Man City 1718 1.0 2014 1 1558.734 1623.188 0.4082936 60 33 61 30 30 34.65443 61.71381 -8.0593731 33.0593731 14 2 7.0213392 12.087081 -28 784 0 0 -27.0593731 732.2096701 -41.1187461 1690.7512815 12 144 -5.0657422 25.6617437 57.96508 1
307 47076 tgc689762 2015-04-04 1 English Premier 2513 Swansea 2.7138053 0.6544322 Hull 1310 1.0 2014 1 1504.837 1381.102 0.6709038 60 41 28 30 30 34.06624 26.69289 -5.0000000 -12.6602429 10 16 7.0051656 8.015931 13 169 0 0 7.3733519 54.3663180 7.6602429 58.6793209 -6 36 -1.0107654 1.0216467 57.96508 1
308 47077 tgc689763 2015-04-05 1 English Premier 2493 Sunderland 0.6928898 2.3531327 Newcastle 1823 0.0 2014 1 1390.012 1505.609 0.3395219 60 26 38 30 30 23.65443 34.71381 -22.0593731 -11.9406269 17 11 1.9538392 6.982081 -12 144 0 0 -11.0593731 122.3097323 -10.1187461 102.3890228 6 36 -5.0282422 25.2832193 57.96508 1
309 47078 tgc689764 2015-04-04 1 English Premier 142 Arsenal 1.0662417 1.0662417 Liverpool 1563 0.5 2014 1 1809.917 1806.928 0.5043015 60 57 55 30 30 56.65443 44.06624 23.9406269 13.0000000 3 5 15.0588392 16.062666 2 4 0 0 12.5881905 158.4625403 10.9406269 119.6973180 -2 4 -1.0038264 1.0076674 57.96508 1
310 47079 tgc689765 2015-04-04 1 English Premier 1724 Man Utd 2.7138053 0.6544322 Aston Villa 154 1.0 2014 1 1774.098 1521.122 0.8109586 60 57 29 30 30 51.06624 20.06624 24.0000000 -19.0000000 4 15 13.0626656 7.025166 28 784 0 0 31.0000000 961.0000000 43.0000000 1849.0000000 -11 121 6.0375000 36.4514062 57.96508 1
311 47080 tgc689766 2015-04-13 1 English Premier 1563 Liverpool 2.7138053 0.6544322 Newcastle 1823 1.0 2014 1 1806.928 1505.609 0.8499915 60 56 41 31 31 45.13248 37.06694 13.0000000 -10.2803841 6 11 14.0528312 8.993765 15 225 0 0 8.0655454 65.0530233 23.2803841 541.9762826 -5 25 5.0590658 25.5941466 57.96508 1
312 47081 tgc689767 2015-04-11 1 English Premier 2513 Swansea 1.0662417 1.0662417 Everton 942 0.5 2014 1 1504.837 1469.315 0.5509422 60 44 35 31 31 36.78005 39.41937 -2.9406269 -3.3397571 9 14 10.0322470 8.024350 9 81 0 0 -2.6393274 6.9660493 0.3991302 0.1593049 -5 25 2.0078973 4.0316517 57.96508 1
313 47082 tgc689768 2015-04-11 1 English Premier 2590 Tottenham 2.7138053 0.6544322 Aston Villa 154 1.0 2014 1 1674.540 1521.122 0.7074734 60 51 29 31 31 47.75913 20.72067 2.3397571 -21.0593731 7 15 8.0085966 7.026505 22 484 0 0 27.0384576 731.0781898 23.3991302 547.5192933 -8 64 0.9820918 0.9645043 57.96508 1
314 47083 tgc689769 2015-04-12 1 English Premier 2093 QPR 1.0662417 1.0662417 Chelsea 536 0.5 2014 1 1362.412 1817.706 0.0678063 60 22 68 31 30 31.34732 61.41937 -25.7196159 36.6602429 20 1 -0.0302298 12.036850 -46 2116 1 1 -30.0720524 904.3283333 -62.3798588 3891.2467837 19 361 -12.0670794 145.6144058 57.96508 1
315 47084 tgc689770 2015-04-11 1 English Premier 2471 Southampton 2.7138053 0.6544322 Hull 1310 1.0 2014 1 1626.101 1381.102 0.8038174 60 54 28 31 31 43.78005 27.34732 21.0593731 -14.7196159 6 16 8.0147470 4.992270 26 676 0 0 16.4327249 270.0344488 35.7789890 1280.1360524 -10 100 3.0224768 9.1353657 57.96508 1
316 47085 tgc689771 2015-04-11 1 English Premier 2802 West Ham 0.6928898 2.3531327 Stoke 2477 0.0 2014 1 1442.016 1611.376 0.2739023 60 43 46 31 31 42.78005 36.78005 4.0593731 0.0593731 10 8 4.9972470 13.047247 -3 9 0 0 6.0000000 36.0000000 4.0000000 16.0000000 2 4 -8.0500000 64.8025000 57.96508 1
317 47086 tgc689772 2015-04-11 1 English Premier 2744 West Brom 1.0662417 1.0662417 Leicester 1527 0.5 2014 1 1536.886 1379.963 0.7116321 60 36 23 31 30 30.36824 27.41937 -9.0000000 -18.3397571 13 19 10.0209206 6.009350 13 169 1 1 2.9488631 8.6957935 9.3397571 87.2310632 -6 36 4.0115709 16.0927014 57.96508 1
318 47087 tgc689773 2015-04-11 1 English Premier 2493 Sunderland 1.0662417 1.0662417 C Palace 646 0.5 2014 1 1390.012 1558.734 0.2746331 60 26 36 31 31 24.34732 37.36824 -23.7196159 -6.0000000 18 12 1.9572702 9.035921 -10 100 0 0 -13.0209154 169.5442390 -17.7196159 313.9847886 6 36 -7.0786504 50.1072910 57.96508 1
319 47088 tgc689774 2015-04-12 1 English Premier 1724 Man Utd 0.6928898 2.3531327 Man City 1718 0.0 2014 1 1774.098 1623.188 0.7044775 60 60 61 31 31 53.78005 62.36824 26.0593731 31.0000000 4 2 13.0622470 9.053421 -1 1 0 0 -8.5881905 73.7570162 -4.9406269 24.4097946 2 4 4.0088264 16.0706890 57.96508 1
320 47089 tgc689775 2015-04-11 1 English Premier 435 Burnley 0.6928898 2.3531327 Arsenal 142 0.0 2014 1 1408.079 1809.917 0.0900386 60 26 58 31 31 27.72067 57.72067 -23.0593731 23.9406269 17 4 4.9890048 13.051505 -32 1024 0 0 -30.0000000 900.0000000 -47.0000000 2209.0000000 13 169 -8.0625000 65.0039062 57.96508 1
321 47090 tgc689776 2015-04-18 1 English Premier 646 C Palace 2.7138053 0.6544322 West Brom 2744 1.0 2014 1 1558.734 1536.886 0.5314003 60 37 37 32 32 38.43448 31.43448 -6.0000000 -9.0000000 12 13 10.0410862 10.023586 0 0 0 0 7.0000000 49.0000000 3.0000000 9.0000000 -1 1 0.0175000 0.0003062 57.96508 1
322 47091 tgc689777 2015-04-18 1 English Premier 536 Chelsea 1.0662417 1.0662417 Man Utd 1724 0.5 2014 1 1817.706 1774.098 0.5624292 60 69 60 31 32 62.48562 54.47294 36.6602429 24.3991302 1 4 10.0320153 13.058178 9 81 -1 1 8.0126793 64.2030297 12.2611127 150.3348844 -3 9 -3.0261627 9.1576609 57.96508 1
323 47092 tgc689778 2015-04-18 1 English Premier 142 Arsenal 2.7138053 0.6544322 Sunderland 2493 1.0 2014 1 1809.917 1390.012 0.9181270 60 61 27 32 32 60.07381 25.41356 25.6008698 -23.7196159 3 17 13.0556889 1.959936 34 1156 0 0 34.6602429 1201.3324360 49.3204857 2432.5103141 -14 196 11.0957530 123.1157354 57.96508 1
324 47093 tgc689779 2015-04-18 1 English Premier 1527 Leicester 1.0662417 1.0662417 Swansea 2513 0.5 2014 1 1379.963 1504.837 0.3276500 60 24 45 31 32 28.48562 37.84629 -18.3397571 -2.9406269 19 9 7.0145153 8.024913 -21 441 -1 1 -9.3606726 87.6221910 -15.3991302 237.1332103 10 100 -1.0103973 1.0209028 57.96508 1
325 47094 tgc689781 2015-04-19 1 English Premier 1718 Man City 2.7138053 0.6544322 West Ham 2802 1.0 2014 1 1623.188 1442.016 0.7394108 60 64 43 32 32 64.72137 43.47294 32.6602429 2.3991302 2 10 9.0301046 3.985678 21 441 0 0 21.2484334 451.4959212 30.2611127 915.7349413 -8 64 5.0444266 25.4462402 57.96508 1
326 47095 tgc689782 2015-04-19 1 English Premier 1823 Newcastle 1.0662417 1.0662417 Tottenham 2590 0.5 2014 1 1505.609 1674.540 0.2743933 60 41 54 32 32 37.72137 50.47294 -12.3397571 4.3991302 11 7 9.0101046 10.020678 -13 169 0 0 -12.7515666 162.6024512 -16.7388873 280.1903484 4 16 -1.0105734 1.0212585 57.96508 1
327 47096 tgc689783 2015-04-18 1 English Premier 1310 Hull 0.6928898 2.3531327 Liverpool 1563 0.0 2014 1 1381.102 1806.928 0.0793471 60 28 59 32 32 28.00175 47.84629 -16.7789890 15.0593731 16 5 1.9736094 14.054913 -31 961 0 0 -19.8445344 393.8055465 -31.8383620 1013.6812970 11 121 -12.0813031 145.9578857 57.96508 1
328 47097 tgc689784 2015-04-18 1 English Premier 942 Everton 2.7138053 0.6544322 Burnley 435 1.0 2014 1 1469.315 1408.079 0.5872246 60 36 26 32 32 40.48562 28.41356 -3.3397571 -24.7196159 14 18 8.0220153 3.979936 10 100 0 0 12.0720524 145.7344482 21.3798588 457.0983622 -4 16 4.0420794 16.3384061 57.96508 1
329 47098 tgc689785 2015-04-18 1 English Premier 2477 Stoke 0.6928898 2.3531327 Southampton 2471 0.0 2014 1 1611.376 1626.101 0.4788214 60 49 57 32 32 39.13318 46.49385 1.7196159 23.1187461 8 6 13.0514310 11.041828 -8 64 0 0 -7.3606726 54.1795007 -21.3991302 457.9227725 2 4 2.0096027 4.0385029 57.96508 1
330 47099 tgc689786 2015-04-25 1 English Premier 2093 QPR 2.7138053 0.6544322 West Ham 2802 1.0 2014 1 1362.412 1442.016 0.3874037 60 23 43 32 33 32.41356 44.12737 -25.7196159 0.3397571 20 10 0.9749358 3.984517 -20 400 -1 1 -11.7138053 137.2132340 -26.0593731 679.0909240 10 100 -3.0095814 9.0575801 57.96508 1
331 47100 tgc689787 2015-04-25 1 English Premier 1718 Man City 0.6928898 2.3531327 Aston Villa 154 0.0 2014 1 1623.188 1521.122 0.6428003 60 67 29 33 32 67.43518 21.37511 34.7196159 -23.1187461 2 15 12.0496860 7.020344 38 1444 1 1 46.0600693 2121.5299855 57.8383620 3345.2761227 -13 169 5.0293420 25.2942808 57.96508 1
332 47101 tgc689788 2015-04-26 1 English Premier 942 Everton 1.0662417 1.0662417 Man Utd 1724 0.5 2014 1 1469.315 1774.098 0.1474841 60 39 61 33 33 43.19942 55.53918 -1.2803841 24.3991302 14 5 11.0490966 11.045844 -22 484 0 0 -12.3397571 152.2696060 -25.6795143 659.4374524 9 81 0.0032530 0.0000106 57.96508 1
333 47102 tgc689789 2015-04-25 1 English Premier 2477 Stoke 1.0662417 1.0662417 Sunderland 2493 0.5 2014 1 1611.376 1390.012 0.7814728 60 49 27 33 33 39.82607 26.06800 0.0593731 -25.7789890 8 17 10.0373620 1.961275 22 484 0 0 13.7580735 189.2845874 25.8383620 667.6209526 -9 81 8.0760870 65.2231811 57.96508 1
334 47103 tgc689790 2015-04-26 1 English Premier 142 Arsenal 1.0662417 1.0662417 Chelsea 536 0.5 2014 1 1809.917 1817.706 0.4887924 60 64 70 33 32 62.78761 63.55186 27.6602429 36.6602429 3 1 13.0577702 10.032181 -6 36 1 1 -0.7642459 0.5840718 -9.0000000 81.0000000 2 4 3.0255894 9.1541911 57.96508 1
335 47104 tgc689791 2015-04-25 1 English Premier 435 Burnley 2.7138053 0.6544322 Leicester 1527 1.0 2014 1 1408.079 1379.963 0.5403746 60 26 25 33 32 29.06800 29.55186 -26.7789890 -18.3397571 18 19 3.9762750 7.012181 1 1 1 1 -0.4838619 0.2341223 -8.4392319 71.2206343 -1 1 -3.0359058 9.2167241 57.96508 1
336 47105 tgc689792 2015-04-25 1 English Premier 2471 Southampton 0.6928898 2.3531327 Tottenham 2590 0.0 2014 1 1626.101 1674.540 0.4307392 60 60 55 33 33 48.84698 51.53918 24.7789890 4.3991302 6 7 14.0610124 8.010844 5 25 0 0 -2.6921936 7.2479062 20.3798588 415.3386446 -1 1 6.0501688 36.6045426 57.96508 1
337 47106 tgc689793 2015-04-25 1 English Premier 1823 Newcastle 2.7138053 0.6544322 Swansea 2513 1.0 2014 1 1505.609 1504.837 0.5011103 60 42 46 33 33 38.78761 38.91253 -12.3397571 -2.9406269 11 9 7.0052702 6.020078 -4 16 0 0 -0.1249185 0.0156046 -9.3991302 88.3436482 2 4 0.9851921 0.9706034 57.96508 1
338 47107 tgc689794 2015-04-25 1 English Premier 646 C Palace 2.7138053 0.6544322 Hull 1310 1.0 2014 1 1558.734 1381.102 0.7354657 60 40 28 33 33 41.14828 28.69464 -3.9406269 -18.4392319 12 16 10.0406676 1.972041 12 144 0 0 12.4536404 155.0931587 14.4986049 210.2095442 -4 16 8.0686271 65.1027437 57.96508 1
339 47108 tgc689795 2015-04-25 1 English Premier 2744 West Brom 2.7138053 0.6544322 Liverpool 1563 1.0 2014 1 1536.886 1806.928 0.1744395 60 37 62 33 33 32.08891 50.19942 -11.0593731 16.7196159 14 4 7.0074254 14.059097 -25 625 0 0 -18.1105100 327.9905714 -27.7789890 771.6722287 10 100 -7.0516712 49.7260670 57.96508 1
340 47109 tgc689796 2015-05-02 1 English Premier 2802 West Ham 2.7138053 0.6544322 Burnley 435 1.0 2014 1 1442.016 1408.079 0.5486841 60 43 29 34 34 44.78180 31.78180 -1.7196159 -24.7196159 11 16 3.9808564 7.003356 14 196 0 0 13.0000000 169.0000000 23.0000000 529.0000000 -5 25 -3.0225000 9.1355062 57.96508 1
341 47110 tgc689797 2015-05-02 1 English Premier 1724 Man Utd 0.6928898 2.3531327 West Brom 2744 0.0 2014 1 1774.098 1536.886 0.7966525 60 62 40 34 34 56.60542 34.80272 24.3991302 -9.0000000 4 14 9.0410092 10.027007 22 484 0 0 21.8027035 475.3578814 33.3991302 1115.5018969 -10 100 -0.9859976 0.9721912 57.96508 1
342 47111 tgc689798 2015-05-02 1 English Premier 1527 Leicester 1.0662417 1.0662417 Newcastle 1823 0.5 2014 1 1379.963 1505.609 0.3266724 60 26 45 34 34 31.27253 41.50142 -20.3991302 -10.2803841 19 10 7.0161857 10.027352 -19 361 0 0 -10.2288854 104.6300969 -10.1187461 102.3890228 9 81 -3.0111659 9.0671203 57.96508 1
343 47112 tgc689799 2015-05-02 1 English Premier 2590 Tottenham 2.7138053 0.6544322 Man City 1718 1.0 2014 1 1674.540 1623.188 0.5733679 60 58 67 34 34 53.89231 68.12807 6.0593731 33.0593731 7 2 8.0150276 9.028117 -9 81 0 0 -14.2357541 202.6566941 -27.0000000 729.0000000 5 25 -1.0130894 1.0263501 57.96508 1
344 47113 tgc689800 2015-05-02 1 English Premier 1310 Hull 0.6928898 2.3531327 Arsenal 142 0.0 2014 1 1381.102 1809.917 0.0780992 60 28 65 34 34 29.34908 63.85385 -20.4986049 27.6602429 17 3 0.9608797 11.050436 -37 1369 0 0 -34.5047773 1190.5796563 -48.1588478 2319.2746193 14 196 -10.0895562 101.7991440 57.96508 1
345 47114 tgc689801 2015-05-02 1 English Premier 1563 Liverpool 2.7138053 0.6544322 QPR 2093 1.0 2014 1 1806.928 1362.412 0.9281652 60 62 26 34 33 50.85385 35.12737 14.6602429 -23.6602429 5 20 11.0354358 3.994517 36 1296 1 1 15.7264846 247.3223173 38.3204857 1468.4596277 -15 225 7.0409186 49.5745353 57.96508 1
346 47115 tgc689802 2015-05-02 1 English Premier 2513 Swansea 2.7138053 0.6544322 Stoke 2477 1.0 2014 1 1504.837 1611.376 0.3513100 60 46 50 34 34 39.56696 40.89231 -5.0000000 0.0593731 9 8 6.0114174 8.025028 -4 16 0 0 -1.3253486 1.7565489 -5.0593731 25.5972557 1 1 -2.0136102 4.0546262 57.96508 1
347 47116 tgc689803 2015-05-02 1 English Premier 154 Aston Villa 2.7138053 0.6544322 Everton 942 1.0 2014 1 1521.122 1469.315 0.5740075 60 32 40 33 34 23.72824 44.26566 -21.4585032 -1.2803841 15 13 10.0395281 12.061762 -8 64 -1 1 -20.5374243 421.7857949 -20.1781192 407.1564929 2 4 -2.0222342 4.0894310 57.96508 1
348 47117 tgc689804 2015-05-02 1 English Premier 2493 Sunderland 1.0662417 1.0662417 Southampton 2471 0.5 2014 1 1390.012 1626.101 0.2043972 60 28 60 34 34 27.13424 49.53987 -25.7789890 23.1187461 18 6 1.9614406 11.046943 -32 1024 0 0 -22.4056371 502.0125738 -48.8977351 2390.9884967 12 144 -9.0855028 82.5463606 57.96508 1
349 47118 tgc689805 2015-05-02 1 English Premier 536 Chelsea 2.7138053 0.6544322 C Palace 646 1.0 2014 1 1817.706 1558.734 0.8161926 60 72 43 34 34 65.68434 43.86209 36.6602429 -1.8812539 1 12 8.0275121 13.062749 29 841 0 0 21.8222515 476.2106604 38.5414968 1485.4469729 -11 121 -5.0352369 25.3536105 57.96508 1
350 47119 tgc689806 2015-05-09 1 English Premier 646 C Palace 0.6928898 2.3531327 Man Utd 1724 0.0 2014 1 1558.734 1774.098 0.2244820 60 43 62 35 35 44.51652 57.29831 -3.9406269 22.7388873 12 5 10.0365882 6.011940 -19 361 0 0 -12.7817881 163.3741067 -26.6795143 711.7964809 7 49 4.0246480 16.1977912 57.96508 1
351 47120 tgc689807 2015-05-09 1 English Premier 536 Chelsea 2.7138053 0.6544322 Liverpool 1563 1.0 2014 1 1817.706 1806.928 0.5155061 60 75 65 35 35 68.39815 53.56766 38.7196159 16.7196159 1 4 8.0304094 11.045017 10 100 0 0 14.8304876 219.9433635 22.0000000 484.0000000 -3 9 -3.0146078 9.0878604 57.96508 1
352 47121 tgc689808 2015-05-09 1 English Premier 154 Aston Villa 2.7138053 0.6544322 West Ham 2802 1.0 2014 1 1521.122 1442.016 0.6119151 60 35 46 34 35 26.44204 47.49561 -19.3991302 0.3397571 15 10 10.0466095 7.012938 -11 121 -1 1 -21.0535624 443.2524898 -19.7388873 389.6236722 5 25 3.0336717 9.2031637 57.96508 1
353 47122 tgc689809 2015-05-09 1 English Premier 1310 Hull 2.7138053 0.6544322 Burnley 435 1.0 2014 1 1381.102 1408.079 0.4612545 60 28 29 35 35 30.04197 32.43623 -22.1588478 -26.7789890 18 16 -0.0456893 3.987196 -1 1 0 0 -2.3942673 5.7325160 4.6201412 21.3457047 2 4 -4.0328850 16.2641611 57.96508 1
354 47123 tgc689810 2015-05-09 1 English Premier 942 Everton 1.0662417 1.0662417 Sunderland 2493 0.5 2014 1 1469.315 1390.012 0.6121849 60 40 29 35 35 44.92010 28.20048 -3.3397571 -25.7789890 14 17 9.0306015 2.984106 11 121 0 0 16.7196159 279.5455567 22.4392319 503.5191261 -3 9 6.0464952 36.5601042 57.96508 1
355 47124 tgc689811 2015-05-09 1 English Premier 142 Arsenal 2.7138053 0.6544322 Swansea 2513 1.0 2014 1 1809.917 1504.837 0.8527308 60 68 49 35 35 66.20699 42.28077 29.3204857 -2.9406269 2 9 11.0421199 9.033499 19 361 0 0 23.9262184 572.4639278 32.2611127 1040.7793920 -7 49 2.0086211 4.0345588 57.96508 1
356 47125 tgc689812 2015-05-09 1 English Premier 1823 Newcastle 2.7138053 0.6544322 West Brom 2744 1.0 2014 1 1505.609 1536.886 0.4551088 60 46 43 35 35 42.56766 37.15585 -10.2803841 -7.3397571 11 13 11.0450172 10.033691 3 9 0 0 5.4118095 29.2876820 -2.9406269 8.6472868 -2 4 1.0113264 1.0227811 57.96508 1
357 47126 tgc689813 2015-05-09 1 English Premier 2477 Stoke 2.7138053 0.6544322 Tottenham 2590 1.0 2014 1 1611.376 1674.540 0.4100881 60 50 61 35 35 41.54674 56.60612 -2.0000000 8.1187461 8 7 8.0213669 11.047109 -11 121 0 0 -15.0593731 226.7847168 -10.1187461 102.3890228 1 1 -3.0257422 9.1551156 57.96508 1
358 47127 tgc689814 2015-05-09 1 English Premier 1527 Leicester 1.0662417 1.0662417 Southampton 2471 0.5 2014 1 1379.963 1626.101 0.1951505 60 27 61 35 35 32.33877 50.60612 -20.3991302 23.1187461 19 6 5.0046672 11.047109 -34 1156 0 0 -18.2673430 333.6958213 -43.5178763 1893.8055567 13 169 -6.0424418 36.5111027 57.96508 1
359 47128 tgc689815 2015-05-09 1 English Premier 1718 Man City 2.7138053 0.6544322 QPR 2093 1.0 2014 1 1623.188 1362.412 0.8177455 60 67 26 35 34 68.78250 35.78180 31.0000000 -25.7196159 3 20 9.0244562 3.988356 41 1681 1 1 33.0006963 1089.0459539 56.7196159 3217.1148308 -17 289 5.0360998 25.3623014 57.96508 1
360 47129 tgc689816 2015-05-16 1 English Premier 2802 West Ham NA NA Everton 942 NA 2014 1 1418.731 1462.584 0.4372227 60 46 41 36 36 48.15004 45.98634 -1.7196159 -3.3397571 11 14 3.9871956 7.019083 5 25 0 0 2.1637017 4.6816051 1.6201412 2.6248575 -3 9 -3.0318874 9.1923410 57.96508 1
361 47130 tgc689817 2015-05-16 1 English Premier 2493 Sunderland NA NA Leicester 1527 NA 2014 1 1396.743 1398.254 0.4978263 60 30 28 36 36 29.26672 33.40502 -25.7789890 -20.3991302 17 19 3.9954326 5.004667 2 4 0 0 -4.1382941 17.1254778 -5.3798588 28.9428807 -2 4 -1.0092346 1.0185545 57.96508 1
362 47131 tgc689818 2015-05-16 1 English Premier 1563 Liverpool NA NA C Palace 646 NA 2014 1 1777.858 1545.265 0.7923111 60 65 43 36 36 54.22209 45.20941 14.6602429 -5.6008698 5 12 10.0336908 10.038680 22 484 0 0 9.0126793 81.2283883 20.2611127 410.5126875 -7 49 -0.0049891 0.0000249 57.96508 1
363 47132 tgc689819 2015-05-16 1 English Premier 1724 Man Utd NA NA Arsenal 142 NA 2014 1 1787.567 1818.753 0.4552400 60 65 71 36 36 59.65144 68.92079 24.3991302 31.3798588 4 2 8.0234587 14.067862 -6 36 0 0 -9.2693488 85.9208277 -6.9807286 48.7305720 2 4 -6.0444034 36.5348125 57.96508 1
364 47133 tgc689820 2015-05-16 1 English Premier 435 Burnley NA NA Stoke 2477 NA 2014 1 1375.755 1646.770 0.1736334 60 29 53 36 36 33.09067 44.26055 -28.8383620 0.0593731 18 8 3.9871956 8.021367 -24 576 0 0 -11.1698830 124.7662868 -28.8977351 835.0790932 10 100 -4.0341712 16.2745374 57.96508 1
365 47134 tgc689821 2015-05-16 1 English Premier 2744 West Brom NA NA Chelsea 536 NA 2014 1 1504.193 1846.776 0.1221672 60 43 78 36 36 37.81028 71.11195 -9.3991302 40.7789890 13 1 10.0336908 10.044825 -35 1225 0 0 -33.3016702 1109.0012367 -50.1781192 2517.8436426 12 144 -0.0111343 0.0001240 57.96508 1
366 47135 tgc689822 2015-05-16 1 English Premier 2590 Tottenham NA NA Hull 1310 NA 2014 1 1639.145 1413.427 0.7857235 60 61 31 36 36 57.26055 32.75577 6.0593731 -20.0994747 7 16 11.0450172 2.977961 30 900 0 0 24.5047773 600.4841104 26.1588478 684.2853171 -9 81 8.0670562 65.0773954 57.96508 1
367 47136 tgc689823 2015-05-16 1 English Premier 2513 Swansea NA NA Man City 1718 NA 2014 1 1496.001 1634.123 0.3110758 60 49 70 36 36 42.93520 71.49630 -5.0000000 33.0593731 9 3 8.0221724 9.024456 -21 441 0 0 -28.5611027 815.7365859 -38.0593731 1448.5158772 6 36 -1.0022838 1.0045729 57.96508 1
368 47137 tgc689824 2015-05-16 1 English Premier 2471 Southampton NA NA Aston Villa 154 NA 2014 1 1607.810 1544.407 0.5902448 60 62 38 36 35 51.67236 29.15585 23.1187461 -17.3397571 6 15 9.0326932 10.033691 24 576 1 1 22.5165088 506.9931689 40.4585032 1636.8904840 -9 81 -1.0009976 1.0019962 57.96508 1
369 47138 tgc689825 2015-05-16 1 English Premier 2093 QPR NA NA Newcastle 1823 NA 2014 1 1351.476 1538.302 0.2543673 60 26 49 35 36 36.43623 45.28146 -27.7789890 -8.2210110 20 10 3.9871956 11.045017 -23 529 -1 1 -8.8452307 78.2381059 -19.5579780 382.5145019 10 100 -7.0578216 49.8128456 57.96508 1
370 47139 tgc689826 2015-05-24 1 English Premier 1310 Hull NA NA Man Utd 1724 NA 2014 1 1413.427 1787.567 0.1039836 60 31 65 37 37 32.75577 59.65144 -20.0994747 24.3991302 16 4 2.9866218 5.006377 -34 1156 0 0 -26.8956713 723.3771369 -44.4986049 1980.1258386 12 144 -2.0197554 4.0794121 57.96508 1
371 47140 tgc689827 2015-05-24 1 English Premier 536 Chelsea NA NA Sunderland 2493 NA 2014 1 1846.776 1396.743 0.9302538 60 78 30 37 37 71.11195 29.26672 40.7789890 -25.7789890 1 17 9.0421596 4.002002 48 2304 0 0 41.8452307 1751.0233314 66.5579780 4429.9644301 -16 256 5.0401579 25.4031920 57.96508 1
372 47141 tgc689828 2015-05-24 1 English Premier 1527 Leicester NA NA QPR 2093 NA 2014 1 1398.254 1351.476 0.5669142 60 28 26 37 36 33.40502 36.43623 -20.3991302 -27.7789890 19 20 4.0020016 3.993765 2 4 1 1 -3.0312183 9.1882843 7.3798588 54.4623159 -1 1 0.0082370 0.0000678 57.96508 1
373 47142 tgc689829 2015-05-24 1 English Premier 1823 Newcastle NA NA West Ham 2802 NA 2014 1 1538.302 1418.731 0.6655901 60 49 46 37 37 45.28146 48.15004 -8.2210110 -1.7196159 10 11 8.0308332 2.984530 3 9 0 0 -2.8685746 8.2287201 -6.5013951 42.2681382 -1 1 5.0463031 25.4651754 57.96508 1
374 47143 tgc689830 2015-05-24 1 English Premier 1718 Man City NA NA Southampton 2471 NA 2014 1 1634.123 1607.810 0.5377953 60 70 62 37 37 71.49630 51.67236 33.0593731 23.1187461 3 6 9.0331170 8.030028 8 64 0 0 19.8239446 392.9887789 9.9406269 98.8160641 -3 9 1.0030894 1.0061883 57.96508 1
375 47144 tgc689831 2015-05-24 1 English Premier 142 Arsenal NA NA West Brom 2744 NA 2014 1 1818.753 1504.193 0.8594531 60 71 43 37 37 68.92079 37.81028 31.3798588 -9.3991302 2 13 13.0651965 7.016610 28 784 0 0 31.1105100 967.8638306 40.7789890 1662.9259422 -11 121 6.0485870 36.5854046 57.96508 1
376 47145 tgc689832 2015-05-24 1 English Premier 942 Everton NA NA Tottenham 2590 NA 2014 1 1462.584 1639.145 0.2657362 60 41 61 37 37 45.98634 57.26055 -3.3397571 6.0593731 14 7 6.0164174 10.042352 -20 400 0 0 -11.2742117 127.1078491 -9.3991302 88.3436482 7 49 -4.0259342 16.2081463 57.96508 1
377 47146 tgc689833 2015-05-24 1 English Premier 154 Aston Villa NA NA Burnley 435 NA 2014 1 1544.407 1375.755 0.7252870 60 38 29 36 37 29.15585 33.09067 -17.3397571 -28.8383620 15 18 9.0310252 2.984530 9 81 -1 1 -3.9348163 15.4827793 11.4986049 132.2179148 -3 9 6.0464952 36.5601042 57.96508 1
378 47147 tgc689834 2015-05-24 1 English Premier 646 C Palace NA NA Swansea 2513 NA 2014 1 1545.265 1496.001 0.5704259 60 43 49 37 37 45.20941 42.93520 -5.6008698 -5.0000000 12 9 7.0215986 5.005091 -6 36 0 0 2.2742117 5.1720388 -0.6008698 0.3610445 3 9 2.0165076 4.0663028 57.96508 1
379 47148 tgc689835 2015-05-24 1 English Premier 2477 Stoke NA NA Liverpool 1563 NA 2014 1 1646.770 1777.858 0.3198192 60 53 65 37 37 44.26055 54.22209 0.0593731 14.6602429 8 5 7.0187013 9.031025 -12 144 0 0 -9.9615424 99.2323268 -14.6008698 213.1853995 3 9 -2.0123240 4.0494478 57.96508 1