Name: IPL 2020 Complete Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

IPL 2020 Complete Data

Complete data of all IPL 2020 matches is provided in this space for data enthusiasts to aid their flair. The data will be refreshed post every match with the updates.
Also historic data of all IPL matches played from 2008 to 2019 is provided here. All the player names are synced in all the 'Deliveries' datasets.
Note: If you are interested in the code and tutorial, you can check it out this link- https://dicco89.medium.com/web-scraping-ball-by-ball-data-from-espn-cricinfo-192b36583d4a
Happy Analyzing !!!

Tables

Deliveries Ipl 2008–2019

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.deliveries_ipl_2008_2019

789.44 KB
179078 rows
21 columns


CREATE TABLE deliveries_ipl_2008_2019 (
  "match_id" BIGINT,
  "inning" BIGINT,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "over" BIGINT,
  "ball" BIGINT,
  "batsman" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "is_super_over" BIGINT,
  "wide_runs" BIGINT,
  "bye_runs" BIGINT,
  "legbye_runs" BIGINT,
  "noball_runs" BIGINT,
  "penalty_runs" BIGINT,
  "batsman_runs" BIGINT,
  "extra_runs" BIGINT,
  "total_runs" BIGINT,
  "player_dismissed" VARCHAR,
  "dismissal_kind" VARCHAR,
  "fielder" VARCHAR
);

Deliveries Ipl 2020

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.deliveries_ipl_2020

67.65 KB
14326 rows
21 columns


CREATE TABLE deliveries_ipl_2020 (
  "match_id" BIGINT,
  "inning" BIGINT,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "over" BIGINT,
  "ball" BIGINT,
  "batsman" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "is_super_over" BIGINT,
  "wide_runs" BIGINT,
  "bye_runs" BIGINT,
  "legbye_runs" BIGINT,
  "noball_runs" BIGINT,
  "penalty_runs" BIGINT,
  "batsman_runs" BIGINT,
  "extra_runs" BIGINT,
  "total_runs" BIGINT,
  "player_dismissed" VARCHAR,
  "dismissal_kind" VARCHAR,
  "fielder" VARCHAR
);

Ipl 2020 Schedule

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.ipl_2020_schedule

4.25 KB
55 rows
5 columns


CREATE TABLE ipl_2020_schedule (
  "sl_no" BIGINT,
  "day" VARCHAR,
  "date" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR
);

Matches Ipl 2008–2019

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.matches_ipl_2008_2019

31.83 KB
756 rows
18 columns


CREATE TABLE matches_ipl_2008_2019 (
  "id" BIGINT,
  "season" BIGINT,
  "city" VARCHAR,
  "date" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "result" VARCHAR,
  "dl_applied" BIGINT,
  "winner" VARCHAR,
  "win_by_runs" BIGINT,
  "win_by_wickets" BIGINT,
  "player_of_match" VARCHAR,
  "venue" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "umpire3" VARCHAR
);

Matches Ipl 2020

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.matches_ipl_2020

14.27 KB
60 rows
18 columns


CREATE TABLE matches_ipl_2020 (
  "id" BIGINT,
  "season" BIGINT,
  "city" VARCHAR,
  "date" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "result" VARCHAR,
  "dl_applied" BIGINT,
  "winner" VARCHAR,
  "win_by_runs" BIGINT,
  "win_by_wickets" BIGINT,
  "player_of_match" VARCHAR,
  "venue" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "umpire3" VARCHAR
);

Qualifiers Ipl 2008–2019

@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data.qualifiers_ipl_2008_2019

4.87 KB
12 rows
7 columns


CREATE TABLE qualifiers_ipl_2008_2019 (
  "season" BIGINT,
  "champion" VARCHAR,
  "runners_up" VARCHAR,
  "q1" VARCHAR,
  "q2" VARCHAR,
  "q3" VARCHAR,
  "q4" VARCHAR
);