Premier League Player Stats 2022-23
Stats of all the players who have featured in the Premier League Season 2022/23.
@kaggle.ameyaranade_premier_league_player_stats_2022_23
Stats of all the players who have featured in the Premier League Season 2022/23.
@kaggle.ameyaranade_premier_league_player_stats_2022_23
Uncover the performance intricacies of Premier League players in the 2022/23 season with this comprehensive dataset. Each file, labeled as PremierLeaguePlayer
CREATE TABLE premierleagueplayerdefensestats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"tkl" BIGINT,
"tklw" BIGINT,
"def_3rd" BIGINT,
"mid_3rd" BIGINT,
"att_3rd" BIGINT,
"tkl_1" BIGINT,
"att" BIGINT,
"tkl_6c6d02" DOUBLE -- Tkl%,
"lost" BIGINT,
"blocks" BIGINT,
"sh" BIGINT,
"pass" BIGINT,
"int" BIGINT,
"tkl_int" BIGINT,
"clr" BIGINT,
"err" BIGINT
);CREATE TABLE premierleagueplayergcastats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"sca" BIGINT,
"sca90" DOUBLE,
"passlive" BIGINT,
"passdead" BIGINT,
"to" BIGINT,
"sh" BIGINT,
"fld" BIGINT,
"def" BIGINT,
"gca" BIGINT,
"gca90" DOUBLE,
"passlive_1" BIGINT,
"passdead_1" BIGINT,
"to_1" BIGINT,
"sh_1" BIGINT,
"fld_1" BIGINT,
"def_1" BIGINT
);CREATE TABLE premierleagueplayerpassingstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"cmp" BIGINT,
"att" BIGINT,
"cmp_fbd6fd" DOUBLE -- Cmp%,
"totdist" BIGINT,
"prgdist" BIGINT,
"cmp_1" BIGINT,
"att_1" BIGINT,
"cmp_1_c8ea36" DOUBLE -- Cmp%.1,
"cmp_2" BIGINT,
"att_2" BIGINT,
"cmp_2_b6e57c" DOUBLE -- Cmp%.2,
"cmp_3" BIGINT,
"att_3" BIGINT,
"cmp_3_98370a" DOUBLE -- Cmp%.3,
"ast" BIGINT,
"xag" DOUBLE,
"xa" DOUBLE,
"a_xag" DOUBLE,
"kp" BIGINT,
"n_1_3" BIGINT -- 1/3,
"ppa" BIGINT,
"crspa" BIGINT,
"prgp" BIGINT
);CREATE TABLE premierleagueplayerpossessionstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"touches" BIGINT,
"def_pen" BIGINT,
"def_3rd" BIGINT,
"mid_3rd" BIGINT,
"att_3rd" BIGINT,
"att_pen" BIGINT,
"live" BIGINT,
"att" BIGINT,
"succ" BIGINT,
"succ_c8ffb4" DOUBLE -- Succ%,
"tkld" BIGINT,
"tkld_a3c7ed" DOUBLE -- Tkld%,
"carries" BIGINT,
"totdist" BIGINT,
"prgdist" BIGINT,
"prgc" BIGINT,
"n_1_3" BIGINT -- 1/3,
"cpa" BIGINT,
"mis" BIGINT,
"dis" BIGINT,
"rec" BIGINT,
"prgr" BIGINT
);CREATE TABLE premierleagueplayershootingstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"gls" BIGINT,
"sh" BIGINT,
"sot" BIGINT,
"sot_d2d6f4" DOUBLE -- SoT%,
"sh_90" DOUBLE,
"sot_90" DOUBLE,
"g_sh" DOUBLE,
"g_sot" DOUBLE,
"dist" DOUBLE,
"fk" BIGINT,
"pk" BIGINT,
"pkatt" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"npxg_sh" DOUBLE,
"g_xg" DOUBLE,
"np_g_xg" DOUBLE
);CREATE TABLE premierleagueplayerstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" DOUBLE,
"born" DOUBLE,
"mp" DOUBLE,
"starts" DOUBLE,
"min" BIGINT,
"n_90s" DOUBLE -- 90s,
"gls" DOUBLE,
"ast" DOUBLE,
"g_a" DOUBLE,
"npgls" DOUBLE,
"pk" DOUBLE,
"pkatt" DOUBLE,
"crdy" DOUBLE,
"crdr" DOUBLE,
"xg" DOUBLE,
"npxg" DOUBLE,
"xag" DOUBLE,
"npxg_xag" DOUBLE,
"prgc" DOUBLE,
"prgp" DOUBLE,
"prgr" DOUBLE,
"glsp90" DOUBLE,
"astp90" DOUBLE,
"g_ap90" DOUBLE,
"npglsp90" DOUBLE,
"npglsastp90" DOUBLE,
"xgp90" DOUBLE,
"xagp90" DOUBLE,
"xg_xagp90" DOUBLE,
"npxgp90" DOUBLE,
"npxg_xagp90" DOUBLE
);Anyone who has the link will be able to view this.