Comprehensive Football Dataset

Detailed dataset for football events and Europe's top 5 leagues

@kaggle.prathamsharma123_comprehensive_football_dataset

Table List

7 tables(28.73 MB)

Bundesliga Points

Events

Ginf

Events

@kaggle.prathamsharma123_comprehensive_football_dataset.events

28.23 MB
941009 rows
22 columns

id_odsp Id Odsp	id_event Id Event	sort_order Sort Order	time Time	text Text	event_type Event Type	event_type2 Event Type2	side Side	event_team Event Team	opponent Opponent	player Player	player2 Player2	player_in Player In	player_out Player Out	shot_place Shot Place	shot_outcome Shot Outcome	location Location	bodypart Bodypart	assist_method Assist Method	situation Situation
UFot0hit/	UFot0hit1	1	2	Attempt missed. Mladen Petric (Hamburg) left footed shot from the left side of the box is high and wide to the left. Assisted by Gokhan Tore.	1	12	2	Hamburg SV	Borussia Dortmund	mladen petric	gokhan tore	nan	nan	6	2	9	2	1	1
UFot0hit/	UFot0hit2	2	4	Corner, Borussia Dortmund. Conceded by Dennis Diekmeier.	2		1	Borussia Dortmund	Hamburg SV	dennis diekmeier	dennis diekmeier	nan	nan
UFot0hit/	UFot0hit3	3	4	Corner, Borussia Dortmund. Conceded by Heiko Westermann.	2		1	Borussia Dortmund	Hamburg SV	heiko westermann	heiko westermann	nan	nan
UFot0hit/	UFot0hit4	4	7	Foul by Sven Bender (Borussia Dortmund).	3		1	Borussia Dortmund	Hamburg SV	sven bender	nan	nan	nan
UFot0hit/	UFot0hit5	5	7	Gokhan Tore (Hamburg) wins a free kick in the defensive half.	8		2	Hamburg SV	Borussia Dortmund	gokhan tore	nan	nan	nan			2
UFot0hit/	UFot0hit6	6	9	Hand ball by Jose Paolo Guerrero (Hamburg).	10		2	Hamburg SV	Borussia Dortmund	jose paolo guerrero	nan	nan	nan
UFot0hit/	UFot0hit7	7	10	Corner, Hamburg. Conceded by Lukasz Piszczek.	2		2	Hamburg SV	Borussia Dortmund	lukasz piszczek	lukasz piszczek	nan	nan
UFot0hit/	UFot0hit8	8	11	Chris Lowe (Borussia Dortmund) wins a free kick in the defensive half.	8		1	Borussia Dortmund	Hamburg SV	chris lowe	nan	nan	nan			2
UFot0hit/	UFot0hit9	9	11	Foul by Gojko Kacar (Hamburg).	3		2	Hamburg SV	Borussia Dortmund	gojko kacar	nan	nan	nan
UFot0hit/	UFot0hit10	10	13	Foul by Gokhan Tore (Hamburg).	3		2	Hamburg SV	Borussia Dortmund	gokhan tore	nan	nan	nan


CREATE TABLE events (
  "id_odsp" VARCHAR,
  "id_event" VARCHAR,
  "sort_order" BIGINT,
  "time" BIGINT,
  "text" VARCHAR,
  "event_type" BIGINT,
  "event_type2" DOUBLE,
  "side" BIGINT,
  "event_team" VARCHAR,
  "opponent" VARCHAR,
  "player" VARCHAR,
  "player2" VARCHAR,
  "player_in" VARCHAR,
  "player_out" VARCHAR,
  "shot_place" DOUBLE,
  "shot_outcome" DOUBLE,
  "is_goal" BIGINT,
  "location" DOUBLE,
  "bodypart" DOUBLE,
  "assist_method" BIGINT,
  "situation" DOUBLE,
  "fast_break" BIGINT
);