Dataset: IPL-data (2008 - 2019)

About this Dataset

IPL-data (2008 - 2019)

The dataset contains two CSV files, (i) matches.csv - which contains the information of all the matches played in IPL from 2008 - to 2019, and (ii) deliveries.csv - which contains the ball wise information for all the seasons.

Tables

Deliveries

@kaggle.dshah1612_ipldata_2008_2019.deliveries

789.44 KB
179078 rows
21 columns


CREATE TABLE deliveries (
  "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
);

Matches

@kaggle.dshah1612_ipldata_2008_2019.matches

31.81 KB
756 rows
18 columns


CREATE TABLE matches (
  "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
);