Major League Soccer Dataset
Player stats, game stats, game events, and tables for MLS
@kaggle.josephvm_major_league_soccer_dataset
Player stats, game stats, game events, and tables for MLS
@kaggle.josephvm_major_league_soccer_dataset
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
);
Anyone who has the link will be able to view this.