T20I Men's Cricket Match Data (2003 - 2023)

Ball-by-ball data for T20 international matches since the creation of the format

@kaggle.jamiewelsh2_ball_by_ball_it20

Table List

1 table(7.02 MB)

Ball By Ball It20

@kaggle.jamiewelsh2_ball_by_ball_it20.ball_by_ball_it20

7.02 MB
425119 rows
35 columns

unnamed_0 Unnamed: 0	match_id Match ID	date Date	venue Venue	bat_first Bat First	bat_second Bat Second	innings Innings	over Over	ball Ball	batter Batter	non_striker Non Striker	bowler Bowler	batter_runs Batter Runs	runs_from_ball Runs From Ball	extra_type Extra Type	wicket Wicket	method Method	player_out Player Out	innings_runs Innings Runs	innings_wickets Innings Wickets	target_score Target Score	balls_remaining Balls Remaining	winner Winner	chased_successfully Chased Successfully	total_batter_runs Total Batter Runs	total_non_striker_runs Total Non Striker Runs	batter_balls_faced Batter Balls Faced	non_striker_balls_faced Non Striker Balls Faced	player_out_runs Player Out Runs	player_out_balls_faced Player Out Balls Faced	bowler_runs_conceded Bowler Runs Conceded	valid_ball Valid Ball
	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	1	BA King	KR Mayers	WD Parnell	1	1	[]		nan	nan	1		259	119	South Africa	1	1		1				1	1
1	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	2	KR Mayers	BA King	WD Parnell	1	1	[]		nan	nan	2		259	118	South Africa	1	1	1	1	1			1	1
2	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	3	BA King	KR Mayers	WD Parnell			[]	1	caught	BA King	2	1	259	117	South Africa	1		1		1	1	2		1
3	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	4	J Charles	KR Mayers	WD Parnell			[]		nan	nan	2	1	259	116	South Africa	1		1	1	1				1
4	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	5	J Charles	KR Mayers	WD Parnell	4	4	[]		nan	nan	6	1	259	115	South Africa	1	4	1	2	1			4	1
5	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	1	6	J Charles	KR Mayers	WD Parnell	4	4	[]		nan	nan	10	1	259	114	South Africa	1	8	1	3	1			4	1
6	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	2	1	KR Mayers	J Charles	AK Markram			[]		nan	nan	10	1	259	113	South Africa	1	1	8	2	3				1
7	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	2	2	KR Mayers	J Charles	AK Markram			[]		nan	nan	10	1	259	112	South Africa	1	1	8	3	3				1
8	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	2	3	KR Mayers	J Charles	AK Markram			[]		nan	nan	10	1	259	111	South Africa	1	1	8	4	3				1
9	1339605	Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SuperSport Park	West Indies	South Africa	1	2	4	KR Mayers	J Charles	AK Markram			[]		nan	nan	10	1	259	110	South Africa	1	1	8	5	3				1


CREATE TABLE ball_by_ball_it20 (
  "unnamed_0" BIGINT,
  "match_id" BIGINT,
  "date" TIMESTAMP,
  "venue" VARCHAR,
  "bat_first" VARCHAR,
  "bat_second" VARCHAR,
  "innings" BIGINT,
  "over" BIGINT,
  "ball" BIGINT,
  "batter" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "batter_runs" BIGINT,
  "extra_runs" BIGINT,
  "runs_from_ball" BIGINT,
  "ball_rebowled" BIGINT,
  "extra_type" VARCHAR,
  "wicket" BIGINT,
  "method" VARCHAR,
  "player_out" VARCHAR,
  "innings_runs" BIGINT,
  "innings_wickets" BIGINT,
  "target_score" BIGINT,
  "runs_to_get" DOUBLE,
  "balls_remaining" BIGINT,
  "winner" VARCHAR,
  "chased_successfully" BIGINT,
  "total_batter_runs" BIGINT,
  "total_non_striker_runs" BIGINT,
  "batter_balls_faced" BIGINT,
  "non_striker_balls_faced" BIGINT,
  "player_out_runs" DOUBLE,
  "player_out_balls_faced" DOUBLE,
  "bowler_runs_conceded" BIGINT,
  "valid_ball" BIGINT
);