European Football Database - Data Description

Player:

• id: Integer, id for the player.
  
• player_api_id: Integer, api id for the player.
  
• player_name: String, name of player.
  
• player_fifa_api_id: Integer, fifa api id for the player.
  
• birthday: String, Date of birth of the player.
  
• height: Number, height of player in centimeters.
  
• weight: Integer, weight of player in pounds.

Country:

• id: Integer, id for country.
  
• name: String, name of the country.

League:

• id: Integer, id for the league.
  
• country_id: Integer, Foreign Key, id of the country that the league is played in.
  
• name: String, name of the country.

Team:

• id: Integer, id for the team
  
• team_api_id: Integer, api id for the team.
  
• team_fifa_api_id: Integer, fifa api id for the team.
  
• team_long_name: String, full name of the team.
  
• team_short_name: String, abbreviated name of the team.

Match:

• id: Integer, id for the match
  
• country_id: Integer, Foreign Key, id of the country that the match is played in.
  
• league_id: Integer, Foreign Key, id of the league that the match is played in.
  
• season: String, season which the match was a part of.
• date: String, date the match was played on.
• match_api_id: Integer, api id for the match.
• home_team_api_id: Integer, api id for the home team.
• away_team_api_id: Integer, api id for the away team.