Women's Football (European Leagues)
Team and Player Performance Statistics
@kaggle.thedevastator_uncovering_female_football_success_in_top_europe
Team and Player Performance Statistics
@kaggle.thedevastator_uncovering_female_football_success_in_top_europe
CREATE TABLE all_players_checkpoint (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" VARCHAR,
"born" DOUBLE,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"gls" BIGINT,
"ast" BIGINT,
"g_pk" BIGINT,
"pk" BIGINT,
"pkatt" BIGINT,
"crdy" BIGINT,
"crdr" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"xag" DOUBLE,
"player_id" VARCHAR,
"squad_id" VARCHAR,
"sh" DOUBLE,
"sot" DOUBLE,
"g_by_sh" DOUBLE,
"g_by_sot" DOUBLE,
"dist" DOUBLE,
"fk" DOUBLE,
"npxg_by_sh" DOUBLE,
"g_xg" DOUBLE,
"np_g_xg" DOUBLE,
"total_cmp" DOUBLE,
"total_att" DOUBLE,
"total_totdist" DOUBLE,
"total_prgdist" DOUBLE,
"xa" DOUBLE,
"a_xag" DOUBLE,
"kp" DOUBLE,
"lastthird" DOUBLE,
"ppa" DOUBLE,
"crspa" DOUBLE,
"prog" DOUBLE,
"sca" DOUBLE,
"sca_passlive" DOUBLE,
"sca_passdead" DOUBLE,
"sca_drib" DOUBLE,
"sca_sh" DOUBLE,
"sca_fld" DOUBLE,
"sca_def" DOUBLE,
"gca" DOUBLE,
"gca_passlive" DOUBLE,
"gca_passdead" DOUBLE,
"gca_drib" DOUBLE,
"gca_sh" DOUBLE,
"gca_fld" DOUBLE,
"gca_def" DOUBLE,
"tackles_tkl" DOUBLE,
"tackles_tklw" DOUBLE,
"tackles_def3rd" DOUBLE,
"tackles_mid3rd" DOUBLE,
"tackles_att3rd" DOUBLE,
"vsdribbles_tkl" DOUBLE,
"vsdribbles_att" DOUBLE,
"vsdribbles_past" DOUBLE,
"blocks_blocks" DOUBLE,
"blocks_sh" DOUBLE,
"blocks_pass" DOUBLE,
"int" DOUBLE,
"tkl_plus_int" DOUBLE,
"clr" DOUBLE,
"err" DOUBLE,
"touches_touches" DOUBLE,
"touches_defpen" DOUBLE,
"touches_def3rd" DOUBLE,
"touches_mid3rd" DOUBLE,
"touches_att3rd" DOUBLE,
"touches_attpen" DOUBLE,
"touches_live" DOUBLE,
"dribbles_succ" DOUBLE,
"dribbles_att" DOUBLE,
"dribbles_mis" DOUBLE,
"dribbles_dis" DOUBLE,
"receiving_rec" DOUBLE,
"receiving_prog" DOUBLE,
"mn_by_mp" DOUBLE,
"mn_by_start" DOUBLE,
"compl" BIGINT,
"subs" BIGINT,
"mn_by_sub" DOUBLE,
"unsub" DOUBLE,
"ts_ppm" DOUBLE,
"ts_ong" DOUBLE,
"ts_onga" DOUBLE,
"ts_diff" DOUBLE,
"ts_on_off" DOUBLE,
"ts_xg_onxg" DOUBLE,
"ts_xg_onxga" DOUBLE,
"ts_xg_xgdiff" DOUBLE,
"ts_xg_on_off" DOUBLE,
"n_2crdy" BIGINT,
"fls" DOUBLE
);
CREATE TABLE all_players (
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" VARCHAR,
"born" DOUBLE,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"gls" BIGINT,
"ast" BIGINT,
"g_pk" BIGINT,
"pk" BIGINT,
"pkatt" BIGINT,
"crdy" BIGINT,
"crdr" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"xag" DOUBLE,
"player_id" VARCHAR,
"squad_id" VARCHAR,
"sh" DOUBLE,
"sot" DOUBLE,
"g_by_sh" DOUBLE,
"g_by_sot" DOUBLE,
"dist" DOUBLE,
"fk" DOUBLE,
"npxg_by_sh" DOUBLE,
"g_xg" DOUBLE,
"np_g_xg" DOUBLE,
"total_cmp" BIGINT,
"total_att" DOUBLE,
"total_totdist" DOUBLE,
"total_prgdist" DOUBLE,
"xa" DOUBLE,
"a_xag" DOUBLE,
"kp" DOUBLE,
"lastthird" DOUBLE,
"ppa" DOUBLE,
"crspa" DOUBLE,
"prog" DOUBLE,
"sca" DOUBLE,
"sca_passlive" DOUBLE,
"sca_passdead" DOUBLE,
"sca_drib" DOUBLE,
"sca_sh" DOUBLE,
"sca_fld" DOUBLE,
"sca_def" DOUBLE,
"gca" DOUBLE,
"gca_passlive" DOUBLE,
"gca_passdead" DOUBLE,
"gca_drib" DOUBLE,
"gca_sh" DOUBLE,
"gca_fld" DOUBLE,
"gca_def" DOUBLE,
"tackles_tkl" DOUBLE,
"tackles_tklw" DOUBLE,
"tackles_def3rd" DOUBLE,
"tackles_mid3rd" DOUBLE,
"tackles_att3rd" DOUBLE,
"vsdribbles_tkl" DOUBLE,
"vsdribbles_att" DOUBLE,
"vsdribbles_past" DOUBLE,
"blocks_blocks" DOUBLE,
"blocks_sh" DOUBLE,
"blocks_pass" DOUBLE,
"int" DOUBLE,
"tkl_plus_int" DOUBLE,
"clr" DOUBLE,
"err" DOUBLE,
"touches_touches" DOUBLE,
"touches_defpen" DOUBLE,
"touches_def3rd" DOUBLE,
"touches_mid3rd" DOUBLE,
"touches_att3rd" DOUBLE,
"touches_attpen" DOUBLE,
"touches_live" DOUBLE,
"dribbles_succ" DOUBLE,
"dribbles_att" DOUBLE,
"dribbles_mis" DOUBLE,
"dribbles_dis" DOUBLE,
"receiving_rec" DOUBLE,
"receiving_prog" DOUBLE,
"mn_by_mp" DOUBLE,
"mn_by_start" DOUBLE,
"compl" BIGINT,
"subs" BIGINT,
"mn_by_sub" DOUBLE,
"unsub" DOUBLE,
"ts_ppm" DOUBLE,
"ts_ong" DOUBLE,
"ts_onga" DOUBLE,
"ts_diff" DOUBLE,
"ts_on_off" DOUBLE,
"ts_xg_onxg" DOUBLE,
"ts_xg_onxga" DOUBLE,
"ts_xg_xgdiff" DOUBLE,
"ts_xg_on_off" DOUBLE,
"n_2crdy" BIGINT,
"fls" DOUBLE
);
CREATE TABLE all_teams (
"squad" VARCHAR,
"n__pl" BIGINT,
"age" DOUBLE,
"poss" DOUBLE,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"gls" BIGINT,
"ast" BIGINT,
"g_pk" BIGINT,
"pk" BIGINT,
"pkatt" BIGINT,
"crdy" BIGINT,
"crdr" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"xag" DOUBLE,
"squad_id" VARCHAR,
"league_id" BIGINT,
"sh" BIGINT,
"sot" BIGINT,
"g_by_sh" DOUBLE,
"g_by_sot" DOUBLE,
"dist" DOUBLE,
"fk" BIGINT,
"npxg_by_sh" DOUBLE,
"g_xg" DOUBLE,
"np_g_xg" DOUBLE,
"total_cmp" BIGINT,
"total_att" BIGINT,
"total_totdist" BIGINT,
"total_prgdist" BIGINT,
"xa" DOUBLE,
"a_xag" DOUBLE,
"kp" BIGINT,
"lastthird" BIGINT,
"ppa" BIGINT,
"crspa" BIGINT,
"prog" BIGINT,
"sca" BIGINT,
"sca_passlive" BIGINT,
"sca_passdead" BIGINT,
"sca_drib" BIGINT,
"sca_sh" BIGINT,
"sca_fld" BIGINT,
"sca_def" BIGINT,
"gca" BIGINT,
"gca_passlive" BIGINT,
"gca_passdead" BIGINT,
"gca_drib" BIGINT,
"gca_sh" BIGINT,
"gca_fld" BIGINT,
"gca_def" BIGINT,
"tackles_tkl" BIGINT,
"tackles_tklw" BIGINT,
"tackles_def3rd" BIGINT,
"tackles_mid3rd" BIGINT,
"tackles_att3rd" BIGINT,
"vsdribbles_tkl" BIGINT,
"vsdribbles_att" BIGINT,
"vsdribbles_past" BIGINT,
"blocks_blocks" BIGINT,
"blocks_sh" BIGINT,
"blocks_pass" BIGINT,
"int" BIGINT,
"tkl_plus_int" BIGINT,
"clr" BIGINT,
"err" BIGINT,
"touches_touches" BIGINT,
"touches_defpen" BIGINT,
"touches_def3rd" BIGINT,
"touches_mid3rd" BIGINT,
"touches_att3rd" BIGINT,
"touches_attpen" BIGINT,
"touches_live" BIGINT,
"dribbles_succ" BIGINT,
"dribbles_att" BIGINT,
"dribbles_mis" BIGINT,
"dribbles_dis" BIGINT,
"receiving_rec" BIGINT,
"receiving_prog" BIGINT,
"mn_by_mp" BIGINT,
"mn_by_start" BIGINT,
"compl" BIGINT,
"subs" BIGINT,
"mn_by_sub" BIGINT,
"unsub" BIGINT,
"ts_ppm" DOUBLE,
"ts_ong" BIGINT,
"ts_onga" BIGINT,
"ts_diff" BIGINT,
"ts_xg_onxg" DOUBLE,
"ts_xg_onxga" DOUBLE,
"ts_xg_xgdiff" DOUBLE,
"n_2crdy" BIGINT,
"fls" BIGINT,
"fld" BIGINT,
"off" BIGINT,
"crs" BIGINT,
"tklw" BIGINT
);
CREATE TABLE gk_players (
"rk" BIGINT,
"player" VARCHAR,
"nation" VARCHAR,
"pos" VARCHAR,
"squad" VARCHAR,
"age" VARCHAR,
"born" BIGINT,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"ga" DOUBLE,
"sota" DOUBLE,
"saves" DOUBLE,
"w" BIGINT,
"d" BIGINT,
"l" BIGINT,
"cs" BIGINT,
"pkatt" BIGINT,
"pka" BIGINT,
"pksv" BIGINT,
"pkm" BIGINT,
"matches" VARCHAR,
"goals_fk" DOUBLE,
"goals_ck" DOUBLE,
"goals_og" DOUBLE,
"psxg" DOUBLE,
"psxg_sot" DOUBLE,
"psxg_3588aa" DOUBLE,
"launched_cmp" DOUBLE,
"launched_att" DOUBLE,
"passes_att" DOUBLE,
"passes_thr" DOUBLE,
"passes_avglen" DOUBLE,
"goal_kicks_att" DOUBLE,
"goal_kicks_avglen" DOUBLE,
"crosses_opp" DOUBLE,
"crosses_stp" DOUBLE,
"sweeper_opa" DOUBLE,
"sweeper_avgdist" DOUBLE,
"player_id" VARCHAR,
"nation_id" VARCHAR,
"squad_id" VARCHAR,
"matches_id" VARCHAR
);
CREATE TABLE gk_teams (
"squad" VARCHAR,
"n__pl" BIGINT,
"mp" BIGINT,
"starts" BIGINT,
"min" BIGINT,
"ga" BIGINT,
"sota" BIGINT,
"saves" BIGINT,
"w" BIGINT,
"d" BIGINT,
"l" BIGINT,
"cs" BIGINT,
"pkatt" BIGINT,
"pka" BIGINT,
"pksv" BIGINT,
"pkm" BIGINT,
"squad_id" VARCHAR,
"league_id" BIGINT,
"goals_ga" BIGINT,
"goals_pka" BIGINT,
"goals_fk" BIGINT,
"goals_ck" BIGINT,
"goals_og" BIGINT,
"psxg" DOUBLE,
"psxg_sot" DOUBLE,
"psxg_3588aa" DOUBLE,
"launched_cmp" BIGINT,
"launched_att" BIGINT,
"passes_att" BIGINT,
"passes_thr" BIGINT,
"passes_avglen" DOUBLE,
"goal_kicks_att" BIGINT,
"goal_kicks_avglen" DOUBLE,
"crosses_opp" BIGINT,
"crosses_stp" BIGINT,
"sweeper_opa" BIGINT,
"sweeper_avgdist" DOUBLE
);
CREATE TABLE matches_checkpoint (
"wk" BIGINT,
"day" VARCHAR,
"date" TIMESTAMP,
"time" VARCHAR,
"home" VARCHAR,
"xghome" DOUBLE,
"score" VARCHAR,
"xgaway" DOUBLE,
"away" VARCHAR,
"home_id" VARCHAR,
"away_id" VARCHAR,
"match_id" VARCHAR,
"league_id" BIGINT,
"xphome" DOUBLE,
"xpaway" DOUBLE,
"scorehome" BIGINT,
"scoreaway" BIGINT
);
CREATE TABLE matches (
"wk" BIGINT,
"day" VARCHAR,
"date" TIMESTAMP,
"time" VARCHAR,
"home" VARCHAR,
"xghome" DOUBLE,
"score" VARCHAR,
"xgaway" DOUBLE,
"away" VARCHAR,
"home_id" VARCHAR,
"away_id" VARCHAR,
"match_id" VARCHAR,
"league_id" BIGINT,
"xphome" DOUBLE,
"xpaway" DOUBLE,
"scorehome" BIGINT,
"scoreaway" BIGINT
);
Anyone who has the link will be able to view this.