Overwatch 2 Statistics
overwatch 2 seasons 1-4 statistics + quick play
@kaggle.mykhailokachan_overwatch_2_statistics
overwatch 2 seasons 1-4 statistics + quick play
@kaggle.mykhailokachan_overwatch_2_statistics
CREATE TABLE ow2_quickplay_heroes_stats_2023_05_06 (
"hero" VARCHAR,
"skill_tier" VARCHAR,
"kda_ratio" DOUBLE,
"pick_rate" DOUBLE,
"win_rate" DOUBLE,
"eliminations_10min" DOUBLE,
"objective_kills_10min" DOUBLE,
"objective_time_10min" BIGINT,
"damage_10min" BIGINT,
"healing_10min" DOUBLE,
"deaths_10min" DOUBLE,
"scoped_accuracy" DOUBLE,
"biotic_grenade_kills_10min" DOUBLE,
"enemies_slept_10min" DOUBLE,
"healing_amplified_10min" DOUBLE,
"nano_boost_assists_10min" DOUBLE,
"blaster_kills_10min" DOUBLE,
"damage_amplified_10min" DOUBLE,
"players_resurrected_10min" DOUBLE,
"final_blows_10min" DOUBLE,
"solo_kills_10min" DOUBLE,
"weapon_accuracy" DOUBLE,
"crit_accuracy" DOUBLE,
"deadeye_kills_10min" DOUBLE,
"magnetic_grenade_attaches" DOUBLE,
"magnetic_grenade_kills_10min" DOUBLE,
"swift_strike_resets_10min" DOUBLE,
"damage_reflected_10min" DOUBLE,
"ultimates_reflected_10min" DOUBLE,
"dragonblade_kills_10min" DOUBLE,
"kunai_kills_10min" DOUBLE,
"effects_cleansed_10min" DOUBLE,
"kitsune_rush_assists_10min" DOUBLE,
"secondary_accuracy" DOUBLE,
"biotic_orb_kills_10min" DOUBLE,
"ally_coalescence_efficiency" DOUBLE,
"enemy_coalescence_efficiency" DOUBLE,
"coalescence_kills_10min" DOUBLE,
"objective_contest_time_10min" DOUBLE,
"charge_kills_10min" DOUBLE,
"fire_strike_kills_10min" DOUBLE,
"earthshatter_kills_10min" DOUBLE,
"long_range_kills_10min" DOUBLE,
"storm_arrow_kills_10min" DOUBLE,
"recon_assists_10min" DOUBLE,
"dragonstrike_kills_10min" DOUBLE,
"venom_mine_kills_10min" DOUBLE,
"helix_rocket_accuracy" DOUBLE,
"helix_rocket_kills_10min" DOUBLE,
"tactical_visor_kills_10min" DOUBLE,
"charged_volley_accuracy" DOUBLE,
"charged_volley_kills_10min" DOUBLE,
"transcendence_healing_10min" DOUBLE,
"knockbacks_10min" DOUBLE,
"sound_barriers_10min" DOUBLE,
"micro_missile_kills_10min" DOUBLE,
"call_mech_kills_10min" DOUBLE,
"self_destruct_kills_10min" DOUBLE,
"direct_hits" DOUBLE,
"concussion_mine_kills_10min" DOUBLE,
"enemies_trapped_10min" DOUBLE,
"coach_gun_kills_10min" DOUBLE,
"dynamite_kills_10min" DOUBLE,
"bob_kills_10min" DOUBLE,
"self_healing_10min" DOUBLE,
"low_health_recalls_10min" DOUBLE,
"pulse_bombs_stuck_10min" DOUBLE,
"pulse_bomb_kills_10min" DOUBLE,
"chain_hook_kills_10min" DOUBLE,
"chain_hook_accuracy" DOUBLE,
"whole_hog_kills_10min" DOUBLE,
"primary_accuracy" DOUBLE,
"high_energy_kills_10min" DOUBLE,
"average_energy" DOUBLE,
"graviton_surge_kills_10min" DOUBLE,
"death_blossom_kills_10min" DOUBLE,
"healing_accuracy" DOUBLE,
"deaths_prevented_10min" DOUBLE,
"amp_matrix_assists_10min" DOUBLE,
"energy_javelin_kills_10min" DOUBLE,
"javelin_spin_kills_10min" DOUBLE,
"terra_surge_kills_10min" DOUBLE,
"airtime" DOUBLE,
"barrage_kills_10min" DOUBLE,
"accretion_kills_10min" DOUBLE,
"overhealth_10min" DOUBLE,
"gravitic_flux_kills_10min" DOUBLE,
"rocket_punch_kills_10min" DOUBLE,
"seismic_slam_kills_10min" DOUBLE,
"meteor_strike_kills_10min" DOUBLE,
"inspire_uptime" DOUBLE,
"icicle_accuracy_10min" DOUBLE,
"icicle_crit_accuracy_10min" DOUBLE,
"enemies_frozen_10min" DOUBLE,
"blizzard_kills_10min" DOUBLE,
"jump_pack_kills_10min" DOUBLE,
"primal_rage_kills_10min" DOUBLE,
"recon_kills_10min" DOUBLE,
"assault_kills_10min" DOUBLE,
"tactical_grenade_kills_10min" DOUBLE
);
CREATE TABLE ow2_season_01_final_heroes_stats_2023_05_06 (
"hero" VARCHAR,
"skill_tier" VARCHAR,
"kda_ratio" DOUBLE,
"pick_rate" DOUBLE,
"win_rate" DOUBLE,
"eliminations_10min" DOUBLE,
"objective_kills_10min" DOUBLE,
"objective_time_10min" BIGINT,
"damage_10min" BIGINT,
"healing_10min" DOUBLE,
"deaths_10min" DOUBLE,
"scoped_accuracy" DOUBLE,
"biotic_grenade_kills_10min" DOUBLE,
"enemies_slept_10min" DOUBLE,
"healing_amplified_10min" DOUBLE,
"nano_boost_assists_10min" DOUBLE,
"blaster_kills_10min" DOUBLE,
"damage_amplified_10min" DOUBLE,
"players_resurrected_10min" DOUBLE,
"final_blows_10min" DOUBLE,
"solo_kills_10min" DOUBLE,
"weapon_accuracy" DOUBLE,
"crit_accuracy" DOUBLE,
"deadeye_kills_10min" DOUBLE,
"magnetic_grenade_attaches" DOUBLE,
"magnetic_grenade_kills_10min" DOUBLE,
"swift_strike_resets_10min" DOUBLE,
"damage_reflected_10min" DOUBLE,
"ultimates_reflected_10min" VARCHAR,
"dragonblade_kills_10min" DOUBLE,
"kunai_kills_10min" DOUBLE,
"effects_cleansed_10min" DOUBLE,
"kitsune_rush_assists_10min" DOUBLE,
"secondary_accuracy" DOUBLE,
"biotic_orb_kills_10min" DOUBLE,
"ally_coalescence_efficiency" DOUBLE,
"enemy_coalescence_efficiency" DOUBLE,
"coalescence_kills_10min" DOUBLE,
"objective_contest_time_10min" DOUBLE,
"charge_kills_10min" DOUBLE,
"fire_strike_kills_10min" DOUBLE,
"earthshatter_kills_10min" DOUBLE,
"long_range_kills_10min" DOUBLE,
"storm_arrow_kills_10min" DOUBLE,
"recon_assists_10min" DOUBLE,
"dragonstrike_kills_10min" DOUBLE,
"venom_mine_kills_10min" DOUBLE,
"helix_rocket_accuracy" DOUBLE,
"helix_rocket_kills_10min" DOUBLE,
"tactical_visor_kills_10min" DOUBLE,
"charged_volley_accuracy" DOUBLE,
"charged_volley_kills_10min" DOUBLE,
"transcendence_healing_10min" DOUBLE,
"knockbacks_10min" DOUBLE,
"sound_barriers_10min" DOUBLE,
"micro_missile_kills_10min" DOUBLE,
"call_mech_kills_10min" DOUBLE,
"self_destruct_kills_10min" DOUBLE,
"direct_hits" DOUBLE,
"concussion_mine_kills_10min" DOUBLE,
"enemies_trapped_10min" DOUBLE,
"coach_gun_kills_10min" DOUBLE,
"dynamite_kills_10min" DOUBLE,
"bob_kills_10min" DOUBLE,
"self_healing_10min" DOUBLE,
"low_health_recalls_10min" DOUBLE,
"pulse_bombs_stuck_10min" DOUBLE,
"pulse_bomb_kills_10min" DOUBLE,
"chain_hook_kills_10min" DOUBLE,
"chain_hook_accuracy" DOUBLE,
"whole_hog_kills_10min" DOUBLE,
"primary_accuracy" DOUBLE,
"high_energy_kills_10min" DOUBLE,
"average_energy" DOUBLE,
"graviton_surge_kills_10min" DOUBLE,
"death_blossom_kills_10min" DOUBLE,
"healing_accuracy" DOUBLE,
"deaths_prevented_10min" DOUBLE,
"amp_matrix_assists_10min" DOUBLE,
"energy_javelin_kills_10min" DOUBLE,
"terra_surge_kills_10min" DOUBLE,
"airtime" DOUBLE,
"barrage_kills_10min" DOUBLE,
"accretion_kills_10min" DOUBLE,
"overhealth_10min" DOUBLE,
"gravitic_flux_kills_10min" DOUBLE,
"rocket_punch_kills_10min" DOUBLE,
"seismic_slam_kills_10min" DOUBLE,
"meteor_strike_kills_10min" DOUBLE,
"inspire_uptime" DOUBLE,
"icicle_accuracy_10min" DOUBLE,
"icicle_crit_accuracy_10min" DOUBLE,
"enemies_frozen_10min" DOUBLE,
"blizzard_kills_10min" DOUBLE,
"jump_pack_kills_10min" DOUBLE,
"primal_rage_kills_10min" DOUBLE,
"recon_kills_10min" DOUBLE,
"assault_kills_10min" DOUBLE,
"tactical_grenade_kills_10min" DOUBLE,
"artillery_kills_10min" DOUBLE
);
CREATE TABLE ow2_season_02_final_heroes_stats_2023_05_06 (
"hero" VARCHAR,
"skill_tier" VARCHAR,
"kda_ratio" DOUBLE,
"pick_rate" DOUBLE,
"win_rate" DOUBLE,
"eliminations_10min" DOUBLE,
"objective_kills_10min" DOUBLE,
"objective_time_10min" BIGINT,
"damage_10min" BIGINT,
"healing_10min" DOUBLE,
"deaths_10min" DOUBLE,
"scoped_accuracy" DOUBLE,
"biotic_grenade_kills_10min" DOUBLE,
"enemies_slept_10min" DOUBLE,
"healing_amplified_10min" DOUBLE,
"nano_boost_assists_10min" DOUBLE,
"blaster_kills_10min" DOUBLE,
"damage_amplified_10min" DOUBLE,
"players_resurrected_10min" DOUBLE,
"final_blows_10min" DOUBLE,
"solo_kills_10min" DOUBLE,
"weapon_accuracy" DOUBLE,
"crit_accuracy" DOUBLE,
"deadeye_kills_10min" DOUBLE,
"magnetic_grenade_attaches" DOUBLE,
"magnetic_grenade_kills_10min" DOUBLE,
"swift_strike_resets_10min" DOUBLE,
"damage_reflected_10min" DOUBLE,
"ultimates_reflected_10min" VARCHAR,
"dragonblade_kills_10min" DOUBLE,
"kunai_kills_10min" DOUBLE,
"effects_cleansed_10min" DOUBLE,
"kitsune_rush_assists_10min" DOUBLE,
"secondary_accuracy" DOUBLE,
"biotic_orb_kills_10min" DOUBLE,
"ally_coalescence_efficiency" DOUBLE,
"enemy_coalescence_efficiency" DOUBLE,
"coalescence_kills_10min" DOUBLE,
"objective_contest_time_10min" DOUBLE,
"charge_kills_10min" DOUBLE,
"fire_strike_kills_10min" DOUBLE,
"earthshatter_kills_10min" DOUBLE,
"long_range_kills_10min" DOUBLE,
"storm_arrow_kills_10min" DOUBLE,
"recon_assists_10min" DOUBLE,
"dragonstrike_kills_10min" DOUBLE,
"venom_mine_kills_10min" DOUBLE,
"helix_rocket_accuracy" DOUBLE,
"helix_rocket_kills_10min" DOUBLE,
"tactical_visor_kills_10min" DOUBLE,
"charged_volley_accuracy" DOUBLE,
"charged_volley_kills_10min" DOUBLE,
"transcendence_healing_10min" DOUBLE,
"knockbacks_10min" DOUBLE,
"sound_barriers_10min" DOUBLE,
"micro_missile_kills_10min" DOUBLE,
"call_mech_kills_10min" DOUBLE,
"self_destruct_kills_10min" DOUBLE,
"direct_hits" DOUBLE,
"concussion_mine_kills_10min" DOUBLE,
"enemies_trapped_10min" DOUBLE,
"coach_gun_kills_10min" DOUBLE,
"dynamite_kills_10min" DOUBLE,
"bob_kills_10min" DOUBLE,
"self_healing_10min" DOUBLE,
"low_health_recalls_10min" DOUBLE,
"pulse_bombs_stuck_10min" DOUBLE,
"pulse_bomb_kills_10min" DOUBLE,
"chain_hook_kills_10min" DOUBLE,
"chain_hook_accuracy" DOUBLE,
"whole_hog_kills_10min" DOUBLE,
"primary_accuracy" DOUBLE,
"high_energy_kills_10min" DOUBLE,
"average_energy" DOUBLE,
"graviton_surge_kills_10min" DOUBLE,
"death_blossom_kills_10min" DOUBLE,
"healing_accuracy" DOUBLE,
"deaths_prevented_10min" DOUBLE,
"amp_matrix_assists_10min" DOUBLE,
"energy_javelin_kills_10min" DOUBLE,
"javelin_spin_kills_10min" DOUBLE,
"terra_surge_kills_10min" DOUBLE,
"airtime" DOUBLE,
"barrage_kills_10min" DOUBLE,
"accretion_kills_10min" DOUBLE,
"overhealth_10min" DOUBLE,
"gravitic_flux_kills_10min" DOUBLE,
"rocket_punch_kills_10min" DOUBLE,
"seismic_slam_kills_10min" DOUBLE,
"meteor_strike_kills_10min" DOUBLE,
"inspire_uptime" DOUBLE,
"icicle_accuracy_10min" DOUBLE,
"icicle_crit_accuracy_10min" DOUBLE,
"enemies_frozen_10min" DOUBLE,
"blizzard_kills_10min" DOUBLE,
"jump_pack_kills_10min" DOUBLE,
"primal_rage_kills_10min" DOUBLE,
"recon_kills_10min" DOUBLE,
"assault_kills_10min" DOUBLE,
"tactical_grenade_kills_10min" DOUBLE
);
CREATE TABLE ow2_season_03_final_heroes_stats_2023_05_06 (
"hero" VARCHAR,
"skill_tier" VARCHAR,
"kda_ratio" DOUBLE,
"pick_rate" DOUBLE,
"win_rate" DOUBLE,
"eliminations_10min" DOUBLE,
"objective_kills_10min" DOUBLE,
"objective_time_10min" BIGINT,
"damage_10min" BIGINT,
"healing_10min" DOUBLE,
"deaths_10min" DOUBLE,
"scoped_accuracy" DOUBLE,
"biotic_grenade_kills_10min" DOUBLE,
"enemies_slept_10min" DOUBLE,
"healing_amplified_10min" DOUBLE,
"nano_boost_assists_10min" DOUBLE,
"blaster_kills_10min" DOUBLE,
"damage_amplified_10min" DOUBLE,
"players_resurrected_10min" DOUBLE,
"final_blows_10min" DOUBLE,
"solo_kills_10min" DOUBLE,
"weapon_accuracy" DOUBLE,
"crit_accuracy" DOUBLE,
"deadeye_kills_10min" DOUBLE,
"magnetic_grenade_attaches" DOUBLE,
"magnetic_grenade_kills_10min" DOUBLE,
"swift_strike_resets_10min" DOUBLE,
"damage_reflected_10min" DOUBLE,
"ultimates_reflected_10min" DOUBLE,
"dragonblade_kills_10min" DOUBLE,
"kunai_kills_10min" DOUBLE,
"effects_cleansed_10min" DOUBLE,
"kitsune_rush_assists_10min" DOUBLE,
"secondary_accuracy" DOUBLE,
"biotic_orb_kills_10min" DOUBLE,
"ally_coalescence_efficiency" DOUBLE,
"enemy_coalescence_efficiency" DOUBLE,
"coalescence_kills_10min" DOUBLE,
"objective_contest_time_10min" DOUBLE,
"charge_kills_10min" DOUBLE,
"fire_strike_kills_10min" DOUBLE,
"earthshatter_kills_10min" DOUBLE,
"long_range_kills_10min" DOUBLE,
"storm_arrow_kills_10min" DOUBLE,
"recon_assists_10min" DOUBLE,
"dragonstrike_kills_10min" DOUBLE,
"venom_mine_kills_10min" DOUBLE,
"helix_rocket_accuracy" DOUBLE,
"helix_rocket_kills_10min" DOUBLE,
"tactical_visor_kills_10min" DOUBLE,
"charged_volley_accuracy" DOUBLE,
"charged_volley_kills_10min" DOUBLE,
"transcendence_healing_10min" DOUBLE,
"knockbacks_10min" DOUBLE,
"sound_barriers_10min" DOUBLE,
"micro_missile_kills_10min" DOUBLE,
"call_mech_kills_10min" DOUBLE,
"self_destruct_kills_10min" DOUBLE,
"direct_hits" DOUBLE,
"concussion_mine_kills_10min" DOUBLE,
"enemies_trapped_10min" DOUBLE,
"coach_gun_kills_10min" DOUBLE,
"dynamite_kills_10min" DOUBLE,
"bob_kills_10min" DOUBLE,
"self_healing_10min" DOUBLE,
"low_health_recalls_10min" DOUBLE,
"pulse_bombs_stuck_10min" DOUBLE,
"pulse_bomb_kills_10min" DOUBLE,
"chain_hook_kills_10min" DOUBLE,
"chain_hook_accuracy" DOUBLE,
"whole_hog_kills_10min" DOUBLE,
"primary_accuracy" DOUBLE,
"high_energy_kills_10min" DOUBLE,
"average_energy" DOUBLE,
"graviton_surge_kills_10min" DOUBLE,
"death_blossom_kills_10min" DOUBLE,
"healing_accuracy" DOUBLE,
"deaths_prevented_10min" DOUBLE,
"amp_matrix_assists_10min" DOUBLE,
"energy_javelin_kills_10min" DOUBLE,
"javelin_spin_kills_10min" DOUBLE,
"terra_surge_kills_10min" DOUBLE,
"airtime" DOUBLE,
"barrage_kills_10min" DOUBLE,
"accretion_kills_10min" DOUBLE,
"overhealth_10min" DOUBLE,
"gravitic_flux_kills_10min" DOUBLE,
"rocket_punch_kills_10min" DOUBLE,
"seismic_slam_kills_10min" DOUBLE,
"meteor_strike_kills_10min" DOUBLE,
"inspire_uptime" DOUBLE,
"icicle_accuracy_10min" DOUBLE,
"icicle_crit_accuracy_10min" DOUBLE,
"enemies_frozen_10min" DOUBLE,
"blizzard_kills_10min" DOUBLE,
"jump_pack_kills_10min" DOUBLE,
"primal_rage_kills_10min" DOUBLE,
"recon_kills_10min" DOUBLE,
"assault_kills_10min" DOUBLE,
"tactical_grenade_kills_10min" DOUBLE
);
CREATE TABLE ow2_season_04_final_heroes_stats_2023_06_27 (
"hero" VARCHAR,
"skill_tier" VARCHAR,
"kda_ratio" DOUBLE,
"pick_rate" DOUBLE,
"win_rate" DOUBLE,
"eliminations_10min" DOUBLE,
"objective_kills_10min" DOUBLE,
"objective_time_10min" BIGINT,
"damage_10min" BIGINT,
"healing_10min" DOUBLE,
"deaths_10min" DOUBLE,
"scoped_accuracy" DOUBLE,
"biotic_grenade_kills_10min" DOUBLE,
"enemies_slept_10min" DOUBLE,
"healing_amplified_10min" DOUBLE,
"nano_boost_assists_10min" DOUBLE,
"blaster_kills_10min" DOUBLE,
"damage_amplified_10min" DOUBLE,
"players_resurrected_10min" DOUBLE,
"final_blows_10min" DOUBLE,
"solo_kills_10min" DOUBLE,
"weapon_accuracy" DOUBLE,
"swift_strike_resets_10min" DOUBLE,
"damage_reflected_10min" DOUBLE,
"ultimates_reflected_10min" DOUBLE,
"dragonblade_kills_10min" DOUBLE,
"crit_accuracy" DOUBLE,
"deadeye_kills_10min" DOUBLE,
"magnetic_grenade_attaches" DOUBLE,
"magnetic_grenade_kills_10min" DOUBLE,
"kunai_kills_10min" DOUBLE,
"effects_cleansed_10min" DOUBLE,
"kitsune_rush_assists_10min" DOUBLE,
"long_range_kills_10min" DOUBLE,
"storm_arrow_kills_10min" DOUBLE,
"recon_assists_10min" DOUBLE,
"dragonstrike_kills_10min" DOUBLE,
"secondary_accuracy" DOUBLE,
"biotic_orb_kills_10min" DOUBLE,
"ally_coalescence_efficiency" DOUBLE,
"enemy_coalescence_efficiency" DOUBLE,
"coalescence_kills_10min" DOUBLE,
"objective_contest_time_10min" DOUBLE,
"charge_kills_10min" DOUBLE,
"fire_strike_kills_10min" DOUBLE,
"earthshatter_kills_10min" DOUBLE,
"venom_mine_kills_10min" DOUBLE,
"helix_rocket_accuracy" DOUBLE,
"helix_rocket_kills_10min" DOUBLE,
"tactical_visor_kills_10min" DOUBLE,
"charged_volley_accuracy" DOUBLE,
"charged_volley_kills_10min" DOUBLE,
"transcendence_healing_10min" DOUBLE,
"micro_missile_kills_10min" DOUBLE,
"call_mech_kills_10min" DOUBLE,
"self_destruct_kills_10min" DOUBLE,
"knockbacks_10min" DOUBLE,
"sound_barriers_10min" DOUBLE,
"self_healing_10min" DOUBLE,
"low_health_recalls_10min" DOUBLE,
"pulse_bombs_stuck_10min" DOUBLE,
"pulse_bomb_kills_10min" DOUBLE,
"direct_hits" DOUBLE,
"concussion_mine_kills_10min" DOUBLE,
"enemies_trapped_10min" DOUBLE,
"coach_gun_kills_10min" DOUBLE,
"dynamite_kills_10min" DOUBLE,
"bob_kills_10min" DOUBLE,
"primary_accuracy" DOUBLE,
"high_energy_kills_10min" DOUBLE,
"average_energy" DOUBLE,
"graviton_surge_kills_10min" DOUBLE,
"healing_accuracy" DOUBLE,
"deaths_prevented_10min" DOUBLE,
"amp_matrix_assists_10min" DOUBLE,
"chain_hook_kills_10min" DOUBLE,
"chain_hook_accuracy" DOUBLE,
"whole_hog_kills_10min" DOUBLE,
"death_blossom_kills_10min" DOUBLE,
"airtime" DOUBLE,
"barrage_kills_10min" DOUBLE,
"accretion_kills_10min" DOUBLE,
"overhealth_10min" DOUBLE,
"gravitic_flux_kills_10min" DOUBLE,
"rocket_punch_kills_10min" DOUBLE,
"seismic_slam_kills_10min" DOUBLE,
"meteor_strike_kills_10min" DOUBLE,
"inspire_uptime" DOUBLE,
"icicle_accuracy_10min" DOUBLE,
"icicle_crit_accuracy_10min" DOUBLE,
"enemies_frozen_10min" DOUBLE,
"blizzard_kills_10min" DOUBLE,
"energy_javelin_kills_10min" DOUBLE,
"javelin_spin_kills_10min" DOUBLE,
"terra_surge_kills_10min" DOUBLE,
"jump_pack_kills_10min" DOUBLE,
"primal_rage_kills_10min" DOUBLE,
"enemies_hacked_10min" DOUBLE,
"low_health_teleports_10min" DOUBLE,
"emp_kills_10min" DOUBLE
);
Anyone who has the link will be able to view this.