Name: Europe's Top 5 League Player Analysis
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

Europe's Top 5 League Player Analysis

110 Player details From Europe's Top 5 Leagues: Premier League, La Liga, Seria A, Ligue 1, and Bundesliga. There are 5 Correlated Excel Data files that you can use to create a comprehensive analysis.

Tables

Career Stats

@kaggle.collinsemensah_europes_top_5_league_player_analysis.career_stats

8 kB
110 rows
7 columns

CREATE TABLE career_stats (
  "stats_id" BIGINT,
  "player_id" BIGINT,
  "games" VARCHAR,
  "goals" VARCHAR,
  "assists" VARCHAR,
  "yellow_cards" VARCHAR,
  "red_cards" VARCHAR
);

Geography

@kaggle.collinsemensah_europes_top_5_league_player_analysis.geography

3.45 kB
33 rows
3 columns

CREATE TABLE geography (
  "nation_id" BIGINT,
  "country" VARCHAR,
  "continent_id" BIGINT
);

Leagues

@kaggle.collinsemensah_europes_top_5_league_player_analysis.leagues

2.27 kB
5 rows
2 columns

CREATE TABLE leagues (
  "league_id" BIGINT,
  "league_name" VARCHAR
);

Player

@kaggle.collinsemensah_europes_top_5_league_player_analysis.player

13.51 kB
110 rows
11 columns

CREATE TABLE player (
  "player_id" BIGINT,
  "full_name" VARCHAR,
  "birthdate" TIMESTAMP,
  "nationality" VARCHAR,
  "nation_id" BIGINT,
  "position" VARCHAR,
  "jersey_number" BIGINT,
  "team_id" BIGINT,
  "year_joined_club" BIGINT,
  "debut_career" BIGINT,
  "n__market_value_in_millions" BIGINT  -- Market Value In Millions
);

Team Data

@kaggle.collinsemensah_europes_top_5_league_player_analysis.team_data

6.55 kB
22 rows
7 columns

CREATE TABLE team_data (
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "founded_year" BIGINT,
  "stadium_name" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "league_id" BIGINT
);