IPL2020

IPL2020 Ball by Ball Data

@kaggle.ambarish_ipl2020

Table List

2 tables(70.47 KB)

Iplt2020 All Matches

Iplt2020 All Matches

@kaggle.ambarish_ipl2020.iplt2020_all_matches

9.66 KB
60 rows
10 columns

venue Venue	competition Competition	dates Dates	outcome_winner Outcome Winner	outcome_wickets Outcome Wickets	outcome_runs Outcome Runs	n_1st_innings_team 1st Innings Team	n_2nd_innings_team 2nd Innings Team	player_of_match Player Of Match	match_no Match No
Sheikh Zayed Stadium	IPL	Sat Sep 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Chennai Super Kings	5		Mumbai Indians	Chennai Super Kings	AT Rayudu	1216492
Dubai International Cricket Stadium	IPL	Sun Sep 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Delhi Capitals			Delhi Capitals	Kings XI Punjab	MP Stoinis	1216493
Sheikh Zayed Stadium	IPL	Wed Oct 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Royal Challengers Bangalore	8		Kolkata Knight Riders	Royal Challengers Bangalore	Mohammed Siraj	1216494
Sharjah Cricket Stadium	IPL	Tue Nov 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sunrisers Hyderabad	10		Mumbai Indians	Sunrisers Hyderabad	S Nadeem	1216495
Sharjah Cricket Stadium	IPL	Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Rajasthan Royals		16	Rajasthan Royals	Chennai Super Kings	SV Samson	1216496
Sheikh Zayed Stadium	IPL	Sat Oct 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Kolkata Knight Riders		59	Kolkata Knight Riders	Delhi Capitals	CV Varun	1216497
Dubai International Cricket Stadium	IPL	Sat Oct 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Kings XI Punjab		12	Kings XI Punjab	Sunrisers Hyderabad	CJ Jordan	1216498
Sheikh Zayed Stadium	IPL	Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mumbai Indians	5		Royal Challengers Bangalore	Mumbai Indians	SA Yadav	1216499
Sharjah Cricket Stadium	IPL	Fri Oct 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Delhi Capitals		46	Delhi Capitals	Rajasthan Royals	R Ashwin	1216500
Sheikh Zayed Stadium	IPL	Wed Oct 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Kolkata Knight Riders		10	Kolkata Knight Riders	Chennai Super Kings	RA Tripathi	1216501


CREATE TABLE iplt2020_all_matches (
  "venue" VARCHAR,
  "competition" VARCHAR,
  "dates" TIMESTAMP,
  "outcome_winner" VARCHAR,
  "outcome_wickets" DOUBLE,
  "outcome_runs" DOUBLE,
  "n_1st_innings_team" VARCHAR,
  "n_2nd_innings_team" VARCHAR,
  "player_of_match" VARCHAR,
  "match_no" BIGINT
);