IPL 2008 To 2019

Indian Premier League Data - (2008 to 2019) from Cricsheet.org

@kaggle.ravijee_ipl_2008_to_2019

Table List

2 tables(987.37 KB)

Ball By Ball Details

@kaggle.ravijee_ipl_2008_to_2019.ball_by_ball_details

949.39 KB
178949 rows
41 columns

unnamed_0 Unnamed: 0	batsman Batsman	batsman_runs Batsman Runs	batting_team Batting Team	bowler Bowler	fielders Fielders	kind Kind	inning Inning	delivery Delivery	match_id Match Id	non_striker Non Striker	player_out Player Out	total Total	city City	competition Competition	decision Decision	eliminator Eliminator	gender Gender	match_type Match Type	method Method	n__of_overs # Of Overs	player_of_match Player Of Match	result Result	teams Teams	umpires Umpires	venue Venue	winner Winner	winner_toss Winner Toss	outcome_by_wickets Outcome By Wickets	match_date Match Date	season Season	over Over
	PA Patel		Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.1	548314	S Dhawan	nan		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
1	PA Patel		Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.2	548314	S Dhawan	nan		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
2	PA Patel	1	Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.3	548314	S Dhawan	nan	1	Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
3	S Dhawan		Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.4	548314	PA Patel	nan		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
4	S Dhawan		Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.5	548314	PA Patel	nan		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
5	S Dhawan	1	Deccan Chargers	Harbhajan Singh	nan	nan	inning_1	0.6	548314	PA Patel	nan	1	Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	1
6	S Dhawan	4	Deccan Chargers	MM Patel	nan	nan	inning_1	1.1	548314	PA Patel	nan	4	Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	2
7	S Dhawan	1	Deccan Chargers	MM Patel	nan	nan	inning_1	1.2	548314	PA Patel	nan	1	Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	2
8	PA Patel		Deccan Chargers	MM Patel	nan	nan	inning_1	1.3	548314	S Dhawan	nan		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	2
9	PA Patel		Deccan Chargers	MM Patel	['RG Sharma']	caught	inning_1	1.4	548314	S Dhawan	PA Patel		Visakhapatnam	IPL	bat	nan	male	T20	nan	20	['RG Sharma']	nan	['Deccan Chargers', 'Mumbai Indians']	['AK Chaudhary', 'JD Cloete']	Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium	Mumbai Indians	Deccan Chargers	5	Mon Apr 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012	2


CREATE TABLE ball_by_ball_details (
  "unnamed_0" BIGINT,
  "batsman" VARCHAR,
  "batsman_runs" DOUBLE,
  "batting_team" VARCHAR,
  "bowler" VARCHAR,
  "byes" DOUBLE,
  "extras_runs" DOUBLE,
  "fielders" VARCHAR,
  "kind" VARCHAR,
  "legbyes" DOUBLE,
  "inning" VARCHAR,
  "delivery" DOUBLE,
  "match_id" BIGINT,
  "noballs" DOUBLE,
  "non_striker" VARCHAR,
  "player_out" VARCHAR,
  "total" DOUBLE,
  "wides" DOUBLE,
  "non_boundary" DOUBLE,
  "penalty" DOUBLE,
  "city" VARCHAR,
  "competition" VARCHAR,
  "decision" VARCHAR,
  "eliminator" VARCHAR,
  "gender" VARCHAR,
  "match_type" VARCHAR,
  "method" VARCHAR,
  "neutral_venue" DOUBLE,
  "n__of_overs" BIGINT,
  "player_of_match" VARCHAR,
  "result" VARCHAR,
  "teams" VARCHAR,
  "umpires" VARCHAR,
  "venue" VARCHAR,
  "winner" VARCHAR,
  "winner_toss" VARCHAR,
  "outcome_by_runs" DOUBLE,
  "outcome_by_wickets" DOUBLE,
  "match_date" TIMESTAMP,
  "season" BIGINT,
  "over" BIGINT
);