ICC MENS T20 WORLD CUP 2022 - DATA

ICC Mens T20 WC 2022

@kaggle.muhammadusman231_icc_mens_t20_world_cup_2022_data

Table List

1 table(12.03 KB)

Menst20wcdata

@kaggle.muhammadusman231_icc_mens_t20_world_cup_2022_data.menst20wcdata

12.03 KB
45 rows
14 columns

match_id Match Id	team_1 Team 1	team_2 Team 2	n__venue Venue	stage Stage	toss_winner Toss Winner	toss_decision Toss Decision	score_of_first_innings Score Of First Innings	wkts_in_first_innings Wkts In First Innings	score_of_second_innings Score Of Second Innings	wkts_in_second_innings Wkts In Second Innings	winner Winner	won_by Won By	player_of_the_match Player Of The Match
1	Namibia	Sri Lanka	GMHBA Stadium, South Geelong, Victoria	First Round	Sri Lanka	Field	163	7	108	10	Namibia	55 Runs	Jan Frylinck
2	UAE	Netherlands	GMHBA Stadium, South Geelong, Victoria	First Round	UAE	Bat	111	8	112	7	Netherlands	3 Wickets	Bas de Leede
3	Scotland	West Indies	Bellerive Oval, Hobart	First Round	West Indies	Field	160	5	118	10	Scotland	42 Runs	George Munsey
4	Zimbave	Ireland	Bellerive Oval, Hobart	First Round	Ireland	Field	174	7	143	9	Zimbave	31 Runs	Sikandar Raza
5	Namibia	Netherlands	GMHBA Stadium, South Geelong, Victoria	First Round	Namibia	Bat	121	6	122	5	Netherlands	5 Wickets	Bas de Leede
6	Sri Lanka	UAE	GMHBA Stadium, South Geelong, Victoria	First Round	UAE	Field	152	8	73	10	Sri Lanka	79 Runs	Pathum Nissanka
7	Scotland	Ireland	Bellerive Oval, Hobart	First Round	Scotland	Bat	176	5	180	4	Ireland	6 Wickets	Curtis Campher
8	West Indies	Zimbave	Bellerive Oval, Hobart	First Round	West Indies	Bat	153	7	122	10	West Indies	31 Runs	Alzarri Joseph
9	Sri Lanka	Netherlands	GMHBA Stadium, South Geelong, Victoria	First Round	Sri Lanka	Bat	162	6	146	9	Sri Lanka	16 Runs	Kusal Mendis
10	UAE	Namibia	GMHBA Stadium, South Geelong, Victoria	First Round	UAE	Bat	148	3	141	8	UAE	7 Runs	Muhammad Waseem


CREATE TABLE menst20wcdata (
  "match_id" BIGINT,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "n__venue" VARCHAR,
  "stage" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "score_of_first_innings" VARCHAR,
  "wkts_in_first_innings" VARCHAR,
  "score_of_second_innings" VARCHAR,
  "wkts_in_second_innings" VARCHAR,
  "winner" VARCHAR,
  "won_by" VARCHAR,
  "player_of_the_match" VARCHAR
);