ICC Mens World Cup 2023

ICC Mens Cricket World Cup 2023, India

@kaggle.pardeep19singh_icc_mens_world_cup_2023

Table List

3 tables(116.42 KB)

Deliveries

Matches

Points Table

Matches

@kaggle.pardeep19singh_icc_mens_world_cup_2023.matches

14.73 KB
48 rows
18 columns

season Season	team1 Team1	team2 Team2	date Date	match_number Match Number	venue Venue	city City	toss_winner Toss Winner	toss_decision Toss Decision	player_of_match Player Of Match	umpire1 Umpire1	umpire2 Umpire2	reserve_umpire Reserve Umpire	match_referee Match Referee	winner Winner	winner_runs Winner Runs	winner_wickets Winner Wickets	match_type Match Type
2023/24	England	New Zealand	2023/10/05	1	Narendra Modi Stadium	Ahmedabad	New Zealand	field	R Ravindra	HDPK Dharmasena	Nitin Menon	Sharfuddoula	J Srinath	New Zealand		9	Group
2023/24	Pakistan	Netherlands	2023/10/06	2	Rajiv Gandhi International Stadium	Hyderabad	Netherlands	field	Saud Shakeel	AT Holdstock	CM Brown	PR Reiffel	JJ Crowe	Pakistan	81		Group
2023/24	Afghanistan	Bangladesh	2023/10/07	3	Himachal Pradesh Cricket Association Stadium	Dharamsala	Bangladesh	field	Mehedi Hasan Miraz	JS Wilson	HDPK Dharmasena	M Erasmus	AJ Pycroft	Bangladesh		6	Group
2023/24	South Africa	Sri Lanka	2023/10/07	4	Arun Jaitley Stadium	Delhi	Sri Lanka	field	AK Markram	RK Illingworth	Sharfuddoula	AG Wharf	J Srinath	South Africa	102		Group
2023/24	Australia	India	2023/10/08	5	MA Chidambaram Stadium	Chennai	Australia	bat	KL Rahul	CB Gaffaney	RA Kettleborough	AT Holdstock	RB Richardson	India		6	Group
2023/24	New Zealand	Netherlands	2023/10/09	6	Rajiv Gandhi International Stadium	Hyderabad	Netherlands	field	MJ Santner	PR Reiffel	RJ Tucker	Nitin Menon	AJ Pycroft	New Zealand	99		Group
2023/24	England	Bangladesh	2023/10/10	7	Himachal Pradesh Cricket Association Stadium	Dharamsala	Bangladesh	field	DJ Malan	Ahsan Raza	P Wilson	HDPK Dharmasena	J Srinath	England	137		Group
2023/24	Sri Lanka	Pakistan	2023/10/10	8	Rajiv Gandhi International Stadium	Hyderabad	Sri Lanka	bat	Mohammad Rizwan	AG Wharf	CB Gaffaney	RJ Tucker	AJ Pycroft	Pakistan		6	Group
2023/24	Afghanistan	India	2023/10/11	9	Arun Jaitley Stadium	Delhi	Afghanistan	bat	RG Sharma	MA Gough	PR Reiffel	Sharfuddoula	JJ Crowe	India		8	Group
2023/24	South Africa	Australia	2023/10/12	10	Bharat Ratna Shri Atal Bihari Vajpayee Ekana Cricket Stadium	Lucknow	Australia	field	Q de Kock	JS Wilson	RK Illingworth	CM Brown	J Srinath	South Africa	134		Group


CREATE TABLE matches (
  "season" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "date" VARCHAR,
  "match_number" BIGINT,
  "venue" VARCHAR,
  "city" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "player_of_match" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "reserve_umpire" VARCHAR,
  "match_referee" VARCHAR,
  "winner" VARCHAR,
  "winner_runs" DOUBLE,
  "winner_wickets" DOUBLE,
  "match_type" VARCHAR
);