ICC Champions Trophy Cricket Dataset (1998-2017)
Dataset containing all ICC Champions Trophy matches results from 1998-2017
@kaggle.kamalisrani_icc_champions_trophy_cricket_dataset_1998_2017
Dataset containing all ICC Champions Trophy matches results from 1998-2017
@kaggle.kamalisrani_icc_champions_trophy_cricket_dataset_1998_2017
Context
The ICC Champions Trophy, is one of cricket's premier limited-overs tournaments, played a pivotal role in international cricket from its inception in 1998 until its last edition in 2017. Originally known as the ICC KnockOut, the tournament was designed to bring together the world's leading cricketing nations in a competitive, yet entertaining format. This data provides the relevant information of all ICC Champions Trophy matches played played between 1998 to 2017. This could be used to predict results of upcoming matches, draw meaningful insights from data such as which all factors majorly contribute to the success of any team.
Content
The data is collected through web-scrapping of different sections of Cricinfo's official website.
Dataset Information
The dataset has 2 different sections -
2.all_champions_trophy_players_list - This dataset has 3 different attributes. This data gives information about the team's (in ascending order, hence starting with Australia) which participated in a particular edition of the CT, along with the player's taking part in the competition.
CREATE TABLE all_champions_trophy_matches_results (
"team1" VARCHAR,
"team2" VARCHAR,
"toss" VARCHAR,
"match_days" VARCHAR,
"winner" VARCHAR,
"player_of_the_match" VARCHAR,
"margin" VARCHAR,
"ground" VARCHAR,
"match_date" TIMESTAMP,
"odi_int_match" VARCHAR,
"team1_avg_batting_ranking" DOUBLE,
"team2_avg_batting_ranking" DOUBLE,
"team1_avg_bowling_ranking" DOUBLE,
"team2_avg_bowling_ranking" DOUBLE,
"team1_total_cts_participated" BIGINT,
"team1_total_cts_won" BIGINT,
"team2_total_cts_participated" BIGINT,
"team2_total_cts_won" BIGINT,
"team1_w_l_ratio_over_team2" DOUBLE
);CREATE TABLE all_champions_trophy_players_list (
"team" VARCHAR,
"year" BIGINT,
"player_name" VARCHAR
);Anyone who has the link will be able to view this.