Dataset: IPL Complete Dataset (2008 - 2022)

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

837.59 KB
225954 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

50.37 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
);