Name: All T20 Internationals Dataset (2005 - 2024)
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

All T20 Internationals Dataset (2005 - 2024)

This extensive dataset serves as a comprehensive repository of historical information regarding T20 International (T20I) cricket matches dating back to the inception of the format. T20I cricket is renowned for its thrilling encounters, and this dataset meticulously documents the particulars of these matches. It stands as a valuable resource for cricket enthusiasts, statisticians, and analysts eager to delve into and dissect T20I cricket data.

Key Features:

Match Details: Thorough information pertaining to each T20I match, encompassing match date, location, and format.
Teams and Players: In-depth details about the participating teams, encompassing player names, roles, and batting/bowling statistics).
Match Outcomes: Insights into match results, encompassing the victorious team and the margin of victory.
Player of the Match: Recognition of the standout player in each T20I match.
Umpires and Match Referees: Particulars of the officials responsible for overseeing the match.
Toss Details: Revelations about the toss winner's decisions, which can significantly influence the game's trajectory.
Venue Information: Location specifics, including stadium name, city, and country.

Potential Use Cases:

Historical Analysis: Investigate and analyze trends and patterns in T20I cricket across different eras.
Performance Evaluation: Evaluate player and team performances based on batting and bowling statistics.
Match Strategy: Gain insights into the impact of toss decisions on match outcomes.
Fantasy Cricket: Ideal for fantasy cricket enthusiasts aiming to construct teams using historical player data.
Sports Journalism: A valuable data source for sports journalists and writers.

Whether you're a passionate cricket fan seeking to relive the excitement of classic T20I matches or an analyst in pursuit of insights, this dataset is a veritable treasure trove of T20I cricket history.

Embark on a journey through the world of T20I cricket, unravel the statistics, and savor the thrill of cricket matches spanning two decades!

Tables

Players Info

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.players_info

642.63 kB
6,701 rows
11 columns

CREATE TABLE players_info (
  "player_id" BIGINT,
  "player_object_id" BIGINT,
  "player_name" VARCHAR,
  "dob" TIMESTAMP,
  "dod" TIMESTAMP,
  "gender" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "country_id" DOUBLE,
  "image_url" VARCHAR,
  "image_metadata" VARCHAR
);

T20i Batting Card

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.t20i_batting_card

590.95 kB
56,357 rows
13 columns

CREATE TABLE t20i_batting_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "team" VARCHAR,
  "batsman" DOUBLE,
  "runs" DOUBLE,
  "balls" DOUBLE,
  "fours" DOUBLE,
  "sixes" DOUBLE,
  "strikerate" DOUBLE,
  "isout" VARCHAR,
  "wickettype" VARCHAR,
  "fielders" VARCHAR,
  "bowler" DOUBLE
);

T20i Bowling Card

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.t20i_bowling_card

310.19 kB
30,648 rows
16 columns

CREATE TABLE t20i_bowling_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "bowler_id" DOUBLE,
  "overs" DOUBLE,
  "balls" DOUBLE,
  "maidens" DOUBLE,
  "conceded" DOUBLE,
  "wickets" DOUBLE,
  "economy" DOUBLE,
  "dots" DOUBLE,
  "fours" DOUBLE,
  "sixes" DOUBLE,
  "wides" DOUBLE,
  "noballs" DOUBLE
);

T20i Fow Card

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.t20i_fow_card

190.24 kB
33,093 rows
7 columns

CREATE TABLE t20i_fow_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "team" VARCHAR,
  "player" DOUBLE,
  "wicket" DOUBLE,
  "over" DOUBLE,
  "runs" DOUBLE
);

T20i Matches Data

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.t20i_matches_data

441.68 kB
2,592 rows
33 columns

CREATE TABLE t20i_matches_data (
  "t20i_match_no" BIGINT,
  "match_id" BIGINT,
  "match_name" VARCHAR,
  "series_id" BIGINT,
  "series_name" VARCHAR,
  "match_date" TIMESTAMP,
  "match_format" VARCHAR,
  "team1_id" BIGINT,
  "team1_name" VARCHAR,
  "team1_captain" BIGINT,
  "team1_runs_scored" DOUBLE,
  "team1_wickets_fell" DOUBLE,
  "team1_extras_rec" DOUBLE,
  "team2_id" BIGINT,
  "team2_name" VARCHAR,
  "team2_captain" BIGINT,
  "team2_runs_scored" DOUBLE,
  "team2_wickets_fell" DOUBLE,
  "team2_extras_rec" DOUBLE,
  "match_venue_stadium" VARCHAR  -- Match Venue (Stadium),
  "match_venue_city" VARCHAR  -- Match Venue (City),
  "match_venue_country" VARCHAR  -- Match Venue (Country),
  "umpire_1" VARCHAR,
  "umpire_2" VARCHAR,
  "match_referee" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_winner_choice" VARCHAR,
  "match_winner" VARCHAR,
  "match_result_text" VARCHAR,
  "mom_player" DOUBLE,
  "team1_playing_11" VARCHAR,
  "team2_playing_11" VARCHAR,
  "debut_players" VARCHAR
);

T20i Partnership Card

@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.t20i_partnership_card

409.21 kB
36,799 rows
13 columns

CREATE TABLE t20i_partnership_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "for_wicket" DOUBLE,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "player1" DOUBLE,
  "player2" DOUBLE,
  "player1_runs" DOUBLE,
  "player2_runs" DOUBLE,
  "player1_balls" DOUBLE,
  "player2_balls" DOUBLE,
  "partnership_runs" DOUBLE,
  "partnership_balls" DOUBLE
);