ODI World Cup 2023 Complete Dataset

@kaggle.enggbilalalikhan_odi_world_cup_2023_complete_dataset

Table List

4 tables(80.48 KB)

Batting Summary

Bowling Summary

Match Schedule Results

World Cup Players Info

Batting Summary

@kaggle.enggbilalalikhan_odi_world_cup_2023_complete_dataset.batting_summary

26.14 KB
916 rows
11 columns

match_no Match No	match_between Match Between	team_innings Team Innings	batsman_name Batsman Name	batting_position Batting Position	dismissal Dismissal	runs Runs	balls Balls	n_4s 4s	n_6s 6s	strike_rate Strike Rate
1	England vs New Zealand	England	Jonny Bairstow	1	c Daryl Mitchell b Mitchell Santner	33	35	4	1	94.300
1	England vs New Zealand	England	Dawid Malan	2	c Tom Latham b Matt Henry	14	24	2		58.300
1	England vs New Zealand	England	Joe Root	3	b Glenn Phillips	77	86	4	1	89.500
1	England vs New Zealand	England	Harry Brook	4	c Devon Conway b Rachin Ravindra	25	16	4	1	156.300
1	England vs New Zealand	England	Moeen Ali	5	b Glenn Phillips	11	17	1		64.700
1	England vs New Zealand	England	Jos Buttler	6	c Tom Latham b Matt Henry	43	42	2	2	102.400
1	England vs New Zealand	England	Liam Livingstone	7	c Matt Henry b Trent Boult	20	22	3		90.900
1	England vs New Zealand	England	Sam Curran	8	c Tom Latham b Matt Henry	14	19			73.700
1	England vs New Zealand	England	Chris Woakes	9	c Will Young b Mitchell Santner	11	12	1		91.700
1	England vs New Zealand	England	Adil Rashid	10	not out	15	13		1	115.400


CREATE TABLE batting_summary (
  "match_no" BIGINT,
  "match_between" VARCHAR,
  "team_innings" VARCHAR,
  "batsman_name" VARCHAR,
  "batting_position" BIGINT,
  "dismissal" VARCHAR,
  "runs" BIGINT,
  "balls" BIGINT,
  "n_4s" BIGINT,
  "n_6s" BIGINT,
  "strike_rate" VARCHAR
);