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

Shots

@kaggle.technika148_football_database.shots

4.99 MB
324543 rows
11 columns

gameid GameID	shooterid ShooterID	assisterid AssisterID	minute Minute	situation Situation	lastaction LastAction	shottype ShotType	shotresult ShotResult	xgoal XGoal	positionx PositionX	positiony PositionY
81	554		27	DirectFreekick	Standard	LeftFoot	BlockedShot	0.104346722364426	0.794000015258789	0.420999984741211
81	555	631	27	SetPiece	Pass	RightFoot	BlockedShot	0.064342200756073	0.86	0.627000007629395
81	554	629	35	OpenPlay	Pass	LeftFoot	BlockedShot	0.0571568161249161	0.843000030517578	0.332999992370605
81	554		35	OpenPlay	Tackle	LeftFoot	MissedShots	0.0921413898468018	0.848000030517578	0.532999992370605
81	555	654	40	OpenPlay	BallRecovery	RightFoot	BlockedShot	0.0357420146465302	0.811999969482422	0.706999969482422
81	555	629	49	OpenPlay	Pass	LeftFoot	MissedShots	0.0212246645241976	0.725	0.545
81	631		64	OpenPlay	nan	RightFoot	SavedShot	0.103004261851311	0.895999984741211	0.597000007629395
81	629	557	72	OpenPlay	Cross	RightFoot	MissedShots	0.106513060629368	0.89	0.534000015258789
81	629		76	DirectFreekick	Standard	RightFoot	MissedShots	0.0430676527321339	0.746999969482422	0.694000015258789
81	646	647	4	OpenPlay	Chipped	LeftFoot	MissedShots	0.297303676605225	0.901999969482422	0.61


CREATE TABLE shots (
  "gameid" BIGINT,
  "shooterid" BIGINT,
  "assisterid" DOUBLE,
  "minute" BIGINT,
  "situation" VARCHAR,
  "lastaction" VARCHAR,
  "shottype" VARCHAR,
  "shotresult" VARCHAR,
  "xgoal" DOUBLE,
  "positionx" DOUBLE,
  "positiony" DOUBLE
);