Cricket World Cup 2023

For beginners to explore and learn sports analytics

@kaggle.maulikpatel1930_cricket_world_cup_2023

Table List

1 table(34.9 KB)

Cwc2023

@kaggle.maulikpatel1930_cricket_world_cup_2023.cwc2023

34.9 KB
48 rows
44 columns

match_id Match ID	match_date Match Date	match_time Match Time	city City	stadium Stadium	team_a Team A	team_b Team B	toss_winner Toss Winner	toss_decision Toss Decision	score_a Score A	wickets_a Wickets A	overs_played_a Overs Played A	maiden_overs_a Maiden Overs A	n_4s_a 4s A	n_6s_a 6s A	boundaries_a Boundaries A	runrate_a Runrate A	leg_byes_a Leg Byes A	byes_a Byes A	wides_a Wides A	no_balls_a No Balls A	extras_a Extras A	score_b Score B	wickets_b Wickets B	overs_played_b Overs Played B	maiden_overs_b Maiden Overs B	n_4s_b 4s B	n_6s_b 6s B	boundaries_b Boundaries B	runrate_b Runrate B	leg_byes_b Leg Byes B	byes_b Byes B	wides_b Wides B	no_balls_b No Balls B	extras_b Extras B	wining_team Wining Team	margin Margin	man_of_the_match Man Of The Match	umpire_1 Umpire 1	umpire_2 Umpire 2	tv_umpire TV Umpire	match_refree Match Refree
1	05-10-2023	2:00 PM	Ahmedabad	Narendra Modi Stadium	England	NewZealand	NewZealand	Field	282	9	50	2	21	6	27	5.64	1	4	3		8	283	1	36.2	2	30	8	38	7.78			6		6	NewZealand	9 Wickets	Rachin Ravindra	Kumar Dharmasena	Nitin Menon	Paul Wilson	Javagal Srinath
2	06-10-2023	2:00 PM	Hyderabad	Eden Gardens	Pakistan	Netherlands	Netherlands	Field	286	10	49	1	33	3	36	5.83			9		9	205	10	41	1	20	4	24	5			8	1	9	Pakistan	81 Runs	Saud Shakeel	Adrian Holdstock	Chris Brown	Rod Tucker	Jeff Crowe
3	07-10-2023	2:00 PM	Dharamshala	HPCA Stadium	Afghanistan	Bangladesh	Bangladesh	Field	156	10	37.2	1	15	2	17	4.17	3		4	1	8	158	4	34.4	5	13	1	14	4.55			8		8	Bangladesh	6 Wickets	Mehidy Hasan Miraz	Joel Wilson	Kumar Dharmasena	Ahsan Raza	Andy Pycroft
4	07-10-2023	2:00 PM	Delhi	Arun Jaitley Stadium	South Africa	Sri Lanka	Sri Lanka	Field	428	5	50	1	45	14	59	8.56	5		14	1	20	326	10	44.5	1	31	17	48	7.27	1		21	1	23	South Africa	102 Runs	Aiden Markram	Richard Illingworth	Sharfuddoula	Michael Gough	Javagal Srinath
5	08-10-2023	2:00 PM	Chennai	M. A. Chidambaram Stadium	Australia	India	Australia	Bat	199	10	49.3	1	16	2	18	4.02	1	1	5	1	8	201	4	41.2	4	14	3	17	4.86	6		6		12	India	6 wickets	KL Rahul	Chris Gaffaney	Richard Kettleborough	Chris Brown	Richie Richardson
6	09-10-2023	2:00 PM	Hyderabad	Rajiv Gandhi International Stadium	NewZealand	Netherlands	Netherlands	Field	322	7	50		30	10	40	6.44	1		2	1	4	223	10	46.3	3	19	3	22	4.79	3		8	2	13	NewZealand	99 Runs	Mitchell Santner	Paul Reiffel	Rod Tucker	Joel Wilson	Andy Pycroft
7	10-10-2023	10:30 AM	Dharamshala	HPCA Stadium	England	Bangladesh	Bangladesh	Field	364	9	50	1	41	7	48	7.28	4		3		7	227	10	48.2		17	3	20	4.69	2	1	4		7	England	137 Runs	Dawid Malan	Ahsan Raza	Paul Wilson	Adrian Holdstock	Javagal Srinath
8	10-10-2023	2:00 PM	Hyderabad	Rajiv Gandhi International Stadium	Sri Lanka	Pakistan	Sri Lanka	Bat	344	9	50		36	9	45	6.88			25	1	26	345	4	48.2		26	6	32	7.13	2	2	9	1	14	Pakistan	6 Wickets	Mohammad Rizwan	Chris Gaffaney	Alex Wharf	Nitin Menon	Andy Pycroft
9	11-10-2023	2:00 PM	Delhi	Arun Jaitley Stadium	Afghanistan	India	Afghanistan	Bat	272	8	50		25	7	32	5.44	4	1	10		15	273	2	35		28	8	36	7.8	3	2	8	2	15	India	8 Wickets	Rohit Sharma	Michael Gough	Paul Reiffel	Marais Erasmus	Jeff Crowe
10	12-10-2023	2:00 PM	Lucknow	BRSABV Ekana Cricket Stadium	South Africa	Australia	Australia	Field	311	7	50	3	26	8	34	6.22	4		11	2	17	177	10	40.5	2	19		19	4.33	2	4	7		13	South Africa	134 Runs	Quinton de Kock	Joel Wilson	Richard Illingworth	Richard Kettleborough	Javagal Srinath


CREATE TABLE cwc2023 (
  "match_id" BIGINT,
  "match_date" VARCHAR,
  "match_time" VARCHAR,
  "city" VARCHAR,
  "stadium" VARCHAR,
  "team_a" VARCHAR,
  "team_b" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "score_a" BIGINT,
  "wickets_a" BIGINT,
  "overs_played_a" DOUBLE,
  "maiden_overs_a" BIGINT,
  "n_4s_a" BIGINT,
  "n_6s_a" BIGINT,
  "boundaries_a" BIGINT,
  "runrate_a" DOUBLE,
  "leg_byes_a" BIGINT,
  "byes_a" BIGINT,
  "wides_a" BIGINT,
  "no_balls_a" BIGINT,
  "penalty_a" BIGINT,
  "extras_a" BIGINT,
  "score_b" BIGINT,
  "wickets_b" BIGINT,
  "overs_played_b" DOUBLE,
  "maiden_overs_b" BIGINT,
  "n_4s_b" BIGINT,
  "n_6s_b" BIGINT,
  "boundaries_b" BIGINT,
  "runrate_b" DOUBLE,
  "leg_byes_b" BIGINT,
  "byes_b" BIGINT,
  "wides_b" BIGINT,
  "no_balls_b" BIGINT,
  "penalty_b" BIGINT,
  "extras_b" BIGINT,
  "wining_team" VARCHAR,
  "margin" VARCHAR,
  "man_of_the_match" VARCHAR,
  "umpire_1" VARCHAR,
  "umpire_2" VARCHAR,
  "tv_umpire" VARCHAR,
  "match_refree" VARCHAR
);