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

Deliveries

@kaggle.pardeep19singh_icc_mens_world_cup_2023.deliveries

93.58 KB
26119 rows
22 columns

match_id Match Id	season Season	start_date Start Date	venue Venue	innings Innings	ball Ball	batting_team Batting Team	bowling_team Bowling Team	striker Striker	non_striker Non Striker	bowler Bowler	runs_off_bat Runs Off Bat	wicket_type Wicket Type	player_dismissed Player Dismissed	other_wicket_type Other Wicket Type	other_player_dismissed Other Player Dismissed
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.1	England	New Zealand	JM Bairstow	DJ Malan	TA Boult		nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.2	England	New Zealand	JM Bairstow	DJ Malan	TA Boult	6	nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.3	England	New Zealand	JM Bairstow	DJ Malan	TA Boult	1	nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.4	England	New Zealand	DJ Malan	JM Bairstow	TA Boult	1	nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.5	England	New Zealand	JM Bairstow	DJ Malan	TA Boult	4	nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.6	England	New Zealand	JM Bairstow	DJ Malan	TA Boult		nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.1	England	New Zealand	DJ Malan	JM Bairstow	MJ Henry		nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.2	England	New Zealand	DJ Malan	JM Bairstow	MJ Henry		nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.3	England	New Zealand	DJ Malan	JM Bairstow	MJ Henry		nan	nan	nan	nan
1	2023/24	Thu Oct 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.4	England	New Zealand	DJ Malan	JM Bairstow	MJ Henry		nan	nan	nan	nan


CREATE TABLE deliveries (
  "match_id" BIGINT,
  "season" VARCHAR,
  "start_date" TIMESTAMP,
  "venue" VARCHAR,
  "innings" BIGINT,
  "ball" DOUBLE,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "striker" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "runs_off_bat" BIGINT,
  "extras" BIGINT,
  "wides" DOUBLE,
  "noballs" DOUBLE,
  "byes" DOUBLE,
  "legbyes" DOUBLE,
  "penalty" DOUBLE,
  "wicket_type" VARCHAR,
  "player_dismissed" VARCHAR,
  "other_wicket_type" VARCHAR,
  "other_player_dismissed" VARCHAR
);