Baselight

Premier League Detailed Team Data

Premier League Detailed Team Data of season 17/18, 18/19 and 19/20

@kaggle.aditya2803_premier_league_team_data

Possession Stats
@kaggle.aditya2803_premier_league_team_data.possession_stats

  • 133.89 KB
  • 2280 rows
  • 32 columns
unnamed_0

Unnamed: 0

date

Date

time

Time

round

Round

day

Day

venue

Venue

result

Result

gf

GF

ga

GA

opponent

Opponent

touches

Touches

def_pen

Def Pen

def_3rd

Def 3rd

mid_3rd

Mid 3rd

att_3rd

Att 3rd

att_pen

Att Pen

live

Live

succ

Succ

att

Att

succ_c8ffb4

Succ%

n__pl

#Pl

megs

Megs

carries

Carries

totdist

TotDist

prgdist

PrgDist

targ

Targ

rec

Rec

rec_04e8c8

Rec%

miscon

Miscon

dispos

Dispos

match_report

Match Report

team

Team

Sun Aug 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)16:00 (20:30)Matchweek 1SunHomeL2Manchester City52195236204109164904580413602289115437531985.164Match ReportArsenal
1Sat Aug 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)17:30 (22:00)Matchweek 2SatAwayL23Chelsea547872392201182251571163.682380201495639635188.61110Match ReportArsenal
2Sat Aug 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15:00 (19:30)Matchweek 3SatHomeW31West Ham686651983422002565291464.395122976170053847387.9114Match ReportArsenal
3Sun Sep 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)13:30 (18:00)Matchweek 4SunAwayW32Cardiff City765622113632274172381457.185832305106463454686.11510Match ReportArsenal
4Sat Sep 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15:00 (19:30)Matchweek 5SatAwayW21Newcastle Utd747822453651772571091369.295262955135561753386.4138Match ReportArsenal
5Sun Sep 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)16:00 (20:30)Matchweek 6SunHomeW2Everton730702353391882967661346.2615072450121558250586.82010Match ReportArsenal
6Sat Sep 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)15:00 (19:30)Matchweek 7SatHomeW2Watford697822323081962564371258.384922498124754146786.3914Match ReportArsenal
7Sun Oct 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)12:00 (16:30)Matchweek 8SunAwayW51Fulham654802593071243160681457.1824202241133551643183.51010Match ReportArsenal
8Mon Oct 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)20:00 (00:30)Matchweek 9MonHomeW31Leicester City8537325143922830810131586.7136873564192769263291.3715Match ReportArsenal
9Sun Oct 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)13:30 (19:00)Matchweek 10SunAwayD22Crystal Palace72079231404129146769185094922711149654148890.21510Match ReportArsenal

CREATE TABLE possession_stats (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "touches" BIGINT,
  "def_pen" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "att_pen" BIGINT,
  "live" BIGINT,
  "succ" BIGINT,
  "att" BIGINT,
  "succ_c8ffb4" DOUBLE,
  "n__pl" BIGINT,
  "megs" BIGINT,
  "carries" BIGINT,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "targ" BIGINT,
  "rec" BIGINT,
  "rec_04e8c8" DOUBLE,
  "miscon" BIGINT,
  "dispos" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Share link

Anyone who has the link will be able to view this.