Dataset: ODI Cricket Matches Dataset (1971 - 2024)

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.01 MB
103225 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

565.37 KB
56514 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

351.91 KB
67963 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

587.07 KB
4745 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_city" VARCHAR,
  "match_venue_country" VARCHAR,
  "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

703.87 KB
73826 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

627.57 KB
6701 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
);