Dataset: Indian Premier League(IPL)Data(till 2016)

About this Dataset

Indian Premier League(IPL)Data(till 2016)

This is the ball by ball data of all the IPL cricket matches till season 9.
(I will be coming up with season 10 data as soon as possible)

Source: http://cricsheet.org/ (data is available on this website in the YAML format. This is converted to CSV format by using R Script ,SQL,SSIS.

Research scope: Predicting the winner of the next season of IPL based on past data, Visualizations, Perspectives, etc.

Tables

Ball By Ball

@kaggle.raghu07_ipl_datatill_2016.ball_by_ball

558.93 KB
136590 rows
10 columns


CREATE TABLE ball_by_ball (
  "match_id" BIGINT,
  "over_id" BIGINT,
  "ball_id" BIGINT,
  "innings_no" BIGINT,
  "team_batting" BIGINT,
  "team_bowling" BIGINT,
  "striker_batting_position" BIGINT,
  "striker" BIGINT,
  "non_striker" BIGINT,
  "bowler" BIGINT
);

Batsman Scored

@kaggle.raghu07_ipl_datatill_2016.batsman_scored

91.01 KB
133097 rows
5 columns


CREATE TABLE batsman_scored (
  "match_id" BIGINT,
  "over_id" BIGINT,
  "ball_id" BIGINT,
  "runs_scored" BIGINT,
  "innings_no" BIGINT
);

Batting Style

@kaggle.raghu07_ipl_datatill_2016.batting_style

2.21 KB
2 rows
2 columns


CREATE TABLE batting_style (
  "batting_id" BIGINT,
  "batting_hand" VARCHAR
);

Bowling Style

@kaggle.raghu07_ipl_datatill_2016.bowling_style

2.45 KB
14 rows
2 columns


CREATE TABLE bowling_style (
  "bowling_id" BIGINT,
  "bowling_skill" VARCHAR
);

City

@kaggle.raghu07_ipl_datatill_2016.city

3.27 KB
29 rows
3 columns


CREATE TABLE city (
  "city_id" BIGINT,
  "city_name" VARCHAR,
  "country_id" BIGINT
);

Country

@kaggle.raghu07_ipl_datatill_2016.country

2.36 KB
12 rows
2 columns


CREATE TABLE country (
  "country_id" BIGINT,
  "country_name" VARCHAR
);

Extra Runs

@kaggle.raghu07_ipl_datatill_2016.extra_runs

24.02 KB
7469 rows
6 columns


CREATE TABLE extra_runs (
  "match_id" BIGINT,
  "over_id" BIGINT,
  "ball_id" BIGINT,
  "extra_type_id" BIGINT,
  "extra_runs" BIGINT,
  "innings_no" BIGINT
);

Extra Type

@kaggle.raghu07_ipl_datatill_2016.extra_type

2.16 KB
5 rows
2 columns


CREATE TABLE extra_type (
  "extra_id" BIGINT,
  "extra_name" VARCHAR
);

Match

@kaggle.raghu07_ipl_datatill_2016.match

20.62 KB
577 rows
13 columns


CREATE TABLE match (
  "match_id" BIGINT,
  "team_1" BIGINT,
  "team_2" BIGINT,
  "match_date" TIMESTAMP,
  "season_id" BIGINT,
  "venue_id" BIGINT,
  "toss_winner" BIGINT,
  "toss_decide" BIGINT,
  "win_type" BIGINT,
  "win_margin" DOUBLE,
  "outcome_type" BIGINT,
  "match_winner" DOUBLE,
  "man_of_the_match" DOUBLE
);

Outcome

@kaggle.raghu07_ipl_datatill_2016.outcome

2.19 KB
3 rows
2 columns


CREATE TABLE outcome (
  "outcome_id" BIGINT,
  "outcome_type" VARCHAR
);

Out Type

@kaggle.raghu07_ipl_datatill_2016.out_type

2.23 KB
9 rows
2 columns


CREATE TABLE out_type (
  "out_id" BIGINT,
  "out_name" VARCHAR
);

Player

@kaggle.raghu07_ipl_datatill_2016.player

17.45 KB
469 rows
6 columns


CREATE TABLE player (
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "dob" TIMESTAMP,
  "batting_hand" BIGINT,
  "bowling_skill" DOUBLE,
  "country_name" BIGINT
);

Player Match

@kaggle.raghu07_ipl_datatill_2016.player_match

32.06 KB
12694 rows
4 columns


CREATE TABLE player_match (
  "match_id" BIGINT,
  "player_id" BIGINT,
  "role_id" BIGINT,
  "team_id" BIGINT
);

Rolee

@kaggle.raghu07_ipl_datatill_2016.rolee

2.15 KB
4 rows
2 columns


CREATE TABLE rolee (
  "role_id" BIGINT,
  "role_desc" VARCHAR
);

Season

@kaggle.raghu07_ipl_datatill_2016.season

4.41 KB
9 rows
5 columns


CREATE TABLE season (
  "season_id" BIGINT,
  "man_of_the_series" BIGINT,
  "orange_cap" BIGINT,
  "purple_cap" BIGINT,
  "season_year" BIGINT
);

Team

@kaggle.raghu07_ipl_datatill_2016.team

2.49 KB
13 rows
2 columns


CREATE TABLE team (
  "team_id" BIGINT,
  "team_name" VARCHAR
);

Toss Decision

@kaggle.raghu07_ipl_datatill_2016.toss_decision

2.09 KB
2 rows
2 columns


CREATE TABLE toss_decision (
  "toss_id" BIGINT,
  "toss_name" VARCHAR
);

Wicket Taken

@kaggle.raghu07_ipl_datatill_2016.wicket_taken

39.02 KB
6727 rows
7 columns


CREATE TABLE wicket_taken (
  "match_id" BIGINT,
  "over_id" BIGINT,
  "ball_id" BIGINT,
  "player_out" BIGINT,
  "kind_out" BIGINT,
  "fielders" DOUBLE,
  "innings_no" BIGINT
);

Win By

@kaggle.raghu07_ipl_datatill_2016.win_by

2.13 KB
4 rows
2 columns


CREATE TABLE win_by (
  "win_id" BIGINT,
  "win_type" VARCHAR
);