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

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.14 KB
3 rows
2 columns


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

Tbl Countries

@kaggle.navarrojavier_la_liga_stats.tbl_countries

4.35 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

76.9 KB
5175 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

34.54 KB
1900 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

104.86 KB
9500 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.82 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.2 KB
5 rows
2 columns


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

Tbl Players Cards

@kaggle.navarrojavier_la_liga_stats.tbl_players_cards

113.36 KB
10383 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 Match Performance

@kaggle.navarrojavier_la_liga_stats.tbl_player_match_performance

494.13 KB
52834 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 Player Team Season

@kaggle.navarrojavier_la_liga_stats.tbl_player_team_season

28.87 KB
2791 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.25 KB
10 rows
2 columns


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

Tbl Stats

@kaggle.navarrojavier_la_liga_stats.tbl_stats

176.49 KB
22704 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.16 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.34 KB
3 rows
2 columns


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