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

About this Dataset

European Club Football Dataset

Includes data for over 23000 matches and over 2 million events for those matches!

Content

This dataset contains information on 6 of the top European football/soccer leagues. I plan on updating this dataset weekly/biweekly with data for new matches played as well as gradually going backwards for game data as well.

(All data listed below is through roughly present during the current season.)

Data start years:

English Premier League
** Game Data - 2001
** Aggregate Stats - 2002
** Tables - 2001
Spanish La Liga
** Game Data - 2004
** Aggregate Stats - 2002
** Tables - 2000
German Bundesliga
** Game Data - 2002
** Aggregate Stats - 2002
** Tables - 2000
Italian Serie A
** Game Data - 2016
** Aggregate Stats - 2001
** Tables - 2000
Dutch Eredivisie
** Game Data - 2018
** Aggregate Stats - 2001
** Tables - 2000
French Ligue 1
** Game Data - 2018
** Aggregate Stats - 2002
** Tables - 2002

Some notes:

Year as a column refers to the year a season started in. So if a match was played in January 2021, it's value for year would be 2020 because that season started in 2020.
Some older matches have no commentary, but they do have one row in events.csv to denote such

Acknowledgements

ESPN, as that's where this data is scraped from
Image

Inspiration

How do the leagues compare in things like goals per game and red cards per team per season?
Which teams across the leagues foul/get fouled the most and the least per year?
SkillCorner has some interesting data here that may be worth a bit of your time to check out.

Tables

All Tables

@kaggle.josephvm_european_club_football_dataset.all_tables

28.41 kB
2,484 rows
12 columns

CREATE TABLE all_tables (
  "place" BIGINT,
  "team" VARCHAR,
  "gp" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gf" BIGINT,
  "ga" BIGINT,
  "gd" BIGINT,
  "p" BIGINT,
  "year" BIGINT,
  "league" VARCHAR
);

Events

@kaggle.josephvm_european_club_football_dataset.events

45.46 MB
2,326,799 rows
3 columns

CREATE TABLE events (
  "id" BIGINT,
  "time" VARCHAR,
  "event" VARCHAR
);

Matches

@kaggle.josephvm_european_club_football_dataset.matches

6.51 MB
25,724 rows
210 columns

CREATE TABLE matches (
  "id" BIGINT,
  "home" VARCHAR,
  "away" VARCHAR,
  "date" VARCHAR,
  "year" BIGINT,
  "time_utc" VARCHAR  -- Time (utc),
  "attendance" DOUBLE,
  "venue" VARCHAR,
  "league" VARCHAR,
  "part_of_competition" VARCHAR,
  "game_status" VARCHAR,
  "shootout" BOOLEAN,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "home_possessionpct" VARCHAR,
  "away_possessionpct" VARCHAR,
  "home_shotssummary" VARCHAR,
  "away_shotssummary" VARCHAR,
  "home_foulscommitted" DOUBLE,
  "away_foulscommitted" DOUBLE,
  "home_yellowcards" DOUBLE,
  "away_yellowcards" DOUBLE,
  "home_redcards" DOUBLE,
  "away_redcards" DOUBLE,
  "home_offsides" DOUBLE,
  "away_offsides" DOUBLE,
  "home_woncorners" DOUBLE,
  "away_woncorners" DOUBLE,
  "home_saves" DOUBLE,
  "away_saves" DOUBLE,
  "home_goal_minutes" VARCHAR,
  "home_goal_scorers" VARCHAR,
  "away_goal_minutes" VARCHAR,
  "away_goal_scorers" VARCHAR,
  "home_starting_1_num" VARCHAR,
  "home_starting_1" VARCHAR,
  "home_starting_2_num" VARCHAR,
  "home_starting_2" VARCHAR,
  "home_starting_3_num" VARCHAR,
  "home_starting_3" VARCHAR,
  "home_starting_4_num" VARCHAR,
  "home_starting_4" VARCHAR,
  "home_starting_5_num" VARCHAR,
  "home_starting_5" VARCHAR,
  "home_starting_6_num" VARCHAR,
  "home_starting_6" VARCHAR,
  "home_starting_7_num" VARCHAR,
  "home_starting_7" VARCHAR,
  "home_starting_8_num" VARCHAR,
  "home_starting_8" VARCHAR,
  "home_starting_9_num" VARCHAR,
  "home_starting_9" VARCHAR,
  "home_starting_10_num" VARCHAR,
  "home_starting_10" VARCHAR,
  "home_starting_11_num" VARCHAR,
  "home_starting_11" VARCHAR,
  "home_bench_1_num" VARCHAR,
  "home_bench_1" VARCHAR,
  "home_bench_1_minute" VARCHAR,
  "home_bench_2_num" VARCHAR,
  "home_bench_2" VARCHAR,
  "home_bench_2_minute" VARCHAR,
  "home_bench_3_num" VARCHAR,
  "home_bench_3" VARCHAR,
  "home_bench_3_minute" VARCHAR,
  "home_bench_4_num" VARCHAR,
  "home_bench_4" VARCHAR,
  "home_bench_4_minute" VARCHAR,
  "home_bench_5_num" VARCHAR,
  "home_bench_5" VARCHAR,
  "home_bench_5_minute" VARCHAR,
  "away_starting_1_num" VARCHAR,
  "away_starting_1" VARCHAR,
  "away_starting_2_num" VARCHAR,
  "away_starting_2" VARCHAR,
  "away_starting_3_num" VARCHAR,
  "away_starting_3" VARCHAR,
  "away_starting_4_num" VARCHAR,
  "away_starting_4" VARCHAR,
  "away_starting_5_num" VARCHAR,
  "away_starting_5" VARCHAR,
  "away_starting_6_num" VARCHAR,
  "away_starting_6" VARCHAR,
  "away_starting_7_num" VARCHAR,
  "away_starting_7" VARCHAR,
  "away_starting_8_num" VARCHAR,
  "away_starting_8" VARCHAR,
  "away_starting_9_num" VARCHAR,
  "away_starting_9" VARCHAR,
  "away_starting_10_num" VARCHAR,
  "away_starting_10" VARCHAR,
  "away_starting_11_num" VARCHAR,
  "away_starting_11" VARCHAR,
  "away_bench_1_num" VARCHAR,
  "away_bench_1" VARCHAR,
  "away_bench_1_minute" VARCHAR,
  "away_bench_2_num" VARCHAR,
  "away_bench_2" VARCHAR,
  "away_bench_2_minute" VARCHAR,
  "away_bench_3_num" VARCHAR
);