Big 5 European Leagues Player Stats 2022-23
Stats of all the players who featured in the Top 5 leagues in 2022/23.
@kaggle.ameyaranade_big_5_european_leagues_player_stats_2022_23
Stats of all the players who featured in the Top 5 leagues in 2022/23.
@kaggle.ameyaranade_big_5_european_leagues_player_stats_2022_23
In 2022/23 season, Big 5 European Leagues constituted of Premier League, Serie A, La Liga, Ligue 1 and Bundesliga. Uncover the performance intricacies of football players in the 2022/23 season from the top 5 European leagues with this comprehensive dataset.
If you wish to contribute to this dataset. Do contact me :)
CREATE TABLE big5_defensestats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"tkl" DOUBLE,
"tklw" BIGINT,
"def_3rd" DOUBLE,
"mid_3rd" DOUBLE,
"att_3rd" DOUBLE,
"tkl_1" DOUBLE,
"att" DOUBLE,
"tkl_6c6d02" DOUBLE -- Tkl%,
"lost" DOUBLE,
"blocks" DOUBLE,
"sh" DOUBLE,
"pass" DOUBLE,
"int" BIGINT,
"tkl_int" DOUBLE,
"clr" DOUBLE,
"err" DOUBLE
);
CREATE TABLE big5_gcastats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"sca" DOUBLE,
"sca90" DOUBLE,
"passlive" DOUBLE,
"passdead" DOUBLE,
"to" DOUBLE,
"sh" DOUBLE,
"fld" DOUBLE,
"def" DOUBLE,
"gca" DOUBLE,
"gca90" DOUBLE,
"passlive_1" DOUBLE,
"passdead_1" DOUBLE,
"to_1" DOUBLE,
"sh_1" DOUBLE,
"fld_1" DOUBLE,
"def_1" DOUBLE
);
CREATE TABLE big5_keepersadvstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"ga" DOUBLE,
"pka" DOUBLE,
"fk" DOUBLE,
"ck" DOUBLE,
"og" DOUBLE,
"psxg" DOUBLE,
"psxg_sot" DOUBLE,
"psxg_3588aa" DOUBLE -- PSxG+/-,
"n__90" DOUBLE -- /90,
"cmp" DOUBLE,
"att" DOUBLE,
"cmp_fbd6fd" DOUBLE -- Cmp%,
"att_1" DOUBLE,
"thr" DOUBLE,
"launch" DOUBLE -- Launch%,
"avglen" DOUBLE,
"att_2" DOUBLE,
"launch_1" DOUBLE -- Launch%.1,
"avglen_1" DOUBLE,
"opp" DOUBLE,
"stp" DOUBLE,
"stp_379866" DOUBLE -- Stp%,
"n__opa" DOUBLE -- #OPA,
"n__opa_90" DOUBLE -- #OPA/90,
"avgdist" DOUBLE
);
CREATE TABLE big5_keepersstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"n_90s" DOUBLE -- 90s,
"ga" DOUBLE,
"ga90" DOUBLE,
"sota" DOUBLE,
"saves" DOUBLE,
"save" DOUBLE -- Save%,
"w" BIGINT,
"d" DOUBLE,
"l" DOUBLE,
"cs" DOUBLE,
"cs_2b84ea" DOUBLE -- CS%,
"pkatt" DOUBLE,
"pka" DOUBLE,
"pksv" DOUBLE,
"pkm" DOUBLE,
"save_1" DOUBLE -- Save%.1
);
CREATE TABLE big5_miscstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"crdy" BIGINT,
"crdr" BIGINT,
"n_2crdy" BIGINT -- 2CrdY,
"fls" BIGINT,
"fld" BIGINT,
"off" BIGINT,
"crs" BIGINT,
"int" BIGINT,
"tklw" BIGINT,
"pkwon" DOUBLE,
"pkcon" DOUBLE,
"og" BIGINT,
"recov" DOUBLE,
"won" DOUBLE,
"lost" DOUBLE,
"won_27ea4a" DOUBLE -- Won%
);
CREATE TABLE big5_passingstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"cmp" DOUBLE,
"att" DOUBLE,
"cmp_fbd6fd" DOUBLE -- Cmp%,
"totdist" DOUBLE,
"prgdist" DOUBLE,
"cmp_1" DOUBLE,
"att_1" DOUBLE,
"cmp_1_c8ea36" DOUBLE -- Cmp%.1,
"cmp_2" DOUBLE,
"att_2" DOUBLE,
"cmp_2_b6e57c" DOUBLE -- Cmp%.2,
"cmp_3" DOUBLE,
"att_3" DOUBLE,
"cmp_3_98370a" DOUBLE -- Cmp%.3,
"ast" BIGINT,
"xag" DOUBLE,
"xa" DOUBLE,
"a_xag" DOUBLE,
"kp" DOUBLE,
"n_1_3" DOUBLE -- 1/3,
"ppa" DOUBLE,
"crspa" DOUBLE,
"prgp" DOUBLE
);
CREATE TABLE big5_passing_typesstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"att" DOUBLE,
"live" DOUBLE,
"dead" DOUBLE,
"fk" DOUBLE,
"tb" DOUBLE,
"sw" DOUBLE,
"crs" BIGINT,
"ti" DOUBLE,
"ck" DOUBLE,
"in" DOUBLE,
"out" DOUBLE,
"str" DOUBLE,
"cmp" DOUBLE,
"off" DOUBLE,
"blocks" DOUBLE
);
CREATE TABLE big5_playingtimestats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" DOUBLE,
"born" DOUBLE,
"mp" BIGINT,
"min" DOUBLE,
"mn_mp" DOUBLE,
"min_59d8e8" DOUBLE -- Min%,
"n_90s" DOUBLE -- 90s,
"starts" BIGINT,
"mn_start" DOUBLE,
"compl" BIGINT,
"subs" BIGINT,
"mn_sub" DOUBLE,
"unsub" BIGINT,
"ppm" DOUBLE,
"ong" DOUBLE,
"onga" DOUBLE,
"n" DOUBLE -- +/-,
"n__90" DOUBLE -- +/-90,
"on_off" DOUBLE,
"onxg" DOUBLE,
"onxga" DOUBLE,
"xg" DOUBLE -- XG+/-,
"xg_90" DOUBLE -- XG+/-90,
"on_off_1" DOUBLE
);
CREATE TABLE big5_possessionstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"n_90s" DOUBLE -- 90s,
"touches" DOUBLE,
"def_pen" DOUBLE,
"def_3rd" DOUBLE,
"mid_3rd" DOUBLE,
"att_3rd" DOUBLE,
"att_pen" DOUBLE,
"live" DOUBLE,
"att" DOUBLE,
"succ" DOUBLE,
"succ_c8ffb4" DOUBLE -- Succ%,
"tkld" DOUBLE,
"tkld_a3c7ed" DOUBLE -- Tkld%,
"carries" DOUBLE,
"totdist" DOUBLE,
"prgdist" DOUBLE,
"prgc" DOUBLE,
"n_1_3" DOUBLE -- 1/3,
"cpa" DOUBLE,
"mis" DOUBLE,
"dis" DOUBLE,
"rec" DOUBLE,
"prgr" DOUBLE
);
CREATE TABLE big5_shootingstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" 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" DOUBLE,
"pk" BIGINT,
"pkatt" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"npxg_sh" DOUBLE,
"g_xg" DOUBLE,
"np_g_xg" DOUBLE
);
CREATE TABLE big5_statsstats22_23 (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"comp" VARCHAR,
"age" BIGINT,
"born" BIGINT,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"n_90s" DOUBLE -- 90s,
"gls" BIGINT,
"ast" BIGINT,
"g_a" BIGINT,
"g_pk" BIGINT,
"pk" BIGINT,
"pkatt" BIGINT,
"crdy" BIGINT,
"crdr" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"xag" DOUBLE,
"npxg_xag" DOUBLE,
"prgc" DOUBLE,
"prgp" DOUBLE,
"prgr" DOUBLE,
"gls_1" DOUBLE,
"ast_1" DOUBLE,
"g_a_1" DOUBLE,
"g_pk_1" DOUBLE,
"g_a_pk" DOUBLE,
"xg_1" DOUBLE,
"xag_1" DOUBLE,
"xg_xag" DOUBLE,
"npxg_1" DOUBLE,
"npxg_xag_1" DOUBLE
);
Anyone who has the link will be able to view this.