CS:GO Match History

History of matches between teams in the game Counter Strike: Global Offensive

@kaggle.artem1337_csgo_matches

Table List

1 table(4.12 MB)

Data Stat All Maps

@kaggle.artem1337_csgo_matches.data_stat_all_maps

4.12 MB
4000 rows
850 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	match_url Match Url	url_team1 Url Team1	url_team2 Url Team2	event_url Event Url	players_url_1 Players Url 1	players_url_2 Players Url 2	total_maps Total Maps	maps_played Maps Played	maps_url Maps Url	maps_name Maps Name	score1_maps Score1 Maps	score2_maps Score2 Maps	picks Picks	date Date	score1 Score1	score2 Score2	h2h_wins1 H2h Wins1	h2h_wins2 H2h Wins2	rank1 Rank1	rank2 Rank2	last_maps1_score_team1 Last Maps1 Score Team1	last_maps1_opponent_score_team1 Last Maps1 Opponent Score Team1	last_maps2_score_team1 Last Maps2 Score Team1	last_maps2_opponent_score_team1 Last Maps2 Opponent Score Team1	last_maps3_score_team1 Last Maps3 Score Team1	last_maps3_opponent_score_team1 Last Maps3 Opponent Score Team1	last_maps4_score_team1 Last Maps4 Score Team1	last_maps4_opponent_score_team1 Last Maps4 Opponent Score Team1	last_maps5_score_team1 Last Maps5 Score Team1	last_maps5_opponent_score_team1 Last Maps5 Opponent Score Team1	last_maps6_score_team1 Last Maps6 Score Team1	last_maps6_opponent_score_team1 Last Maps6 Opponent Score Team1	last_maps7_score_team1 Last Maps7 Score Team1	last_maps7_opponent_score_team1 Last Maps7 Opponent Score Team1	last_maps8_score_team1 Last Maps8 Score Team1	last_maps8_opponent_score_team1 Last Maps8 Opponent Score Team1	last_maps9_score_team1 Last Maps9 Score Team1	last_maps9_opponent_score_team1 Last Maps9 Opponent Score Team1	last_maps10_score_team1 Last Maps10 Score Team1	last_maps10_opponent_score_team1 Last Maps10 Opponent Score Team1	last_maps11_score_team1 Last Maps11 Score Team1	last_maps11_opponent_score_team1 Last Maps11 Opponent Score Team1	last_maps12_score_team1 Last Maps12 Score Team1	last_maps12_opponent_score_team1 Last Maps12 Opponent Score Team1	last_maps13_score_team1 Last Maps13 Score Team1	last_maps13_opponent_score_team1 Last Maps13 Opponent Score Team1	last_maps14_score_team1 Last Maps14 Score Team1	last_maps14_opponent_score_team1 Last Maps14 Opponent Score Team1	last_maps15_score_team1 Last Maps15 Score Team1	last_maps15_opponent_score_team1 Last Maps15 Opponent Score Team1	last_maps16_score_team1 Last Maps16 Score Team1	last_maps16_opponent_score_team1 Last Maps16 Opponent Score Team1	last_maps17_score_team1 Last Maps17 Score Team1	last_maps17_opponent_score_team1 Last Maps17 Opponent Score Team1	last_maps18_score_team1 Last Maps18 Score Team1	last_maps18_opponent_score_team1 Last Maps18 Opponent Score Team1	last_maps19_score_team1 Last Maps19 Score Team1	last_maps19_opponent_score_team1 Last Maps19 Opponent Score Team1	last_maps20_score_team1 Last Maps20 Score Team1	last_maps20_opponent_score_team1 Last Maps20 Opponent Score Team1	last_maps1_score_team2 Last Maps1 Score Team2	last_maps1_opponent_score_team2 Last Maps1 Opponent Score Team2	last_maps2_score_team2 Last Maps2 Score Team2	last_maps2_opponent_score_team2 Last Maps2 Opponent Score Team2	last_maps3_score_team2 Last Maps3 Score Team2	last_maps3_opponent_score_team2 Last Maps3 Opponent Score Team2	last_maps4_score_team2 Last Maps4 Score Team2	last_maps4_opponent_score_team2 Last Maps4 Opponent Score Team2	last_maps5_score_team2 Last Maps5 Score Team2	last_maps5_opponent_score_team2 Last Maps5 Opponent Score Team2	last_maps6_score_team2 Last Maps6 Score Team2	last_maps6_opponent_score_team2 Last Maps6 Opponent Score Team2	last_maps7_score_team2 Last Maps7 Score Team2	last_maps7_opponent_score_team2 Last Maps7 Opponent Score Team2	last_maps8_score_team2 Last Maps8 Score Team2	last_maps8_opponent_score_team2 Last Maps8 Opponent Score Team2	last_maps9_score_team2 Last Maps9 Score Team2	last_maps9_opponent_score_team2 Last Maps9 Opponent Score Team2	last_maps10_score_team2 Last Maps10 Score Team2	last_maps10_opponent_score_team2 Last Maps10 Opponent Score Team2	last_maps11_score_team2 Last Maps11 Score Team2	last_maps11_opponent_score_team2 Last Maps11 Opponent Score Team2	last_maps12_score_team2 Last Maps12 Score Team2	last_maps12_opponent_score_team2 Last Maps12 Opponent Score Team2	last_maps13_score_team2 Last Maps13 Score Team2	last_maps13_opponent_score_team2 Last Maps13 Opponent Score Team2	last_maps14_score_team2 Last Maps14 Score Team2	last_maps14_opponent_score_team2 Last Maps14 Opponent Score Team2	last_maps15_score_team2 Last Maps15 Score Team2	last_maps15_opponent_score_team2 Last Maps15 Opponent Score Team2	last_maps16_score_team2 Last Maps16 Score Team2	last_maps16_opponent_score_team2 Last Maps16 Opponent Score Team2	last_maps17_score_team2 Last Maps17 Score Team2	last_maps17_opponent_score_team2 Last Maps17 Opponent Score Team2	last_maps18_score_team2 Last Maps18 Score Team2	last_maps18_opponent_score_team2 Last Maps18 Opponent Score Team2	last_maps19_score_team2 Last Maps19 Score Team2	last_maps19_opponent_score_team2 Last Maps19 Opponent Score Team2	last_maps20_score_team2 Last Maps20 Score Team2
	/matches/2341924/hard-legion-vs-hellraisers-lootbet-season-7	/team/10421/hard-legion	/team/5310/hellraisers	/events/5359/lootbet-season-7	['/player/12027/Krad', '/player/13982/Forester', '/player/3459/kinqie', '/player/12016/svyat', '/player/14171/rAge']	['/player/11250/Flarich', '/player/8786/jR', '/player/9410/kalinka', '/player/16870/ProbLeM', '/player/19232/JIaYm']	3	3	['/stats/matches/mapstatsid/103958/hard-legion-vs-hellraisers', '/stats/matches/mapstatsid/103964/hellraisers-vs-hard-legion', '/stats/matches/mapstatsid/103969/hellraisers-vs-hard-legion']	['Inferno', 'Dust2', 'Train']	['16', '9', '16']	['14', '16', '12']	[-1, 1]	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	4	2	World rank: #30	World rank: #66	16	7	16	10	16	6	9	16	16	12	6	16	16	19	16	5	10	16	16	12	20	22	12	16	5	16	14	16	6	16	16	9	14	16	16	11	8	16	9	16	16	11	13	16	16	13	22	18	16	9	9	16	16	14	11	16	4	16	5	16	16	11	16	14	16	13	16	13	16	19	14	16	10	16	16	10	19	17	10
1	/matches/2341888/bantz-vs-truckers-with-attitude-lpl-pro-league-season-5	/team/10712/bantz	/team/10713/truckers-with-attitude	/events/5319/lpl-pro-league-season-5	['/player/18737/Falcon', '/player/20017/motion', '/player/18738/Roflko', '/player/20086/addict', '/player/12588/BRACE']	['/player/18736/pz', '/player/11806/JD', '/player/17307/smooth_criminal22', '/player/16281/swede', '/player/12573/pan1K']	3	3	['/stats/matches/mapstatsid/103959/bantz-vs-truckers-with-attitude', '/stats/matches/mapstatsid/103966/truckers-with-attitude-vs-bantz', '/stats/matches/mapstatsid/103968/truckers-with-attitude-vs-bantz']	['Vertigo', 'Inferno', 'Mirage']	['19', '7', '9']	['16', '16', '16']	[-1, 1]	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2		1	World rank: #108	World rank: #100	16	6	16	13	8	16	16	19	16	6	11	16	17	19	16	10	16	8	16	11	16	6	8	16																	16	6	16	14	16	8	16	12	16	7	13	16	19	17	6	16	16	3	16	10	16	7	16	4	8	16
2	/matches/2341576/natus-vincere-vs-mad-lions-dreamhack-masters-spring-2020-europe	/team/4608/natus-vincere	/team/8362/mad-lions	/events/5285/dreamhack-masters-spring-2020-europe	['/player/7594/flamie', '/player/7998/s1mple', '/player/8918/electronic', '/player/11840/Boombl4', '/player/16947/Perfecto']	['/player/10330/acoR', '/player/14148/sjuush', '/player/9612/Bubzkji', '/player/14419/roeJ', '/player/8151/AcilioN']	3	2	['/stats/matches/mapstatsid/103961/natus-vincere-vs-mad-lions', '/stats/matches/mapstatsid/103965/mad-lions-vs-natus-vincere']	['Mirage', 'Overpass']	['16', '16']	['5', '7']	[-1, 1]	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2				World rank: #1	World rank: #17	12	16	19	22	15	12	10	13	11	13	13	3	13	11	15	12	2	13	13	11	16	14	16	8	14	16	12	16	16	9	16	14	8	16	16	19	14	16	12	16	16	10	5	16	16	7	16	12	16	12	18	22	13	16	15	15	16	5	16	7	16	10	16	10	16	5	9	16	14	16	13	16	7	16	16	11	16	13	16
3	/matches/2342056/pc419-vs-overt-esea-mdl-season-34-australia	/team/9750/pc419	/team/10711/overt	/events/5264/esea-mdl-season-34-australia	['/player/11793/dash', '/player/11803/Fluent%20Swede', '/player/9104/DANZ', '/player/9116/m0nt', '/player/11452/Magnum']	['/player/12584/vax', '/player/11808/xeL', '/player/18351/cl0ver', '/player/19956/Jam', '/player/18355/Hyphen']	1	1	['/stats/matches/mapstatsid/103960/overt-vs-pc419']	['Overpass']	['10']	['16']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	10	16			World rank: #162	World rank: #138	9	16	9	16	2	16	2	16	6	16	13	16	16	14	4	16	6	16	16	8																					6	16	18	22	6	16	8	16	16	6	16	9	4	16	11	16	14	16	13	16	14	16	16	8	7	16	5	16	16	10
4	/matches/2342055/order-vs-skyfire-esea-mdl-season-34-australia	/team/8668/order	/team/6161/skyfire	/events/5264/esea-mdl-season-34-australia	['/player/11139/aliStair', '/player/16323/Valiance', '/player/9108/tucks', '/player/8745/Rickeh', '/player/12593/J1rah']	['/player/11492/Noisia', '/player/8770/MoeycQ', '/player/17394/tot', '/player/16034/Dirty', '/player/14502/Prodigy']	1	1	['/stats/matches/mapstatsid/103957/skyfire-vs-order']	['Dust2']	['16']	['14']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	16	14	1		World rank: #68	World rank: #130	16	5	16	11	13	16	10	16	16	13	16	13	16	8	13	16	10	16	16	6	16	6	16	7	16	7	11	16	16	11	16	4	19	16	16	2	16	7	16	11	17	19	16	5	14	16	9	16	6	16	7	16	13	16	11	16	19	16	16	12	16	14	7	16	14	16	16	6	16	12	14	16	3	16	16	12	16	9	13
5	/matches/2341973/japaleno-vs-honoris-home-sweet-home-cup-8	/team/7144/japaleno	/team/10737/honoris	/events/5355/home-sweet-home-cup-8	['/player/9277/FREDDyFROG', '/player/9279/Relaxa', '/player/15639/dezon', '/player/9811/PlesseN', '/player/13361/tabz']	['/player/165/NEO', '/player/161/TaZ', '/player/12699/STOMP', '/player/15203/reiko', '/player/18979/Prism']	1	1	['/stats/matches/mapstatsid/103956/honoris-vs-japaleno']	['Mirage']	['12']	['16']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	16			World rank: #86	World rank: #113	14	16	8	16	5	16	16	10	12	16	12	16	13	16	7	16	11	16	14	16	16	5	16	5	16	10	16	8	9	16	4	16	19	22	8	16	13	16	6	16	19	17	16	14	8	16	3	16	13	16	8	16	16	6	9	16	5	16	16	13	4	16	6	16	16	4	14	16	11	16
6	/matches/2342053/incept-vs-pc419-esea-mdl-season-34-australia	/team/7135/incept	/team/9750/pc419	/events/5264/esea-mdl-season-34-australia	['/player/18195/micalis', '/player/14956/yourwombat', '/player/14689/nibke', '/player/14290/SkulL', '/player/18890/Rev']	['/player/11793/dash', '/player/11803/Fluent%20Swede', '/player/9104/DANZ', '/player/9116/m0nt', '/player/11452/Magnum']	1	1	['/stats/matches/mapstatsid/103954/pc419-vs-incept']	['Mirage']	['19']	['16']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	19	16			World rank: #132	World rank: #162	13	16	5	16	16	14	13	16	5	16	4	16	16	5	10	16	13	16	16	13	16	8	16	11	10	16	12	16	19	16	16	11	16	13	8	16	6	16	7	16	9	16	9	16	2	16	2	16	6	16	13	16	16	14	4	16	6	16	16	8
7	/matches/2341887/rooster-vs-downfall-lpl-pro-league-season-5	/team/9881/rooster	/team/8883/downfall	/events/5319/lpl-pro-league-season-5	['/player/12877/chelleos', '/player/18214/nettik', '/player/17385/DannyG', '/player/17390/ADK', '/player/18024/jhd']	['/player/13056/moop', '/player/17934/kyson', '/player/14329/2D', '/player/12889/eLUSIVE', '/player/17582/bogeymanh']	3	2	['/stats/matches/mapstatsid/103949/downfall-vs-rooster', '/stats/matches/mapstatsid/103953/rooster-vs-downfall']	['Inferno', 'Overpass']	['16', '16']	['6', '13']	[1, -1]	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2				World rank: #94	Unranked	19	17	16	3	16	7	5	16	9	16	16	5	7	16	16	11	11	16	16	14	16	19	16	11	7	16	16	13	16	9	16	12	16	4	16	7	16	13	11	16
8	/matches/2342054/ground-zero-vs-forbidden-esea-mdl-season-34-australia	/team/8536/ground-zero	/team/10715/forbidden	/events/5264/esea-mdl-season-34-australia	['/player/9636/BURNRUOk', '/player/16529/Llamas', '/player/9680/Noobster', '/player/18017/PEARSS', '/player/19190/Liki']	['/player/20041/combo', '/player/19905/Zym', '/player/19731/charizard', '/player/20039/rayn', '/player/19906/damyo']	1	1	['/stats/matches/mapstatsid/103952/ground-zero-vs-forbidden']	['Mirage']	['16']	['9']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	16	9			World rank: #96	World rank: #148	10	16	4	16	16	8	16	8	16	1	16	9	16	9	16	8	16	14	12	16	7	16	4	16	16	6	16	4	8	16	4	16	15	19	6	16	7	16	16	19	5	16	3	16	7	16	6	16	16	13	6	16	3	16	5	16	16	13	5	16	10	16
9	/matches/2342052/control-vs-order-esea-mdl-season-34-australia	/team/8434/control	/team/8668/order	/events/5264/esea-mdl-season-34-australia	['/player/18356/rewind', '/player/12874/Bz', '/player/18359/lew', '/player/18357/dreams', '/player/20088/tieay']	['/player/11139/aliStair', '/player/16323/Valiance', '/player/9108/tucks', '/player/8745/Rickeh', '/player/12593/J1rah']	1	1	['/stats/matches/mapstatsid/103951/order-vs-control']	['Nuke']	['1']	['16']	nan	Thu Jun 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16			World rank: #135	World rank: #68	3	16	2	16	11	16	6	16	16	6	16	6																													16	5	16	11	13	16	10	16	16	13	16	13	16	8	13	16	10	16	16	6	16	6	16	7	16	7	11	16	16	11	16	4	19	16	16	2	16	7	16


CREATE TABLE data_stat_all_maps (
  "unnamed_0" BIGINT,
  "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
);