Overwatch League Stats Lab
OWL2021 - Map and Player Statistics
@kaggle.sherrytp_overwatch_league_stats_lab
OWL2021 - Map and Player Statistics
@kaggle.sherrytp_overwatch_league_stats_lab
CREATE TABLE match_map_stats (
"round_start_time" TIMESTAMP,
"round_end_time" TIMESTAMP,
"stage" VARCHAR,
"match_id" BIGINT,
"game_number" BIGINT,
"match_winner" VARCHAR,
"map_winner" VARCHAR,
"map_loser" VARCHAR,
"map_name" VARCHAR,
"map_round" BIGINT,
"winning_team_final_map_score" BIGINT,
"losing_team_final_map_score" BIGINT,
"control_round_name" VARCHAR,
"attacker" VARCHAR,
"defender" VARCHAR,
"team_one_name" VARCHAR,
"team_two_name" VARCHAR,
"attacker_payload_distance" DOUBLE,
"defender_payload_distance" DOUBLE,
"attacker_time_banked" DOUBLE,
"defender_time_banked" DOUBLE,
"attacker_control_perecent" DOUBLE,
"defender_control_perecent" DOUBLE,
"attacker_round_end_score" BIGINT,
"defender_round_end_score" BIGINT
);
CREATE TABLE phs_2021_1 (
"start_time" TIMESTAMP,
"esports_match_id" BIGINT,
"tournament_title" VARCHAR,
"map_type" VARCHAR,
"map_name" VARCHAR,
"player_name" VARCHAR,
"team_name" VARCHAR,
"stat_name" VARCHAR,
"hero_name" VARCHAR,
"stat_amount" DOUBLE
);
Anyone who has the link will be able to view this.