Dataset: Major League Soccer Dataset

About this Dataset

Major League Soccer Dataset

Overview

NOTE: As of now, the source of player data that I had used has changed. So unless I find a new source/figure out how to retrieve it from the changed website, that part of the dataset won't be updated anymore. The tables, matches, and events parts are all fine and will be updated around midweek while the season is going.

NOTE: Version 31 doesn't contain an updated table. I will try to soon either fix how I get it or just compute that information based on the game data.

This dataset contains player, game, event, and table data from Major League Soccer (MLS).

There is currently information on over 6000 matches and almost 420,000 events from those matches.

For an introduction to the data, check out this kernel.
For a quick overview of what data is available for what years, visit this spreadsheet

Player Data

all_goalkeepers.csv - all goalkeeper data from every season of MLS through 2020
all_players.csv - all outfield player data from every season of MLS through 2020

Game Data

matches.csv - match data from the 2001-2021 seasons

Event Data

events.csv - events from games from the 2008-2021 seasons

Tables

all_tables.csv - end of season / current standing of tables for every season through 2021

Dataset Updates

V21 - all_tables.csv updated, now has 1996-2020 and additional columns; includes a section for each conference and then (for most years) an overall table as well
V8 - matches.csv now 1996-2020 (dates look a little different for this period)
V4 - all updated with matches through 8/17/2020 (except all_tables.csv, webpage with the table seems to be down)
V3 - events.csv and matches.csv now 2001-2020 (events only available for 2008 onwards)
V2 - events.csv and matches.csv now 2012-2020

I plan to update this dataset weekly while MLS games are being played.

Acknowledgements

Image: https://www.houstondynamo.com/post/2020/06/10/mls-back-all-26-teams-resume-season-espn-wide-world-sports-starting-july-8
Player Data: https://www.mlssoccer.com/stats
Match Data 1996-2000: https://fbref.com/en/comps/22/44/schedule/2000-Major-League-Soccer-Scores-and-Fixtures
Table Data: https://en.wikipedia.org/wiki/1996_Major_League_Soccer_season
Other Data: https://www.espn.com/soccer/league/_/name/usa.1/

All data was scraped from the above two sources by me. My code is here.

Inspiration

There's a myriad of questions that can be asked about soccer teams and players.

What stats impact the chances of a team winning the most?
Which players have the best win rate and worst win rate over the years?
Which goalkeepers have performed the best?
etc.

Tables

All Goalkeepers

@kaggle.josephvm_major_league_soccer_dataset.all_goalkeepers

41.64 KB
2006 rows
19 columns


CREATE TABLE all_goalkeepers (
  "player" VARCHAR,
  "club" VARCHAR,
  "pos" VARCHAR,
  "gp" BIGINT,
  "gs" BIGINT,
  "mins" BIGINT,
  "shts" BIGINT,
  "sv" BIGINT,
  "ga" BIGINT,
  "gaa" DOUBLE,
  "pkg_a" VARCHAR,
  "w" BIGINT,
  "l" BIGINT,
  "t" BIGINT,
  "sho" BIGINT,
  "w_7863af" DOUBLE,
  "sv_607ef0" DOUBLE,
  "year" BIGINT,
  "season" VARCHAR
);

All Players

@kaggle.josephvm_major_league_soccer_dataset.all_players

266.27 KB
15767 rows
28 columns


CREATE TABLE all_players (
  "player" VARCHAR,
  "club" VARCHAR,
  "pos" VARCHAR,
  "gp" BIGINT,
  "gs" BIGINT,
  "mins" BIGINT,
  "g" BIGINT,
  "a" BIGINT,
  "shts" BIGINT,
  "sog" BIGINT,
  "gwg" BIGINT,
  "pkg_a" VARCHAR,
  "hmg" BIGINT,
  "rdg" BIGINT,
  "g_90min" DOUBLE,
  "sc" DOUBLE,
  "gwa" BIGINT,
  "hma" BIGINT,
  "rda" BIGINT,
  "a_90min" DOUBLE,
  "fc" BIGINT,
  "fs" BIGINT,
  "off" BIGINT,
  "yc" BIGINT,
  "rc" BIGINT,
  "sog_d42f2a" DOUBLE,
  "year" BIGINT,
  "season" VARCHAR
);

All Tables

@kaggle.josephvm_major_league_soccer_dataset.all_tables

21.28 KB
788 rows
17 columns


CREATE TABLE all_tables (
  "pos" DOUBLE,
  "team" VARCHAR,
  "gp" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "sw" DOUBLE,
  "gf" BIGINT,
  "ga" BIGINT,
  "gd" VARCHAR,
  "pts" VARCHAR,
  "qualification" VARCHAR,
  "conference" VARCHAR,
  "year" BIGINT,
  "sl" DOUBLE,
  "d" DOUBLE,
  "head_to_head" VARCHAR,
  "ppg" DOUBLE
);

Events

@kaggle.josephvm_major_league_soccer_dataset.events

8.75 MB
504313 rows
3 columns


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

Matches

@kaggle.josephvm_major_league_soccer_dataset.matches

1.39 MB
7289 rows
209 columns


CREATE TABLE matches (
  "id" DOUBLE,
  "home" VARCHAR,
  "away" VARCHAR,
  "date" VARCHAR,
  "year" BIGINT,
  "time_utc" VARCHAR,
  "attendance" DOUBLE,
  "venue" VARCHAR,
  "league" VARCHAR,
  "part_of_competition" VARCHAR,
  "game_status" VARCHAR,
  "shootout" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "referee" VARCHAR,
  "home_goal_minutes" VARCHAR,
  "home_goal_scorers" VARCHAR,
  "away_goal_minutes" VARCHAR,
  "away_goal_scorers" VARCHAR,
  "home_starting_1_num" DOUBLE,
  "home_starting_1" VARCHAR,
  "home_starting_2_num" DOUBLE,
  "home_starting_2" VARCHAR,
  "home_starting_3_num" DOUBLE,
  "home_starting_3" VARCHAR,
  "home_starting_4_num" DOUBLE,
  "home_starting_4" VARCHAR,
  "home_starting_5_num" DOUBLE,
  "home_starting_5" VARCHAR,
  "home_starting_6_num" DOUBLE,
  "home_starting_6" VARCHAR,
  "home_starting_7_num" DOUBLE,
  "home_starting_7" VARCHAR,
  "home_starting_8_num" DOUBLE,
  "home_starting_8" VARCHAR,
  "home_starting_9_num" DOUBLE,
  "home_starting_9" VARCHAR,
  "home_starting_10_num" DOUBLE,
  "home_starting_10" VARCHAR,
  "home_starting_11_num" DOUBLE,
  "home_starting_11" VARCHAR,
  "home_bench_1_num" DOUBLE,
  "home_bench_1" VARCHAR,
  "home_bench_1_minute" VARCHAR,
  "home_bench_2_num" DOUBLE,
  "home_bench_2" VARCHAR,
  "home_bench_2_minute" VARCHAR,
  "home_bench_3_num" DOUBLE,
  "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" DOUBLE,
  "home_bench_5" VARCHAR,
  "home_bench_5_minute" VARCHAR,
  "home_bench_6_num" DOUBLE,
  "home_bench_6" VARCHAR,
  "home_bench_6_minute" VARCHAR,
  "home_bench_7_num" DOUBLE,
  "home_bench_7" VARCHAR,
  "home_bench_7_minute" VARCHAR,
  "home_bench_8_num" DOUBLE,
  "home_bench_8" VARCHAR,
  "home_bench_8_minute" VARCHAR,
  "home_bench_9_num" DOUBLE,
  "home_bench_9" VARCHAR,
  "home_bench_9_minute" VARCHAR,
  "away_starting_1_num" DOUBLE,
  "away_starting_1" VARCHAR,
  "away_starting_2_num" DOUBLE,
  "away_starting_2" VARCHAR,
  "away_starting_3_num" DOUBLE,
  "away_starting_3" VARCHAR,
  "away_starting_4_num" DOUBLE,
  "away_starting_4" VARCHAR,
  "away_starting_5_num" DOUBLE,
  "away_starting_5" VARCHAR,
  "away_starting_6_num" DOUBLE,
  "away_starting_6" VARCHAR,
  "away_starting_7_num" DOUBLE,
  "away_starting_7" VARCHAR,
  "away_starting_8_num" DOUBLE,
  "away_starting_8" VARCHAR,
  "away_starting_9_num" DOUBLE,
  "away_starting_9" VARCHAR,
  "away_starting_10_num" DOUBLE,
  "away_starting_10" VARCHAR,
  "away_starting_11_num" DOUBLE,
  "away_starting_11" VARCHAR,
  "away_bench_1_num" DOUBLE,
  "away_bench_1" VARCHAR,
  "away_bench_1_minute" VARCHAR,
  "away_bench_2_num" DOUBLE,
  "away_bench_2" VARCHAR,
  "away_bench_2_minute" VARCHAR,
  "away_bench_3_num" DOUBLE,
  "away_bench_3" VARCHAR,
  "away_bench_3_minute" VARCHAR,
  "away_bench_4_num" DOUBLE
);