Dataset: CS:GO BestOf3 HLTV.org

About this Dataset

CS:GO BestOf3 HLTV.org

Context

The present Dataset came from a python web scraping project to get matches in HLTV from Dez 2017 to June 2021.

Columns

The dataset has information about the following themes:

Time of the match, like date, time and timestamp;
Teams in match, like name, rank, total score and witch team won the match;
Maps picks and bans;
Lineup of each team, with information of each player in each map;
Link to the match, as match url

Tables

Cs Hltv Data

@kaggle.viniciusromanosilva_csgo_hltv.cs_hltv_data

922.96 KB
3490 rows
157 columns


CREATE TABLE cs_hltv_data (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "first_team" VARCHAR,
  "second_team" VARCHAR,
  "first_team_world_rank" VARCHAR,
  "second_team_world_rank" VARCHAR,
  "first_team_total_score" BIGINT,
  "second_team_total_score" BIGINT,
  "first_team_won" BIGINT,
  "m1" VARCHAR,
  "first_team_score_m1" BIGINT,
  "second_team_score_m1" BIGINT,
  "m2" VARCHAR,
  "first_team_score_m2" BIGINT,
  "second_team_score_m2" BIGINT,
  "m3" VARCHAR,
  "first_team_score_m3" VARCHAR,
  "second_team_score_m3" VARCHAR,
  "side_first_team_m1" VARCHAR,
  "side_second_team_m1" VARCHAR,
  "score_first_team_t1_m1" BIGINT,
  "score_first_team_t2_m1" BIGINT,
  "score_second_team_t1_m1" BIGINT,
  "score_second_team_t2_m1" BIGINT,
  "side_first_team_m2" VARCHAR,
  "side_second_team_m2" VARCHAR,
  "score_first_team_t1_m2" BIGINT,
  "score_first_team_t2_m2" BIGINT,
  "score_second_team_t1_m2" BIGINT,
  "score_second_team_t2_m2" BIGINT,
  "side_first_team_m3" VARCHAR,
  "side_second_team_m3" VARCHAR,
  "score_first_team_t1_m3" VARCHAR,
  "score_first_team_t2_m3" VARCHAR,
  "score_second_team_t1_m3" VARCHAR,
  "score_second_team_t2_m3" VARCHAR,
  "first_team_p1" VARCHAR,
  "first_team_p1_ct_kd" VARCHAR,
  "first_team_p1_ct" BIGINT,
  "first_team_p1_ct_adr" DOUBLE,
  "first_team_p1_ct_kast" VARCHAR,
  "first_team_p1_ct_rating" DOUBLE,
  "first_team_p1_t_kd" VARCHAR,
  "first_team_p1_t" BIGINT,
  "first_team_p1_t_adr" DOUBLE,
  "first_team_p1_t_kast" VARCHAR,
  "first_team_p1_t_rating" DOUBLE,
  "first_team_p2" VARCHAR,
  "first_team_p2_ct_kd" VARCHAR,
  "first_team_p2_ct" BIGINT,
  "first_team_p2_ct_adr" DOUBLE,
  "first_team_p2_ct_kast" VARCHAR,
  "first_team_p2_ct_rating" DOUBLE,
  "first_team_p2_t_kd" VARCHAR,
  "first_team_p2_t" BIGINT,
  "first_team_p2_t_adr" DOUBLE,
  "first_team_p2_t_kast" VARCHAR,
  "first_team_p2_t_rating" DOUBLE,
  "first_team_p3" VARCHAR,
  "first_team_p3_ct_kd" VARCHAR,
  "first_team_p3_ct" BIGINT,
  "first_team_p3_ct_adr" DOUBLE,
  "first_team_p3_ct_kast" VARCHAR,
  "first_team_p3_ct_rating" DOUBLE,
  "first_team_p3_t_kd" VARCHAR,
  "first_team_p3_t" BIGINT,
  "first_team_p3_t_adr" DOUBLE,
  "first_team_p3_t_kast" VARCHAR,
  "first_team_p3_t_rating" DOUBLE,
  "first_team_p4" VARCHAR,
  "first_team_p4_ct_kd" VARCHAR,
  "first_team_p4_ct" BIGINT,
  "first_team_p4_ct_adr" DOUBLE,
  "first_team_p4_ct_kast" VARCHAR,
  "first_team_p4_ct_rating" DOUBLE,
  "first_team_p4_t_kd" VARCHAR,
  "first_team_p4_t" BIGINT,
  "first_team_p4_t_adr" DOUBLE,
  "first_team_p4_t_kast" VARCHAR,
  "first_team_p4_t_rating" DOUBLE,
  "first_team_p5" VARCHAR,
  "first_team_p5_ct_kd" VARCHAR,
  "first_team_p5_ct" BIGINT,
  "first_team_p5_ct_adr" DOUBLE,
  "first_team_p5_ct_kast" VARCHAR,
  "first_team_p5_ct_rating" DOUBLE,
  "first_team_p5_t_kd" VARCHAR,
  "first_team_p5_t" BIGINT,
  "first_team_p5_t_adr" DOUBLE,
  "first_team_p5_t_kast" VARCHAR,
  "first_team_p5_t_rating" DOUBLE,
  "second_team_p1" VARCHAR,
  "second_team_p1_ct_kd" VARCHAR,
  "second_team_p1_ct" BIGINT,
  "second_team_p1_ct_adr" DOUBLE,
  "second_team_p1_ct_kast" VARCHAR,
  "second_team_p1_ct_rating" DOUBLE,
  "second_team_p1_t_kd" VARCHAR,
  "second_team_p1_t" BIGINT
);