Pakistan Super League (PSL) Ultimate Ball-by-Ball

Ball-by-Ball Data set of PSL from its first season in 2016 to it's last season.

@kaggle.ijazzia_pakistan_super_league_psl_ultimate_ball_by_ball

Table List

1 table(721.37 KB)

Psl

@kaggle.ijazzia_pakistan_super_league_psl_ultimate_ball_by_ball.psl

721.37 KB
59560 rows
55 columns

unnamed_0 Unnamed: 0	team Team	over_number Over Number	ball_number Ball Number	batter Batter	bowler Bowler	non_striker Non Striker	batter_runs Batter Runs	total_runs Total Runs	wickets Wickets	wicket_type Wicket Type	fielders_for_wicket Fielders For Wicket	player_out Player Out	dates Dates	match_type Match Type	gender Gender	overs Overs	venue Venue	season Season	event_match_number Event Match Number	official_umpires Official Umpires	opposition Opposition	team_type Team Type	team_a_players Team A Players	team_b_players Team B Players	toss_winner Toss Winner	winner Winner	motm MOTM	outcome_by_wickets Outcome By Wickets
	Lahore Qalandars	1	1	Fakhar Zaman	Imad Wasim	Gauhar Ali	1	1		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
1	Lahore Qalandars	1	2	Gauhar Ali	Imad Wasim	Fakhar Zaman	4	4		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
2	Lahore Qalandars	1	3	Gauhar Ali	Imad Wasim	Fakhar Zaman			1	caught	Mohammad Amir	Gauhar Ali	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
3	Lahore Qalandars	1	4	Haris Sohail	Imad Wasim	Fakhar Zaman	1	1		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
4	Lahore Qalandars	1	5	Fakhar Zaman	Imad Wasim	Haris Sohail				0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
5	Lahore Qalandars	1	6	Fakhar Zaman	Imad Wasim	Haris Sohail	4	4		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
6	Lahore Qalandars	2	1	Haris Sohail	Mohammad Amir	Fakhar Zaman	1	1		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
7	Lahore Qalandars	2	2	Fakhar Zaman	Mohammad Amir	Haris Sohail	4	4		0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
8	Lahore Qalandars	2	3	Fakhar Zaman	Mohammad Amir	Haris Sohail				0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5
9	Lahore Qalandars	2	4	Fakhar Zaman	Mohammad Amir	Haris Sohail				0	0	0	Thu Feb 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	T20	male	20	Dubai International Cricket Stadium	2018/19	20	['RK Illingworth', 'Rashid Riaz']	Karachi Kings	club	['Fakhar Zaman', 'Gauhar Ali', 'Haris Sohail', 'AB de Villiers', 'CJ Anderson', 'Sohail Akhtar', 'D Wiese', 'S Lamichhane', 'Yasir Shah', 'Haris Rauf', 'Aizaz Cheema']	['Babar Azam', 'C Munro', 'LS Livingstone', 'CA Ingram', 'Iftikhar Ahmed', 'Mohammad Rizwan', 'Imad Wasim', 'Aamer Yamin', 'Mohammad Amir', 'Umer Khan', 'AW Summers']	Karachi Kings	Karachi Kings	Iftikhar Ahmed	5


CREATE TABLE psl (
  "unnamed_0" BIGINT,
  "team" VARCHAR,
  "over_number" BIGINT,
  "ball_number" BIGINT,
  "batter" VARCHAR,
  "bowler" VARCHAR,
  "non_striker" VARCHAR,
  "batter_runs" BIGINT,
  "runs_extras" BIGINT,
  "byes" BIGINT,
  "legbyes" BIGINT,
  "noballs" BIGINT,
  "penalty" BIGINT,
  "wides" BIGINT,
  "nonboundry_runs" VARCHAR,
  "total_runs" BIGINT,
  "wickets" BIGINT,
  "wicket_type" VARCHAR,
  "fielders_for_wicket" VARCHAR,
  "player_out" VARCHAR,
  "review_by" VARCHAR,
  "batter_review" VARCHAR,
  "review_decision" VARCHAR,
  "review_umpire" VARCHAR,
  "review_type" VARCHAR,
  "review_umpire_call" BIGINT,
  "target_runs" DOUBLE,
  "target_overs" DOUBLE,
  "dates" TIMESTAMP,
  "match_type" VARCHAR,
  "gender" VARCHAR,
  "overs" BIGINT,
  "venue" VARCHAR,
  "season" VARCHAR,
  "event_match_number" DOUBLE,
  "toss_decision" VARCHAR,
  "official_umpires" VARCHAR,
  "opposition" VARCHAR,
  "team_type" VARCHAR,
  "team_a_players" VARCHAR,
  "team_b_players" VARCHAR,
  "toss_winner" VARCHAR,
  "winner" VARCHAR,
  "motm" VARCHAR,
  "outcome_by_runs" BIGINT,
  "outcome_by_wickets" BIGINT,
  "replacement" BIGINT,
  "replacement_in" VARCHAR,
  "replacement_out" DOUBLE,
  "replacement_reason" VARCHAR,
  "replacement_role" VARCHAR,
  "sub_in" VARCHAR,
  "sub_out" VARCHAR,
  "sub_team" VARCHAR,
  "sub_reason" VARCHAR
);