Dataset: Comprehensive Football Dataset

About this Dataset

Comprehensive Football Dataset

This comprehensive football dataset includes data for football games from Europe's top 5 football leagues: Bundesliga (Germany), La Liga (Spain), Ligue 1 (France), Premier League (England) and Serie A (Italy) from the 2011/2012 season to the 2016/2017 season. The dataset also contains information about points for each team in each league from 2004-2018.

Tables

Bundesliga Points

@kaggle.prathamsharma123_comprehensive_football_dataset.bundesliga_points

11.35 KB
18 rows
15 columns


CREATE TABLE bundesliga_points (
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT
);

Events

@kaggle.prathamsharma123_comprehensive_football_dataset.events

28.23 MB
941009 rows
22 columns


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
);

Ginf

@kaggle.prathamsharma123_comprehensive_football_dataset.ginf

450.91 KB
10112 rows
18 columns


CREATE TABLE ginf (
  "id_odsp" VARCHAR,
  "link_odsp" VARCHAR,
  "adv_stats" BOOLEAN,
  "date" TIMESTAMP,
  "league" VARCHAR,
  "season" BIGINT,
  "country" VARCHAR,
  "ht" VARCHAR,
  "at" VARCHAR,
  "fthg" BIGINT,
  "ftag" BIGINT,
  "odd_h" DOUBLE,
  "odd_d" DOUBLE,
  "odd_a" DOUBLE,
  "odd_over" DOUBLE,
  "odd_under" DOUBLE,
  "odd_bts" DOUBLE,
  "odd_bts_n" DOUBLE
);

Laliga Points

@kaggle.prathamsharma123_comprehensive_football_dataset.laliga_points

11.38 KB
20 rows
15 columns


CREATE TABLE laliga_points (
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT
);

Ligue1 Points

@kaggle.prathamsharma123_comprehensive_football_dataset.ligue1_points

11.37 KB
20 rows
15 columns


CREATE TABLE ligue1_points (
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT
);

Premierleague Points

@kaggle.prathamsharma123_comprehensive_football_dataset.premierleague_points

11.42 KB
20 rows
15 columns


CREATE TABLE premierleague_points (
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT
);

Seriea Points

@kaggle.prathamsharma123_comprehensive_football_dataset.seriea_points

11.42 KB
20 rows
15 columns


CREATE TABLE seriea_points (
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT
);