Baselight

Football Database

Football and Betting Statistics of the European Top5 Leagues

@kaggle.technika148_football_database

Teamstats
@kaggle.technika148_football_database.teamstats

  • 653.71 KB
  • 25360 rows
  • 16 columns
gameid

GameID

teamid

TeamID

season

Season

date

Date

location

Location

goals

Goals

xgoals

XGoals

shots

Shots

shotsontarget

ShotsOnTarget

deep

Deep

ppda

Ppda

fouls

Fouls

corners

Corners

yellowcards

YellowCards

redcards

RedCards

result

Result

81892015Sat Aug 08 2015 15:45:00 GMT+0000 (Coordinated Universal Time)h10.62753991413.82611212W
81822015Sat Aug 08 2015 15:45:00 GMT+0000 (Coordinated Universal Time)a0.674694108.21881223L
82732015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)h0.876106112116.91363L
82712015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)a10.78225373211.84621334W
83722015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)h20.60422610556.65781D
83902015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)a20.557892115417.15791322D
84752015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)h42.56803198510.881362W
84772015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)a21.4594611569.55561734L
85792015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)h11.1307617655.73681411L
85782015Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)a32.109751171010.625204W

CREATE TABLE teamstats (
  "gameid" BIGINT,
  "teamid" BIGINT,
  "season" BIGINT,
  "date" TIMESTAMP,
  "location" VARCHAR,
  "goals" BIGINT,
  "xgoals" DOUBLE,
  "shots" BIGINT,
  "shotsontarget" BIGINT,
  "deep" BIGINT,
  "ppda" DOUBLE,
  "fouls" BIGINT,
  "corners" BIGINT,
  "yellowcards" DOUBLE,
  "redcards" BIGINT,
  "result" VARCHAR
);

Share link

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