Skip to content

Instantly share code, notes, and snippets.

@oddlyspaced

oddlyspaced/euro-soccer.md

Last active November 25, 2024 16:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save oddlyspaced/fe74a95b0e7fd8ac4f4db3acae759466 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save oddlyspaced/fe74a95b0e7fd8ac4f4db3acae759466 to your computer and use it in GitHub Desktop.
Download ZIP
European Soccer Dataset Metadata
Raw
euro-soccer.md

Metadata for the European Soccer Database

1. country Table

  • Description: Contains information about countries represented in the dataset.
  • Columns:
    • id: Unique identifier for the country.
    • name: Name of the country.

2. league Table

  • Description: Stores data about soccer leagues in different countries.
  • Columns:
    • id: Unique identifier for the league.
    • country_id: Foreign key linking the league to a country (country.id).
    • name: Name of the league (e.g., Premier League).

3. match Table

  • Description: Detailed information about matches across leagues and seasons.
  • Columns:
    • id: Unique identifier for the match.
    • country_id: Foreign key linking the match to a country (country.id).
    • league_id: Foreign key linking the match to a league (league.id).
    • season: Season in which the match was played (e.g., 2015/2016).
    • stage: Stage of the competition (e.g., group stage, knockout stage).
    • date: Date when the match was played.
    • match_api_id: API identifier for the match.
    • home_team_api_id: Foreign key referencing the home team (team.team_api_id).
    • away_team_api_id: Foreign key referencing the away team (team.team_api_id).
    • home_team_goal: Goals scored by the home team.
    • away_team_goal: Goals scored by the away team.
    • home_player_X1 to home_player_X11: Player X-coordinates for the home team.
    • away_player_X1 to away_player_X11: Player X-coordinates for the away team.
    • home_player_Y1 to home_player_Y11: Player Y-coordinates for the home team.
    • away_player_Y1 to away_player_Y11: Player Y-coordinates for the away team.
    • home_player_1 to home_player_11: IDs of home team players (alternative mapping).
    • away_player_1 to away_player_11: IDs of away team players (alternative mapping).
    • goal: Goal event details during the match.
    • shoton: Information about shots on target.
    • shotoff: Information about shots off target.
    • foulcommit: Details of fouls committed.
    • card: Card events (yellow or red).
    • cross: Crossing events during the match.
    • corner: Corner kick events.
    • possession: Possession statistics.
    • B365H, B365D, B365A: Betting odds for Home Win, Draw, and Away Win from Bet365.
    • BWH, BWD, BWA: Betting odds from Bet&Win.
    • IWH, IWD, IWA: Betting odds from Interwetten.
    • LBH, LBD, LBA: Betting odds from Ladbrokes.
    • PSH, PSD, PSA: Betting odds from Pinnacle.
    • WHH, WHD, WHA: Betting odds from William Hill.
    • SJH, SJD, SJA: Betting odds from SJ.
    • VCH, VCD, VCA: Betting odds from VC Bet.
    • GBH, GBD, GBA: Betting odds from Gamebookers.
    • BSH, BSD, BSA: Betting odds from BetSafe.

4. player Table

  • Description: Metadata about individual soccer players.
  • Columns:
    • id: Unique identifier for the player.
    • player_api_id: Unique API identifier for the player.
    • player_name: Name of the player.
    • player_fifa_api_id: FIFA API identifier for the player.
    • birthday: Date of birth of the player.
    • height: Height of the player (in cm).
    • weight: Weight of the player (in kg).

5. player_attributes Table

  • Description: Contains detailed attributes of players, recorded over time.
  • Columns:
    • id: Unique identifier for the player attributes entry.
    • player_api_id: Foreign key referencing the player (player.player_api_id).
    • player_fifa_api_id: FIFA API identifier for the player.
    • date: Date when the attributes were recorded.
    • overall_rating: Overall rating of the player.
    • potential: Potential rating of the player.
    • preferred_foot: Preferred foot of the player (e.g., left, right).
    • attacking_work_rate, defensive_work_rate: Work rates in attack and defense.
    • Technical Skills: crossing, finishing, heading_accuracy, short_passing, volleys, dribbling, curve, free_kick_accuracy, long_passing, ball_control.
    • Physical Attributes: acceleration, sprint_speed, agility, stamina, strength, balance, reactions, jumping.
    • Defensive Skills: interceptions, marking, standing_tackle, sliding_tackle.
    • Goalkeeping: gk_diving, gk_handling, gk_kicking, gk_positioning, gk_reflexes.

6. team Table

  • Description: Metadata about soccer teams.
  • Columns:
    • id: Unique identifier for the team.
    • team_api_id: Unique API identifier for the team.
    • team_fifa_api_id: FIFA API identifier for the team.
    • team_long_name: Full name of the team.
    • team_short_name: Shortened name or abbreviation of the team.

7. team_attributes Table

  • Description: Contains tactical and performance metrics of teams over time.
  • Columns:
    • id: Unique identifier for the team attributes entry.
    • team_api_id: Foreign key referencing the team (team.team_api_id).
    • team_fifa_api_id: FIFA API identifier for the team.
    • date: Date when the attributes were recorded.
    • Build-Up Play: buildUpPlaySpeed, buildUpPlaySpeedClass, buildUpPlayDribbling, buildUpPlayDribblingClass, buildUpPlayPassing, buildUpPlayPassingClass, buildUpPlayPositioningClass.
    • Chance Creation: chanceCreationPassing, chanceCreationPassingClass, chanceCreationCrossing, chanceCreationCrossingClass, chanceCreationShooting, chanceCreationShootingClass, chanceCreationPositioningClass.
    • Defense: defencePressure, defencePressureClass, defenceAggression, defenceAggressionClass, defenceTeamWidth, defenceTeamWidthClass, defenceDefenderLineClass.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment