Name: Comprehensive Football Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.63 kB
18 rows
15 columns

CREATE TABLE bundesliga_points (
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018
);

Events

@kaggle.prathamsharma123_comprehensive_football_dataset.events

29.6 MB
941,009 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

461.73 kB
10,112 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.65 kB
20 rows
15 columns

CREATE TABLE laliga_points (
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018
);

Ligue1 Points

@kaggle.prathamsharma123_comprehensive_football_dataset.ligue1_points

11.64 kB
20 rows
15 columns

CREATE TABLE ligue1_points (
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018
);

Premierleague Points

@kaggle.prathamsharma123_comprehensive_football_dataset.premierleague_points

11.69 kB
20 rows
15 columns

CREATE TABLE premierleague_points (
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018
);

Seriea Points

@kaggle.prathamsharma123_comprehensive_football_dataset.seriea_points

11.69 kB
20 rows
15 columns

CREATE TABLE seriea_points (
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018
);