Name: IPL Complete Dataset (2008 - 2022)
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

IPL Complete Dataset (2008 - 2022)

Purpose

IPL 2022 is over and we can start analyzing the data from IPL 2008 - 2022. Dataset can be used to perform exploratory data analysis and to build machine learning models. This data set contains match information and detailed information about each innings.

Files

Dataset has two files:

ipl_match_info_data.csv - This file has information about each match.
ipl_match_ball_by_ball_data.csv - This file has information about every ball played in the innings.

Content

Both the file has match_id which is the key column for each match.

Tables

Ipl Match Ball By Ball Data

@kaggle.biswajitbrahmma_ipl_complete_dataset_2008_2022.ipl_match_ball_by_ball_data

857.7 kB
225,954 rows
22 columns

CREATE TABLE ipl_match_ball_by_ball_data (
  "match_id" BIGINT,
  "season" VARCHAR,
  "start_date" TIMESTAMP,
  "venue" VARCHAR,
  "innings" BIGINT,
  "ball" DOUBLE,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "striker" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "runs_off_bat" BIGINT,
  "extras" BIGINT,
  "wides" DOUBLE,
  "noballs" DOUBLE,
  "byes" DOUBLE,
  "legbyes" DOUBLE,
  "penalty" DOUBLE,
  "wicket_type" VARCHAR,
  "player_dismissed" VARCHAR,
  "other_wicket_type" VARCHAR,
  "other_player_dismissed" VARCHAR
);

Ipl Match Info Data

@kaggle.biswajitbrahmma_ipl_complete_dataset_2008_2022.ipl_match_info_data

51.58 kB
950 rows
27 columns

CREATE TABLE ipl_match_info_data (
  "match_id" BIGINT,
  "season" VARCHAR,
  "date" TIMESTAMP,
  "city" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "player_of_match" VARCHAR,
  "winner" VARCHAR,
  "winner_wickets" BIGINT,
  "winner_runs" BIGINT,
  "outcome" VARCHAR,
  "result_type" VARCHAR,
  "results" BIGINT,
  "gender" VARCHAR,
  "event" VARCHAR,
  "match_number" DOUBLE,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "reserve_umpire" VARCHAR,
  "tv_umpire" VARCHAR,
  "match_referee" VARCHAR,
  "eliminator" VARCHAR,
  "method" VARCHAR,
  "date_1" TIMESTAMP
);