IPL2020

IPL2020 Ball by Ball Data

@kaggle.ambarish_ipl2020

Table List

2 tables(70.47 KB)

Iplt2020 All Matches

All Matches Details

@kaggle.ambarish_ipl2020.all_matches_details

60.82 KB
14510 rows
12 columns

innings Innings	delivery_no Delivery No	delivery_no_over Delivery No Over	non_striker Non Striker	bowler Bowler	runs_extras Runs Extras	runs_total Runs Total	runs_batsman Runs Batsman	batsman Batsman	player_out Player Out	player_out_kind Player Out Kind	match_no Match No
1st innings		0.1	Shubman Gill	TA Boult				RA Tripathi	nan	nan	1216526
1st innings	1	0.2	Shubman Gill	TA Boult		1	1	RA Tripathi	nan	nan	1216526
1st innings	2	0.3	RA Tripathi	TA Boult				Shubman Gill	nan	nan	1216526
1st innings	3	0.4	RA Tripathi	TA Boult	1	1		Shubman Gill	nan	nan	1216526
1st innings	4	0.5	RA Tripathi	TA Boult				Shubman Gill	nan	nan	1216526
1st innings	5	0.6	RA Tripathi	TA Boult				Shubman Gill	nan	nan	1216526
1st innings	6	0.7	RA Tripathi	TA Boult		1	1	Shubman Gill	nan	nan	1216526
1st innings	7	1.1	RA Tripathi	NM Coulter-Nile				Shubman Gill	nan	nan	1216526
1st innings	8	1.2	RA Tripathi	NM Coulter-Nile	1	1		Shubman Gill	nan	nan	1216526
1st innings	9	1.3	RA Tripathi	NM Coulter-Nile	1	1		Shubman Gill	nan	nan	1216526


CREATE TABLE all_matches_details (
  "innings" VARCHAR,
  "delivery_no" BIGINT,
  "delivery_no_over" DOUBLE,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "runs_extras" BIGINT,
  "runs_total" BIGINT,
  "runs_batsman" BIGINT,
  "batsman" VARCHAR,
  "player_out" VARCHAR,
  "player_out_kind" VARCHAR,
  "match_no" BIGINT
);