Football Database

Football and Betting Statistics of the European Top5 Leagues

@kaggle.technika148_football_database

Table List

6 tables(15.71 MB)

Appearances

Games

Leagues

Shots

Teams

Teamstats

Appearances

@kaggle.technika148_football_database.appearances

9.43 MB
356513 rows
19 columns

gameid GameID	playerid PlayerID	shots Shots	xgoals XGoals	xgoalschain XGoalsChain	xgoalsbuildup XGoalsBuildup	keypasses KeyPasses	xassists XAssists	position Position	positionorder PositionOrder	yellowcard YellowCard	time Time	substitutein SubstituteIn	leagueid LeagueID
81	560							GK	1		90		1
81	557			0.106513060629368	0.106513060629368	1	0.106513060629368	DR	2		82	222605	1
81	548			0.127737730741501	0.127737730741501			DC	3		90		1
81	628			0.106513060629368	0.106513060629368			DC	3		90		1
81	1006			0.0212246645241976	0.0212246645241976			DL	4		90		1
81	551			0.163669869303703	0.163669869303703			DMC	7		90		1
81	654			0.0357420146465302		1	0.0357420146465302	DMC	7		61	222606	1
81	554	3	0.253644913434982	0.255811274051666	0.106513060629368			AMR	11	1	90		1
81	555	3	0.121308878064156	0.0569666810333729				AMC	12		69	222607	1
81	631	1	0.103004261851311	0.124228924512863	0.0212246645241976	1	0.064342200756073	AML	13		90		1


CREATE TABLE appearances (
  "gameid" BIGINT,
  "playerid" BIGINT,
  "goals" BIGINT,
  "owngoals" BIGINT,
  "shots" BIGINT,
  "xgoals" DOUBLE,
  "xgoalschain" DOUBLE,
  "xgoalsbuildup" DOUBLE,
  "assists" BIGINT,
  "keypasses" BIGINT,
  "xassists" DOUBLE,
  "position" VARCHAR,
  "positionorder" BIGINT,
  "yellowcard" BIGINT,
  "redcard" BIGINT,
  "time" BIGINT,
  "substitutein" BIGINT,
  "substituteout" BIGINT,
  "leagueid" BIGINT
);