Name: Match Info And Ball By Ball Data For ODIs
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

Match Info And Ball By Ball Data For ODIs

This dataset encompasses detailed ball-by-ball data and match information for various cricket matches available in cricsheet website. The data provides an in-depth analysis at the granular level, capturing every ball bowled, the runs scored, the type of dismissal, and more.

Ball-by-Ball Data: Includes details like the batting team, over, batter, bowler, runs scored, extras, dismissal information, etc.
Match Info: Contains metadata about the match, like the venue, teams playing, toss decision, match outcome, and other relevant details.

Acknowledgment:
A big shoutout to Cricsheet for making such comprehensive cricket data available to the public. Their open-source initiative has empowered enthusiasts and analysts to understand the game better.

Data Extraction Process:
The raw data was sourced from Cricsheet in JSON format. A systematic extraction process was followed using Python, where each file was parsed to extract ball-by-ball data and match metadata. The data was then transformed and cleaned to form structured datasets, making it easier for researchers, analysts, and cricket enthusiasts to derive insights.

Usage:
This dataset is perfect for those looking to perform detailed cricket match analyses, understand patterns, player performances, or even develop predictive models. Whether you're a data scientist, a cricket enthusiast, or someone looking to delve into sports analytics, this dataset offers a plethora of opportunities.

Ball-by-Ball Dataset:

Match ID: A unique identifier for each match.
Inning Team: The team that is batting during the particular inning.
Over: The current over number in the inning.
Batter: The name of the batsman facing the delivery.
Bowler: The name of the bowler delivering the ball.
Non-striker: The name of the batsman at the non-striker's end.
Runs by Batter: Runs scored by the batsman on that particular delivery.
Extras: Extra runs awarded, such as no-balls or wides.
Total Runs: Total runs scored off the delivery (including runs by the batter and extras).
Wicket Kind: The method by which the batsman was dismissed (e.g., caught, bowled, run out).
Player Out: Name of the player who got out on that delivery.
Fielder: If the wicket kind involves a fielder (like caught or run out), this mentions the fielder's name.
Review By: The team that asked for the DRS review.
Umpire: The umpire who made the DRS decision.
Review Decision: The outcome of the DRS review (e.g., upheld, overturned).
Review Type: The type of review (e.g., LBW, caught behind).
Replacement In: Player who came in as a replacement.
Replacement Out: Player who was replaced.
Replacement Team: Team for which the replacement occurred.
Replacement Reason: Reason for the replacement.
Replacement Role: Role of the player being replaced (e.g., bowler, batsman).

Match Info Dataset:

Match ID: A unique identifier for each match.
City: The city where the match took place.
Date: The date on which the match was played.
Match Type: The format of the cricket match (e.g., ODI, T20).
Match Type Number: A unique number associated with the match type for that series.
Season: The cricket season/year.
Team Type: Type of team (e.g., international, domestic).
Team 1: One of the teams playing the match.
Team 2: The other team playing the match.
Toss Winner: The team that won the toss.
Toss Decision: The decision made by the toss-winning team (e.g., bat or field).
Venue: The stadium or ground where the match was played.
Winner: The team that won the match.
Win Margin Type: Indicates if the win margin is in terms of runs or wickets.
Win Margin: The margin by which the winning team won (in terms of runs or wickets).
Player of the Match: The player who was awarded the "Player of the Match" title.
Event Name: The name of the tournament or series.
Event Match Number: Match number in the event or series.
Event Stage: The stage of the event (e.g., Super Sixes, Finals).
Gender: Gender category of the match (e.g., male, female).
Umpire 1: One of the on-field umpires.
Umpire 2: The other on-field umpire.
TV Umpire: The third umpire.
Match Referee: The official match referee.

Tables

Ball By Ball Data

@kaggle.subhrajyotinath_match_info_and_ball_by_ball_data_for_odis.ball_by_ball_data

5.41 MB
1,266,326 rows
22 columns

CREATE TABLE ball_by_ball_data (
  "match_id" BIGINT,
  "inning_team" VARCHAR,
  "over" BIGINT,
  "batter" VARCHAR,
  "bowler" VARCHAR,
  "non_striker" VARCHAR,
  "runs_by_batter" BIGINT,
  "extras" BIGINT,
  "total_runs" BIGINT,
  "wicket_kind" VARCHAR,
  "player_out" VARCHAR,
  "fielder" VARCHAR,
  "review_by" VARCHAR,
  "umpire" VARCHAR,
  "review_decision" VARCHAR,
  "review_type" VARCHAR,
  "replacement_in" VARCHAR,
  "replacement_out" VARCHAR,
  "replacement_team" VARCHAR,
  "replacement_reason" VARCHAR,
  "replacement_role" VARCHAR,
  "current_wickets" BIGINT
);

Match Info

@kaggle.subhrajyotinath_match_info_and_ball_by_ball_data_for_odis.match_info

118.4 kB
2,382 rows
24 columns

CREATE TABLE match_info (
  "match_id" BIGINT,
  "city" VARCHAR,
  "date" TIMESTAMP,
  "match_type" VARCHAR,
  "match_type_number" BIGINT,
  "season" VARCHAR,
  "team_type" VARCHAR,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "venue" VARCHAR,
  "winner" VARCHAR,
  "win_margin_type" VARCHAR,
  "win_margin" DOUBLE,
  "player_of_the_match" VARCHAR,
  "event_name" VARCHAR,
  "event_match_number" DOUBLE,
  "event_stage" VARCHAR,
  "gender" VARCHAR,
  "umpire_1" VARCHAR,
  "umpire_2" VARCHAR,
  "tv_umpire" VARCHAR,
  "match_referee" VARCHAR
);