Dataset: ICC Champions Trophy Cricket Dataset (1998-2017)

About this Dataset

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 -

all_champions_trophy_matches_results - This dataset has 19 different attributes.

Team1 (string): Team 1 of the match
Team2 (string): Team 2 of the match
Toss (string): Team who won the toss, and whether decided to bat or field first
Match days (string): Either 'day' or 'daynight' match
Winner (string): Winner of Team 1 vs Team 2. If result ended in a tie, then the value is 'tied', and if that match was abandoned, then the value is 'no result'
Player of the Match (string): Player of the Match of a particular content. If match was abandoned, value would be null
Margin (string): Margin of victory of Winner, it could be either in runs or wickets
Ground (string): Ground at which the match was played
Match Date (string): Date when the match was played
ODI Int Match (string): ODI International Match No.
Team1 Avg Batting Ranking (number): Batting average of all participating players of Team1 in a particular CT edition one-day prior to the match played. If any player is not included in the Top 100 of ICC Men's ODI Batting Ranking, the player is assigned a ranking of 101 to maintain data consistency and avoid missing values. Data is web-scraped through https://www.relianceiccrankings.com/datespecific/odi/batting/2024/07/06/ (for example).Accurate data is scraped by inputting date equal to the day prior of the contest in the url.
Team2 Avg Batting Ranking (number): Batting average of all participating players of Team2 in a particular CT edition one-day prior to the match played. If any player is not included in the Top 100 of ICC Men's ODI Batting Ranking, the player is assigned a ranking of 101 to maintain data consistency and avoid missing values. Data is web-scraped through https://www.relianceiccrankings.com/datespecific/odi/batting/2024/07/06/ (for example).Accurate data is scraped by inputting date equal to the day prior of the contest in the url.
Team1 Avg Bowling Ranking (number): Bowling average of all participating players of Team1 in a particular CT edition one-day prior to the match played. If any player is not included in the Top 100 of ICC Men's ODI Bowling Ranking, the player is assigned a ranking of 101 to maintain data consistency and avoid missing values. Data is web-scraped through https://www.relianceiccrankings.com/datespecific/odi/bowling/2024/07/06/ (for example).Accurate data is scraped by inputting date equal to the day prior of the contest in the url.
Team2 Avg Bowling Ranking (number): Bowling average of all participating players of Team2 in a particular CT edition one-day prior to the match played. If any player is not included in the Top 100 of ICC Men's ODI Bowling Ranking, the player is assigned a ranking of 101 to maintain data consistency and avoid missing values. Data is web-scraped through https://www.relianceiccrankings.com/datespecific/odi/bowling/2024/07/06/ (for example).Accurate data is scraped by inputting date equal to the day prior of the contest in the url
Team1 Total CTs participated (number): Total participation in CTs by Team1. Data recorded till one day before the start of each CT
Team1 Total CTs won (number): Total CTs editions won by Team1. Data recorded till one day before the start of each CT
Team2 Total CTs partipated (number): Total participation in CTs by Team2. Data recorded till one day before the start of each CT
Team2 Total CTs won (number): Total CTs editions won by Team2. Data recorded till one day before the start of each CT
Team1 win % over Team2 (number): Team1 W (Win)/L (Loss) ratio Team2 leading upto that match including all ODI Int matches. This data is recorded manually using Cricinfo's popular Statsguru (https://stats.espncricinfo.com/ci/engine/stats/index.html)

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.

Team (string): Name of the country
Year (string): Year of participation
Player Name(string): Player Name of the Team

Tables

All Champions Trophy Matches Results

@kaggle.kamalisrani_icc_champions_trophy_cricket_dataset_1998_2017.all_champions_trophy_matches_results

22.22 KB
115 rows
19 columns


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
);

All Champions Trophy Players List

@kaggle.kamalisrani_icc_champions_trophy_cricket_dataset_1998_2017.all_champions_trophy_players_list

11.62 KB
1036 rows
3 columns


CREATE TABLE all_champions_trophy_players_list (
  "team" VARCHAR,
  "year" BIGINT,
  "player_name" VARCHAR
);