Counter Strike 2 Match Data/Status For Betting
CS2 Match data from Nov-23 to Jan-24
@kaggle.victorpicinin_counter_strike_2_hltv_match_data
CS2 Match data from Nov-23 to Jan-24
@kaggle.victorpicinin_counter_strike_2_hltv_match_data
CREATE TABLE cs2_hltv_match_data2 (
"matchid" BIGINT,
"team1" VARCHAR,
"team2" VARCHAR,
"map" VARCHAR,
"team1_win" BIGINT,
"t1_mapwinrate" VARCHAR,
"t2_mapwinrate" VARCHAR,
"t1_player0_total_kills" DOUBLE,
"t1_player0_headshot" VARCHAR -- T1 Player0 Headshot %,
"t1_player0_total_deaths" DOUBLE,
"t1_player0_k_d_ratio" VARCHAR,
"t1_player0_damage_round" DOUBLE -- T1 Player0 Damage / Round,
"t1_player0_grenade_dmg_round" DOUBLE -- T1 Player0 Grenade Dmg / Round,
"t1_player0_maps_played" DOUBLE,
"t1_player0_rounds_played" DOUBLE,
"t1_player0_kills_round" DOUBLE -- T1 Player0 Kills / Round,
"t1_player0_assists_round" DOUBLE -- T1 Player0 Assists / Round,
"t1_player0_deaths_round" DOUBLE -- T1 Player0 Deaths / Round,
"t1_player0_saved_by_teammate_round" DOUBLE -- T1 Player0 Saved By Teammate / Round,
"t1_player0_saved_teammates_round" DOUBLE -- T1 Player0 Saved Teammates / Round,
"t1_player0_rating_1_0" DOUBLE,
"t1_player1_total_kills" DOUBLE,
"t1_player1_headshot" VARCHAR -- T1 Player1 Headshot %,
"t1_player1_total_deaths" DOUBLE,
"t1_player1_k_d_ratio" DOUBLE,
"t1_player1_damage_round" DOUBLE -- T1 Player1 Damage / Round,
"t1_player1_grenade_dmg_round" DOUBLE -- T1 Player1 Grenade Dmg / Round,
"t1_player1_maps_played" DOUBLE,
"t1_player1_rounds_played" DOUBLE,
"t1_player1_kills_round" DOUBLE -- T1 Player1 Kills / Round,
"t1_player1_assists_round" DOUBLE -- T1 Player1 Assists / Round,
"t1_player1_deaths_round" DOUBLE -- T1 Player1 Deaths / Round,
"t1_player1_saved_by_teammate_round" DOUBLE -- T1 Player1 Saved By Teammate / Round,
"t1_player1_saved_teammates_round" DOUBLE -- T1 Player1 Saved Teammates / Round,
"t1_player1_rating_1_0" DOUBLE,
"t1_player2_total_kills" DOUBLE,
"t1_player2_headshot" VARCHAR -- T1 Player2 Headshot %,
"t1_player2_total_deaths" DOUBLE,
"t1_player2_k_d_ratio" DOUBLE,
"t1_player2_damage_round" DOUBLE -- T1 Player2 Damage / Round,
"t1_player2_grenade_dmg_round" DOUBLE -- T1 Player2 Grenade Dmg / Round,
"t1_player2_maps_played" DOUBLE,
"t1_player2_rounds_played" DOUBLE,
"t1_player2_kills_round" DOUBLE -- T1 Player2 Kills / Round,
"t1_player2_assists_round" DOUBLE -- T1 Player2 Assists / Round,
"t1_player2_deaths_round" DOUBLE -- T1 Player2 Deaths / Round,
"t1_player2_saved_by_teammate_round" DOUBLE -- T1 Player2 Saved By Teammate / Round,
"t1_player2_saved_teammates_round" DOUBLE -- T1 Player2 Saved Teammates / Round,
"t1_player2_rating_2_0" DOUBLE,
"t1_player3_total_kills" DOUBLE,
"t1_player3_headshot" VARCHAR -- T1 Player3 Headshot %,
"t1_player3_total_deaths" DOUBLE,
"t1_player3_k_d_ratio" DOUBLE,
"t1_player3_damage_round" DOUBLE -- T1 Player3 Damage / Round,
"t1_player3_grenade_dmg_round" DOUBLE -- T1 Player3 Grenade Dmg / Round,
"t1_player3_maps_played" DOUBLE,
"t1_player3_rounds_played" DOUBLE,
"t1_player3_kills_round" DOUBLE -- T1 Player3 Kills / Round,
"t1_player3_assists_round" DOUBLE -- T1 Player3 Assists / Round,
"t1_player3_deaths_round" DOUBLE -- T1 Player3 Deaths / Round,
"t1_player3_saved_by_teammate_round" DOUBLE -- T1 Player3 Saved By Teammate / Round,
"t1_player3_saved_teammates_round" DOUBLE -- T1 Player3 Saved Teammates / Round,
"t1_player3_rating_2_0" DOUBLE,
"t1_player4_total_kills" DOUBLE,
"t1_player4_headshot" VARCHAR -- T1 Player4 Headshot %,
"t1_player4_total_deaths" DOUBLE,
"t1_player4_k_d_ratio" DOUBLE,
"t1_player4_damage_round" DOUBLE -- T1 Player4 Damage / Round,
"t1_player4_grenade_dmg_round" DOUBLE -- T1 Player4 Grenade Dmg / Round,
"t1_player4_maps_played" DOUBLE,
"t1_player4_rounds_played" DOUBLE,
"t1_player4_kills_round" DOUBLE -- T1 Player4 Kills / Round,
"t1_player4_assists_round" DOUBLE -- T1 Player4 Assists / Round,
"t1_player4_deaths_round" DOUBLE -- T1 Player4 Deaths / Round,
"t1_player4_saved_by_teammate_round" DOUBLE -- T1 Player4 Saved By Teammate / Round,
"t1_player4_saved_teammates_round" DOUBLE -- T1 Player4 Saved Teammates / Round,
"t1_player4_rating_2_0" DOUBLE,
"t2_player0_total_kills" DOUBLE,
"t2_player0_headshot" VARCHAR -- T2 Player0 Headshot %,
"t2_player0_total_deaths" DOUBLE,
"t2_player0_k_d_ratio" DOUBLE,
"t2_player0_damage_round" DOUBLE -- T2 Player0 Damage / Round,
"t2_player0_grenade_dmg_round" DOUBLE -- T2 Player0 Grenade Dmg / Round,
"t2_player0_maps_played" DOUBLE,
"t2_player0_rounds_played" DOUBLE,
"t2_player0_kills_round" DOUBLE -- T2 Player0 Kills / Round,
"t2_player0_assists_round" DOUBLE -- T2 Player0 Assists / Round,
"t2_player0_deaths_round" DOUBLE -- T2 Player0 Deaths / Round,
"t2_player0_saved_by_teammate_round" DOUBLE -- T2 Player0 Saved By Teammate / Round,
"t2_player0_saved_teammates_round" DOUBLE -- T2 Player0 Saved Teammates / Round,
"t2_player0_rating_1_0" DOUBLE,
"t2_player1_total_kills" DOUBLE,
"t2_player1_headshot" VARCHAR -- T2 Player1 Headshot %,
"t2_player1_total_deaths" DOUBLE,
"t2_player1_k_d_ratio" DOUBLE,
"t2_player1_damage_round" DOUBLE -- T2 Player1 Damage / Round,
"t2_player1_grenade_dmg_round" DOUBLE -- T2 Player1 Grenade Dmg / Round,
"t2_player1_maps_played" DOUBLE,
"t2_player1_rounds_played" DOUBLE,
"t2_player1_kills_round" DOUBLE -- T2 Player1 Kills / Round
);
Anyone who has the link will be able to view this.