Name: Soccer Stats LaLiga - From 2014/2015 To 2018/2019
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Soccer Stats LaLiga - From 2014/2015 To 2018/2019

Context

Football is one the most exciting sports worldwide. LaLiga (Spain football legue) has been known for having the best players in the last years and every match gives us the opportunity to enjoy amazing plays and goals.
I am planning to upload data from EPL, Bundesliga, Serie A and Ligue 1, but I wanted to upload this one first to check if changes are needed to be made in the other datasets.

Content

This dataset contains information and stats of each match from LaLiga seasons from 2014/2015 to 2018/2019. This information has been taken from different sources. (Goals, assistances, cards, corners, fouls, shots, offsides and ball possesion.)

Inspiration

This is a rich dataset that offers lots of rooms for exploration. These are some of the question that I would like to explore:

Most frequent score in LaLiga in the last 5 years?
How often a team with a lower odd wins the match?
How often there is a missed penalty in a match?
How much money would I earn/lose if I bet $10 on draw in all 380 matches per season?

Tables

Tbl Cards

@kaggle.navarrojavier_la_liga_stats.tbl_cards

2.19 kB
3 rows
2 columns

CREATE TABLE tbl_cards (
  "id_card" BIGINT,
  "card" VARCHAR
);

Tbl Countries

@kaggle.navarrojavier_la_liga_stats.tbl_countries

4.45 kB
98 rows
3 columns

CREATE TABLE tbl_countries (
  "id_country" BIGINT,
  "country_code" VARCHAR,
  "country_name" VARCHAR
);

Tbl Goals

@kaggle.navarrojavier_la_liga_stats.tbl_goals

78.75 kB
5,175 rows
6 columns

CREATE TABLE tbl_goals (
  "id_goal" BIGINT,
  "id_plts" BIGINT,
  "id_match" BIGINT,
  "minute" VARCHAR,
  "id_way_to_score" BIGINT,
  "id_assist_player" BIGINT
);

Tbl Matches

@kaggle.navarrojavier_la_liga_stats.tbl_matches

35.37 kB
1,900 rows
11 columns

CREATE TABLE tbl_matches (
  "id_match" BIGINT,
  "id_league" BIGINT,
  "id_season" BIGINT,
  "week" BIGINT,
  "stadium" BIGINT,
  "referee" BIGINT,
  "match_date" TIMESTAMP,
  "home_team" BIGINT,
  "away_team" BIGINT,
  "home_coach" BIGINT,
  "away_coach" BIGINT
);

Tbl Matches Odds

@kaggle.navarrojavier_la_liga_stats.tbl_matches_odds

107.38 kB
9,500 rows
5 columns

CREATE TABLE tbl_matches_odds (
  "id_match_bet" BIGINT,
  "id_match" BIGINT,
  "id_bet" BIGINT,
  "decimal" DOUBLE,
  "american" DOUBLE
);

Tbl Missed Penalties

@kaggle.navarrojavier_la_liga_stats.tbl_missed_penalties

5.96 kB
141 rows
4 columns

CREATE TABLE tbl_missed_penalties (
  "id_missed_penalty" BIGINT,
  "id_match" BIGINT,
  "id_plts" BIGINT,
  "minute" VARCHAR
);

Tbl Odds

@kaggle.navarrojavier_la_liga_stats.tbl_odds

2.25 kB
5 rows
2 columns

CREATE TABLE tbl_odds (
  "id_odd" BIGINT,
  "odd_description" VARCHAR
);

Tbl Player Match Performance

@kaggle.navarrojavier_la_liga_stats.tbl_player_match_performance

505.99 kB
52,834 rows
6 columns

CREATE TABLE tbl_player_match_performance (
  "id_plmp" BIGINT,
  "id_plts" BIGINT,
  "id_match" BIGINT,
  "minute_in" VARCHAR,
  "minute_out" VARCHAR,
  "id_plts_sub_in" VARCHAR
);

Tbl Players Cards

@kaggle.navarrojavier_la_liga_stats.tbl_players_cards

116.08 kB
10,383 rows
5 columns

CREATE TABLE tbl_players_cards (
  "id_player_card" BIGINT,
  "id_match" BIGINT,
  "id_plts" BIGINT,
  "id_card" BIGINT,
  "minute" VARCHAR
);

Tbl Player Team Season

@kaggle.navarrojavier_la_liga_stats.tbl_player_team_season

29.56 kB
2,791 rows
4 columns

CREATE TABLE tbl_player_team_season (
  "id_plts" BIGINT,
  "id_player" BIGINT,
  "id_team" BIGINT,
  "id_season" BIGINT
);

Tbl Seasons

@kaggle.navarrojavier_la_liga_stats.tbl_seasons

2.31 kB
10 rows
2 columns

CREATE TABLE tbl_seasons (
  "id_season" BIGINT,
  "season" VARCHAR
);

Tbl Stats

@kaggle.navarrojavier_la_liga_stats.tbl_stats

180.72 kB
22,704 rows
5 columns

CREATE TABLE tbl_stats (
  "id_stat" BIGINT,
  "id_match" BIGINT,
  "id_team" BIGINT,
  "id_stat_code" BIGINT,
  "occurrences_percentage" BIGINT
);

Tbl Stats Code

@kaggle.navarrojavier_la_liga_stats.tbl_stats_code

2.21 kB
6 rows
2 columns

CREATE TABLE tbl_stats_code (
  "id_stat" BIGINT,
  "stat" VARCHAR
);

Tbl Ways To Score

@kaggle.navarrojavier_la_liga_stats.tbl_ways_to_score

2.4 kB
3 rows
2 columns

CREATE TABLE tbl_ways_to_score (
  "id_way_to_score" BIGINT,
  "way_to_score" VARCHAR
);