Name: ODI Cricket Matches Dataset (1971 - 2024)
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

ODI Cricket Matches Dataset (1971 - 2024)

This extensive dataset provides a rich repository of historical information on One Day International (ODI) cricket matches played since 1971. ODI cricket is known for its thrilling encounters, and this dataset captures the details of these matches comprehensively. It is a valuable resource for cricket enthusiasts, statisticians, and analysts interested in exploring and analyzing ODI cricket data.

Key Features:

Match Details: Comprehensive information about each ODI match, including match date, location, and format.
Teams and Players: Details of the participating teams, including player names, roles, and batting/bowling statistics.
Match Outcomes: Information on match results, including the winning team and margin of victory.
Player of the Match: Recognition of the standout player in each match.
Umpires and Match Referees: Details of the officials responsible for overseeing the match.
Toss Details: Insights into the toss winner's choice, influencing the course of the game.
Venue Information: Location details, including stadium name, city, and country.

Potential Use Cases:

Historical Analysis: Study and analyze trends and patterns in ODI cricket over the years.
Performance Evaluation: Assess the performance of players and teams based on batting, and bowling statistics.
Match Strategy: Understand the impact of toss decisions on match outcomes.
Fantasy Cricket: Ideal for fantasy cricket enthusiasts looking to build teams based on historical player data.
Sports Journalism: Source of valuable data for sports journalists and writers.

Whether you're a cricket fan looking to relive the moments of classic matches or an analyst seeking insights, this dataset is a treasure trove of ODI cricket history.

Explore the world of ODI cricket, unravel the statistics, and enjoy the excitement of cricket matches spanning over five decades!

Tables

Odi Batting Card

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.odi_batting_card

1.06 MB
103,225 rows
13 columns

CREATE TABLE odi_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
);

Odi Bowling Card

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.odi_bowling_card

578.93 kB
56,514 rows
16 columns

CREATE TABLE odi_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
);

Odi Fow Card

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.odi_fow_card

360.35 kB
67,963 rows
7 columns

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

Odi Matches Data

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.odi_matches_data

601.16 kB
4,745 rows
33 columns

CREATE TABLE odi_matches_data (
  "odi_match_no" BIGINT,
  "match_id" BIGINT,
  "match_name" VARCHAR,
  "series_id" DOUBLE,
  "series_name" VARCHAR,
  "match_date" TIMESTAMP,
  "match_format" VARCHAR,
  "team1_id" DOUBLE,
  "team1_name" VARCHAR,
  "team1_captain" DOUBLE,
  "team1_runs_scored" DOUBLE,
  "team1_wickets_fell" DOUBLE,
  "team1_extras_rec" DOUBLE,
  "team2_id" DOUBLE,
  "team2_name" VARCHAR,
  "team2_captain" DOUBLE,
  "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
);

Odi Partnership Card

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.odi_partnership_card

720.76 kB
73,826 rows
13 columns

CREATE TABLE odi_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
);

Players Info

@kaggle.bhuvaneshprasad_odi_matches_historical_data_since_1971.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
);