Name: All Premier League Team And Players (1992-2024)
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

All Premier League Team And Players (1992-2024)

This dataset covers all Premier League teams and players from 1992 to 2024. It includes detailed information about the lineups, match results and statistics by season. The data is collected from official sources and the transfermarkt website. This dataset provides a unique opportunity to analyze the history and development of the Premier League. It will be useful for researchers, fans and analysts interested in football.

Dataset Structure

clubs.csv: A list of teams with their IDs and capitals with names like 'Season_1992'. There is 1 in this cell if the team participated and 0 if not.
DATA_CSV
- Season_1992
- Season_1993
- ...
  A list of team files with their players and player descriptions. The structure of the team's file in the season is Name_id_YEAR
DATA_JSON
The same as DATA_CSV but in json format. The files were converted to csv format using a python script.

Tables

Clubs

@kaggle.samoilovmikhail_all_premier_league_team_and_players_1992_2024.clubs

26.98 kB
51 rows
36 columns

CREATE TABLE clubs (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "team_name" VARCHAR,
  "team_id" BIGINT,
  "season_1992" BIGINT,
  "season_1993" BIGINT,
  "season_1994" BIGINT,
  "season_1995" BIGINT,
  "season_1996" BIGINT,
  "season_1997" BIGINT,
  "season_1998" BIGINT,
  "season_1999" BIGINT,
  "season_2000" BIGINT,
  "season_2001" BIGINT,
  "season_2002" BIGINT,
  "season_2003" BIGINT,
  "season_2004" BIGINT,
  "season_2005" BIGINT,
  "season_2006" BIGINT,
  "season_2007" BIGINT,
  "season_2008" BIGINT,
  "season_2009" BIGINT,
  "season_2010" BIGINT,
  "season_2011" BIGINT,
  "season_2012" BIGINT,
  "season_2013" BIGINT,
  "season_2014" BIGINT,
  "season_2015" BIGINT,
  "season_2016" BIGINT,
  "season_2017" BIGINT,
  "season_2018" BIGINT,
  "season_2019" BIGINT,
  "season_2020" BIGINT,
  "season_2021" BIGINT,
  "season_2022" BIGINT,
  "season_2023" BIGINT,
  "season_2024" BIGINT
);