Baselight
Sign In

Overwatch 2 Statistics

overwatch 2 seasons 1-4 statistics + quick play

@kaggle.mykhailokachan_overwatch_2_statistics

Loading...
Loading...

About this Dataset

Overwatch 2 Statistics

This dataset is built on data from Overbuff with the help of python and selenium. Development environment - Jupyter Notebook.

The tables contain the data for competitive seasons 1-4 and for quick play for each hero and rank along with the standard statistics (common to each hero as well as information belonging to a specific hero).

Note: data for some columns are missing on Overbuff site (there is '—' instead of a specific value), so they were dropped: Scoped Crits for Ashe and Widowmaker, Rip Tire Kills for Junkrat, Minefield Kills for Wrecking Ball. 'Self Healing' column for Bastion was dropped too as Bastion doesn't have this property anymore in OW2. Also, there are no values for "Javelin Spin Kills / 10min" for Orisa in season 1 (the column was dropped).
Overall, all missing values were cleaned.

Attention: Overbuff doesn't contain info about OW 1 competitive seasons (when you change a skill tier, the data isn't changed). If you know a site where it's possible to get this data, please, leave a comment. Thank you!

The code on GitHub .

All procedure is done in 5 stages:

The procedure to fetch the data takes 7 minutes on average.

This project and code were born from this GitHub code.

Tables

Ow2 Quickplay Heroes Stats 2023–05–06

@kaggle.mykhailokachan_overwatch_2_statistics.ow2_quickplay_heroes_stats_2023_05_06
  • 121.9 kB
  • 288 rows
  • 131 columns
Loading... 
CREATE TABLE ow2_quickplay_heroes_stats_2023_05_06 (
  "hero" VARCHAR,
  "skill_tier" VARCHAR,
  "kda_ratio" DOUBLE,
  "pick_rate" DOUBLE  -- Pick Rate, %,
  "win_rate" DOUBLE  -- Win Rate, %,
  "eliminations_10min" DOUBLE  -- Eliminations / 10min,
  "objective_kills_10min" DOUBLE  -- Objective Kills / 10min,
  "objective_time_10min" BIGINT  -- Objective Time / 10min,
  "damage_10min" BIGINT  -- Damage / 10min,
  "healing_10min" DOUBLE  -- Healing / 10min,
  "deaths_10min" DOUBLE  -- Deaths / 10min,
  "scoped_accuracy" DOUBLE  -- Scoped Accuracy, %,
  "biotic_grenade_kills_10min" DOUBLE  -- Biotic Grenade Kills / 10min,
  "enemies_slept_10min" DOUBLE  -- Enemies Slept / 10min,
  "healing_amplified_10min" DOUBLE  -- Healing Amplified / 10min,
  "nano_boost_assists_10min" DOUBLE  -- Nano Boost Assists / 10min,
  "blaster_kills_10min" DOUBLE  -- Blaster Kills / 10min,
  "damage_amplified_10min" DOUBLE  -- Damage Amplified / 10min,
  "players_resurrected_10min" DOUBLE  -- Players Resurrected / 10min,
  "final_blows_10min" DOUBLE  -- Final Blows / 10min,
  "solo_kills_10min" DOUBLE  -- Solo Kills / 10min,
  "weapon_accuracy" DOUBLE  -- Weapon Accuracy, %,
  "crit_accuracy" DOUBLE  -- Crit Accuracy, %,
  "deadeye_kills_10min" DOUBLE  -- Deadeye Kills / 10min,
  "magnetic_grenade_attaches" DOUBLE,
  "magnetic_grenade_kills_10min" DOUBLE  -- Magnetic Grenade Kills / 10min,
  "swift_strike_resets_10min" DOUBLE  -- Swift Strike Resets / 10min,
  "damage_reflected_10min" DOUBLE  -- Damage Reflected / 10min,
  "ultimates_reflected_10min" DOUBLE  -- Ultimates Reflected / 10min,
  "dragonblade_kills_10min" DOUBLE  -- Dragonblade Kills / 10min,
  "kunai_kills_10min" DOUBLE  -- Kunai Kills / 10min,
  "effects_cleansed_10min" DOUBLE  -- Effects Cleansed / 10min,
  "kitsune_rush_assists_10min" DOUBLE  -- Kitsune Rush Assists / 10min,
  "secondary_accuracy" DOUBLE  -- Secondary Accuracy, %,
  "biotic_orb_kills_10min" DOUBLE  -- Biotic Orb Kills / 10min,
  "ally_coalescence_efficiency" DOUBLE  -- Ally Coalescence Efficiency, %,
  "enemy_coalescence_efficiency" DOUBLE  -- Enemy Coalescence Efficiency, %,
  "coalescence_kills_10min" DOUBLE  -- Coalescence Kills / 10min,
  "objective_contest_time_10min" DOUBLE  -- Objective Contest Time / 10min,
  "charge_kills_10min" DOUBLE  -- Charge Kills / 10min,
  "fire_strike_kills_10min" DOUBLE  -- Fire Strike Kills / 10min,
  "earthshatter_kills_10min" DOUBLE  -- Earthshatter Kills / 10min,
  "long_range_kills_10min" DOUBLE  -- Long Range Kills / 10min,
  "storm_arrow_kills_10min" DOUBLE  -- Storm Arrow Kills / 10min,
  "recon_assists_10min" DOUBLE  -- Recon Assists / 10min,
  "dragonstrike_kills_10min" DOUBLE  -- Dragonstrike Kills / 10min,
  "venom_mine_kills_10min" DOUBLE  -- Venom Mine Kills / 10min,
  "helix_rocket_accuracy" DOUBLE  -- Helix Rocket Accuracy, %,
  "helix_rocket_kills_10min" DOUBLE  -- Helix Rocket Kills / 10min,
  "tactical_visor_kills_10min" DOUBLE  -- Tactical Visor Kills / 10min,
  "charged_volley_accuracy" DOUBLE  -- Charged Volley Accuracy, %,
  "charged_volley_kills_10min" DOUBLE  -- Charged Volley Kills / 10min,
  "transcendence_healing_10min" DOUBLE  -- Transcendence Healing / 10min,
  "knockbacks_10min" DOUBLE  -- Knockbacks / 10min,
  "sound_barriers_10min" DOUBLE  -- Sound Barriers / 10min,
  "micro_missile_kills_10min" DOUBLE  -- Micro Missile Kills, % / 10min,
  "call_mech_kills_10min" DOUBLE  -- Call Mech Kills / 10min,
  "self_destruct_kills_10min" DOUBLE  -- Self-Destruct Kills / 10min,
  "direct_hits" DOUBLE,
  "concussion_mine_kills_10min" DOUBLE  -- Concussion Mine Kills / 10min,
  "enemies_trapped_10min" DOUBLE  -- Enemies Trapped / 10min,
  "coach_gun_kills_10min" DOUBLE  -- Coach Gun Kills / 10min,
  "dynamite_kills_10min" DOUBLE  -- Dynamite Kills / 10min,
  "bob_kills_10min" DOUBLE  -- Bob Kills / 10min,
  "self_healing_10min" DOUBLE  -- Self Healing / 10min,
  "low_health_recalls_10min" DOUBLE  -- Low Health Recalls / 10min,
  "pulse_bombs_stuck_10min" DOUBLE  -- Pulse Bombs Stuck / 10min,
  "pulse_bomb_kills_10min" DOUBLE  -- Pulse Bomb Kills / 10min,
  "chain_hook_kills_10min" DOUBLE  -- Chain Hook Kills / 10min,
  "chain_hook_accuracy" DOUBLE  -- Chain Hook Accuracy, %,
  "whole_hog_kills_10min" DOUBLE  -- Whole Hog Kills / 10min,
  "primary_accuracy" DOUBLE  -- Primary Accuracy, %,
  "high_energy_kills_10min" DOUBLE  -- High Energy Kills / 10min,
  "average_energy" DOUBLE  -- Average Energy, %,
  "graviton_surge_kills_10min" DOUBLE  -- Graviton Surge Kills / 10min,
  "death_blossom_kills_10min" DOUBLE  -- Death Blossom Kills / 10min,
  "healing_accuracy" DOUBLE,
  "deaths_prevented_10min" DOUBLE  -- Deaths Prevented / 10min,
  "amp_matrix_assists_10min" DOUBLE  -- Amp Matrix Assists / 10min,
  "energy_javelin_kills_10min" DOUBLE  -- Energy Javelin Kills / 10min,
  "javelin_spin_kills_10min" DOUBLE  -- Javelin Spin Kills / 10min,
  "terra_surge_kills_10min" DOUBLE  -- Terra Surge Kills / 10min,
  "airtime" DOUBLE  -- Airtime, %,
  "barrage_kills_10min" DOUBLE  -- Barrage Kills / 10min,
  "accretion_kills_10min" DOUBLE  -- Accretion Kills / 10min,
  "overhealth_10min" DOUBLE  -- Overhealth / 10min,
  "gravitic_flux_kills_10min" DOUBLE  -- Gravitic Flux Kills / 10min,
  "rocket_punch_kills_10min" DOUBLE  -- Rocket Punch Kills / 10min,
  "seismic_slam_kills_10min" DOUBLE  -- Seismic Slam Kills / 10min,
  "meteor_strike_kills_10min" DOUBLE  -- Meteor Strike Kills / 10min,
  "inspire_uptime" DOUBLE,
  "icicle_accuracy_10min" DOUBLE  -- Icicle Accuracy, % / 10min,
  "icicle_crit_accuracy_10min" DOUBLE  -- Icicle Crit Accuracy, % / 10min,
  "enemies_frozen_10min" DOUBLE  -- Enemies Frozen / 10min,
  "blizzard_kills_10min" DOUBLE  -- Blizzard Kills / 10min,
  "jump_pack_kills_10min" DOUBLE  -- Jump Pack Kills / 10min,
  "primal_rage_kills_10min" DOUBLE  -- Primal Rage Kills / 10min,
  "recon_kills_10min" DOUBLE  -- Recon Kills / 10min,
  "assault_kills_10min" DOUBLE  -- Assault Kills / 10min,
  "tactical_grenade_kills_10min" DOUBLE  -- Tactical Grenade Kills / 10min
);

Ow2 Season 01 Final Heroes Stats 2023–05–06

@kaggle.mykhailokachan_overwatch_2_statistics.ow2_season_01_final_heroes_stats_2023_05_06
  • 118.13 kB
  • 280 rows
  • 126 columns
Loading... 
CREATE TABLE ow2_season_01_final_heroes_stats_2023_05_06 (
  "hero" VARCHAR,
  "skill_tier" VARCHAR,
  "kda_ratio" DOUBLE,
  "pick_rate" DOUBLE  -- Pick Rate, %,
  "win_rate" DOUBLE  -- Win Rate, %,
  "eliminations_10min" DOUBLE  -- Eliminations / 10min,
  "objective_kills_10min" DOUBLE  -- Objective Kills / 10min,
  "objective_time_10min" BIGINT  -- Objective Time / 10min,
  "damage_10min" BIGINT  -- Damage / 10min,
  "healing_10min" DOUBLE  -- Healing / 10min,
  "deaths_10min" DOUBLE  -- Deaths / 10min,
  "scoped_accuracy" DOUBLE  -- Scoped Accuracy, %,
  "biotic_grenade_kills_10min" DOUBLE  -- Biotic Grenade Kills / 10min,
  "enemies_slept_10min" DOUBLE  -- Enemies Slept / 10min,
  "healing_amplified_10min" DOUBLE  -- Healing Amplified / 10min,
  "nano_boost_assists_10min" DOUBLE  -- Nano Boost Assists / 10min,
  "blaster_kills_10min" DOUBLE  -- Blaster Kills / 10min,
  "damage_amplified_10min" DOUBLE  -- Damage Amplified / 10min,
  "players_resurrected_10min" DOUBLE  -- Players Resurrected / 10min,
  "final_blows_10min" DOUBLE  -- Final Blows / 10min,
  "solo_kills_10min" DOUBLE  -- Solo Kills / 10min,
  "weapon_accuracy" DOUBLE  -- Weapon Accuracy, %,
  "crit_accuracy" DOUBLE  -- Crit Accuracy, %,
  "deadeye_kills_10min" DOUBLE  -- Deadeye Kills / 10min,
  "magnetic_grenade_attaches" DOUBLE,
  "magnetic_grenade_kills_10min" DOUBLE  -- Magnetic Grenade Kills / 10min,
  "swift_strike_resets_10min" DOUBLE  -- Swift Strike Resets / 10min,
  "damage_reflected_10min" DOUBLE  -- Damage Reflected / 10min,
  "ultimates_reflected_10min" VARCHAR  -- Ultimates Reflected / 10min,
  "dragonblade_kills_10min" DOUBLE  -- Dragonblade Kills / 10min,
  "kunai_kills_10min" DOUBLE  -- Kunai Kills / 10min,
  "effects_cleansed_10min" DOUBLE  -- Effects Cleansed / 10min,
  "kitsune_rush_assists_10min" DOUBLE  -- Kitsune Rush Assists / 10min,
  "secondary_accuracy" DOUBLE  -- Secondary Accuracy, %,
  "biotic_orb_kills_10min" DOUBLE  -- Biotic Orb Kills / 10min,
  "ally_coalescence_efficiency" DOUBLE  -- Ally Coalescence Efficiency, %,
  "enemy_coalescence_efficiency" DOUBLE  -- Enemy Coalescence Efficiency, %,
  "coalescence_kills_10min" DOUBLE  -- Coalescence Kills / 10min,
  "objective_contest_time_10min" DOUBLE  -- Objective Contest Time / 10min,
  "charge_kills_10min" DOUBLE  -- Charge Kills / 10min,
  "fire_strike_kills_10min" DOUBLE  -- Fire Strike Kills / 10min,
  "earthshatter_kills_10min" DOUBLE  -- Earthshatter Kills / 10min,
  "long_range_kills_10min" DOUBLE  -- Long Range Kills / 10min,
  "storm_arrow_kills_10min" DOUBLE  -- Storm Arrow Kills / 10min,
  "recon_assists_10min" DOUBLE  -- Recon Assists / 10min,
  "dragonstrike_kills_10min" DOUBLE  -- Dragonstrike Kills / 10min,
  "venom_mine_kills_10min" DOUBLE  -- Venom Mine Kills / 10min,
  "helix_rocket_accuracy" DOUBLE  -- Helix Rocket Accuracy, %,
  "helix_rocket_kills_10min" DOUBLE  -- Helix Rocket Kills / 10min,
  "tactical_visor_kills_10min" DOUBLE  -- Tactical Visor Kills / 10min,
  "charged_volley_accuracy" DOUBLE  -- Charged Volley Accuracy, %,
  "charged_volley_kills_10min" DOUBLE  -- Charged Volley Kills / 10min,
  "transcendence_healing_10min" DOUBLE  -- Transcendence Healing / 10min,
  "knockbacks_10min" DOUBLE  -- Knockbacks / 10min,
  "sound_barriers_10min" DOUBLE  -- Sound Barriers / 10min,
  "micro_missile_kills_10min" DOUBLE  -- Micro Missile Kills, % / 10min,
  "call_mech_kills_10min" DOUBLE  -- Call Mech Kills / 10min,
  "self_destruct_kills_10min" DOUBLE  -- Self-Destruct Kills / 10min,
  "direct_hits" DOUBLE,
  "concussion_mine_kills_10min" DOUBLE  -- Concussion Mine Kills / 10min,
  "enemies_trapped_10min" DOUBLE  -- Enemies Trapped / 10min,
  "coach_gun_kills_10min" DOUBLE  -- Coach Gun Kills / 10min,
  "dynamite_kills_10min" DOUBLE  -- Dynamite Kills / 10min,
  "bob_kills_10min" DOUBLE  -- Bob Kills / 10min,
  "self_healing_10min" DOUBLE  -- Self Healing / 10min,
  "low_health_recalls_10min" DOUBLE  -- Low Health Recalls / 10min,
  "pulse_bombs_stuck_10min" DOUBLE  -- Pulse Bombs Stuck / 10min,
  "pulse_bomb_kills_10min" DOUBLE  -- Pulse Bomb Kills / 10min,
  "chain_hook_kills_10min" DOUBLE  -- Chain Hook Kills / 10min,
  "chain_hook_accuracy" DOUBLE  -- Chain Hook Accuracy, %,
  "whole_hog_kills_10min" DOUBLE  -- Whole Hog Kills / 10min,
  "primary_accuracy" DOUBLE  -- Primary Accuracy, %,
  "high_energy_kills_10min" DOUBLE  -- High Energy Kills / 10min,
  "average_energy" DOUBLE  -- Average Energy, %,
  "graviton_surge_kills_10min" DOUBLE  -- Graviton Surge Kills / 10min,
  "death_blossom_kills_10min" DOUBLE  -- Death Blossom Kills / 10min,
  "healing_accuracy" DOUBLE,
  "deaths_prevented_10min" DOUBLE  -- Deaths Prevented / 10min,
  "amp_matrix_assists_10min" DOUBLE  -- Amp Matrix Assists / 10min,
  "energy_javelin_kills_10min" DOUBLE  -- Energy Javelin Kills / 10min,
  "terra_surge_kills_10min" DOUBLE  -- Terra Surge Kills / 10min,
  "airtime" DOUBLE  -- Airtime, %,
  "barrage_kills_10min" DOUBLE  -- Barrage Kills / 10min,
  "accretion_kills_10min" DOUBLE  -- Accretion Kills / 10min,
  "overhealth_10min" DOUBLE  -- Overhealth / 10min,
  "gravitic_flux_kills_10min" DOUBLE  -- Gravitic Flux Kills / 10min,
  "rocket_punch_kills_10min" DOUBLE  -- Rocket Punch Kills / 10min,
  "seismic_slam_kills_10min" DOUBLE  -- Seismic Slam Kills / 10min,
  "meteor_strike_kills_10min" DOUBLE  -- Meteor Strike Kills / 10min,
  "inspire_uptime" DOUBLE,
  "icicle_accuracy_10min" DOUBLE  -- Icicle Accuracy, % / 10min,
  "icicle_crit_accuracy_10min" DOUBLE  -- Icicle Crit Accuracy, % / 10min,
  "enemies_frozen_10min" DOUBLE  -- Enemies Frozen / 10min,
  "blizzard_kills_10min" DOUBLE  -- Blizzard Kills / 10min,
  "jump_pack_kills_10min" DOUBLE  -- Jump Pack Kills / 10min,
  "primal_rage_kills_10min" DOUBLE  -- Primal Rage Kills / 10min,
  "recon_kills_10min" DOUBLE  -- Recon Kills / 10min,
  "assault_kills_10min" DOUBLE  -- Assault Kills / 10min,
  "tactical_grenade_kills_10min" DOUBLE  -- Tactical Grenade Kills / 10min,
  "artillery_kills_10min" DOUBLE  -- Artillery Kills / 10min
);

Ow2 Season 02 Final Heroes Stats 2023–05–06

@kaggle.mykhailokachan_overwatch_2_statistics.ow2_season_02_final_heroes_stats_2023_05_06
  • 122.68 kB
  • 288 rows
  • 131 columns
Loading... 
CREATE TABLE ow2_season_02_final_heroes_stats_2023_05_06 (
  "hero" VARCHAR,
  "skill_tier" VARCHAR,
  "kda_ratio" DOUBLE,
  "pick_rate" DOUBLE  -- Pick Rate, %,
  "win_rate" DOUBLE  -- Win Rate, %,
  "eliminations_10min" DOUBLE  -- Eliminations / 10min,
  "objective_kills_10min" DOUBLE  -- Objective Kills / 10min,
  "objective_time_10min" BIGINT  -- Objective Time / 10min,
  "damage_10min" BIGINT  -- Damage / 10min,
  "healing_10min" DOUBLE  -- Healing / 10min,
  "deaths_10min" DOUBLE  -- Deaths / 10min,
  "scoped_accuracy" DOUBLE  -- Scoped Accuracy, %,
  "biotic_grenade_kills_10min" DOUBLE  -- Biotic Grenade Kills / 10min,
  "enemies_slept_10min" DOUBLE  -- Enemies Slept / 10min,
  "healing_amplified_10min" DOUBLE  -- Healing Amplified / 10min,
  "nano_boost_assists_10min" DOUBLE  -- Nano Boost Assists / 10min,
  "blaster_kills_10min" DOUBLE  -- Blaster Kills / 10min,
  "damage_amplified_10min" DOUBLE  -- Damage Amplified / 10min,
  "players_resurrected_10min" DOUBLE  -- Players Resurrected / 10min,
  "final_blows_10min" DOUBLE  -- Final Blows / 10min,
  "solo_kills_10min" DOUBLE  -- Solo Kills / 10min,
  "weapon_accuracy" DOUBLE  -- Weapon Accuracy, %,
  "crit_accuracy" DOUBLE  -- Crit Accuracy, %,
  "deadeye_kills_10min" DOUBLE  -- Deadeye Kills / 10min,
  "magnetic_grenade_attaches" DOUBLE,
  "magnetic_grenade_kills_10min" DOUBLE  -- Magnetic Grenade Kills / 10min,
  "swift_strike_resets_10min" DOUBLE  -- Swift Strike Resets / 10min,
  "damage_reflected_10min" DOUBLE  -- Damage Reflected / 10min,
  "ultimates_reflected_10min" VARCHAR  -- Ultimates Reflected / 10min,
  "dragonblade_kills_10min" DOUBLE  -- Dragonblade Kills / 10min,
  "kunai_kills_10min" DOUBLE  -- Kunai Kills / 10min,
  "effects_cleansed_10min" DOUBLE  -- Effects Cleansed / 10min,
  "kitsune_rush_assists_10min" DOUBLE  -- Kitsune Rush Assists / 10min,
  "secondary_accuracy" DOUBLE  -- Secondary Accuracy, %,
  "biotic_orb_kills_10min" DOUBLE  -- Biotic Orb Kills / 10min,
  "ally_coalescence_efficiency" DOUBLE  -- Ally Coalescence Efficiency, %,
  "enemy_coalescence_efficiency" DOUBLE  -- Enemy Coalescence Efficiency, %,
  "coalescence_kills_10min" DOUBLE  -- Coalescence Kills / 10min,
  "objective_contest_time_10min" DOUBLE  -- Objective Contest Time / 10min,
  "charge_kills_10min" DOUBLE  -- Charge Kills / 10min,
  "fire_strike_kills_10min" DOUBLE  -- Fire Strike Kills / 10min,
  "earthshatter_kills_10min" DOUBLE  -- Earthshatter Kills / 10min,
  "long_range_kills_10min" DOUBLE  -- Long Range Kills / 10min,
  "storm_arrow_kills_10min" DOUBLE  -- Storm Arrow Kills / 10min,
  "recon_assists_10min" DOUBLE  -- Recon Assists / 10min,
  "dragonstrike_kills_10min" DOUBLE  -- Dragonstrike Kills / 10min,
  "venom_mine_kills_10min" DOUBLE  -- Venom Mine Kills / 10min,
  "helix_rocket_accuracy" DOUBLE  -- Helix Rocket Accuracy, %,
  "helix_rocket_kills_10min" DOUBLE  -- Helix Rocket Kills / 10min,
  "tactical_visor_kills_10min" DOUBLE  -- Tactical Visor Kills / 10min,
  "charged_volley_accuracy" DOUBLE  -- Charged Volley Accuracy, %,
  "charged_volley_kills_10min" DOUBLE  -- Charged Volley Kills / 10min,
  "transcendence_healing_10min" DOUBLE  -- Transcendence Healing / 10min,
  "knockbacks_10min" DOUBLE  -- Knockbacks / 10min,
  "sound_barriers_10min" DOUBLE  -- Sound Barriers / 10min,
  "micro_missile_kills_10min" DOUBLE  -- Micro Missile Kills, % / 10min,
  "call_mech_kills_10min" DOUBLE  -- Call Mech Kills / 10min,
  "self_destruct_kills_10min" DOUBLE  -- Self-Destruct Kills / 10min,
  "direct_hits" DOUBLE,
  "concussion_mine_kills_10min" DOUBLE  -- Concussion Mine Kills / 10min,
  "enemies_trapped_10min" DOUBLE  -- Enemies Trapped / 10min,
  "coach_gun_kills_10min" DOUBLE  -- Coach Gun Kills / 10min,
  "dynamite_kills_10min" DOUBLE  -- Dynamite Kills / 10min,
  "bob_kills_10min" DOUBLE  -- Bob Kills / 10min,
  "self_healing_10min" DOUBLE  -- Self Healing / 10min,
  "low_health_recalls_10min" DOUBLE  -- Low Health Recalls / 10min,
  "pulse_bombs_stuck_10min" DOUBLE  -- Pulse Bombs Stuck / 10min,
  "pulse_bomb_kills_10min" DOUBLE  -- Pulse Bomb Kills / 10min,
  "chain_hook_kills_10min" DOUBLE  -- Chain Hook Kills / 10min,
  "chain_hook_accuracy" DOUBLE  -- Chain Hook Accuracy, %,
  "whole_hog_kills_10min" DOUBLE  -- Whole Hog Kills / 10min,
  "primary_accuracy" DOUBLE  -- Primary Accuracy, %,
  "high_energy_kills_10min" DOUBLE  -- High Energy Kills / 10min,
  "average_energy" DOUBLE  -- Average Energy, %,
  "graviton_surge_kills_10min" DOUBLE  -- Graviton Surge Kills / 10min,
  "death_blossom_kills_10min" DOUBLE  -- Death Blossom Kills / 10min,
  "healing_accuracy" DOUBLE,
  "deaths_prevented_10min" DOUBLE  -- Deaths Prevented / 10min,
  "amp_matrix_assists_10min" DOUBLE  -- Amp Matrix Assists / 10min,
  "energy_javelin_kills_10min" DOUBLE  -- Energy Javelin Kills / 10min,
  "javelin_spin_kills_10min" DOUBLE  -- Javelin Spin Kills / 10min,
  "terra_surge_kills_10min" DOUBLE  -- Terra Surge Kills / 10min,
  "airtime" DOUBLE  -- Airtime, %,
  "barrage_kills_10min" DOUBLE  -- Barrage Kills / 10min,
  "accretion_kills_10min" DOUBLE  -- Accretion Kills / 10min,
  "overhealth_10min" DOUBLE  -- Overhealth / 10min,
  "gravitic_flux_kills_10min" DOUBLE  -- Gravitic Flux Kills / 10min,
  "rocket_punch_kills_10min" DOUBLE  -- Rocket Punch Kills / 10min,
  "seismic_slam_kills_10min" DOUBLE  -- Seismic Slam Kills / 10min,
  "meteor_strike_kills_10min" DOUBLE  -- Meteor Strike Kills / 10min,
  "inspire_uptime" DOUBLE,
  "icicle_accuracy_10min" DOUBLE  -- Icicle Accuracy, % / 10min,
  "icicle_crit_accuracy_10min" DOUBLE  -- Icicle Crit Accuracy, % / 10min,
  "enemies_frozen_10min" DOUBLE  -- Enemies Frozen / 10min,
  "blizzard_kills_10min" DOUBLE  -- Blizzard Kills / 10min,
  "jump_pack_kills_10min" DOUBLE  -- Jump Pack Kills / 10min,
  "primal_rage_kills_10min" DOUBLE  -- Primal Rage Kills / 10min,
  "recon_kills_10min" DOUBLE  -- Recon Kills / 10min,
  "assault_kills_10min" DOUBLE  -- Assault Kills / 10min,
  "tactical_grenade_kills_10min" DOUBLE  -- Tactical Grenade Kills / 10min
);

Ow2 Season 03 Final Heroes Stats 2023–05–06

@kaggle.mykhailokachan_overwatch_2_statistics.ow2_season_03_final_heroes_stats_2023_05_06
  • 122.67 kB
  • 288 rows
  • 131 columns
Loading... 
CREATE TABLE ow2_season_03_final_heroes_stats_2023_05_06 (
  "hero" VARCHAR,
  "skill_tier" VARCHAR,
  "kda_ratio" DOUBLE,
  "pick_rate" DOUBLE  -- Pick Rate, %,
  "win_rate" DOUBLE  -- Win Rate, %,
  "eliminations_10min" DOUBLE  -- Eliminations / 10min,
  "objective_kills_10min" DOUBLE  -- Objective Kills / 10min,
  "objective_time_10min" BIGINT  -- Objective Time / 10min,
  "damage_10min" BIGINT  -- Damage / 10min,
  "healing_10min" DOUBLE  -- Healing / 10min,
  "deaths_10min" DOUBLE  -- Deaths / 10min,
  "scoped_accuracy" DOUBLE  -- Scoped Accuracy, %,
  "biotic_grenade_kills_10min" DOUBLE  -- Biotic Grenade Kills / 10min,
  "enemies_slept_10min" DOUBLE  -- Enemies Slept / 10min,
  "healing_amplified_10min" DOUBLE  -- Healing Amplified / 10min,
  "nano_boost_assists_10min" DOUBLE  -- Nano Boost Assists / 10min,
  "blaster_kills_10min" DOUBLE  -- Blaster Kills / 10min,
  "damage_amplified_10min" DOUBLE  -- Damage Amplified / 10min,
  "players_resurrected_10min" DOUBLE  -- Players Resurrected / 10min,
  "final_blows_10min" DOUBLE  -- Final Blows / 10min,
  "solo_kills_10min" DOUBLE  -- Solo Kills / 10min,
  "weapon_accuracy" DOUBLE  -- Weapon Accuracy, %,
  "crit_accuracy" DOUBLE  -- Crit Accuracy, %,
  "deadeye_kills_10min" DOUBLE  -- Deadeye Kills / 10min,
  "magnetic_grenade_attaches" DOUBLE,
  "magnetic_grenade_kills_10min" DOUBLE  -- Magnetic Grenade Kills / 10min,
  "swift_strike_resets_10min" DOUBLE  -- Swift Strike Resets / 10min,
  "damage_reflected_10min" DOUBLE  -- Damage Reflected / 10min,
  "ultimates_reflected_10min" DOUBLE  -- Ultimates Reflected / 10min,
  "dragonblade_kills_10min" DOUBLE  -- Dragonblade Kills / 10min,
  "kunai_kills_10min" DOUBLE  -- Kunai Kills / 10min,
  "effects_cleansed_10min" DOUBLE  -- Effects Cleansed / 10min,
  "kitsune_rush_assists_10min" DOUBLE  -- Kitsune Rush Assists / 10min,
  "secondary_accuracy" DOUBLE  -- Secondary Accuracy, %,
  "biotic_orb_kills_10min" DOUBLE  -- Biotic Orb Kills / 10min,
  "ally_coalescence_efficiency" DOUBLE  -- Ally Coalescence Efficiency, %,
  "enemy_coalescence_efficiency" DOUBLE  -- Enemy Coalescence Efficiency, %,
  "coalescence_kills_10min" DOUBLE  -- Coalescence Kills / 10min,
  "objective_contest_time_10min" DOUBLE  -- Objective Contest Time / 10min,
  "charge_kills_10min" DOUBLE  -- Charge Kills / 10min,
  "fire_strike_kills_10min" DOUBLE  -- Fire Strike Kills / 10min,
  "earthshatter_kills_10min" DOUBLE  -- Earthshatter Kills / 10min,
  "long_range_kills_10min" DOUBLE  -- Long Range Kills / 10min,
  "storm_arrow_kills_10min" DOUBLE  -- Storm Arrow Kills / 10min,
  "recon_assists_10min" DOUBLE  -- Recon Assists / 10min,
  "dragonstrike_kills_10min" DOUBLE  -- Dragonstrike Kills / 10min,
  "venom_mine_kills_10min" DOUBLE  -- Venom Mine Kills / 10min,
  "helix_rocket_accuracy" DOUBLE  -- Helix Rocket Accuracy, %,
  "helix_rocket_kills_10min" DOUBLE  -- Helix Rocket Kills / 10min,
  "tactical_visor_kills_10min" DOUBLE  -- Tactical Visor Kills / 10min,
  "charged_volley_accuracy" DOUBLE  -- Charged Volley Accuracy, %,
  "charged_volley_kills_10min" DOUBLE  -- Charged Volley Kills / 10min,
  "transcendence_healing_10min" DOUBLE  -- Transcendence Healing / 10min,
  "knockbacks_10min" DOUBLE  -- Knockbacks / 10min,
  "sound_barriers_10min" DOUBLE  -- Sound Barriers / 10min,
  "micro_missile_kills_10min" DOUBLE  -- Micro Missile Kills, % / 10min,
  "call_mech_kills_10min" DOUBLE  -- Call Mech Kills / 10min,
  "self_destruct_kills_10min" DOUBLE  -- Self-Destruct Kills / 10min,
  "direct_hits" DOUBLE,
  "concussion_mine_kills_10min" DOUBLE  -- Concussion Mine Kills / 10min,
  "enemies_trapped_10min" DOUBLE  -- Enemies Trapped / 10min,
  "coach_gun_kills_10min" DOUBLE  -- Coach Gun Kills / 10min,
  "dynamite_kills_10min" DOUBLE  -- Dynamite Kills / 10min,
  "bob_kills_10min" DOUBLE  -- Bob Kills / 10min,
  "self_healing_10min" DOUBLE  -- Self Healing / 10min,
  "low_health_recalls_10min" DOUBLE  -- Low Health Recalls / 10min,
  "pulse_bombs_stuck_10min" DOUBLE  -- Pulse Bombs Stuck / 10min,
  "pulse_bomb_kills_10min" DOUBLE  -- Pulse Bomb Kills / 10min,
  "chain_hook_kills_10min" DOUBLE  -- Chain Hook Kills / 10min,
  "chain_hook_accuracy" DOUBLE  -- Chain Hook Accuracy, %,
  "whole_hog_kills_10min" DOUBLE  -- Whole Hog Kills / 10min,
  "primary_accuracy" DOUBLE  -- Primary Accuracy, %,
  "high_energy_kills_10min" DOUBLE  -- High Energy Kills / 10min,
  "average_energy" DOUBLE  -- Average Energy, %,
  "graviton_surge_kills_10min" DOUBLE  -- Graviton Surge Kills / 10min,
  "death_blossom_kills_10min" DOUBLE  -- Death Blossom Kills / 10min,
  "healing_accuracy" DOUBLE,
  "deaths_prevented_10min" DOUBLE  -- Deaths Prevented / 10min,
  "amp_matrix_assists_10min" DOUBLE  -- Amp Matrix Assists / 10min,
  "energy_javelin_kills_10min" DOUBLE  -- Energy Javelin Kills / 10min,
  "javelin_spin_kills_10min" DOUBLE  -- Javelin Spin Kills / 10min,
  "terra_surge_kills_10min" DOUBLE  -- Terra Surge Kills / 10min,
  "airtime" DOUBLE  -- Airtime, %,
  "barrage_kills_10min" DOUBLE  -- Barrage Kills / 10min,
  "accretion_kills_10min" DOUBLE  -- Accretion Kills / 10min,
  "overhealth_10min" DOUBLE  -- Overhealth / 10min,
  "gravitic_flux_kills_10min" DOUBLE  -- Gravitic Flux Kills / 10min,
  "rocket_punch_kills_10min" DOUBLE  -- Rocket Punch Kills / 10min,
  "seismic_slam_kills_10min" DOUBLE  -- Seismic Slam Kills / 10min,
  "meteor_strike_kills_10min" DOUBLE  -- Meteor Strike Kills / 10min,
  "inspire_uptime" DOUBLE,
  "icicle_accuracy_10min" DOUBLE  -- Icicle Accuracy, % / 10min,
  "icicle_crit_accuracy_10min" DOUBLE  -- Icicle Crit Accuracy, % / 10min,
  "enemies_frozen_10min" DOUBLE  -- Enemies Frozen / 10min,
  "blizzard_kills_10min" DOUBLE  -- Blizzard Kills / 10min,
  "jump_pack_kills_10min" DOUBLE  -- Jump Pack Kills / 10min,
  "primal_rage_kills_10min" DOUBLE  -- Primal Rage Kills / 10min,
  "recon_kills_10min" DOUBLE  -- Recon Kills / 10min,
  "assault_kills_10min" DOUBLE  -- Assault Kills / 10min,
  "tactical_grenade_kills_10min" DOUBLE  -- Tactical Grenade Kills / 10min
);

Ow2 Season 04 Final Heroes Stats 2023–06–27

@kaggle.mykhailokachan_overwatch_2_statistics.ow2_season_04_final_heroes_stats_2023_06_27
  • 124.68 kB
  • 296 rows
  • 133 columns
Loading... 
CREATE TABLE ow2_season_04_final_heroes_stats_2023_06_27 (
  "hero" VARCHAR,
  "skill_tier" VARCHAR,
  "kda_ratio" DOUBLE,
  "pick_rate" DOUBLE  -- Pick Rate, %,
  "win_rate" DOUBLE  -- Win Rate, %,
  "eliminations_10min" DOUBLE  -- Eliminations / 10min,
  "objective_kills_10min" DOUBLE  -- Objective Kills / 10min,
  "objective_time_10min" BIGINT  -- Objective Time / 10min,
  "damage_10min" BIGINT  -- Damage / 10min,
  "healing_10min" DOUBLE  -- Healing / 10min,
  "deaths_10min" DOUBLE  -- Deaths / 10min,
  "scoped_accuracy" DOUBLE  -- Scoped Accuracy, %,
  "biotic_grenade_kills_10min" DOUBLE  -- Biotic Grenade Kills / 10min,
  "enemies_slept_10min" DOUBLE  -- Enemies Slept / 10min,
  "healing_amplified_10min" DOUBLE  -- Healing Amplified / 10min,
  "nano_boost_assists_10min" DOUBLE  -- Nano Boost Assists / 10min,
  "blaster_kills_10min" DOUBLE  -- Blaster Kills / 10min,
  "damage_amplified_10min" DOUBLE  -- Damage Amplified / 10min,
  "players_resurrected_10min" DOUBLE  -- Players Resurrected / 10min,
  "final_blows_10min" DOUBLE  -- Final Blows / 10min,
  "solo_kills_10min" DOUBLE  -- Solo Kills / 10min,
  "weapon_accuracy" DOUBLE  -- Weapon Accuracy, %,
  "swift_strike_resets_10min" DOUBLE  -- Swift Strike Resets / 10min,
  "damage_reflected_10min" DOUBLE  -- Damage Reflected / 10min,
  "ultimates_reflected_10min" DOUBLE  -- Ultimates Reflected / 10min,
  "dragonblade_kills_10min" DOUBLE  -- Dragonblade Kills / 10min,
  "crit_accuracy" DOUBLE  -- Crit Accuracy, %,
  "deadeye_kills_10min" DOUBLE  -- Deadeye Kills / 10min,
  "magnetic_grenade_attaches" DOUBLE,
  "magnetic_grenade_kills_10min" DOUBLE  -- Magnetic Grenade Kills / 10min,
  "kunai_kills_10min" DOUBLE  -- Kunai Kills / 10min,
  "effects_cleansed_10min" DOUBLE  -- Effects Cleansed / 10min,
  "kitsune_rush_assists_10min" DOUBLE  -- Kitsune Rush Assists / 10min,
  "long_range_kills_10min" DOUBLE  -- Long Range Kills / 10min,
  "storm_arrow_kills_10min" DOUBLE  -- Storm Arrow Kills / 10min,
  "recon_assists_10min" DOUBLE  -- Recon Assists / 10min,
  "dragonstrike_kills_10min" DOUBLE  -- Dragonstrike Kills / 10min,
  "secondary_accuracy" DOUBLE  -- Secondary Accuracy, %,
  "biotic_orb_kills_10min" DOUBLE  -- Biotic Orb Kills / 10min,
  "ally_coalescence_efficiency" DOUBLE  -- Ally Coalescence Efficiency, %,
  "enemy_coalescence_efficiency" DOUBLE  -- Enemy Coalescence Efficiency, %,
  "coalescence_kills_10min" DOUBLE  -- Coalescence Kills / 10min,
  "objective_contest_time_10min" DOUBLE  -- Objective Contest Time / 10min,
  "charge_kills_10min" DOUBLE  -- Charge Kills / 10min,
  "fire_strike_kills_10min" DOUBLE  -- Fire Strike Kills / 10min,
  "earthshatter_kills_10min" DOUBLE  -- Earthshatter Kills / 10min,
  "venom_mine_kills_10min" DOUBLE  -- Venom Mine Kills / 10min,
  "helix_rocket_accuracy" DOUBLE  -- Helix Rocket Accuracy, %,
  "helix_rocket_kills_10min" DOUBLE  -- Helix Rocket Kills / 10min,
  "tactical_visor_kills_10min" DOUBLE  -- Tactical Visor Kills / 10min,
  "charged_volley_accuracy" DOUBLE  -- Charged Volley Accuracy, %,
  "charged_volley_kills_10min" DOUBLE  -- Charged Volley Kills / 10min,
  "transcendence_healing_10min" DOUBLE  -- Transcendence Healing / 10min,
  "micro_missile_kills_10min" DOUBLE  -- Micro Missile Kills, % / 10min,
  "call_mech_kills_10min" DOUBLE  -- Call Mech Kills / 10min,
  "self_destruct_kills_10min" DOUBLE  -- Self-Destruct Kills / 10min,
  "knockbacks_10min" DOUBLE  -- Knockbacks / 10min,
  "sound_barriers_10min" DOUBLE  -- Sound Barriers / 10min,
  "self_healing_10min" DOUBLE  -- Self Healing / 10min,
  "low_health_recalls_10min" DOUBLE  -- Low Health Recalls / 10min,
  "pulse_bombs_stuck_10min" DOUBLE  -- Pulse Bombs Stuck / 10min,
  "pulse_bomb_kills_10min" DOUBLE  -- Pulse Bomb Kills / 10min,
  "direct_hits" DOUBLE,
  "concussion_mine_kills_10min" DOUBLE  -- Concussion Mine Kills / 10min,
  "enemies_trapped_10min" DOUBLE  -- Enemies Trapped / 10min,
  "coach_gun_kills_10min" DOUBLE  -- Coach Gun Kills / 10min,
  "dynamite_kills_10min" DOUBLE  -- Dynamite Kills / 10min,
  "bob_kills_10min" DOUBLE  -- Bob Kills / 10min,
  "primary_accuracy" DOUBLE  -- Primary Accuracy, %,
  "high_energy_kills_10min" DOUBLE  -- High Energy Kills / 10min,
  "average_energy" DOUBLE  -- Average Energy, %,
  "graviton_surge_kills_10min" DOUBLE  -- Graviton Surge Kills / 10min,
  "healing_accuracy" DOUBLE,
  "deaths_prevented_10min" DOUBLE  -- Deaths Prevented / 10min,
  "amp_matrix_assists_10min" DOUBLE  -- Amp Matrix Assists / 10min,
  "chain_hook_kills_10min" DOUBLE  -- Chain Hook Kills / 10min,
  "chain_hook_accuracy" DOUBLE  -- Chain Hook Accuracy, %,
  "whole_hog_kills_10min" DOUBLE  -- Whole Hog Kills / 10min,
  "death_blossom_kills_10min" DOUBLE  -- Death Blossom Kills / 10min,
  "airtime" DOUBLE  -- Airtime, %,
  "barrage_kills_10min" DOUBLE  -- Barrage Kills / 10min,
  "accretion_kills_10min" DOUBLE  -- Accretion Kills / 10min,
  "overhealth_10min" DOUBLE  -- Overhealth / 10min,
  "gravitic_flux_kills_10min" DOUBLE  -- Gravitic Flux Kills / 10min,
  "rocket_punch_kills_10min" DOUBLE  -- Rocket Punch Kills / 10min,
  "seismic_slam_kills_10min" DOUBLE  -- Seismic Slam Kills / 10min,
  "meteor_strike_kills_10min" DOUBLE  -- Meteor Strike Kills / 10min,
  "inspire_uptime" DOUBLE,
  "icicle_accuracy_10min" DOUBLE  -- Icicle Accuracy, % / 10min,
  "icicle_crit_accuracy_10min" DOUBLE  -- Icicle Crit Accuracy, % / 10min,
  "enemies_frozen_10min" DOUBLE  -- Enemies Frozen / 10min,
  "blizzard_kills_10min" DOUBLE  -- Blizzard Kills / 10min,
  "energy_javelin_kills_10min" DOUBLE  -- Energy Javelin Kills / 10min,
  "javelin_spin_kills_10min" DOUBLE  -- Javelin Spin Kills / 10min,
  "terra_surge_kills_10min" DOUBLE  -- Terra Surge Kills / 10min,
  "jump_pack_kills_10min" DOUBLE  -- Jump Pack Kills / 10min,
  "primal_rage_kills_10min" DOUBLE  -- Primal Rage Kills / 10min,
  "enemies_hacked_10min" DOUBLE  -- Enemies Hacked / 10min,
  "low_health_teleports_10min" DOUBLE  -- Low Health Teleports / 10min,
  "emp_kills_10min" DOUBLE  -- EMP Kills / 10min
);

Share link

Anyone who has the link will be able to view this.