T20 Cricket Huge Dataset (Since 2015)

Details of T20 Cricket matches ball by ball.This contains more than 10lakh Rows.

@kaggle.yashusinghal_t20_cricket_dataset

Table List

1 table(36.84 MB)

T20 Bbb

@kaggle.yashusinghal_t20_cricket_dataset.t20_bbb

36.84 MB
1397245 rows
50 columns

unnamed_0 Unnamed: 0	p_match P Match	inns Inns	bat Bat	p_bat P Bat	team_bat Team Bat	bowl Bowl	p_bowl P Bowl	team_bowl Team Bowl	ball Ball	ball_id Ball Id	outcome Outcome	score Score	dismissal Dismissal	p_out P Out	over Over	ball_1 Ball.1	legbyes Legbyes	cur_bat_runs Cur Bat Runs	cur_bat_bf Cur Bat Bf	cur_bowl_ovr Cur Bowl Ovr	cur_bowl_runs Cur Bowl Runs	inns_runs Inns Runs	inns_balls Inns Balls	inns_balls_rem Inns Balls Rem	inns_rr Inns Rr	max_balls Max Balls	date Date	year Year	ground Ground	country Country	winner Winner	toss Toss	competition Competition	bat_hand Bat Hand	bowl_style Bowl Style	bowl_kind Bowl Kind	batruns Batruns	ballfaced Ballfaced	bowlruns Bowlruns	bat_out Bat Out
	1001349	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	1	0.01	no run		nan	5334	1	1			1	0.1			1	119		120	Fri Feb 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Melbourne Cricket Ground	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
1	1001349	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	2	0.02	no run		nan	5334	1	2			2	0.2			2	118		120	Fri Feb 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Melbourne Cricket Ground	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
2	1001349	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	3	0.03	run	1	nan	5334	1	3		1	3	0.3	1	1	3	117	2	120	Fri Feb 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Melbourne Cricket Ground	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler	1	1	1	true
3	1001351	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	3	0.03	no run		nan	5334	1	3			1	0.3	1	1	3	117	2	120	Sun Feb 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Simonds Stadium, South Geelong, Victoria	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
4	1001351	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	4	0.04	four	4	nan	5334	1	4		4	2	0.4	5	5	4	116	7.5	120	Sun Feb 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Simonds Stadium, South Geelong, Victoria	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler	4	1	4	true
5	1001351	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	5	0.05	leg bye	1	nan	5334	1	5	1	4	3	0.5	5	6	5	115	7.2	120	Sun Feb 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Simonds Stadium, South Geelong, Victoria	Australia	Sri Lanka	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
6	1001353	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	1	0.01	no run		nan	5334	1	1			1	0.1			1	119		120	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Adelaide Oval	Australia	Australia	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
7	1001353	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	2	0.02	no run		nan	5334	1	2			2	0.2			2	118		120	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Adelaide Oval	Australia	Australia	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
8	1001353	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	3	0.03	no run		nan	5334	1	3			3	0.3			3	117		120	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Adelaide Oval	Australia	Australia	Sri Lanka	T20I	RHB	RF	pace bowler		1		true
9	1001353	1	Aaron Finch	5334	Australia	Lasith Malinga	49758	Sri Lanka	4	0.04	no run		nan	5334	1	4			4	0.4			4	116		120	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	Adelaide Oval	Australia	Australia	Sri Lanka	T20I	RHB	RF	pace bowler		1		true


CREATE TABLE t20_bbb (
  "unnamed_0" BIGINT,
  "p_match" BIGINT,
  "inns" BIGINT,
  "bat" VARCHAR,
  "p_bat" BIGINT,
  "team_bat" VARCHAR,
  "bowl" VARCHAR,
  "p_bowl" BIGINT,
  "team_bowl" VARCHAR,
  "ball" BIGINT,
  "ball_id" DOUBLE,
  "outcome" VARCHAR,
  "score" BIGINT,
  "out" BOOLEAN,
  "dismissal" VARCHAR,
  "p_out" BIGINT,
  "over" BIGINT,
  "ball_1" BIGINT,
  "noball" BIGINT,
  "wide" BIGINT,
  "byes" BIGINT,
  "legbyes" BIGINT,
  "cur_bat_runs" BIGINT,
  "cur_bat_bf" BIGINT,
  "cur_bowl_ovr" DOUBLE,
  "cur_bowl_wkts" BIGINT,
  "cur_bowl_runs" BIGINT,
  "inns_runs" BIGINT,
  "inns_wkts" BIGINT,
  "inns_balls" BIGINT,
  "inns_runs_rem" DOUBLE,
  "inns_balls_rem" BIGINT,
  "inns_rr" DOUBLE,
  "inns_rrr" DOUBLE,
  "target" DOUBLE,
  "max_balls" BIGINT,
  "date" TIMESTAMP,
  "year" BIGINT,
  "ground" VARCHAR,
  "country" VARCHAR,
  "winner" VARCHAR,
  "toss" VARCHAR,
  "competition" VARCHAR,
  "bat_hand" VARCHAR,
  "bowl_style" VARCHAR,
  "bowl_kind" VARCHAR,
  "batruns" BIGINT,
  "ballfaced" BIGINT,
  "bowlruns" BIGINT,
  "bat_out" BOOLEAN
);