Name: Indian Premier League(IPL)Data(till 2016)
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

572.34 kB
136,590 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

93.19 kB
133,097 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.27 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.51 kB
14 rows
2 columns

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

City

@kaggle.raghu07_ipl_datatill_2016.city

3.35 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.42 kB
12 rows
2 columns

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

Extra Runs

@kaggle.raghu07_ipl_datatill_2016.extra_runs

24.6 kB
7,469 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.21 kB
5 rows
2 columns

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

Match

@kaggle.raghu07_ipl_datatill_2016.match

21.11 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.24 kB
3 rows
2 columns

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

Out Type

@kaggle.raghu07_ipl_datatill_2016.out_type

2.28 kB
9 rows
2 columns

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

Player

@kaggle.raghu07_ipl_datatill_2016.player

17.87 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.83 kB
12,694 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.2 kB
4 rows
2 columns

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

Season

@kaggle.raghu07_ipl_datatill_2016.season

4.52 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.55 kB
13 rows
2 columns

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

Toss Decision

@kaggle.raghu07_ipl_datatill_2016.toss_decision

2.14 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.96 kB
6,727 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.18 kB
4 rows
2 columns

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