About this Dataset

IPL Dataset 2008-2022

Content

These datasets contains the data of all the Indian Premier League matches that has ever happened. The data about all IPL fixtures from first match to last occurred match are contained in different .csv files. These data can be used for analyzing the performance of each team in different matches. These datasets are great for Exploratory Data Analysis and visualization.

Attribute Information

Match ID - ID of the match
Date - Date of occurrence of the match
Venue - Match venue
Team1 - First team
Team2 - Second team
Toss Winner - Team who won the toss
Toss Decision - Decision of toss winner
Stage - Stage of match
First Innings Score - Score obtained in first innings
First Innings Wicket - Wickets fell in first innings
Second Innings score - Score obtained in second innings
Second Innings Wicket - Wickets fell in second innings
Match Winner - Winner of the match
Won by - Whether the match was won by runs or wickets
Margin - By how many wickets or runs was the match won
Player of the match - Name of the person chosen as the Player of the match

Source

Data source - Data was collected from different websites like www.wikipedia.com, www.espncricinfo.com, www.cricbuzz.com, etc.

Tables

Ipl 2008

@kaggle.amritharj_ipl_dataset_20082022.ipl_2008

14.4 KB
59 rows
16 columns


CREATE TABLE ipl_2008 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "second_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2009

@kaggle.amritharj_ipl_dataset_20082022.ipl_2009

14.28 KB
59 rows
16 columns


CREATE TABLE ipl_2009 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "seconds_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_match" VARCHAR
);

Ipl 2010

@kaggle.amritharj_ipl_dataset_20082022.ipl_2010

14.7 KB
60 rows
16 columns


CREATE TABLE ipl_2010 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2011

@kaggle.amritharj_ipl_dataset_20082022.ipl_2011

15.23 KB
74 rows
16 columns


CREATE TABLE ipl_2011 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "second_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2012

@kaggle.amritharj_ipl_dataset_20082022.ipl_2012

15.09 KB
76 rows
16 columns


CREATE TABLE ipl_2012 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "second_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2013

@kaggle.amritharj_ipl_dataset_20082022.ipl_2013

15.1 KB
76 rows
16 columns


CREATE TABLE ipl_2013 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2014

@kaggle.amritharj_ipl_dataset_20082022.ipl_2014

14.42 KB
60 rows
16 columns


CREATE TABLE ipl_2014 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "stage" VARCHAR,
  "toss_decision" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2015

@kaggle.amritharj_ipl_dataset_20082022.ipl_2015

14.53 KB
60 rows
16 columns


CREATE TABLE ipl_2015 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "second_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2016

@kaggle.amritharj_ipl_dataset_20082022.ipl_2016

14.36 KB
60 rows
16 columns


CREATE TABLE ipl_2016 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" BIGINT,
  "player_of_the_match" VARCHAR
);

Ipl 2017

@kaggle.amritharj_ipl_dataset_20082022.ipl_2017

14.46 KB
60 rows
16 columns


CREATE TABLE ipl_2017 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" DOUBLE,
  "first_innings_wicket" DOUBLE,
  "second_innings_score" DOUBLE,
  "second_innings_wicket" DOUBLE,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2018

@kaggle.amritharj_ipl_dataset_20082022.ipl_2018

14.32 KB
60 rows
16 columns


CREATE TABLE ipl_2018 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" BIGINT,
  "player_of_the_match" VARCHAR
);

Ipl 2019

@kaggle.amritharj_ipl_dataset_20082022.ipl_2019

14.41 KB
60 rows
16 columns


CREATE TABLE ipl_2019 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2020

@kaggle.amritharj_ipl_dataset_20082022.ipl_2020

14.41 KB
60 rows
16 columns


CREATE TABLE ipl_2020 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2021

@kaggle.amritharj_ipl_dataset_20082022.ipl_2021

14.33 KB
60 rows
16 columns


CREATE TABLE ipl_2021 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" DOUBLE,
  "player_of_the_match" VARCHAR
);

Ipl 2022

@kaggle.amritharj_ipl_dataset_20082022.ipl_2022

15.04 KB
74 rows
16 columns


CREATE TABLE ipl_2022 (
  "match_id" BIGINT,
  "date" VARCHAR,
  "venue" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "stage" VARCHAR,
  "first_innings_score" BIGINT,
  "first_innings_wicket" BIGINT,
  "second_innings_score" BIGINT,
  "second_innings_wicket" BIGINT,
  "match_winner" VARCHAR,
  "won_by" VARCHAR,
  "margin" BIGINT,
  "player_of_the_match" VARCHAR
);