Name: CS:GO Match History
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

CS:GO Match History

Dataset Description

Data collected from late February to mid June 2020.
Also you can create own dataset using my parser: python hltv parser.

Column Descriptions

match_url - link to the match

event_url - link to the tournament

players_url_1 - links to players of the 1st team

players_url_2 - links to players of the second team

maps_url - links to statistics of played maps

maps_name - map names

score1_maps - score on each map of team 1

score2_maps - score on each map of team 2

picks - peaks of teams; 1 - the first team, -1 - the second team; if the array is None, then the maps are < 2

date - match date

total_maps - planned to play maps (usually 1, 3 or 5)

maps_played - maps were played as a result

score1 - score of the 1st team

score2 - score of the 2nd team

h2h_wins1 - history of victories of the 1st team over the 2nd

h2h_wins2 - history of victories of the 2nd team over the 1st

rank1 - rank of the 1st team

rank2 - rank of the 2nd team

5last_match[match_id]_total_maps[team_id] - the last 5 matches of the [team_id] (1 or 2); [match_id] - serial number of the match; total maps played

5last_match[match_id]_score[team_id] - the last 5 matches of the [team_id] (1 or 2); [match_id] - serial number of the match; score [team_id] in this match

5last_match[match_id]_opponent_score[team_id] - the last 5 matches of the [team_id] (1 or 2); [match_id] - serial number of the match; opponent score in this match

last_maps [id] _score[team_id] - team*s score; id - map number, team_id - team number (team1 or team2)

last_maps [id] _opponent_score[team_id] - opponent’s score; id - map number, team_id - team number (team1 or team2)

event_type - type of tournament (Lan or Online)

event_teams - the number of teams in the tournament

prize_pool - prize pool of the tournament
playerID - player number (from 1 to 5); team_id - team number (1 or 2)

player [playerID]_days_in_current_team[team_id] - days how long player is in the team (0 or more)

player[playerID]_days_in_all_team[team_id] - days how long player is in all teams (0 or more)

player[playerID]_teams_all_team[team_id] - the number of teams the player was in (0 or more)

[param] _player [player] _team[team_id] - player statistics

[param] _maps_player [player_id] _team[team_id] - played maps for calculating statistics (only some parameters)

age_player [player_id] _team[team_id] - player age

[param][map]_team[team_id]

map_played[id]_team[team_id] - score; [id] - serial number of played map

map_played[id]_opponent_team[team_id] - opponent score; [id] - serial number of played map

[param]_team[team_id]

current_map_played_[id]_team[team_id] - score; [id] - serial number of played map

current_map_played_[id]_opponent_team[team_id] - opponent score; [id] - serial number of played map

Tables

Data Stat All Maps

@kaggle.artem1337_csgo_matches.data_stat_all_maps

4.32 MB
4,000 rows
850 columns

CREATE TABLE data_stat_all_maps (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "match_url" VARCHAR,
  "url_team1" VARCHAR,
  "url_team2" VARCHAR,
  "event_url" VARCHAR,
  "players_url_1" VARCHAR,
  "players_url_2" VARCHAR,
  "total_maps" BIGINT,
  "maps_played" BIGINT,
  "maps_url" VARCHAR,
  "maps_name" VARCHAR,
  "score1_maps" VARCHAR,
  "score2_maps" VARCHAR,
  "picks" VARCHAR,
  "date" TIMESTAMP,
  "score1" BIGINT,
  "score2" BIGINT,
  "h2h_wins1" BIGINT,
  "h2h_wins2" BIGINT,
  "rank1" VARCHAR,
  "rank2" VARCHAR,
  "last_maps1_score_team1" BIGINT,
  "last_maps1_opponent_score_team1" BIGINT,
  "last_maps2_score_team1" BIGINT,
  "last_maps2_opponent_score_team1" BIGINT,
  "last_maps3_score_team1" BIGINT,
  "last_maps3_opponent_score_team1" BIGINT,
  "last_maps4_score_team1" BIGINT,
  "last_maps4_opponent_score_team1" BIGINT,
  "last_maps5_score_team1" BIGINT,
  "last_maps5_opponent_score_team1" BIGINT,
  "last_maps6_score_team1" BIGINT,
  "last_maps6_opponent_score_team1" BIGINT,
  "last_maps7_score_team1" BIGINT,
  "last_maps7_opponent_score_team1" BIGINT,
  "last_maps8_score_team1" BIGINT,
  "last_maps8_opponent_score_team1" BIGINT,
  "last_maps9_score_team1" BIGINT,
  "last_maps9_opponent_score_team1" BIGINT,
  "last_maps10_score_team1" BIGINT,
  "last_maps10_opponent_score_team1" BIGINT,
  "last_maps11_score_team1" BIGINT,
  "last_maps11_opponent_score_team1" BIGINT,
  "last_maps12_score_team1" BIGINT,
  "last_maps12_opponent_score_team1" BIGINT,
  "last_maps13_score_team1" BIGINT,
  "last_maps13_opponent_score_team1" BIGINT,
  "last_maps14_score_team1" BIGINT,
  "last_maps14_opponent_score_team1" BIGINT,
  "last_maps15_score_team1" BIGINT,
  "last_maps15_opponent_score_team1" BIGINT,
  "last_maps16_score_team1" BIGINT,
  "last_maps16_opponent_score_team1" BIGINT,
  "last_maps17_score_team1" BIGINT,
  "last_maps17_opponent_score_team1" BIGINT,
  "last_maps18_score_team1" BIGINT,
  "last_maps18_opponent_score_team1" BIGINT,
  "last_maps19_score_team1" BIGINT,
  "last_maps19_opponent_score_team1" BIGINT,
  "last_maps20_score_team1" BIGINT,
  "last_maps20_opponent_score_team1" BIGINT,
  "last_maps1_score_team2" BIGINT,
  "last_maps1_opponent_score_team2" BIGINT,
  "last_maps2_score_team2" BIGINT,
  "last_maps2_opponent_score_team2" BIGINT,
  "last_maps3_score_team2" BIGINT,
  "last_maps3_opponent_score_team2" BIGINT,
  "last_maps4_score_team2" BIGINT,
  "last_maps4_opponent_score_team2" BIGINT,
  "last_maps5_score_team2" BIGINT,
  "last_maps5_opponent_score_team2" BIGINT,
  "last_maps6_score_team2" BIGINT,
  "last_maps6_opponent_score_team2" BIGINT,
  "last_maps7_score_team2" BIGINT,
  "last_maps7_opponent_score_team2" BIGINT,
  "last_maps8_score_team2" BIGINT,
  "last_maps8_opponent_score_team2" BIGINT,
  "last_maps9_score_team2" BIGINT,
  "last_maps9_opponent_score_team2" BIGINT,
  "last_maps10_score_team2" BIGINT,
  "last_maps10_opponent_score_team2" BIGINT,
  "last_maps11_score_team2" BIGINT,
  "last_maps11_opponent_score_team2" BIGINT,
  "last_maps12_score_team2" BIGINT,
  "last_maps12_opponent_score_team2" BIGINT,
  "last_maps13_score_team2" BIGINT,
  "last_maps13_opponent_score_team2" BIGINT,
  "last_maps14_score_team2" BIGINT,
  "last_maps14_opponent_score_team2" BIGINT,
  "last_maps15_score_team2" BIGINT,
  "last_maps15_opponent_score_team2" BIGINT,
  "last_maps16_score_team2" BIGINT,
  "last_maps16_opponent_score_team2" BIGINT,
  "last_maps17_score_team2" BIGINT,
  "last_maps17_opponent_score_team2" BIGINT,
  "last_maps18_score_team2" BIGINT,
  "last_maps18_opponent_score_team2" BIGINT,
  "last_maps19_score_team2" BIGINT,
  "last_maps19_opponent_score_team2" BIGINT,
  "last_maps20_score_team2" BIGINT
);