ICC Mens World Cup 2023
ICC Mens Cricket World Cup 2023, India
@kaggle.pardeep19singh_icc_mens_world_cup_2023
ICC Mens Cricket World Cup 2023, India
@kaggle.pardeep19singh_icc_mens_world_cup_2023
Context
The 2023 ICC Men's Cricket World Cup is the 13th edition of the Cricket World Cup, a quadrennial One Day International (ODI) cricket tournament contested by men's national teams and organized by the International Cricket Council (ICC). The tournament is being hosted by India, it started on 5 October and is scheduled to conclude on 19 November 2023. England are the defending champions, having won the 2019 edition by defeating New Zealand in the final at Lord's, London.
Reference: https://en.wikipedia.org/wiki/2023_Cricket_World_Cup
Content
deliveries.csv -> Containing ball by ball all matches datamatches.csv -> Details for each match playedpoints_table.csv -> Tournament standings so farAcknowledgements
The source of this dataset is Cricsheet. Cricsheet provides ball and ball data for most cricket tournaments. Matches-level data has been processed using raw info files and converted into a single CSV file. The points table has been scraped from ESPN Cricinfo site.
Inspiration
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
);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
);CREATE TABLE points_table (
"ranking" BIGINT,
"team" VARCHAR,
"matches" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"tie" BIGINT,
"no_results" BIGINT,
"points" BIGINT,
"net_run_rate" DOUBLE,
"for" VARCHAR,
"against" VARCHAR
);Anyone who has the link will be able to view this.