Goalkeeper And Midfielder Statistics
Leveraging Statistical Data Of Goalkeepers and Midfielders
@kaggle.thedevastator_maximizing_player_performance_with_goalkeeper_an
Leveraging Statistical Data Of Goalkeepers and Midfielders
@kaggle.thedevastator_maximizing_player_performance_with_goalkeeper_an
CREATE TABLE def_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_4gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE fwd_perapp_5gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE gk_perapp_2gws (
"name" VARCHAR,
"app" BIGINT,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" BIGINT,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE gk_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" BIGINT,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_2gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_3gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_4gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
CREATE TABLE mid_perapp_5gws (
"name" VARCHAR,
"app" VARCHAR,
"minutes" BIGINT,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shots_in_box" DOUBLE,
"shots_outside_box" DOUBLE,
"headed_attempts" DOUBLE,
"big_chance" DOUBLE,
"big_chance_created" DOUBLE,
"goals" DOUBLE,
"goals_inside_box" DOUBLE,
"goals_outside_box" DOUBLE,
"headed_goal" DOUBLE,
"goal_involvement" BIGINT,
"key_pass" DOUBLE,
"big_chance_created_1" DOUBLE,
"assists" DOUBLE,
"crosses_tot" DOUBLE,
"crosses_succ" DOUBLE,
"crosses_succ_708309" BIGINT,
"exp_goals_xg" DOUBLE,
"non_penalty_xg_npxg" DOUBLE,
"exp_assists_xa" DOUBLE,
"exp_att_points_xatt" DOUBLE,
"exp_points_xpts" DOUBLE,
"exp_involvement_xgi" BIGINT,
"cost_m" DOUBLE,
"points" DOUBLE,
"bonus_points" DOUBLE,
"baseline_bps" DOUBLE,
"bps" DOUBLE,
"threat" DOUBLE,
"creativity" DOUBLE,
"influence" DOUBLE,
"total_passes" DOUBLE,
"accurate_passes" DOUBLE,
"pass_completion" BIGINT,
"opp_half_passes" DOUBLE,
"opp_half_accurate" DOUBLE,
"opp_half_pass" BIGINT,
"final_3rd_passes" DOUBLE,
"final_3rd_accurate" DOUBLE,
"final_3rd_pass" BIGINT,
"throughballs_tot" DOUBLE,
"throughballs_succ" DOUBLE,
"touches_all" DOUBLE,
"touches_box" DOUBLE,
"entries_box" DOUBLE,
"fouls_won_final_3rd" DOUBLE,
"penalty_box_entries" DOUBLE,
"fouls_won_box" DOUBLE,
"fouls_made" DOUBLE,
"corners_taken" DOUBLE,
"set_piece_into_box" DOUBLE,
"freekicks_indirect" DOUBLE,
"freekicks_taken" DOUBLE,
"freekicks_accurate" DOUBLE,
"freekicks_direct" DOUBLE,
"freekick_scored" DOUBLE,
"penalties_taken" DOUBLE,
"penalties_scored" DOUBLE,
"penalties_missed" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"exp_clean_sheets" VARCHAR,
"expected_goals_conceded" DOUBLE,
"shots_conceded" DOUBLE,
"shots_in_box_conceded" DOUBLE,
"shots_on_target_conceded" DOUBLE,
"headed_shots_conceded" DOUBLE,
"shots_conc_set_pieces" DOUBLE,
"big_chances_conceded" DOUBLE,
"tackles_tot" DOUBLE,
"tackles_won" DOUBLE,
"tackles_won_a21347" BIGINT,
"recoveries" DOUBLE,
"clearances" DOUBLE,
"blocks" DOUBLE,
"interceptions" DOUBLE,
"cbi" DOUBLE,
"shots_conc_set_pieces_1" DOUBLE,
"wins" DOUBLE,
"saves" DOUBLE,
"yellow_cards" DOUBLE,
"second_yellows" DOUBLE,
"red_cards" DOUBLE,
"offsides" DOUBLE,
"errors_lead_to_goal" DOUBLE,
"errors_lead_to_shot" DOUBLE,
"own_goals" DOUBLE,
"names" VARCHAR,
"position" VARCHAR,
"team" VARCHAR
);
Anyone who has the link will be able to view this.