2021-2022 Season England Premier League Team Data
Explaining the premier league squad stats in accordance different type of data.
@kaggle.mechatronixs_20212022_season_england_premier_league_team_data
Explaining the premier league squad stats in accordance different type of data.
@kaggle.mechatronixs_20212022_season_england_premier_league_team_data
CREATE TABLE england_premier_league_squad_defensive_actions_22 (
"squad" VARCHAR,
"npl" BIGINT,
"tottkl" BIGINT,
"tottklw" BIGINT,
"def3rdtck" BIGINT,
"mid3rdtck" BIGINT,
"att3rdtck" BIGINT,
"tklwvsdrib" BIGINT,
"atttckvsdrib" BIGINT,
"tklwvsdribrt" DOUBLE,
"pastdribntck" BIGINT,
"presstot" BIGINT,
"succpress" BIGINT,
"pressrt" DOUBLE,
"def3rdpres" BIGINT,
"mid3rdpres" BIGINT,
"att3rdpres" BIGINT,
"totblocbal" BIGINT,
"shblocball" BIGINT,
"shsvbloc" BIGINT,
"passblock" BIGINT,
"int" BIGINT,
"tklpint" BIGINT,
"clear" BIGINT,
"err" BIGINT
);
CREATE TABLE england_premier_league_squad_goalkeeping_22 (
"squad" VARCHAR,
"n__pl" BIGINT,
"mp" BIGINT,
"gatot" BIGINT,
"ga90" DOUBLE,
"sota" BIGINT,
"saves" BIGINT,
"savert" DOUBLE,
"w" BIGINT,
"d" BIGINT,
"l" BIGINT,
"cs" BIGINT,
"csrt" DOUBLE,
"pkatt" BIGINT,
"pka" BIGINT,
"pksv" BIGINT,
"pkm" BIGINT,
"savpenrt" DOUBLE
);
CREATE TABLE england_premier_league_squad_goal_shot_creation_22 (
"squad" VARCHAR,
"npl" BIGINT,
"scat" BIGINT,
"sca90" DOUBLE,
"passlivesca" BIGINT,
"passdeadsca" BIGINT,
"dribsca" BIGINT,
"shsca" BIGINT,
"fldsca" BIGINT,
"defsca" BIGINT,
"gcat" BIGINT,
"gca90" DOUBLE,
"passlivegca" BIGINT,
"passdeadgca" BIGINT,
"dribgca" BIGINT,
"shgca" BIGINT,
"fldgca" BIGINT,
"defgca" BIGINT
);
CREATE TABLE england_premier_league_squad_passing_stats_22 (
"squad" VARCHAR,
"npl" BIGINT,
"n_90s" DOUBLE,
"cmptot" BIGINT,
"atttot" BIGINT,
"totcmprt" DOUBLE,
"totdist" BIGINT,
"prgdist" BIGINT,
"cmpsh" BIGINT,
"attsh" BIGINT,
"cmpshrt" DOUBLE,
"cmpmed" BIGINT,
"attmed" BIGINT,
"cmpmedrt" DOUBLE,
"cmplng" BIGINT,
"attlng" BIGINT,
"cmplngrt" DOUBLE,
"ast" BIGINT,
"xa" DOUBLE,
"amxa" DOUBLE,
"kp" BIGINT,
"n_1_3car" BIGINT,
"ppa" BIGINT,
"crspa" BIGINT,
"progps" BIGINT
);
CREATE TABLE england_premier_league_squad_possession_22 (
"squad" VARCHAR,
"npl" BIGINT,
"poss" DOUBLE,
"tottouc" BIGINT,
"defpentouc" BIGINT,
"def3rdtouc" BIGINT,
"mid3rdtouc" BIGINT,
"att3rdtouc" BIGINT,
"attpentouc" BIGINT,
"livetouc" BIGINT,
"succdrib" BIGINT,
"attdrib" BIGINT,
"succdribrt" DOUBLE,
"n__pl" BIGINT,
"megs" BIGINT,
"totcarr" BIGINT,
"totdistcarr" BIGINT,
"prgdistcarr" BIGINT,
"progcarr" BIGINT,
"n_1_3carr" BIGINT,
"cpa" BIGINT,
"miscarr" BIGINT,
"discarr" BIGINT,
"targrec" BIGINT,
"sucrec" BIGINT,
"recrt" DOUBLE,
"progrec" BIGINT
);
CREATE TABLE england_premier_league_squad_shooting_22 (
"squad" VARCHAR,
"npl" BIGINT,
"n_90s" DOUBLE,
"glstot" BIGINT,
"totsh" BIGINT,
"totshtg" BIGINT,
"sotgrt" DOUBLE,
"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,
"gmxg" DOUBLE,
"npgmxg" DOUBLE
);
CREATE TABLE england_premier_league_stats_22 (
"squad" VARCHAR,
"npl" BIGINT,
"age" DOUBLE,
"poss" DOUBLE,
"mp" BIGINT,
"glstot" BIGINT,
"asttot" BIGINT,
"gmpktot" BIGINT,
"pktot" BIGINT,
"pkatttot" BIGINT,
"crdyel" BIGINT,
"crdred" BIGINT,
"glsper90" DOUBLE,
"astper90" DOUBLE,
"gpaper90" DOUBLE,
"gmpkper90" DOUBLE,
"gpampkper90" DOUBLE,
"xgtot" DOUBLE,
"npxgtot" DOUBLE,
"xatot" DOUBLE,
"npxgpxa" DOUBLE,
"xgper90" DOUBLE,
"xaper90" DOUBLE,
"xgpxaper90" DOUBLE,
"npxgper90" DOUBLE,
"npxgpxaper90" DOUBLE
);
CREATE TABLE england_premier_league_table_22 (
"rk" BIGINT,
"squad" VARCHAR,
"mp" BIGINT,
"w" BIGINT,
"d" BIGINT,
"l" BIGINT,
"gf" BIGINT,
"ga" BIGINT,
"gd" BIGINT,
"pts" BIGINT,
"pts_mp" DOUBLE,
"xg" DOUBLE,
"xga" DOUBLE,
"xgd" DOUBLE,
"xgd_90" DOUBLE,
"attendance" BIGINT,
"top_team_scorer" VARCHAR
);
Anyone who has the link will be able to view this.