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)

Ipl Summary

@kaggle.ravijee_ipl_2008_to_2019.ipl_summary

37.99 KB
756 rows
21 columns

match_id Match Id	city City	competition Competition	decision Decision	eliminator Eliminator	gender Gender	match_type Match Type	method Method	neutral_venue Neutral Venue	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_runs Outcome By Runs	outcome_by_wickets Outcome By Wickets	match_date Match Date	season Season
548314	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
1178429	Bengaluru	IPL	field	nan	male	T20	nan		20	['SO Hetmyer']	nan	['Royal Challengers Bangalore', 'Sunrisers Hyderabad']	['NJ Llong', 'AK Chaudhary']	M.Chinnaswamy Stadium	Royal Challengers Bangalore	Royal Challengers Bangalore		4	Sat May 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2019
419157	Bangalore	IPL	field	nan	male	T20	nan		20	['R McLaren']	nan	['Royal Challengers Bangalore', 'Mumbai Indians']	['HDPK Dharmasena', 'SJA Taufel']	M Chinnaswamy Stadium	Mumbai Indians	Royal Challengers Bangalore	57		Sat Apr 17 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2010
548375	Pune	IPL	bat	nan	male	T20	nan		20	['Shakib Al Hasan']	nan	['Pune Warriors', 'Kolkata Knight Riders']	['S Asnani', 'BR Doctrove']	Subrata Roy Sahara Stadium	Kolkata Knight Riders	Kolkata Knight Riders	34		Sat May 19 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012
392234	Durban	IPL	bat	nan	male	T20	nan	1	20	['M Muralitharan']	nan	['Chennai Super Kings', 'Kings XI Punjab']	['BG Jerling', 'SJA Taufel']	Kingsmead	Chennai Super Kings	Chennai Super Kings	24		Wed May 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2009
548317	Mumbai	IPL	field	nan	male	T20	nan		20	['KA Pollard']	nan	['Mumbai Indians', 'Rajasthan Royals']	['Aleem Dar', 'BNJ Oxenford']	Wankhede Stadium	Mumbai Indians	Rajasthan Royals	27		Wed Apr 11 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2012
598055	Pune	IPL	bat	nan	male	T20	nan		20	['MG Johnson']	nan	['Pune Warriors', 'Mumbai Indians']	['Asad Rauf', 'AK Chaudhary']	Subrata Roy Sahara Stadium	Mumbai Indians	Pune Warriors		5	Sat May 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2013
1136609	Kolkata	IPL	field	nan	male	T20	nan		20	['Kuldeep Yadav']	nan	['Kolkata Knight Riders', 'Rajasthan Royals']	['HDPK Dharmasena', 'AK Chaudhary']	Eden Gardens	Kolkata Knight Riders	Kolkata Knight Riders		6	Tue May 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2018
501235	Jaipur	IPL	field	nan	male	T20	nan		20	['LRPL Taylor']	nan	['Rajasthan Royals', 'Pune Warriors']	['SK Tarapore', 'SJA Taufel']	Sawai Mansingh Stadium	Rajasthan Royals	Rajasthan Royals		6	Sun May 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2011
1178426	Mumbai	IPL	bat	Mumbai Indians	male	T20	nan		20	['JJ Bumrah']	tie	['Mumbai Indians', 'Sunrisers Hyderabad']	['CK Nandan', 'S Ravi']	Wankhede Stadium	Mumbai Indians	nan			Thu May 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2019


CREATE TABLE ipl_summary (
  "match_id" BIGINT,
  "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
);