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

Defensive Actions
@kaggle.aditya2803_premier_league_team_data.defensive_actions

  • 95.85 KB
  • 2280 rows
  • 34 columns
unnamed_0

Unnamed: 0

date

Date

time

Time

round

Round

day

Day

venue

Venue

result

Result

gf

GF

ga

GA

opponent

Opponent

tkl

Tkl

tklw

TklW

def_3rd

Def 3rd

mid_3rd

Mid 3rd

att_3rd

Att 3rd

tkl_1

Tkl.1

att

Att

tkl_6c6d02

Tkl%

past

Past

press

Press

succ

Succ

n

%

def_3rd_1

Def 3rd.1

mid_3rd_1

Mid 3rd.1

att_3rd_1

Att 3rd.1

blocks

Blocks

sh

Sh

shsv

ShSv

pass

Pass

int

Int

clr

Clr

err

Err

match_report

Match Report

team

Team

Sun Aug 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)14:00 (18:30)Matchweek 1SunAwayW1Newcastle Utd24121012283026.72247412626.613224696184141270Match ReportArsenal
1Sat Aug 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)12:30 (17:00)Matchweek 2SatHomeW21Burnley26161212282236.4141524630.37254262882022802Match ReportArsenal
2Sat Aug 24 2019 00:00:00 GMT+0000 (Coordinated Universal Time)17:30 (22:00)Matchweek 3SatAwayL13Liverpool38263242103826.32843012027.92581106258302814662Match ReportArsenal
3Sun Sep 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)16:30 (21:00)Matchweek 4SunHomeD22Tottenham4224141810123633.3243129630.892110110284242026Match ReportArsenal
4Sun Sep 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)16:30 (21:00)Matchweek 5SunAwayD22Watford22181210165429.6383746216.6194138422412121830Match ReportArsenal
5Sun Sep 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time)16:30 (21:00)Matchweek 6SunHomeW32Aston Villa3626181262306.7282427229.87698686421434Match ReportArsenal
6Mon Sep 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)20:00 (00:30)Matchweek 7MonAwayD11Manchester Utd362218126183847.4203308224.8100174565614421240Match ReportArsenal
7Sun Oct 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)14:00 (18:30)Matchweek 8SunHomeW1Bournemouth422618204164833.33239412431.5110172112302281068Match ReportArsenal
8Mon Oct 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)20:00 (00:30)Matchweek 9MonAwayL1Sheffield Utd34182410102050101906031.6668440302281044Match ReportArsenal
9Sun Oct 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)16:30 (22:00)Matchweek 10SunHomeD22Crystal Palace382820144184242.9243488424.1126162602410141274Match ReportArsenal

CREATE TABLE defensive_actions (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "tkl" BIGINT,
  "tklw" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "tkl_1" BIGINT,
  "att" BIGINT,
  "tkl_6c6d02" DOUBLE,
  "past" BIGINT,
  "press" BIGINT,
  "succ" BIGINT,
  "n" DOUBLE,
  "def_3rd_1" BIGINT,
  "mid_3rd_1" BIGINT,
  "att_3rd_1" BIGINT,
  "blocks" BIGINT,
  "sh" BIGINT,
  "shsv" BIGINT,
  "pass" BIGINT,
  "int" BIGINT,
  "clr" BIGINT,
  "err" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Share link

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